Reconciliation
The truth about manual reconciliation: why growing Nigerian businesses are switching
Manual reconciliation feels free. The spreadsheet is open, the accountant knows the routine, and the bank balance eventually agrees. But the cost is real: hours spent ticking lines, books reopened after the close, suspense balances nobody can explain, and a finance team that can't take leave in the first week of the month. As a business adds outlets, terminals and processors, those costs grow faster than the business.
The hours add up
APQC benchmarks, reported by CFO.com in May 2026 (checked November 2026), put the time to reconcile one bank account at about 2.6 hours for top performers, 4 hours at the median and 5 hours or more for the slowest.
Example figures: a company with 6 bank accounts, 2 processors and 4 POS clearing accounts has 12 accounts to reconcile. At 4 hours each, that is 48 hours a month, more than a working week, before anyone reviews a single reconciliation.
Errors that reopen the books
Manual matching depends on someone spotting the right line among hundreds. Miss it, and an item carried forward "to be investigated" turns out three months later to be a posting error, with three months of management accounts wrong. The most quoted survey on this, a 2017 survey of 259 accounting professionals sponsored by a software company, found 3 in 4 had reopened the books after the close to fix errors. It is old, so treat it as a pattern rather than a precise figure.
Fraud hides in unreconciled accounts
The longer an account goes without a proper reconciliation, the easier it is to hide something in it. The ACFE's Occupational Fraud 2026 report estimates that organisations lose 5% of revenue a year to fraud, and the typical scheme ran 12 months before it was found, as Accounting Today reported (checked November 2026). Suspense accounts, clearing accounts and old reconciling items are where small, regular losses sit unnoticed. See the biggest finance leaks in Nigerian businesses.
The spreadsheet lives in one person's head
- Key-person risk: when that person is on leave or resigns, the reconciliation stops or starts again from scratch.
- No audit trail: a spreadsheet shows the answer, not who matched what, when or why.
- No real review: a reviewer signs a printout but can't see which matches were forced or which items were quietly cleared.
Auditors, and for Public Interest Entities the ICFR attestation, ask the same question: can you show the control ran? A spreadsheet makes that hard to prove. See ICFR in Nigeria.
The rules have added work
- Stamp duty on transfers: from 1 January 2026, the ₦50 EMTL was replaced by a ₦50 stamp duty paid by the sender on transfers of ₦10,000 and above, as Nairametrics reported. That is many small debits to explain and book.
- Rev360: WHT credits migrated from TaxPro Max should be reviewed, says a Templars client alert (May 2026). That needs a clean record of WHT deducted by customers.
- E-invoicing: medium taxpayers (₦1bn to ₦5bn turnover) went live on 1 July 2026, according to KPMG's summary of the NRS notice.
Confirm the rules that apply to you with your tax adviser.
Manual reconciliation compared with Brillrec
| Manual (spreadsheets) | Brillrec | |
|---|---|---|
| Statements | Copied or retyped | PDF, Excel or CSV from any Nigerian bank, in the bank's layout; running balance checked line by line |
| Matching | By eye | Automatic by reference, NIP session ID, amount and date, including split and grouped payments; possible duplicates shown side by side, and the next-best line offered when you reject a suggestion |
| POS and processors | Agreed by hand, if at all | Settlement gross less fees, VAT and deductions checked against the bank; Paystack, Flutterwave, Monnify and Squad fees recomputed; bank POS net amount checked each day |
| Charges and stamp duty | Booked in a lump, or missed | Explained in one step and sent to the journal export |
| Open items | A tab nobody reads | Carried forward at sign-off; items over 30 days tracked, with an explanation required as they age |
| Review | A signature on a printout | Preparer, optional approver and reviewer; sign-off can require a reviewer who is not the preparer, and segregation of duties is checked |
| Audit trail | File versions | Tamper-evident audit log and a PDF sign-off pack |
| Controls and close | Separate spreadsheets | One record: sign-off completes the close task and shows the control as operating |
What switching looks like
- Try it on your own month. Start the 14-day trial (every Professional feature, no card). Load last month's statements and ledger for a few accounts and see what matches.
- Connect what you use. QuickBooks, Zoho Books, Sage, Xero and Business Central connect directly; Odoo connects read-only; other ledgers and exports, including SAP, come in by file. Connect Paystack, Flutterwave, Monnify or Squad with read-only keys, and set your own matching rules. Guided setup is available for ₦150,000 one-off, plus VAT.
- Sign off. The preparer and reviewer sign off, which locks the reconciliation; reopening needs a reason and is logged. The month-end checklist tracks the rest.
For a closer comparison, read Excel vs reconciliation software.
How Brillrec helps
Brillrec is the finance operations platform for Nigerian businesses, with three products on one record:
- Reconciliation: bank, POS, processors, wallets, NIBSS NIP reports, investments and client money against the ledger. Clearing and suspense accounts (Professional and above) sign off only when every item is matched or explained.
- Internal Control Automation: a controls register from a Nigerian control library and segregation-of-duties findings on every plan; unusual journal checks on Essential and above; ICFR and the evidence pack on Professional and above.
- Financial Close Management: checklists with Nigerian statutory dates on every plan; balance sheet reconciliations and the WHT tracker on Essential and above.
Bank and processor connections only read, so Brillrec cannot move money. Approved journals can be posted to QuickBooks, Sage, Xero or Business Central on Professional and above. If you have no cash book yet, Brillrec drafts one from the bank statement, with a suggested account for each line, for you to check and post into your own books. An admin can download everything the organisation holds in Brillrec as one zip file, including the original files.
Records are never used to train AI. AI is optional: an admin can switch it off, it never signs off or approves, and every use is logged. It can run in masked mode, which replaces account, BVN, phone and card numbers, emails and dates before anything is sent, and an admin has separate switches for Reconciliation and Close.
Reported by clients: 99% of clients' bank and ledger lines matched automatically in a month; 70% less month-end close time; 50% less audit preparation time; 2.5x finance team productivity. Results depend on your records and how your team works. See client results.
Essential and above include all three products, from ₦75,000 a month plus VAT. See pricing.
Frequently asked questions
What are the risks of manual reconciliation?
Lost hours, errors found after the close, losses hidden in suspense and old reconciling items, dependence on one person, and no reliable record of who matched what.
Is it worth switching for a small business?
For one or two bank accounts, a spreadsheet or your accounting software may be enough. Brillrec's Essential plan covers unlimited accounts and users for ₦75,000 a month plus VAT, for when it isn't.
Can I keep my accounting system?
Yes. Brillrec reads your ledger and reconciles around it. Your books stay where they are.
Start your free 14-day trial, no card needed, or book a 20-minute demo.