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)?
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.
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.
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.
In your QuickBooks Desktop, go to the Help menu and select App Center: Find More Business Solutions.
In the Apps for QuickBooks Desktop Marketplace window, make sure to enter a keyword in the search field to narrow down the process.
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.