cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Finley
Level 2

CSV and XLSX versions of my exported QB report do not have the same values.

When exporting my P&L in .xlsx format, I noticed that the Net Profit line for my year to date did not match the Net Profit line from my balance sheet. Of course, it should. After a lot of trial and error, I realized if I printed the same report in .csv format, the .csv file had the same values as the report I could see in QB. 

Why doesn't the .xlsx version of the exported report match the values of the report I can see inside my QB app.

I am using the desktop version for non-profits.

2 Comments 2
MoiraskyeT
QuickBooks Team

CSV and XLSX versions of my exported QB report do not have the same values.

We are committed to ensuring you have a positive experience, Finley. Our goal is to facilitate seamless and efficient transactions in QuickBooks, allowing you to navigate the program with confidence and fully utilize its features.

 

It appears you're having some difficulty exporting the Profit & Loss report to .XLSX format, and it seems the year-to-date numbers aren't matching with the net profit on your balance sheet. To help resolve this, we recommend using the Rebuild Data Tool to verify and correct the issue. We're here to support you every step of the way.

 

I've provided this article to give you more detailed assistance in how to Export reports as Excel workbooks in QuickBooks Desktop.

 

When everything is in place, consider reviewing this article for more guidance. It's designed to assist you through the process efficiently: Customize reports in QuickBooks Desktop.


Feel free to reach out to the Community if you have any further questions about exporting your reports in QuickBooks Desktop. Just click on Reply, and I'll be here to assist you.

Chrea
Level 6

CSV and XLSX versions of my exported QB report do not have the same values.

@Finley 

Run the Verify/Rebuild Data utility. Did encounter any unresolved error messages?

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up