Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi there,
QuickBooks Online gives you the flexibility to generate reports to get insights about your business. And you can export them to Excel if you want to use your reports outside of QuickBooks. I'll be happy show you how.
How to export reports from QuickBooks Online to Excel
Based on what you've described, it's not possible to have the account numbers in a separate column. If you don't account numbers to show up on the report, you can temporarily turn off account numbers from the company settings. Here's how:
Let me know if you have further questions. I'm here to help get you back on track. Otherwise, enjoy the rest of you week and feel free to reach out if you need anything.
That doesn't answer the question. There needs to be a way to export the trial balance and have the account numbers and descriptions in 2 separate columns.
How can this be done?
Hey gerryw,
Thanks for your response. It's important to have reports that suit your needs, I can see the benefit of having this information in a separate column. The Trial Balance in QuickBooks Online is designed with a focus on providing a detailed overview of everything that happened in your books, so the customization options available are to help maintain consistency. Feel free to submit feedback about this to our engineering team. Your comments serve as the foundation to keep building the best QuickBooks experience possible.
As a workaround, you could add a comma (or other symbol) at the end of your account numbers. This makes it easy to use the excellent Text to Columns feature found in the Data tab of your Excel software. Just insert an additional column to the right of the Account column, then use Text to Columns to split the information delimited by your symbol.
Let me know how this goes!
I am also having this issue and it's going to cause hours of manual data entry. I cannot believe this is not an option in QB. This should be a very simple fix on QB's end. I would consider switching to another program if I wasn't already invested in QB. Hugely disappointing.
Well, you can separate it using Text to Columns function in Excel. There's also some formulas you could use to break it out.
But yes I agree, I'm shocked this isn't the default for the program.
Hi Andre,
This sounds like an easy solution. But, it is not reasonable solution, as I have multiple companies with many GL accounts.
Hopefully, QBO will fix this issue soon.
Gerry
Text to Columns only works if there is one space.
One solution I have found so far is;
If data is in A1 try this formula for everything before the space
=LEFT(A1,FIND(" ",A1)-1)
and for everything after
=REPLACE(A1,1,FIND(" ",A1),"")
Gerry
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.