How can I get a single column Trial Balance report?

Forum|Forum|4 years ago
August 24, 2021
1 reply
4 views

No text available

QuickBooks Online

GeorgiaC

Level 13

Hi simon-gerra-theb

The TB report is designed to show credit and debit accounts in columns with totals that are equal, and as such it's not possible to format this into a single column. 👩‍💻

simon-gerra-thebAuthor

Hi, In every other finance package I have used you simply have Credits as negative and Debits as positive numbers in a single column. If this is not possible I think it would be a simply piece of development work for your developers to create as in Excel you can do this by adding a third column C and inputting the formula A - B = C Single column trial balance. Thanks.

ShiellaGraceA

Level 9

Thanks for getting back to us here, @simon-gerra-theb.

I appreciate the idea of adding a third column for the formula. I can see your thoughts and experience would help us to provide a more customer-friendly interface of the product. Rest assured, your encounter and suggestion have been shared with our Developers.

In the meantime, you'll want to export the Trial Balance report to Excel so you can insert an additional column.

To export:

Go to Reports.
Enter Trial Balance in the search field.
Select the Report period and then tap the Export icon next to the Printer icon.

After that, an Excel Spreadsheet will open, from there you can insert a column for the formula. Want more details about this option? Check out this guide: Export your reports to Excel from QuickBooks Online.

In case you need help with financial reports, feel free to browse this link: Setting up reports to customise, run, and share.

I'll be around if you have other questions or concerns with reports. Don't hesitate to reply. Take care and stay safe.

Sign up

Login with SSO

Let's get you signed in

Login with SSO