Reconcile your business bank account with your books using this free Excel bank reconciliation template for Kenyan SMEs and identify unexplained differences.
Your bookkeeping records and bank statement should ultimately tell the same financial story—but timing differences, bank charges, missing transactions and recording errors can cause the balances to differ.
The FedhaTrac Bank Reconciliation Template helps you systematically compare the bank statement balance against your cashbook or bookkeeping balance.
Record outstanding deposits, unpresented payments, bank charges, interest and other reconciling items. The workbook automatically calculates the adjusted bank balance, adjusted book balance and remaining reconciliation difference.
A difference that does not reduce to zero is an indication that something still needs to be investigated.
