BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months*   Ends 11/30

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
LollyNino_C
QuickBooks Team

Reply to message

Hello there, @grunertime

 

Thank you all for taking the time to post in the Community. You'll want to export the Trial balance into an Excel file. 

 

From there, you can customize the data to show the specific details you wanted. The Trial Balance report only displays the Debit and Credit Column. To filter and export the report, just follow these steps:

  1. In the Report period section, filter it to show the data for a month.
  2. Click the Export icon and select Export to Excel (see screenshot).
  3. Follow the same steps until you're finished with the current year.
  4. In the Excel spreadsheet, manually customize the columns the way you'd like them to be displayed.

 

You can also check these articles for more details: 

 

  

I'm always available if you have more questions about QuickBooks Desktop. Just leave a reply and I'll get back to you as soon as possible. Have a great day and stay safe. 

Need to get in touch?

Contact us