Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

re: "Flat data" reporting

We have QB Desktop. Is there a way to have a report exported into Excel so that the data is "flat" - meaning no indents on the left-hand side?

 

For instance: I need to take a trial balance from Quick Books and export it into Excel and dump it into a mapped Excel model. I have to manually remove the indents (time-consuming). Is there a way to have the data export flush left (meaning the account names & numbers)?

 

Thank you in advance!

3 Comments
QuickBooks Team

re: "Flat data" reporting

Hi @jriley1414,

 

This specific option you want for the Excel export feature is unavailable.

 

Let's take for example the report you stated above, which is the Trial Balance report. There's a single column indent for the account names to differentiate the Total row at the bottom of the report. 

 

In case you encounter any issues with the export process, keep this article for reference: Fix export to Excel issues in QuickBooks Desktop

 

Post a reply if you need clarification with this process, and I'll get back to you. 

Level 2

re: "Flat data" reporting

Hi Ryan,

 

Unfortunately, this suggestion did not solve my issue. As QB does not offer a working trial balance (except in the accountant's version), I must utilize the attached Excel report ("comparative trail balance") as I need beginning and ending totals with +/- change.  This report has multiple levels of indents similar to a P&L.

 

Again, I am working in a mapped Excel model and the model cannot be changed. I can send along a report we run out of AccountEdge to get this data so that you can see what I am talking about. I have redacted any sensitive information on the attached that has come out of QB.

 

Thank you!

 

Jeannine

 

 

QuickBooks Team

re: "Flat data" reporting

Hello there,@jriley1414.

 

 I appreciate you for getting back to us and provide more details about your concern. Let me chime in and share some ideas about exporting reports into an Excel file.

 

Yes, you're right. Once you export your report into Excel it has multiple indentions since it's a normal behavior of QuickBooks. That's why you'll need to manually modify the report according to your preference.

 

However, you can search for a third-party app in our QuickBooks Desktop Apps Center. Just look for a Trial Balance Importer that you can try. 

 

All of the apps listed on this site are integrated with the program. This way, it would be easy for you to import your IIF files into QuickBooks. 

 

Here's how:

 

  1. In your QuickBooks Desktop, go to the Help menu and select App Center: Find More Business Solutions.
  2. In the Apps for QuickBooks Desktop Marketplace window, make sure to enter a keyword in the search field to narrow down the process.
  3. Then, select the app from the list.

 

You can also check our Firm of the Future site. This is where we share recent happenings and future developments, such as updates to newly added features in QuickBooks.

 

Additionally, here's an article that'll further guide you in managing the growth of your business using QBDT: QuickBooks Help Articles. It includes topics about account management, banking, and expenses, to name a few. You can click the + More topics to view additional selections.

 

Please know that I'm only a post away if you have any other issues or concerns. I'll be more than willing to help.

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

Need to get in touch?

Contact us