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 fiscal year to date.
How to run a Balance Sheet report
- Go to Business overview and select Reports (Take me there), or go to Reports (Take me there).
- 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 and the specific account you select within the report. (Example: If you have US $50 of sales tax in March and US $60 in April, the Balance Sheet will show US $110 for the sales tax liability account.)
- If the date range for the report is April, it will still show the cumulative total of US $110. However, if you select US $110, its transaction detail report shows a beginning balance of US $50 and then US $60 transaction for April.
- In addition, the Sales by Product/Service report will be 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 US $60 only.
Compare your Balance Sheet report and A/R Aging Summary or A/R Aging Detail reports
When comparing your Balance Sheet report (Last Year/Accrual) and your A/R aging summary or A/R aging detail reports there are some things you should know, such as:
- When you compare these two reports, you must specify the correct Aging Method on the A/R aging report.
- If you're running the Balance Sheet report for any date in the past, you must select Report date for the Aging Method on your A/R aging reports, in order for the Total Accounts Receivable to match on both the Balance Sheet and A/R aging report.
Why the Balance Sheet report may not show a correct balance
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 on 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.
Why the Balance Sheet report may not match the register
If your company's fiscal year is different from the calendar year, the amounts on both the report and the register 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 fiscal year
- Go to Business overview and select Reports (Take me there), or go to Reports (Take me there).
- In the search bar, search for and open the Balance Sheet report.
- Select Customize.
- Choose the appropriate Report period.
- Select Run report.
Option 2: Change your fiscal year on the company file
- Go to Settings ⚙, then select Account and settings.
- Select Advanced.
- In the Accounting section, select the edit ✏️ icon.
- From First month of income tax year dropdown, choose January.
- Select Save and Done.
