Understanding the Trial Balance Report in QuickBooks Online

Have you ever wanted to see a snapshot of ALL your financial accounts?
 
That’s what the Trial Balance is for. It combines both the Profit and Loss and Balance Sheet into one report.

The Trial Balance in QuickBooks Online

To find the Trial Balance in QuickBooks Online, click Reports in the left-hand menu. Then, search for Trial Balance.

searching for Trial Balance from the reports screen in QBO.

You have a few options for this report. You can

  • Pick a date range
  • Display columns by month, or Total only
  • Show non-zero or active-only rows/columns
  • Select Cash or Accrual Accounting methods

For this example, I’m selecting the date range All Dates and then clicking Run report.

Selecting a date range for the Trial Balance report from the Report period drop-down in QBO

The report shows all of the accounts on the Balance Sheet. Followed by all of the accounts on the Profit and Loss. 

Trial Balance versus Balance Sheet

Here’s a side-by-side of the Trial Balance and Balance Sheet, both with All Dates selected.

Side-by-side of the Trial Balance and Balance Sheet in QBO showing that they have the accounts.

Trial Balance versus Profit and Loss

Here is a side-by-side of the Trial Balance and the Profit and Loss report.

Side-by-side of the Trial Balance and Profit and Loss reports in QBO

You may notice that the Profit and Loss report has indented sub-accounts that you can hide if needed.

The Trial Balance lists ALL accounts in one column, including sub-accounts. Sub-account names have colons separating the different account levels in their name.

Example of sub-accounts listed on the Trial Balance report.

Everything from the Balance Sheet and Profit and Loss appears on the Trial Balance except the Net Income.

That’s because Net Income is the difference between income and expenses. Net Income doesn’t appear on the Trial Balance because, mathematically, it’s already there.

☕ If you found this helpful you can say “thanks” by buying me a coffee… https://www.buymeacoffee.com/gentlefrog

Below is a video if you prefer to watch a walkthrough.

If you have questions about QuickBooks Online click the green button below to schedule a free consultation.

Need some one-on-one QuickBooks assistance?
Share Now

This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.

Leave a Reply

Your email address will not be published. Required fields are marked *

Read similar articles

How to Enable Account Cards in QuickBooks Online’s Bank Transactions Screen

Learn how to enable the account cards on your Bank Transactions screen in QuickBooks Online.

How to Find Out Which QuickBooks Online Clients Require Immediate Attention for Payroll Tax Updates

Learn how to find out which of your clients have issues with upcoming payroll tax changes.

Have a QuickBooks / Bookkeeping Question?

Let me know what you’d like to see in future videos, blog posts, and courses.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.

Review Your QuickBooks

Are you a small business owner struggling to make sense of your QuickBooks data?

  • Discover how to spot costly mistakes in your bookkeeping and fix them quickly and easily.

  • Save time and money by streamlining your bookkeeping process and reducing errors.

  • Learn how to identify trends in your financial data so you can make smarter business decisions.

  • Get organized and stay on top of your finances by tracking expenses, managing receipts, and closing your books effectively.

Sign up now for this free mini-course and start mastering the essential bookkeeping skills that every small business owner needs to succeed!

FREE Mini Course

Sign up now and enjoy the peace of mind that comes with knowing your bookkeeping is accurate, up-to-date, and free from costly errors.

We won’t send spam. Unsubscribe at any time.