How to Do Bank Reconciliation: A Step-by-Step Guide

If your Xero bank balance has been wrong from the start, every subsequent reconciliation will show a persistent discrepancy. Duplicates happen when bank feeds overlap with manual imports, or when a bank feed resends historical transactions after a reconnection. Filter the trial balance or general ledger for these accounts and recode anything that’s sitting there. Run a transaction report for each account code that receives auto-applied transactions and scan for anything that looks wrong. It’s significantly faster than reconciling one at a time when you have dozens of similar transactions (e.g., thirty days of card terminal deposits all going to “Sales”). On the reconciliation screen, click the Transfer tab and select the other bank account.

Individuals and businesses with simple accounting needs should consider reconciling their accounts monthly after receiving a bank statement. A bank reconciliation statement allows companies and auditors to verify the accuracy of financial records and compare these records with bank account balances. A bank reconciliation statement is a summary of recent banking activity that is used to reconcile personal or business records against the bank’s record of transactions. A bank reconciliation statement is a document that accounting principles explained: how they work gaap ifrs tracks and explains the differences between your bank statement and internal financial records. Ultimately, bank reconciliation is a relatively straightforward accounting process that is essential for understanding a company’s cash position.

Mistake 3: No Close Checklist

It can take a long time to figure out mismatches. Or it could be a transaction that you forgot to enter. This is why you’re doing bank rec, and there’s often a straightforward explanation.

• Reconciling your bank statements is key to keeping your business’s finances accurate.
• Next, update your records to reflect the outstanding checks by deducting their total amount from your bank balance.
• Automation doesn’t eliminate the need for human oversight, but it dramatically reduces the time spent on routine matching and calculation.
• This process reviews the opening balance, the sequence and accuracy of all transactions, and concludes with the closing balance.
• The case of Enron Corporation exemplifies how bank reconciliation is used to identify the fraudulent activities in the company.

Why does my Xero bank reconciliation not balance?

Once you’ve gone through and matched each transaction, compare the final closing balance on the bank statement to your account. Tick each transaction on the ledger that matches the transactions on your bank statement (tick the ones on the bank statement too) and highlight or make a note of any differences on both documents that need to be sorted. Your tax accountant will want to check the accuracy of your cashbook by viewing your final bank statement and reconciliation statementfor the end of the year. Learn everything you need to know about bank reconciliation statements for a business – how to do them and how often. From there, compare the new, adjusted cash balances of your bank account to your accounting records.

After reviewing all deposits and withdrawals, adjusting the cash balance and accounting for interest and fees, your ledger’s ending balance should match the bank statement balance. Before sitting down to reconcile your business and bank records, gather your company ledger and the current and previous bank statements. Bank reconciliation statements can help identify accounting errors, discrepancies and fraud. A bank reconciliation statement is a document prepared by a company that shows its recorded bank account balance matches the balance the bank lists. Bank statements are commonly routinely produced by the financial institution and used by account holders to perform their bank reconciliations. The main purpose of bank reconciliation is to confirm that your business’s financial records are both accurate and complete.

Make the necessary adjustments to the bank statement for errors or missing transactions. Your bank statement and financial records contain your opening and closing balances for the month. To overcome bank reconciliation problems, you can utilize automation solutions to carry out the process for your business any time you wish to run it. From bank reconciliations to balance sheet reconciliations, the various types of financial reconciliations are not going anywhere any time soon.

Financial reconciliation is more than fixing mistakes. Tools like AI-driven platforms cut down on manual work and speed up the process. They also make sure your financial reports are reliable and ready for audits.

Software and System Issues

This systematic check verifies that every dollar entering and leaving your account is accurately reflected in your records. Learn what cash position really represents in 2026, calculations, how it connects to cash flow, and which tools help accounting teams and CFOs maintain visibility. Keep in mind that immaterial accounts with unusual activity or fraud indicators will warrant more frequent attention, regardless of their balance size. At scale, high-volume or high-risk accounts benefit from weekly or daily reconciliation, while lower-volume accounts may require only monthly reconciliation. The reconciliation should create a clear audit trail showing how book and bank balances tie out. Leading organizations are moving beyond periodic reconciliation toward continuous monitoring that identifies and resolves discrepancies daily or even in real-time.

Regular bank reconciliation isn’t just good accounting practice—it’s a powerful tool that safeguards your business’s financial integrity and drives smarter decision-making. When these records don’t match – and they often don’t due to timing differences and pending transactions – bank reconciliation helps explain why. This significantly reduces the effort that goes into the reconciliation process and enables businesses to verify their cash balances anytime throughout the month. After all reconciliation adjustments, the final correct cash balance captured in the company accounting records and on its balance sheet as at 30 September 20XX was $2,000. The final balance on the bank reconciliation statement, after all corrections and adjustments, is the actual “true” cash balance reported in the company’s balance sheet.

Why Are Bank Reconciliations Important?

Reach out to us now for streamlined financial excellence and expert bank reconciliation. ‍Invensis, a premier finance and accounting services company with over two decades of expertise, excels in comprehensive financial solutions. Deposits in transit present a significant factor in the bank reconciliation process.

Here’s how to approach increasingly sophisticated reconciliation scenarios. Don’t wait until audit season to organize your reconciliation documentation. Periodic quality reviews—whether by internal audit, Controllers, or external firms—identify process weaknesses before they become audit findings. Document these protocols so your team applies consistent judgment across all reconciliations. For example, differences under $100 might be investigated only if they appear repeatedly, while variances over $10,000 demand immediate explanation and resolution. Define clear materiality thresholds that determine when differences require investigation versus when they can be written off or carried forward.

If you have a multi-currency bank account or your bank feed includes foreign currency transactions, Xero handles the conversion automatically using its built-in exchange rates. Sometimes a single bank line covers expenses that belong to different accounts. When Xero finds an existing transaction that matches a bank statement line – same amount, similar date, plausible description – it shows a green “OK” button. The reconciliation screen shows bank statement lines on the left and Xero’s matching options on the right. You’ll see each connected bank account with a number in a blue badge – that’s the count of transactions waiting to be reconciled.

Proper preparation sets the foundation for an efficient and accurate bank reconciliation. This appears on your bank statement but hasn’t been recorded in your books, making your book balance appear higher than it is. Example – You deposited $2,000 in cash on March 31, but since it was made after the bank’s cutoff time, it won’t appear until your April statement.

• Check the coding on auto-applied rules by running a transaction report filtered by the target account – if anything looks out of place, the rule needs tightening or removing.
• For example, employees may exploit loopholes in the internal control of a company to their advantage.
• Manage complex financials, inventory, payroll and more in one secure platform.
• Bank reconciliation serves as your financial watchdog, catching discrepancies before they impact your bottom line.
• This step matters because it makes outsourcing accounting tasks to virtual assistants measurable.
• Link your banking systems with your accounting software using APIs or cloud tools.

Make sure each deposit appears as income in your accounts. Some accounting software will pull in bills and receipts with the help of data capture tools and extract the data automatically. This might be in a logbook, on a spreadsheet, or in an accounting software package. Bank reconciliation happens when you compare your record of sales and expenses against the record your bank has.

This information is only accurate at the time of publication. It does not constitute legal, financial, or other professional advice and should not be relied upon as a statement of law, policy or advice. But catching theft, embezzlement, and other forms of fraud are also some of the main reasons for reconciling accounts in the first place.