Service

Bank reconciliation and accounts payable and receivable

Opening answer

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 it matters

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.

Problems

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
Scope

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
Frequency

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

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).

Deliverables

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

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.

Tools

Software I use

  • QuickBooks Online
  • Xero
  • Microsoft Excel
Process

How we'll work together

  1. Review

    I review your file and list every issue.

  2. Scope

    You get a clear plan, timeline and price.

  3. Fix

    I clean up, reconcile and document every adjustment.

  4. Hand over

    You receive reconciled books, reports and a summary.

  5. Maintain

    Optional monthly bookkeeping keeps the backlog from returning.

FAQs

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.