How to Generate a Balance Sheet in QuickBooks

To generate a balance sheet in QuickBooks Online, open Reports, go to Standard reports, and select Balance Sheet. Choose the reporting date or period, confirm the accounting method and any other filters, then refresh or run the report. Export or save the report only after reviewing the settings and reconciling the underlying accounts.

A generated report is not automatically an accurate report. QuickBooks organizes transactions by account type, date, and reporting basis. Incorrect opening balances, unreconciled accounts, duplicated transactions, wrong account types, stale receivables or payables, and unsupported journal entries can all produce a balance sheet that looks complete but cannot be relied on.

QuickBooks Online balance sheet steps

1. Go to Reports, then open Standard reports.
2. Search for and select Balance Sheet. Use Balance Sheet Summary if a higher-level view is more appropriate.
3. Set the Report period or as-of date. A balance sheet is a snapshot at a point in time.
4. Confirm the Accounting method and any display, comparison, class, location, or other filters available in the company’s version.
5. Refresh the report and review the title and settings displayed at the top.
6. Expand or select an account to inspect the transaction detail when a balance is unexpected.
7. Use the export or print options after the review is complete. Current QuickBooks guidance describes Excel, CSV, and PDF options in the report workflow.

QuickBooks interfaces change, and some users may see a classic or enhanced reporting experience. The report name, reporting date, accounting method, and account detail matter more than matching an old screenshot exactly.

Understand what the report date does

A balance sheet reports assets, liabilities, and equity as of a date. The balances are cumulative. Selecting one month does not mean that every balance-sheet account reflects only that month’s transactions. Cash, receivables, loans, fixed assets, sales tax payable, and equity carry prior activity forward.

This is why a balance-sheet number may not match a report that covers only transactions within a date range. QuickBooks notes that cumulative balance-sheet accounts can show a beginning balance plus current-period activity when you open their detail.

When comparing the balance sheet with an accounts receivable aging for a historical date, align the aging method and report date. A current-date aging can differ from a historical balance sheet because later payments and adjustments changed the customer balances.

Also confirm the company’s fiscal-year setting when reviewing year-to-date equity and comparative periods. Record the exact report settings with the saved copy so another reviewer can reproduce the final result accurately.

Confirm cash or accrual settings

The accounting method can change how certain reports present income, expense, receivable, and payable activity. Use the method selected for the reporting purpose and confirm that all related reports use consistent settings before comparing them.

Do not switch methods simply to make a difference disappear. Identify which transactions are included under each method and discuss reporting or tax-basis decisions with the appropriate adviser.

Reconcile the accounts before relying on the balance sheet

Start with cash because every other cleanup entry eventually affects another account. Save the reconciliation report and investigate old uncleared transactions rather than deleting them solely to clear the list.

Review the accounting equation

A balance sheet follows the relationship:

Assets = Liabilities + Equity

QuickBooks should calculate a balanced report when transactions are posted through the accounting system. If the report is out of balance, Intuit recommends drilling into accounts and narrowing the reporting date to identify when the difference began. A data or file issue may require specialized support.

A report can satisfy the equation and still be wrong. A bank account can be overstated while revenue is overstated by the same entry. A loan can be understated while expense is overstated. Balance is a mathematical check, not proof that every account is supported.

Investigate accounts receivable differences

If the balance sheet does not match the receivables aging, confirm the same as-of date, method, customer filters, and report basis. Then review unapplied payments, credits, deleted or changed transactions, journal entries to accounts receivable, and customer names on entries.

For historical comparisons, use an aging setting that reflects the report period rather than today’s aging when supported. Drill into the balance-sheet receivable amount and compare the transaction-level detail with the aging total.

Customize the report for useful review

Useful options can include prior-period comparison, year-over-year columns, percentages, account detail, classes, or locations, depending on the subscription and reporting experience. Add complexity only when the underlying dimensions are used consistently.

For a management package, a comparative balance sheet can reveal changes in cash, receivables, inventory, debt, and equity. Pair it with the profit and loss statement, cash flow statement, receivable aging, payable aging, and notes explaining material changes.

Illustrative review example

Assume the balance sheet shows $85,000 in cash, $140,000 in accounts receivable, $35,000 in inventory, $90,000 in payables, and a negative payroll liability. The reviewer should not begin by formatting the report.

1. Confirm the report date and accounting method.
2. Compare cash with completed bank reconciliations.
3. Compare receivables with the aging and inspect old or credit balances.
4. Reconcile inventory with the subledger and recent count adjustments.
5. Compare payables with vendor aging and statements.
6. Investigate the negative payroll liability against payroll reports and deposits.
7. Document corrections and rerun the report with the same settings.

The figures are illustrative. A negative balance is not automatically an error, but it deserves an explanation supported by the account’s normal purpose and transaction detail.

Export and preserve the final report

After review, export the report in the format needed by the recipient and preserve the settings. A PDF is useful for a fixed review copy. Excel or CSV can support analysis, but exporting does not create a controlled financial statement by itself.

Record the company, as-of date, accounting method, report version, filters, preparer, reviewer, and completion date. Save the supporting reconciliations with the report so the numbers can be traced later.

Common QuickBooks balance-sheet mistakes

• Using the wrong as-of date or inconsistent accounting method.
• Comparing a historical balance sheet with a current-date aging.
• Assuming a mathematically balanced report is accurate.
• Leaving bank, credit card, loan, payroll, and clearing accounts unreconciled.
• Posting equipment, loan principal, or owner transactions to expense.
• Using journal entries in receivables or payables without customer or vendor support.
• Exporting before documenting filters and completing the close.

Read the balance sheet guide for report fundamentals and the out-of-balance troubleshooting guide for a deeper diagnostic process.