When a balance sheet does not tie to the trial balance, the cause is usually one of five things: different report dates or bases, current-year earnings missing from equity, an unmapped or double-mapped account, an entry posted after printing, or rounding. Check them in that order, and let the size of the difference point the way.
This post works through each cause with one fictional client, Ironleaf Landscaping Inc., at December 31, 2026. The client emailed a balance sheet PDF; the firm has a trial balance export from the same books. Every name and amount is an example, and every total below foots.
Checking a balance sheet against the trial balance in order
Checking a balance sheet against a trial balance goes fastest when you start with the causes that explain the whole difference at once, then move to causes that touch one account. Confirm the report date and basis, compare the difference to net income, look for unmapped accounts, look for late entries, and only then consider rounding.
The order matters because the early checks take a minute each and rule out large categories. Comparing two report headers is quicker than reviewing forty mapping rows. A difference that equals net income to the dollar ends the search before you open a single account.
Before starting, put both reports side by side at the line level. Here is Ironleaf's comparison:
| Line | Trial balance | Client balance sheet | Difference |
|---|---|---|---|
| Cash | 19,600 | 19,600 | 0 |
| Accounts receivable | 22,800 | 20,550 | 2,250 |
| Equipment, net | 61,000 | 61,000 | 0 |
| Total assets | 103,400 | 101,150 | 2,250 |
| Accounts payable | 12,900 | 12,900 | 0 |
| Equipment loan | 30,000 | 30,000 | 0 |
| Common stock | 10,000 | 10,000 | 0 |
| Retained earnings, beginning | 27,100 | 27,100 | 0 |
| Current-year net income | 23,400 | 21,150 | 2,250 |
| Total liabilities and equity | 103,400 | 101,150 | 2,250 |
Both reports balance internally. They disagree with each other by 2,250, and the difference sits in two lines: receivables and current-year income. That pattern, an asset and income moving together by the same amount, usually means a sale was recorded in one report and not the other. The section on late entries below finishes this example.
The difference-hunting table gives a first guess from the size or pattern of the gap:
| Size or pattern of the difference | Likely cause | Check to run |
|---|---|---|
| Exactly current-year net income | Revenue and expense accounts not rolled into equity | Look for a current-year earnings line in equity |
| Exactly one account's balance | Account unmapped, mapped to two lines, or missing from one report | Count how many lines each account feeds |
| Twice one account's balance | A debit read as a credit, or the reverse | Compare each account's sign with its normal balance |
| A round number, such as 5,000 | A single journal entry posted after one report ran | Compare entries by posting date |
| Divisible by 9 | Two digits transposed when typed | Compare each typed line with the source |
| A few dollars | Rounding of lines to whole dollars | Compare the unrounded totals |
| Matches a group of accounts | Different report date or accounting basis | Compare both report headers |
The divisible-by-9 row is arithmetic, not folklore. If 5,280 is typed as 5,820, the difference is 540, which is 9 times 60. Any swap of two adjacent digits produces a multiple of 9.
Are the balance sheet and trial balance run for the same date and basis?
A balance sheet and a trial balance tie only when both were run as of the same date and on the same accounting basis. A balance sheet dated November 30 and a trial balance dated December 31 will differ by a month of activity. A cash-basis report and an accrual-basis report will differ by receivables, payables and accruals.
Read both headers first. The date on a balance sheet is a single "as of" date. A trial balance header may show a period, such as "January through December 2026", and its balances are as of the last day of that period. If the client printed the balance sheet mid-month and the firm pulled the trial balance at month-end, there is nothing to investigate account by account; rerun one of them.
Basis differences show up as a group of lines moving together. On an accrual basis, sales invoiced but not collected sit in accounts receivable. On a cash basis, they do not exist yet, so receivables, the related revenue and therefore equity all come out lower. If Ironleaf's balance sheet had been run on a cash basis, the difference would have touched receivables, payables and income all at once, rather than one invoice.
Comparative columns hide a related trap. A two-year balance sheet may put the current year on the left or on the right. Before comparing, confirm which column holds December 31, 2026. When the balance sheet arrives as a PDF, converting it carefully keeps those column headers attached to their numbers; the guide to moving a balance sheet to Excel from a PDF or software report covers multi-column layouts.
Current-year earnings missing from the balance sheet equity section
When the difference between total assets and total liabilities plus equity equals net income exactly, current-year earnings are missing from equity. Before year-end closing, revenue and expense accounts still hold the year's activity. A balance sheet built only from asset, liability and equity accounts leaves that result out, and the sheet falls short by exactly that amount.
Here is how that looks if the firm builds Ironleaf's balance sheet in Excel and maps only the balance sheet accounts:
| Line | Amount |
|---|---|
| Total assets | 103,400 |
| Accounts payable | 12,900 |
| Equipment loan | 30,000 |
| Common stock | 10,000 |
| Retained earnings, beginning | 27,100 |
| Total liabilities and equity | 80,000 |
| Difference | 23,400 |
The difference of 23,400 is Ironleaf's net income for 2026. The fix is a current-year net income line in equity that sums every revenue and expense account. The Excel workbook's balance sheet check cell flags this gap automatically, so a missing earnings line shows up the moment the workbook recalculates.
Get the net income figure from the income statement for the same period, not from memory or last year's file. If the income statement and the balance sheet came from different runs, they can disagree with each other too. Moving the income statement into the same workbook makes the comparison one formula; see the guide to an income statement to Excel with periods and subtotals.
The opposite case also happens. A trial balance pulled after the books were closed already includes the year's result in retained earnings. Adding a current-year earnings line on top of that counts net income twice, and the sheet is out by 23,400 in the other direction.
Which unmapped or misgrouped accounts break the balance sheet tie?
An unmapped account is a trial balance account that feeds no balance sheet line, so its balance vanishes. A misgrouped account feeds the wrong line or two lines at once. Unmapped accounts produce a difference equal to one account's balance; an account counted twice produces a difference equal to that balance, and a reversed sign doubles it.
New accounts often cause these. A client who opened a savings account or a second loan in October adds a row to the trial balance that last year's mapping has never seen. If the balance sheet workbook uses a mapping table, that row lands on no line. The mapping guide explains a COUNTIF formula for catching unmapped trial balance accounts before they cause a mismatch.
To find a misgrouped account by hand, filter the trial balance to accounts whose balance equals the difference, or half of it. Suppose Ironleaf's difference had been 3,600 and one account, a 3,600 prepaid insurance balance, appeared on both the prepaid line and the other current assets line; the match points straight at it. Had the same balance been read as a credit instead, the difference would be 7,200, and half of it would point to the same account.
A spreadsheet that totals each line with SUMIFS will also return zero, without an error, when a line label does not match the mapping text exactly. Microsoft's SUMIFS function reference describes how criteria select rows; a label with a stray space selects none. A line showing zero that should carry a balance is a mapping problem, not a missing account.
Entries posted after the balance sheet was printed
Entries posted after a balance sheet was printed are a common reason a client's statement and the firm's trial balance disagree by a round or specific amount. The client prints a balance sheet, then the bookkeeper or the firm records an adjustment or a late invoice. The trial balance pulled later includes it; the printed page does not.
Ironleaf is this case. The 2,250 difference sits in accounts receivable and current-year income. The trial balance's receivables detail shows invoice 1187, dated December 30, 2026, for 2,250, entered on January 12, 2027. The client printed the balance sheet on January 8. Same date, same basis, different moment in time.
The fix is not to adjust either report. Decide which version is final, usually the later one with the adjustment, and ask the client for a reprinted balance sheet or note the reconciling item in the workpapers.
Closed periods complicate this. If the client's books treat December as closed, but an entry was still dated into it later, a balance sheet printed before that entry and one printed after it will differ, even though both say December 31. Ask who posted after the print date, and to which period.
Late entries also explain differences in other tie-outs. A bank reconciliation that stops balancing after it was signed off often has the same root cause; the post on bank reconciliation errors works through that version.
Balance sheet tie-out edge cases: rounding and hidden zero accounts
Rounding and hidden zero accounts explain the small or odd differences left after the main checks. A balance sheet printed in whole dollars rounds each line, so its total can differ from the trial balance by a dollar or two. A report that hides inactive or zero-looking accounts can drop a small leftover balance.
Here is a rounding example. Suppose Ironleaf's three asset accounts carry cents:
| Account | Trial balance | Rounded line |
|---|---|---|
| Cash | 19,600.40 | 19,600 |
| Accounts receivable | 22,800.40 | 22,800 |
| Equipment, net | 61,000.40 | 61,000 |
| Total | 103,401.20 | 103,400 |
The unrounded total, 103,401.20, rounds to 103,401. The rounded lines add to 103,400. The one-dollar gap is rounding and nothing else. In Excel, the ROUND function lets you compare totals at two decimals, so a one-dollar presentation gap does not send you looking for an error that is not there.
Hidden accounts are a different story. If a report was run with zero-balance rows suppressed, an inactive account with a leftover balance of 40.00 might be left off one report, or grouped into "Other" on one report and listed on the other. When the difference is small and not a rounding pattern, ask the client to rerun both reports with every account shown.
When documents come in from several places, the first question is often which report is which. Schema CPA classifies every page a client sends by document type, issuer and period, so a November balance sheet and a December trial balance in one PDF are labelled as different periods before anyone compares them; the workflow section on the homepage walks through the classify step.