# Bank reconciliation

> Match your bank statement against what's recorded, catch what's missing, and do it monthly so small differences never become a year-long hunt.

Source: https://managestrata.ca/docs/finances/bank-reconciliation

Reconciliation answers one question: **does what we recorded match what the bank actually did?**

Do it every month. A $40 difference found four weeks after it happened is a two-minute fix. Found eleven months later, it's an afternoon.

**Finances → Bank reconciliation**.

## How it works

  1. **Download your bank statement as CSV**

   Every Canadian bank offers this. Choose the period you're reconciling.
  1. **Paste the rows in**

   Copy from the file and paste into the reconciliation box.
  1. **Read the match**

   ManageStrata compares the bank rows against your recorded transactions and
   shows you three groups: matched, on the bank but not recorded, and recorded
   but not on the bank.
  1. **Deal with the unmatched**

   That list is the whole point of the exercise. See below.

> **Comparing saves nothing**
>
> Pasting a statement and reading the match writes nothing to your books. The only
> thing this page ever posts is the bank lines you tick and then **Record these** —
> see below. Nothing is matched off, written off or balanced for you. That's
> deliberate: an automatic reconciliation that quietly creates transactions would
> let a mistake propagate silently.

The box at the top of the page says which of the two CSV screens this is: this one compares and records only **fund** postings, never a payment from an owner. To put receipts against lots, use **Import payments** instead. [Import is not reconciliation →](https://managestrata.ca/docs/finances/opening-balances-and-imports#import-a-run-of-receipts)

The comparison runs against your **whole** fund ledger, not a recent slice of it — a posting the page hadn't loaded would show up as "on the bank, not in ManageStrata", which is a fabricated discrepancy in the one tool whose job is finding real ones. For a very deep ledger that can't be walked in a single pass, the page says so above the results and tells you how much of it was loaded, rather than quietly matching against part of your books.

## Reading the unmatched lists

### On the bank, not in ManageStrata

Money moved and you haven't recorded it. Usually:

- an owner's e-transfer nobody entered → [record the payment](https://managestrata.ca/docs/finances/payments-and-expenses) against their lot;
- a bill paid by automatic debit → record the expense;
- **bank fees** → record as an operating expense, and check they're what you expect;
- interest earned → record it against the fund that earned it, usually the reserve.

**You can post these from here.** Tick the lines that are genuinely missing from the books and record them in one go, against the fund — no re-keying somewhere else from a list you're holding in your head.

Each ticked line gets a **budget line** picker of its own. That's per line rather than per batch on purpose: a bank charge and a landscaping direct debit come off the same statement, so one category for the whole run would be wrong for one of them every time. These are also the postings least likely to be categorised later — they arrive in a batch of a dozen at month end and each is small, which is how a [budget's Uncategorised row](https://managestrata.ca/docs/finances/budgets#budget-vs-actual) fills up.

The lines offered are the ones your council **adopted**, not the ones already spent against — a bank statement is often where a category gets used for the first time. Leave it blank and the posting is uncategorised, exactly as it was before.

Changing a category retires the review, the same way ticking a line does: the category is part of what gets written down, so a preview taken before it changed isn't a preview of what would be posted. Review again and it's named in what you're shown.

> **Recorded against the fund, never against a lot**
>
> A bank line tells you the corporation's cash changed; it does not tell you whose
> money it was. One lump deposit can be twenty owners' fees. So a reconciliation
> posts fund-level entries only — an owner's payment still gets recorded against
> [their lot](https://managestrata.ca/docs/finances/owner-ledgers), where it can be seen on their ledger.

The whole posting is recorded as one batch, so a set of lines recorded by mistake is undone in a single step.

### Undoing a recording

Every set of lines you've recorded is listed at the foot of the page, under **Recorded from bank statements**, newest first, with the day it was recorded and the date of its latest bank line.

**Undo this recording** reverses every line in that batch at once. A **reason** is required — *"Ticked the wrong statement's lines"* — and you see what will be reversed before you confirm with **Undo it**. Each line comes back out of the fund **and off the budget line it was filed against**, so [budget vs actual](https://managestrata.ca/docs/finances/budgets#budget-vs-actual) no longer shows a bank charge you've taken back as spent.

Nothing is deleted: the originals and the reversals both stay on the ledger, carrying the reason. The batch stays in the list marked **Undone**, with the date and the reason beside it, and a batch can only be undone once. Then paste the statement again and record the right lines.

### In ManageStrata, not on the bank

Recorded, but the money hasn't moved. Usually:

- **a cheque not yet cashed** — normal, and it should clear next month. If it's still outstanding after two or three months, chase it;
- **a payment recorded on the wrong date** — recorded in June, cleared in July;
- **a payment that never actually cleared** — an NSF cheque. [Reverse it](https://managestrata.ca/docs/finances/corrections);
- **a duplicate** — the same payment entered twice. Reverse one.

> **These are not yours to post from here**
>
> There is deliberately **no button** for either. An uncashed cheque or a deposit
> in transit is *timing*, not error — writing it off would erase a real obligation
> to make a subtraction come out even. And there is no balancing figure to force
> the totals to agree, which is the adjustment that makes a set of books stop
> meaning anything. Fix these at the source instead.

> **A cheque outstanding for months is a real problem**
>
> Either it was lost, or it was never sent, or it was recorded and never issued.
> All three need investigating rather than carrying forward. Uncashed cheques are
> where the awkward findings live.

## Two accounts

Where you hold separate bank accounts for the operating and reserve funds — required in some jurisdictions, good practice everywhere — reconcile each against its own statement. Transfers between them should appear on both sides in the same period; a transfer showing on one and not the other is the first thing to check.

## What "reconciled" means

You're done when every difference between the bank and your books is **explained**, not when the difference is zero. Outstanding cheques and deposits in transit are legitimate differences. Unexplained ones are not.

Note anything genuinely outstanding for next month's review — the same uncashed cheque appearing three months running is a signal, not a constant.

## A monthly routine

| Step | Roughly |
| --- | --- |
| Download the statement | 2 min |
| Paste and review the match | 5 min |
| Record what's missing | 10 min |
| Correct what's wrong | Varies |
| Note anything still outstanding | 2 min |

Twenty minutes a month, and the year-end [financial statement](https://managestrata.ca/docs/finances/statements-and-closing) becomes a formality rather than a reconstruction.

## Before year end

Reconcile every month of the year before you produce statements, and reconcile the final month before you [close the books](https://managestrata.ca/docs/finances/statements-and-closing). Closing a period locks postings dated into it — do it on numbers you've actually checked.

## When it won't reconcile

  1. **Narrow it to a month**

   Reconcile month by month until one fails. That's where the problem is.
  1. **Look for the amount itself**

   Search the ledger for the exact difference. Very often it's one transaction.
  1. **Check for transpositions**

   A difference divisible by 9 — $27, $90, $450 — is the classic sign of
   transposed digits, e.g. 412 keyed as 421.
  1. **Check the fund**

   An expense recorded against the wrong fund reconciles against neither
   statement if you hold two accounts.
  1. **Ask for help**

   If it still won't come out, [contact support](https://managestrata.ca/docs/basics/getting-help) with the
   period and the amount. Don't force it with a balancing entry — an
   unexplained plug is worse than an unreconciled month.
