Money Matters

Step-by-step balance sheet reconciliation (with examples and best practices)

Discover the essential steps, examples and how to do balance sheet reconciliation. Maintain financial integrity with our comprehensive reconciliation guide.

9 April, 202611 min read Share

---

Key takeaways

• Balance sheet reconciliation verifies financial accuracy by comparing balances for assets, liabilities, and equity against supporting documentation to confirm they are correct and properly recorded.
• It helps detect errors, discrepancies, and potential fraud early, including issues caused by timing differences, manual entry mistakes, or system errors.
• Regular reconciliation improves the reliability of financial reporting, ensuring that transactions are correctly classified and financial statements reflect the true position of the business.
• Accurate reconciliations support better decision-making, giving stakeholders confidence in the financial data used to plan, manage cash flow, and assess performance.

---

Balance sheet reconciliation is the process of verifying that the balances in your balance sheet match the supporting documents used to record them.

It ensures your financial statements are accurate, complete, and based on reliable data.

It’s a means of double-checking your accounts to catch errors early and prevent bigger problems down the road. 

This guide explains what balance sheet reconciliation is, why it matters, and how to carry it out effectively.

See how this fundamental process gives you a solid foundation for keeping your business on track. 

Here’s what we’ll cover: 

What is balance sheet reconciliation? 

Balance sheet reconciliation involves comparing the balances of assets, liabilities, and equity with supporting documentation to confirm they are accurate and complete.

Discrepancies in a balance sheet can arise from several sources, including:

• Timing differences between recorded transactions
• Data entry errors
• System errors or software issues
• Fraud or unauthorised transactions

Comparing balances with supporting documents helps you identify and resolve discrepancies early, typically as part of your monthly or quarterly close.

Reconciliation ensures your financial records are correctly classified and supported, improving overall reliability.

How balance sheet reconciliation works?

The balance sheet reconciliation process typically involves:

• Comparing ledger balances with supporting documents
• Identifying discrepancies or mismatches
• Investigating and explaining differences
• Adjusting entries where required
• Documenting and reviewing final balances

Why is balance sheet account reconciliation important? 

As balance sheet reconciliation improves the reliability of your financial records, you can benefit from: 

Accuracy 

Meaning the numbers in your balance sheet truly reflect your company’s financial position and cash flow. 

Reconciliation helps ensure all transactions are correctly recorded and categorised. 

Free of fraudulent input and errors 

Safeguarding your assets and ensuring the accuracy and integrity of your financial records. 

Trustworthiness 

Meaning you can be confident in the financial story your records tell and the business insights you can draw from them. 

You know you are making sound business decisions based on reliable information. 

Internal control and corporate governance 

Identifying weaknesses in your accounting procedures and internal controls allows you to implement improvements that can help you prevent future errors and potential fraud. 

Effective cash flow management 

Balance sheet reconciliation provides a broad overview of all assets and liabilities, including accounts receivable (trade debtors) and accounts payable (trade creditors). 

These directly impact your cash flow, and a clear understanding of them sets the stage for effective cash flow forecasting and management. 

Beyond these practical points, reconciliation means your records seal your reputation with lenders and investors. 

Regular reconciliation builds trust with stakeholders and ensures compliance with HMRC reporting requirements and UK accounting standards, helping you avoid regulatory penalties. 

Balance sheet reconciliation checklist

Performing balance sheet reconciliation is clearly good practice. 

However, a consolidated balance sheet can involve a lot of documentation, with ample opportunity for mistakes. 

Follow these steps for a fail-safe reconciliation process: 

1. Identify balance sheet accounts 

First, be sure that all relevant account ledgers are represented in your balance sheet. 

The primary components include your assets, liabilities, and equity statements. 

However, other common examples are cash, accounts receivable, and loan ledgers. List them all before you begin. 

2. Gather important documents 

The supporting documents you need to verify each ledger include: 

• Bank statements for the cash account 

• Invoices and customer records to support accounts receivable 

• Supplier statements, credit card statements, and purchase orders backing up accounts payable 

• Fixed asset registers covering property and equipment 

• Inventory records outlining all stock 

• Contracts with suppliers confirming your prepaid and recurring expenses 

• Expense reports that detail your accrued liabilities 

• Shareholder records that list ownership in equity account 

3. Verify that all accounts balance 

This is a high-level comparison where you check that the ending balance for each account in your general ledger matches the total shown in your supporting documents. 

For example, check that the cash balance in your ledger tallies with the ending balance on your bank statement. 

You do this for all balance sheet accounts to get an initial overview. 

4. Reconcile balance sheet accounts 

This is the core of the process, where you compare each account line by line, in much more detail than when simply verifying the final balances. 

For example, you match individual debits and credits in your ledger to the corresponding items on your supporting documents. 

Any difference between the general ledger and the supporting documentation is referred to as a “reconciling item”, which is the formal term for flagging issues. 

Here’s how it looks for the main accounts in a typical balance sheet. 

Reconcile cash accounts 

Check that all bank deposits and withdrawals in your bank statements match the cash receipts and disbursements recorded in the cash ledger. 

Look for outstanding cheques (payments you’ve made that the recipient hasn’t cashed yet) or deposits in transit (money you’ve deposited that the bank hasn’t recorded yet). 

Reconcile AR 

Ensure your accounts receivable records match what customers owe by checking customer payments against outstanding invoices. 

Investigate past-due amounts and follow up on any discrepancies found. 

Reconcile AP 

You should have a supplier statement for every payable recorded. 

Verify that all invoices are accounted for in the accounts payable ledger. Investigate any differences or missing invoices. 

Ensure you are paying the correct amounts. 

Reconcile fixed assets 

Ensure all purchases and disposals are recorded and accompanied by depreciation calculations. 

Verify that these calculations are correct based on the asset’s useful life and the depreciation method used. 

Physically verify assets periodically, where practicable, in line with internal control guidance to confirm their existence and condition. 

Reconcile inventory 

Compare physical inventory counts with your inventory records. 

Investigate any discrepancies or shrinkage (loss of inventory due to theft, damage, or obsolescence). 

Use inventory costing methods, such as FIFO (First In First Out), consistently in accordance with UK accounting standards to value your inventory. 

Reconcile prepaid expenses 

Prepaid accounts include items such as insurance or rent that you’ve paid in advance. 

Ensure the expense amortisation schedule is accurate and verify that expenses are recognised in the same periods in which the benefit was received. 

Reconcile accrued liabilities 

Accrued liabilities are expenses your company has incurred but hasn’t paid yet. 

Estimate these liabilities and verify against supporting documentation, such as payroll records for wages payable and HMRC guidance for taxes due. 

Ensure the amounts are reasonable and fully supported by appropriate documentation in line with UK accounting standards. 

It helps to review these calculations regularly so you can be sure which elements are required and that they’re accurately estimated. 

Reconcile equity accounts 

Transactions affecting equity include owner contributions or dividends. 

Ensure all changes are properly documented with supporting documentation, such as share certificates or board meeting minutes. 

Check that these same figures are reflected accurately in the shareholder records. 

5. Investigate discrepancies 

When balances don’t match, find out why as soon as possible. 

Trace every difference back to its origin. 

It could be a data entry error, a missing transaction, or even fraudulent manipulation of the data. 

6. Update your general ledger 

Once you find errors, identify the source of truth (most likely the earliest document in the chain of events) and correct your general ledger accordingly. 

Make journal entries to indicate where you have adjusted the balances, documenting all relevant details. 

Appropriate details include the date, the accounts affected, the reason for the adjustment, and where to find the supporting documentation. 

This creates a clear audit trail. 

7. Review and approve 

Finally, if possible, have a second person review and approve all reconciliations. 

This added oversight greatly reduces the chance of unresolved discrepancies surviving the process. 

Balance sheet reconciliation example 

Let’s use the cash account as the scenario for a reconciliation example. Imagine your bank statement shows a balance of €10,200 at the end of the month, but the cash account in your general ledger says €10,500.  
 
You need to work out why your internal system is up €300. 

You scan through the cash ledger and find that a €300 deposit was indeed actioned and recorded. 

Most likely, the bank hasn’t processed it yet. 

This deposit is a reconciling item, which you would note as a “deposit in transit” on your cash reconciliation. Your reconciled cash balance will now match. 

Here’s what it looks like in a reconciliation document for this month: 

	GL cash ledger	Bank statement
Sales	€12,000	€12,000 deposited
Salaries	€2,000	€2,000 withdrawn
Sale on credit	€300	–
Dividend	€200	€200 deposited
Balance	€10,500	€10,200
Difference		€300
Reconciling item		Deposit in transit €300
Reconciled balance		€10,500

Challenges when reconciling balance sheet accounts 

Being a complex operation involving many documents, there are several challenges that can arise during a balance sheet reconciliation. 

Here are the most common ones. 

High transaction volumes 

These could catch you by surprise when your business grows or during seasonal peaks. 

Reconciliation is time-consuming, but managing and matching numerous transactions greatly adds to the load. 

Missing documentation 

If invoices, receipts, or other supporting documents are lost or misplaced, it’s very difficult to verify the balances in your accounts. 

You may need to contact the other party in affected transactions to obtain copies of the documentation. 

Data entry errors 

If you use a traditional filing system and paper records, human error is always a risk. 

Mistakes made when entering financial data into your accounting system will show up during reconciliation. 

However, they result in lost time that could have been avoided. 

Data in disconnected silos 

Compiling data from different sources is not only time-consuming but also presents the challenge of harmonising data recorded in different formats. 

Timing differences between records 

All your transactions involve two parties, each with different workloads and processes. 

This means that one party might record a transaction at a different time than the other. 

For example, a payment you send might not clear the recipient’s bank until the next day. 

Lack of proper procedures 

Without clear guidelines and standardised internal controls, your reconciliation process can become inefficient, and inconsistencies may be overlooked. 

Balance sheet reconciliation best practices 

Concerned about those challenges? 

Fear not—there’s a lot you can do to make your reconciliation go smoothly. 

Try these basic tips: 

Establish a regular reconciliation schedule 

When transaction volume is high, perform cash account reconciliations on a daily or weekly basis. 

This helps catch discrepancies quickly, preventing errors from snowballing through the rest of the accounting process. 

Monthly reconciliation is typically sufficient for other balance sheet accounts. 

Use a consistent reconciliation format 

Having a standard template or method for your reconciliations makes the process easier to follow and review. 
 
By following a standardised process, you and your staff will learn to spot deviations more easily, whilst also improving the general efficiency of the process. 
 
This consistency ensures thoroughness and accuracy across all account reconciliations. 

Keep clear and organised documentation 

Maintaining well-organised supporting documents for all transactions is crucial for efficient reconciliation. 

This makes it easier to trace and verify account balances, saving time when investigating discrepancies. 

Segregate duties 

If you have sufficient staff, take steps to divide the workload between different people. 

By preventing one person from controlling everything in the financial process, you reduce the risk of errors and fraud. 

Separating the responsibilities for recording transactions, reconciling accounts, and approving adjustments adds to your system of checks and balances. 

Regularly review procedures and assess risk 

Periodically reviewing your balance sheet reconciliation procedures and conducting a thorough risk assessment can significantly boost the efficiency and accuracy of this operation. 

This lets you identify potential bottlenecks and unnecessary steps, whilst pinpointing accounts that are inherently higher risk. 

With that information, you can focus your reconciliation efforts where they are most needed and potentially identify discrepancies more quickly. 

Regularly updating your processes based on these reviews ensures continuous improvement and more reliable financial statements. 

Invest in accounting software to automate tasks 

Specialised software with features like bank feeds and automated matching can significantly streamline the balance sheet reconciliation process. 

Going through balance sheets line by line is hugely time-consuming and drains your mental resources. 

By using software to reduce manual effort, you don’t just speed up the process; you also minimise data entry errors. 

These solutions often come with pre-configured workflows to simplify comparisons and identify discrepancies. 

Cloud-based solutions have the advantage of real-time updates and built-in communication tools. 

By facilitating collaboration, you ensure that all stakeholders are on the same page. 

Making balance sheet reconciliation part of your financial routine 

Regularly reconciling your balance sheet accounts is a proven way to maintain accurate financial records, particularly as your business grows and adds complexity. 

However, reconciliation requires patience and diligence. 

Consistent processes and the use of suitable tools can greatly simplify the task. 

Accounting software takes the effort out of transaction matching, instantly flagging discrepancies as they arise. 
 
Many systems, including Sage, offer built-in reconciliation tools, saving time and improving the efficiency and accuracy of this crucial process. 

Frequently asked questions (FAQs)

Browse more topics from this article

• Bookkeeping