Balance sheet reconciliation is the process of matching each balance sheet account against its supporting records, such as bank statements, vendor ledgers or physical stock counts, to confirm the recorded balance is accurate before it is reported. For a small business, this usually means checking cash, receivables, payables and inventory on a set schedule rather than only at year's end.
The method used depends on the account. A cash account needs to be checked against a bank statement. A receivables account needs to be checked against customer invoices and payments. Choosing the right method for each account is what keeps errors from carrying forward into the financial statements.
What are the most common balance sheet reconciliation methods?
Small businesses generally use a mix of these methods, applied to different accounts rather than a single method for the whole balance sheet.
- Bank reconciliation. Matches the cash book against the bank statement to catch missed entries, bank charges, or timing differences between when a cheque is issued and when it clears.
- Accounts receivable reconciliation. Matches the receivables ledger against individual customer invoices and payments received, to confirm that the outstanding balance for each customer is correct.
- Accounts payable reconciliation. Matches the payables ledger against vendor invoices and payments made, so the business does not overpay or miss a due payment.
- Inventory reconciliation. Matches the recorded stock quantity and value against a physical count, which surfaces shrinkage, damage or data entry errors.
- Fixed asset reconciliation. Matches the asset register against the general ledger and physical verification, accounting for depreciation and any disposals.
- Intercompany or three way reconciliation. Used where a business deals with related entities or needs to match a purchase order, goods receipt and invoice before payment is released.
How do you perform a balance sheet reconciliation?
The process is largely the same across account types, even though the supporting documents differ.
- Pull the account balance from the general ledger as of the reconciliation date.
- Gather the supporting records, such as the bank statement, vendor statements, or a physical stock count sheet.
- Compare the two figures line by line, not just the closing totals, so timing differences are not mistaken for errors.
- List every discrepancy, noting whether it is a timing difference (a cheque not yet cleared), a recording error (wrong amount entered), or a genuine loss (stock shrinkage).
- Adjust the books where the discrepancy is a genuine error, and document why. Timing differences do not need an adjustment, only tracking until they clear.
- Sign off the reconciliation with the date and the name of the person who performed it, so there is a record for audit or review.
Doing this on a fixed monthly schedule, rather than only before filing returns or closing the year, means errors get caught while they are still small and easy to trace back to their source.
What common mistakes should small businesses avoid during reconciliation?
A few recurring mistakes account for most of the reconciliation errors small businesses run into.
- Reconciling only the cash account. Receivables, payables and inventory carry just as much risk of error, but often get checked far less often, if at all.
- Comparing closing balances only. Two accounts can show the same closing total while individual entries are wrong in offsetting ways. Line by line comparison is what actually catches errors.
- Treating every discrepancy as an error. Timing differences are normal and do not need correction, only tracking. Adjusting the books for a timing difference creates a new error.
- Skipping documentation. Without a note on why an adjustment was made, the same discrepancy can get investigated and corrected twice, or missed by whoever reviews the books next.
- Reconciling too infrequently. Waiting until year end to reconcile means a full year of transactions has to be checked at once, making it harder to trace where an error started.
Conclusion
A balance sheet is only as reliable as the reconciliations behind it. Matching each account to its supporting records on a regular schedule, rather than only when a return is due, is what keeps discrepancies small and traceable. For businesses managing this manually across spreadsheets, the process is often where errors slip through simply due to the volume of entries involved. TallyPrime's ledger and bank reconciliation tools let a business match entries against bank statements and vendor records within the same system used to record transactions, which removes a step where manual copying often introduces mistakes.
