Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe 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!
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.
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
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:
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.
I have the same issue. I don't know how you are "getting rid of the indents" but this is what I do:
1. Insert column on the left.
2. Use the equation =B5&B6&B7&B8. This will put the title of the line item in that first column.
3. Copy the formula down to the bottom.
4. Select the column
5. Copy then Paste Values on top of the same column.
6. Now all the titles are in the first column.
7. Delete all the extraneous columns.
8. Now the amounts are next to the titles with no indents.
It's the quickest work-around I know.
Shouldn't the formula stay on the same row, but advance columns...as in: =B50&C50&D50&E50&F50&G50
That's how I do it...
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.