![QuickBooks Help](https://uxfabric.intuitcdn.net/web-app/sh-exp-sbg-app-experience/sbg_ohh_icon.19f2ae89.png)
Run a Balance Sheet report in QuickBooks Online
by Intuit•7• Updated about 6 hours ago
Learn how to run a Balance Sheet report in QuickBooks Online.
A Balance Sheet report gives you a financial snapshot of your company as of a specific date. It calculates how much your business is worth (your business's equity) by subtracting all the money your company owes (liabilities) from everything it owns (assets):
Assets - Liabilities = Equity
Note: The total for equity includes your company's net income for the financial year to date.
Some of your reports will look different depending on whether they're in the classic view or ![]() |
Run a Balance Sheet report
- Go to Reports (Take me there).
- From the Business overview section, select Balance Sheet.
Tip: To see a higher-level summary, run the Balance Sheet Summary report instead.
Differences between a Balance Sheet report and other reports
You may notice that your Balance Sheet report doesn't match your other reports even after making sure that all the filters are the same. There are a few reasons why this occurs, such as:
- Your Balance Sheet report is a cumulative report that carries a beginning balance.
- In other reports, the date range you set only applies to net income/profit for the year and the specific account you select within the report. (Example: If you have A$50 of GST in March and A$ 60 in April, the Balance sheet will show A$110 for the GST liability account).
- If the date range for the report is April, it will still show a cumulative total of A$110. However, if you select A$ 110, its transaction detail report shows a beginning balance of A$ 50 and then a A$ 60 transaction for April.
- In addition, the Sales by Product/Service Detail report is limited to the date range you set. If you set the report date for April, then it will truly reflect only April and show the A$ 60 only.
Compare your Balance Sheet report and Accounts Receivable Ageing Summary or Accounts Receivable Ageing Detail reports
When comparing your Balance Sheet report (Last Year/Accrual) and your Accounts receivable ageing summary or Accounts receivable ageing detail reports, there are some things you should know, such as:
- When you compare these two reports, you must specify the correct Ageing method in the Accounts receivable ageing report.
- If you're running the Balance Sheet report for any date in the past, you must select Report period for the Ageing method on your Accounts receivable ageing reports in order for the Total Accounts Receivable to match on both the Balance Sheet and Accounts receivable ageing report.
You can customise your Balance Sheet report to show Year-over-Year columns.
- Go to Reports (Take me there).
- In the search bar, search for and open Balance Sheet Comparison.
- Select Switch to modern view, if you see it.
- Select Custom dates from the Report period ▼ dropdown.
- Select From and To to set the start and end date.
- Select
Refresh report.
The value of the assets should always equal the combined value of the liabilities and equity (Equity = Assets - Liabilities). If your balance sheet isn't balancing correctly, you can troubleshoot the issue:
- Select each account in the report to see the transactions related to the balance of each account.
- You can start running the date range down by starting from year to date (YTD), and narrowing it down each month, until you have the date range narrowed to the day that the balance sheet goes off.
- From there, you can start to figure out what transaction is causing the balance sheet to be off and resolve the issue.
If your company's financial year is different from the calendar year, the amounts on both the report and the account history may not match because the balance sheet is run on a calendar year. You can resolve this issue by doing one of the following:
Option 1: Change the date of the report to match your financial year
- Go to Reports (Take me there).
- In the search bar, search for and open the Balance Sheet report.
- Select Switch to modern view, if you see it.
- Select the appropriate period from the Report period ▼ dropdown.
- Select
Refresh report.
Option 2: Change your financial year on the company file
- Go to Settings
and select Account and settings.
- Select Advanced.
- In the Accounting section, select the edit ✏️ icon.
- From the First month of tax year dropdown, select January.
- Select Save, then Done.
You must sign in to vote.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Resolve accounts receivable or accounts payable balances on a cash basis balance sheet in QuickBooks Onlineby QuickBooks
- Add to or edit the chart of accountsby QuickBooks
- Run a balance sheet by class or location in QuickBooks Onlineby QuickBooks
- Impacts of inventory tracking on the Balance Sheet and Profit & Loss reports in QuickBooks Onlineby QuickBooks