Bank reconciliation and accounts payable and receivable
Bank reconciliation means checking every transaction in your accounting software against your bank statement, so the two balances match. Accounts payable and receivable management makes sure what you owe suppliers, and what customers owe you, is accurate. I handle both in QuickBooks Online and Xero, every month or as part of a cleanup.
Why does bank reconciliation matter?
If your bank balance in QuickBooks doesn't match the statement, nothing built on top of it can be trusted. That includes your profit and loss statement, your cash position and your tax figures. Reconciliation catches duplicate entries, missing transactions and bank errors while they are still easy to fix.
Common reconciliation problems I fix
- The opening balance no longer matches the statement because a past reconciled transaction was edited or deleted
- Duplicate transactions created when bank feed items were added instead of matched
- Transfers between your own accounts recorded on one side only
- Customer payments not matched to their invoices
- Old uncleared items carried forward month after month
What AP/AR management includes
- Matching customer payments to the right invoices
- Matching supplier payments to the right bills
- Clearing unapplied payments and credits
- Correcting aging reports so they show only real balances
- Checking supplier statements against recorded bills
How often should you reconcile?
At least once a month, as soon as your statements arrive. Businesses with high transaction volumes often reconcile weekly. The longer you wait, the harder it is to trace a difference.
Results from real work
For one client, 224 sales invoices had been posted to receivables instead of the bank. I cleared the resulting $84K false balance (case study 2). For an immigration firm, I invoiced 33 signed client agreements so each client's dues became visible (case study 5).
What you'll receive
Reconciliation reports for every account
Corrected accounts receivable and payable aging reports
A list of items that need your decision
Pricing
Reconciliation is included in every monthly package: 2 accounts on Essentials, 5 on Growth and 8 on Full Service. AP/AR tracking starts on the Growth package ($750/month). Past months are covered by the cleanup packages, from $500. See all packages.
Software I use
- QuickBooks Online
- Xero
- Microsoft Excel
How we'll work together
Review
I review your file and list every issue.
Scope
You get a clear plan, timeline and price.
Fix
I clean up, reconcile and document every adjustment.
Hand over
You receive reconciled books, reports and a summary.
Maintain
Optional monthly bookkeeping keeps the backlog from returning.
Frequently asked questions
Can you reconcile past months?
Yes, as part of a cleanup project.
What if my accounts were reconciled wrongly before?
I find where the balances first went wrong and correct them with documented entries.
Do you need my online banking login?
No. Your bank statements and access to your accounting file are enough.
Let's get your books in order.
Tell me where your books stand today. I'll reply within a few hours with a clear next step.