Balance sheet reconciliation checklist: each account and its proof
By Arthur Teboul, DokuTrak · Published
In brief
A balance sheet reconciliation checklist lists every balance sheet account with the outside document that proves its balance, who holds that document and how often to check it. Each account gets a workpaper showing the ledger balance, the proof balance and an explanation of any difference.
The checklist: Balance sheet reconciliation checklist
One line per account type. Request the client documents in the first group before the close, then sign each account off with its proof.
- PDFPrint it or tick it off on screen.Free, no email
- WordEdit it and send it under your name.Free, with your email
- Excel trackerOne row per item, with a status column.Free, with your email
Proof to request from the client
- Bank statements for every accountEnding balance proves cash. Full month, PDF.
- Credit card statementsClosing balance; list charges after the closing date.
- Loan, line of credit and mortgage statementsPrincipal balance at month-end.
- Payroll provider tax liability reportWithholding and employer taxes owed but not yet deposited.
- Lease or deposit receipt for security deposits
- Purchase invoices for new fixed assetsDate, price and description.
- Petty cash count sheet and slipsSigned by whoever holds the cash.
Assets
- Checking and savingsReconciling items: outstanding checks, deposits in transit, bank charges.
- Processor clearing accountsShould be near zero once payouts are matched.
- Accounts receivable and allowance for doubtful accountsAging total equals the ledger; review items past ninety days.
- InventoryCount or valuation report; quarterly or yearly for small clients.
- Prepaid expensesPrepaid schedule total equals the ledger.
- Fixed assets and accumulated depreciationRegister equals the ledger.
Liabilities and equity
- Accounts payableAging equals the ledger; spot-check vendor statements.
- Accrued liabilitiesAccrual worksheet, each line reversing next month.
- Payroll liabilitiesEqual to deposits due but not yet made: about one month for a monthly depositor, a few days for a semiweekly one.
- Sales tax payableEqual to the liability report or return for the period.
- Loans and lines of creditLender principal; difference to interest expense.
- Owner and shareholder loansSigned note or the owner’s written confirmation.
- Deferred revenueSchedule of customer prepayments by contract.
- Equity and retained earningsPrior year-end balance plus this year’s activity; no unreviewed direct postings.
Sign-off
- Workpaper for every accountLedger balance, proof balance, reconciling items, difference.
- Differences above tolerance explained before sign-offWrite the firm’s tolerance on the checklist.
- No unexplained amount parked in suspenseOpen question sent to the client instead.
- Preparer and reviewer initials and dates on each workpaper
What a balance sheet reconciliation is
A balance sheet reconciliation is the check that each asset, liability and equity balance in the ledger agrees with independent proof, such as a statement, a count or a schedule. It is wider than a bank reconciliation, which covers cash only.
Balance sheet accounts never reset. In a double-entry system, asset, liability and net worth accounts stay open permanently, while income and expense accounts close each year (IRS Publication 583, Starting a Business and Keeping Records). An error left on the balance sheet therefore carries forward until someone finds it.
The proof for each account
For a small business, most of the proof sits with the client or a third party. Knowing who holds each document tells you what to request before the close.
| Account | Proof of the balance | Who holds it | How often |
|---|---|---|---|
| Checking and savings | Bank statement ending balance | Client, from the bank | Monthly |
| Petty cash | Count sheet signed by the custodian, plus slips | Client | Monthly or quarterly |
| Credit cards | Card statement closing balance | Client, from the issuer | Monthly |
| Processor clearing | Processor balance or payout report | Client’s processor account | Monthly |
| Accounts receivable | Aging report equal to the ledger | Your books | Monthly |
| Inventory | Count or valuation report | Client | Quarterly or yearly |
| Prepaid expenses | Prepaid schedule balance | Your workpapers | Monthly |
| Fixed assets | Fixed asset register, purchase invoices | Your workpapers and the client | Monthly |
| Security deposits | Lease or deposit receipt | Client | Yearly |
| Accounts payable | Aging report, vendor statements | Your books and vendors | Monthly |
| Payroll liabilities | Payroll provider tax liability report | Client’s payroll provider | Monthly |
| Sales tax payable | Sales tax return or liability report | Client or your files | Each filing period |
| Loans and lines of credit | Lender statement principal | Client, from the lender | Monthly |
| Owner and shareholder loans | Signed note or owner confirmation | Client | Quarterly |
| Equity and retained earnings | Prior year-end balance plus activity | Your workpapers | Monthly review |
Cash, cards and loans
Start with cash because the rest depends on it. IRS Publication 583 explains that a statement can differ from the books because of bank charges not yet entered, or deposits and checks that had not cleared by the statement date (IRS Publication 583, Starting a Business and Keeping Records). Those are your reconciling items, and each one should clear within a month or two.
A card’s statement closes on its own date, rarely the last day of the month. Reconcile to the statement, then list the charges between its closing date and month-end as reconciling items. The bank reconciliation template has the layout for both.
For loans, the lender statement gives the principal still owed. Match it, and move any difference to interest expense, which the bank feed often mixes into principal.
Accounts with no outside statement
Prepaids, accruals, deferred revenue and fixed assets have no bank to confirm them. Their proof is a schedule you keep, and the reconciliation checks that the schedule total equals the ledger.
Accruals come from an accrual worksheet with each line reversing next month. Prepaids come from the prepaid expenses schedule. Under an accrual method, an expense belongs in the books when the all-events test is met and economic performance has occurred (IRS Publication 538, Accounting Periods and Methods), which is what those schedules track.
Payroll liabilities are a special case. The balance should equal taxes withheld and owed but not yet deposited. For a monthly depositor, employment taxes on a month’s payments are due by the 15th of the next month (IRS Publication 15 (Circular E), Employer’s Tax Guide), so its month-end balance is usually one month of withholding and employer tax. A semiweekly depositor pays within days of each payday (IRS Publication 15 (Circular E), Employer’s Tax Guide), so its balance should be much smaller.
What each workpaper should show
A reconciling item is a specific, explained difference between the ledger and the proof, such as a check written but not yet cashed. A workpaper lists them one by one, never as a single lump.
Every account’s workpaper should show the same fields, so a reviewer can read any of them in seconds.
- Account name and number, and the period-end date.
- Ledger balance and proof balance, with the proof document named.
- Each reconciling item, with a date and a one-line explanation.
- Remaining difference, which should be zero or under the firm’s tolerance.
- Preparer, date prepared, reviewer and date reviewed.
When a difference will not clear
A tolerance is a dollar amount below which a difference is documented and carried rather than chased. Above it, the account is not signed off until the difference is explained.
Do not post an unexplained difference to a suspense account and call the account reconciled. Write a note, send the client a specific question, for example about a deposit you cannot match, and keep the account on the open list until the answer arrives.
Questions people ask
Which balance sheet accounts must be reconciled every month?
At least cash, credit cards, loans, receivables, payables and payroll liabilities. Accounts that move less, such as security deposits or inventory for a small client, can be checked quarterly or yearly.
How do I reconcile an account that has no statement?
Keep a schedule for it, such as a prepaid schedule, an accrual worksheet or a fixed asset register, and check that the schedule total equals the ledger balance.
Is a balance sheet reconciliation the same as a bank reconciliation?
No. A bank reconciliation is one part of it. The balance sheet reconciliation covers every asset, liability and equity account, each with its own proof.
Is there a balance sheet reconciliation checklist template in Excel?
Yes. The checklist on this page downloads as Excel, Word or PDF, with one line per account type and the proof document it needs.
Sources
- IRS Publication 583, Starting a Business and Keeping Records: Asset, liability and net worth accounts stay open while income and expense accounts close each year; bank statements can differ from the books by charges and uncleared items.
- IRS Publication 538, Accounting Periods and Methods: Under an accrual method, an expense is taken when the all-events test is met and economic performance has occurred.
- IRS Publication 15 (Circular E), Employer’s Tax Guide: Under the monthly deposit schedule, employment taxes on payments made during a month are deposited by the 15th day of the following month; semiweekly depositors deposit by the Wednesday or Friday after each payday.
About the author
Arthur Teboul (Founder, DokuTrak) is building DokuTrak after watching professionals lose hours chasing clients for documents over email. Arthur Teboul.
Editorial standards
How this page was made (methodology): it is built from the primary sources listed under Sources, and every rule and figure on it links to the source it comes from. Last updated October 25, 2026. Spotted an error or a rule that changed? Contact us.
Ask once. DokuTrak does the chasing.
- Your client uploads from one link, with no account and no password.
- Reminders go out on a schedule, by default 2, 5, 10 and 14 days after the request, until the file arrives.
- With AI review switched on in your workspace (it is off by default), each upload gets a first pass that flags a file that is not the requested document or an unreadable or blurry scan. It says so when it is not sure.
- You accept every file or mark it for re-upload, and your client gets the note by email. The AI never accepts a file.