← All Posts

Blog

What the Balance Sheet Knows by November

Picture the first week of November. The report on the screen is a balance sheet dated October 31, and next to it sit the October bank statement, the October credit card statement, and the latest statement from the lender. The job is to go down the page one line at a time and ask every line the same question: can something outside this software prove this number? Some lines can, and they go quickly. The rest are why this is worth doing in November.

A balance sheet is, according to the SEC’s guide to financial statements, a snapshot of what a company owns and owes at a fixed point in time. Plenty of owners skip it, which is understandable: the profit and loss statement answers the question they care about, and this one reads like an inventory. But double-entry bookkeeping records every transaction in at least two accounts, so when somebody isn’t sure where something belongs, the uncertainty has to land somewhere. Often the P&L gets the tidy half of that entry, and the balance sheet keeps the receipts.

November suits this because of what has piled up and what hasn’t happened yet. Ten months of shortcuts are sitting there, and anything someone called temporary in March has had plenty of time to prove otherwise. October’s statements are in, two closes remain in the year, and people can still remember why they did what they did. Run the same read in late January, after your CPA has asked for year-end reports, and it’s the same detective work with colder leads.

Start with the lines that have witnesses

Cash and credit cards go first, because a bank will testify. QuickBooks’ reconciliation guide has you enter the ending balance and date from the statement and keep matching until the difference is $0.00, and its video says that’s best done every month. The balance in your books can still differ from a bank statement for an honest reason: IRS Publication 583 notes that a statement won’t include deposits made after the statement date or checks that didn’t clear before it, and you should be able to name each one. QuickBooks’ troubleshooting page lists missing or duplicate transactions among the causes of ending balance issues, and those are what you’re really looking for. While you’re in there, check whether any reconciliation only finished because of an adjusting entry. QuickBooks says those should be a last resort, because making them for large discrepancies can cause problems in the books. Each one also creates an income or expense transaction. A small one is a shrug with a date on it; a big one deserves a conversation.

Loans get the lender’s statement. QuickBooks’ loan setup guide uses a liability account to track what you owe, with payments recorded to that account and interest recorded to an expense account. Trouble shows up when the whole monthly payment gets coded one way for months. Send it all to interest and the loan sits frozen at its original balance; send it all to the loan and the balance falls faster than the lender says it should, with interest missing from the P&L. Either way, the lender’s figure settles the argument.

Receivables have a witness too, an internal one. QuickBooks says your balance sheet and accounts receivable aging reports should match, and that when they don’t, it’s usually because the report’s aging method defaults to current. The fix it gives is switching that setting to “Report date.” The same page also tells you to run the balance sheet using accrual and to make sure the date ranges match. If you report on a cash basis and still see accounts receivable or accounts payable on the balance sheet, Intuit’s cash-basis guide names two common causes: a transaction that affected those accounts, and payments never applied to an invoice or bill. The unapplied payments can be opened and applied. For correcting those accounts with a journal entry, the same guide says to consult your CPA first.

Then the lines that are only waiting

The next group are waiting rooms: accounts where a transaction is supposed to pause on its way somewhere else, and where nothing is supposed to settle in. QuickBooks’ guide to special accounts says Undeposited Funds holds payments until you deposit them into your bank account, which is perfectly fine for Friday’s checks. An old balance is a different animal. Here’s an invented example: an October 31 balance sheet showing $4,318.62 in Undeposited Funds, all of it customer payments from spring. That money reached the bank months ago, so a likely story is that the deposit came through the bank feed and got categorized as income instead of being matched to the payments. QuickBooks’ matching guide points out that categorizing creates a brand-new record, and its guide to duplicate transactions describes the result when an invoice is paid and the bank deposit also gets added as new income: the income is counted twice. If that’s what happened here, the year looks $4,318.62 better than it was.

The same special-accounts guide says Uncategorized Asset “records any asset that can’t be matched to an account,” which is about as candid as an account description gets. A balance there isn’t something you own so much as a question nobody answered. Homemade versions turn up too, under names like Suspense, and they get the same treatment: open the transaction list and find out what each one was.

Opening Balance Equity is a slightly different waiting room. QuickBooks says it offsets the starting balances you enter so the books stay balanced, and the special-accounts guide calls it the default account for adjustments. So a balance there records that a setup or an adjustment happened, and says very little about anyone’s stake in the business. We’d expect it to be empty once setup is finished, and if it grew this year, we’d want to know what landed there. Where an old balance finally belongs is a question for your CPA.

If you take retainers, the liability side has a waiting room of its own. QuickBooks’ retainer guide holds that money in a liability account until it’s used, and says you can track what you’re holding for each customer from the balance sheet report. That total should equal what you still owe in work or refunds. Another invented figure: $1,275 still held for a client whose project wrapped in May. The likely explanations are a final invoice billed in full with the retainer never applied, income nobody recorded, or a refund nobody sent, and each is easier to sort out now than next spring.

One more look, this time backward. Run the balance sheet as of the end of last year and compare it with the final numbers your CPA worked from. If they differ, check first that the report is on the same basis as the CPA’s figures. After that, the likely explanations are adjustments that never got posted to the books (sometimes deliberately) and changes someone has made to an earlier period since. If you’ve closed your books in QuickBooks, its closed-books page points to an Exceptions to Closing Date report that shows changes made after the close.

Go slowly with the fixes, because they move real numbers. If that Undeposited Funds balance does turn out to be doubled income, clearing it lowers reported income, and editing a reconciled transaction has consequences of its own: QuickBooks’ beginning balance guide says that changes the ending balance of your last reconciliation and sets the beginning balance for the next one. We’d write down what each line turned out to be, fix what’s plainly wrong in the current year, and take anything touching a closed year to your CPA before changing it.

Here’s what this read won’t do: tell you the P&L is right. Say a $612.40 software bill got coded to Office Supplies. Cash went out, an expense got recorded, net income is the same, and the balance sheet can’t tell the difference; it’ll tie out to the penny with every expense in the wrong category. This read also won’t say whether the business is healthy, and what any of it means for your taxes is your CPA’s call. What you get is narrower: a list of the numbers you can prove, and a list of the ones you’re still taking on faith.


Bat City Books helps service-based small businesses get to year-end with balance sheets they can back up. If yours has lines nobody can explain, let’s talk.