How to Create a Balance Sheet in QuickBooks Online, and Check It Before It Goes Out
You don't build a balance sheet in QuickBooks. You run it: Reports, search Balance Sheet, pick the date. QuickBooks totals what the business owns, what it owes, and what's left as equity from the transactions already in your books. The part that takes time is making sure those transactions are right before someone outside reads it.
Run it in under a minute
- 1
Open the report
Reports › Search "Balance Sheet"It's one of the standard reports, listed with the other business overview reports. The name is just Balance Sheet.
- 2
Set the date it's "as of"
A balance sheet is a snapshot on one day, not a range. For a lender, that's usually the last day of the month or quarter they asked about.
- 3
Pick cash or accrual
Use the basis the person asking expects. If you're not sure, ask your accountant; lenders usually want accrual.
Watch for: switching basis changes Accounts Receivable and Accounts Payable, sometimes to zero. That's expected, not an error.
- 4
Add comparison columns if they help
Display columns by can show months or quarters side by side, or split by class or location. A lender comparing this quarter to last will thank you for it.
- 5
Save it, export it, or print it
Save the customization so next quarter is one click. Export to PDF or Excel for email, or use the print icon. Check the PDF layout before printing to paper.
Before a lender or accountant sees it
QuickBooks Online keeps both sides of every transaction, so total assets will equal liabilities plus equity. What a reader questions is whether the lines themselves are believable.
Is the bank balance the same as the bank statement?
If the cash line doesn't match the statement for that date, reconcile the account first. It's the first number a lender compares.
Is there anything in Opening Balance Equity?
It should be zero once setup is done. A balance there means opening entries were never finished. See Opening Balance Equity.
Is there an Uncategorized Asset line?
That's bank feed items nobody categorized. It inflates assets with money that isn't really an asset. Clear it out before sending.
Is Undeposited Funds larger than a few days of takings?
A big balance usually means payments were received but never grouped into deposits, so cash is double counted somewhere.
Do loan balances match the lender's statement?
The person reading the report has their own figure for what you owe them. If yours is different, they'll notice before anything else.
Does retained earnings look right after year end?
QuickBooks rolls last year's profit into retained earnings on its own. Odd entries there often come from someone posting to it by hand.
Cash or accrual on a balance sheet
Only what has actually moved
- Unpaid customer invoices don't appear, so Accounts Receivable is usually zero.
- Unpaid vendor bills don't appear either.
- Matches how many small businesses think about money day to day.
What you are owed and what you owe
- Open invoices show as Accounts Receivable, open bills as Accounts Payable.
- Gives a truer picture of what the business can cover in the next few months.
- What lenders and investors usually ask for.
Send whichever basis the reader asked for, and say which one it is in the email. Two balance sheets for the same date on different bases look like two different businesses.
Questions people ask
What is a balance sheet in QuickBooks?
A report of what the business owns (assets), what it owes (liabilities) and what's left for the owners (equity) on one specific date. The income statement covers a stretch of time; the balance sheet is a single day.
What is the balance sheet called in QuickBooks Online?
Balance Sheet, the standard name. That's different from the income statement, which QuickBooks calls Profit and Loss. There are also Balance Sheet Detail and Balance Sheet Summary versions if you need more or less.
How do I print a balance sheet in QuickBooks?
Run the report, then use the print icon at the top. If you want to check the layout first, export it to PDF and print from there.
How do I reconcile balance sheet accounts in QuickBooks?
That's separate from running the report. You reconcile each bank, credit card or loan account against its statement with the Reconcile tool, the same one you use for checking. Reconciled accounts are what make the balance sheet trustworthy.
Why doesn't my balance sheet match last time I ran it?
Someone changed a transaction dated on or before that day, or the report basis changed between cash and accrual. Compare both versions with the same basis, then check the audit log for edits to that period.