Bank & Card Reconciliation

Every bank, card and loan account agreed to its statement on a fixed rhythm, with a standard working paper, a chase list for unexplained items, second-person review and a clean year-end pack.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Bank & Card Reconciliation, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

193

Starter tasks

🧾 Finance & Accounting

Bank & Card Reconciliation

Matching bank, credit card and loan statements to the books, chasing unexplained items and keeping balances provably correct for any size of business.

  1. Register of every account to reconcile
  2. Official statement archive for every account
  3. Agreed starting balance for each account
  4. Bank feed health check
  5. Standard reconciliation working paper
  6. Unreconciled months backlog assessment
  7. Catch-up reconciliation, oldest month first
  8. Reconciliation calendar and owners
  9. Small difference write-off threshold
  10. Weekly bank feed matching session
  11. Monthly bank reconciliation to the statement
  12. Credit card statement reconciliation
  13. Loan and finance balance agreement
  14. Savings and deposit account reconciliation
  15. Outstanding items ageing review
  16. Unexplained items chase list
  17. Second-person reconciliation review
  18. Transfers between your own accounts
  19. Reconciled balance drift check
  20. Reconciliation health log
  21. How a bank reconciliation actually works
  22. Reading a business card statement line by line
  23. Tracking down a reconciliation difference
  24. Statement import overlaps and gaps
  25. Foreign currency account reconciliation
  26. Uncleared, stale and stopped cheques
  27. Undoing a wrong match in the software
  28. Spreadsheet reconciliation for accounts without feeds
  29. Closing dormant accounts and unused cards
  30. Company card statement split by cardholder
  31. Feed balance versus statement balance
  32. Deposits recorded the way the bank shows them
  33. Payment references that make matching easy
  34. Weekly or monthly reconciliation decision
  35. Choosing a matching tool for high volumes
  36. Unexpected bank charges queried
  37. Year-end bank and card reconciliation pack
  38. Switching to a new bank account
  39. Cutover reconciliation when changing software
  40. Replacing a lost or compromised card
  41. Disputing a bank or card error
  42. Freelancer's thirty minute monthly reconciliation
  43. Returned payments and reversals in a tight month
  44. Handing reconciliations to a new team member
  45. Reconciling for a client as an outside bookkeeper
  46. Reconciliation status board for a finance team
  47. Proof of cash four-way reconciliation
  48. Matching rules with tolerances for high-volume accounts
  49. Client money or trust account reconciliation
  50. Sweep and zero-balance account reconciliation

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Register of every account to reconcile

Most reconciliation gaps start with an account nobody remembered: the old savings pot, the fuel card, the second credit card, the equipment loan. Listing every bank, card, loan, overdraft and deposit account the business holds, matched to its ledger account, sets the scope for everything else in this area and shows at once which ones have never been reconciled.

First tasks

  • List every account from your online banking, card portals and lender letters
  • Match each account to its ledger account in the accounting software
  • Flag ledger bank accounts that have no real account behind them
  • Note the last reconciled date for each account in the register
  • Recheck the register for new or closed accounts @recurring(yearly)

Official statement archive for every account

Bank feeds are a convenience, not evidence: they drop transactions, duplicate others and rarely show the closing balance the bank stands behind. Keeping the official monthly statement for each account in one place, with a consistent file name, gives every reconciliation a fixed figure to agree to and gives the accountant or tax authority the proof they will ask for.

First tasks

  • Create one statement folder per account in the register
  • Download the current and last financial year's statements as PDFs
  • Rename each file with account, year and month
  • Request any missing statements from the bank in writing
  • Save every account's new monthly statement into the archive @recurring(monthly:3)

Agreed starting balance for each account

Reconciling forward is impossible until there is one date on which the books and the statement are known to agree. Choosing that date for each account, usually the last year end your accountant signed off, and proving the ledger balance matches the statement on it, means every later difference belongs to a known period instead of the whole history.

First tasks

  • Ask your accountant on which date the books last agreed to the bank
  • Pull the statement balance and ledger balance for that date
  • List and explain any difference between the two figures
  • Save the starting balance and its evidence in each account's folder

Make it yours.

Install Bank & Card Reconciliation, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.