There is a financial task that most South African business owners know they should do regularly. However they more often than not postpone and sometimes avoid entirely. Until a problem makes them do it.
The Bank Reconciliation
This task sits somewhere between necessary and mind numbing of many business owners, hence why it is one of the most commonly neglected bookkeeping functions.
That neglect is costly. An unreconciled bank account is an unreliable bank account. it is not complete or accurate. Every management report, every VAT return, every cash flow forecast that draws on unreconciled data is wrong. It is having a shaky and incomplete foundation for a 3 story building and having a meeting on the top floor.
Wrong financial data, lead to bad decisions.
So lets find out EXACTLY what a bank reconciliation actually is, why it matters so much and how Xero makes it significantly faster and more reliable than any manual process (and a few digital ones too).
What bank reconciliation actually is
Bank reconciliation is the process of matching the transactions in your accounting system to the transactions on your bank statement, confirming that both records agree and identifying any differences.
Every rand that appears on your bank statement should have a corresponding entry in your Xero account. Every entry in Xero should be supported by an actual bank transaction. When the two sets of records match exactly, your books are reconciled. When they do not, something requires investigation.
The output of a completed bank reconciliation is a Xero account balance that matches your actual bank statement balance. This is the foundation on which every other financial report depends. If this number is wrong, everything built on top of it is also wrong.
Bank reconciliation is not a bureaucratic chore. It is the quality control check that ensures every financial report you read is based on accurate data. Skip it, and your management accounts are built on sand.
Why unreconciled books cause specific problems for SA SMEs
For South African businesses specifically, unreconciled books create three categories of risk.
VAT errors. Your VAT201 return to SARS must reflect the correct output and input VAT for the period. If transactions are missing, duplicated or miscategorised in your Xero account, your VAT return will be incorrect. SARS does not accept ignorance as a defence. Interest and penalties apply regardless of intent.
Inaccurate management accounts. The income statement, balance sheet and cash flow statement you review each month are only as accurate as the underlying bank data. An unreconciled account may be missing invoices that were paid, including payments that were never captured or double-counting transactions that appeared twice. Each of these distorts your view of your business.
Audit and due diligence risk. If your business is ever subject to a SARS audit, a bank financing application or a business sale process, your financial records will be scrutinised. Unreconciled books raise immediate questions about the reliability of your financial management, and the remediation work required is both costly and time-consuming.
How Xero bank reconciliation works
Xero’s bank reconciliation process works as follows: your live bank feed imports transactions from your SA bank account automatically, usually within 24 hours. Each imported transaction appears in your reconciliation queue. You match each transaction to an existing entry in Xero (an invoice, a bill, a spend money or receive money transaction) or you create a new entry directly from the transaction.
When a transaction is matched and confirmed, it moves from the reconciliation queue to your reconciled transaction history. When all transactions in the queue are addressed, your account is fully reconciled for that period.
| 1 | Open Xero and go to Accounting then Bank Accounts | Select the bank account you want to reconcile. You will see your current reconciliation queue. |
| 2 | Review each imported transaction | For each transaction, Xero will suggest a match based on amount, date and payee. Review the suggestion. If it is correct, accept it. If not, search for the correct match or create a new transaction. |
| 3 | Categorise new transactions | For transactions with no match (new spend, unrecorded income), create a new entry directly from the transaction. Assign the correct account code, tax rate and description. |
| 4 | Handle recurring transactions with rules | For transactions that recur monthly (bank charges, subscriptions, payroll), set up a bank rule in Xero. The rule will automatically categorise and code the transaction every time it appears, eliminating repetitive manual work. |
| 5 | Reconcile to zero | Work through the queue until every transaction is matched or coded. When the queue is empty and your Xero balance matches your bank statement, reconciliation is complete. |
| 6 | Investigate discrepancies | If your Xero balance does not match your bank statement after reconciliation, there is an error somewhere. Common causes include duplicate entries, transactions posted to the wrong date and missing transactions. Do not leave discrepancies unresolved. |
How often should you reconcile?
The honest answer is: as often as possible. Weekly reconciliation is the minimum standard for a business with active cash flow. Daily reconciliation, which Xero’s bank feed makes genuinely feasible, is the gold standard.
The longer you leave reconciliation, the more transactions accumulate in your queue and the harder it becomes to resolve discrepancies accurately. A transaction from eight weeks ago is much harder to investigate than one from yesterday.
At BCAS we provide ongoing bookkeeping for all our clients, which includes weekly reconciliation as a standard service. This is what keeps their Xero accounts current, their management reports accurate and their VAT returns reliable. It is also what makes the monthly management accounts conversation meaningful, because the numbers we are discussing are correct.
The frequency of your bank reconciliation directly determines the reliability of every financial decision you make. Weekly is the minimum. If you are making daily operational decisions based on your cash position, reconcile daily.
Common reconciliation errors and how to fix them
| Common error | How to fix it |
| Duplicate transaction | Delete the duplicate entry. Check whether it was caused by a manual capture alongside an automatic bank feed import. Set up a bank rule to prevent recurrence. |
| Transaction posted to wrong period | Use the Xero transaction history to find and recode the entry to the correct date. This affects period-specific reports so it is important to correct promptly. |
| Missing transaction | Check whether the bank feed has a gap. If the feed has disconnected, reconnect it and import the missing period manually. If the transaction was simply not captured, create it. |
| Incorrect account code | Edit the transaction and assign the correct account code. If this transaction type recurs, update or create a bank rule. |
| Balance does not reconcile after all transactions matched | Check for a transaction in Xero that does not have a bank feed counterpart. This is usually a manually entered transaction that was never actually banked. |
A bank reconciliation is not exciting. But it is foundational. Every insight from your Xero dashboard, every management account, every VAT return and every business decision you make based on financial data depends on your reconciliation being current and correct.
In the next post we move to the PCP Method and look at what a purpose-driven business actually looks like in practice, using composite examples drawn from the kinds of businesses we work with at BCAS.
Want your Xero account reconciled weekly and your books kept current without lifting a finger? Book a free discovery call with BC Accounting Services at bcas.co.za to find out about our bookkeeping service.
About the author
Bruce is the founder of BC Accounting Services (BCAS), a Xero Silver Partner and Certified Adviser based in South Africa. He works with SME owners and growing businesses to build financial clarity, strategic direction and measurable performance through the PCP Method: Purpose, Clarity, Performance.
bcas.co.za #bcaccounting #purposedrivenbusiness #purposeclarityperformance