# Opening balances and imports

> Bring an existing set of books into ManageStrata — state what the funds hold, what each lot owed on that day, and import the receipts you already have.

Source: https://managestrata.ca/docs/finances/opening-balances-and-imports

Almost nobody starts a strata corporation and ManageStrata on the same day. You arrive with funds that hold money, owners who already owe some of it, and a run of receipts in a spreadsheet or a bank export.

Three tools bring that in, and the order matters.

## Pick a cutoff date first

One date, before you enter anything: the day your ManageStrata books begin. The first day of a month, or better, the first day of your [fiscal year](https://managestrata.ca/docs/account/corporation-settings#fiscal-year-start).

Everything as at that date is an **opening balance**. Everything after it gets recorded as it happens.

> **Don't re-key years of history**
>
> An opening balance plus accurate records from a clean start gives you everything
> you need going forward. The old statements are already in your
> [document library](https://managestrata.ca/docs/documents/library), and they remain the record of the years
> they cover.

## State the opening balance

**Finances → Move books in → Opening balance**.

**Move books in** is where both of these tools live, and it states the choice
between them before either screen opens — which is the choice this page is
about.

Two different facts, entered separately:

**What the funds hold.** The operating and contingency reserve fund balances as at the cutoff, from your bank statements.

**What each lot owed.** Any arrears outstanding on that date, per lot, so an owner's [ledger](https://managestrata.ca/docs/finances/owner-ledgers) starts honest.

> **Cash and receivables are not the same money**
>
> It's tempting to enter arrears as though the money had been received. It hasn't
> — that's why it's arrears. Entering it as cash puts your operating fund above
> your bank account by exactly the amount owing, and the error compounds every
> month until someone reconciles. The two boxes are separate for this reason.

Leave a field **blank** if you don't know it. Blank means unstated; a zero asserts the fund was empty, which is a different and usually wrong claim.

On the [financial statement](https://managestrata.ca/docs/finances/statements-and-closing#current-position) the funds' opening balance has its own **Opening balance** column and is never counted as a contribution — the reserve you arrived with is where the fund started, not something owners paid in since. The printed statement names the takeover date it was brought forward at.

You can set one opening balance per corporation. Setting it twice is refused — undo the first if it was wrong.

### Posting behind the opening balance

Once the opening balance exists, it stands for **everything** that happened before its date. So a posting dated earlier than that date is that history counted a second time, and the form says so:

> This is dated before your opening balance of 2026-01-01, which already includes everything up to that date — so posting it here counts it twice. Date it after 2026-01-01 unless you are deliberately rebuilding the history behind that figure.

**It's a warning, never a refusal.** A corporation still migrating its books has real reasons to post behind the cutoff, and the person doing it knows more about why than the software does. But if you weren't deliberately rebuilding history, this is telling you the date is wrong. [The date on every posting →](https://managestrata.ca/docs/finances/payments-and-expenses#the-date-on-every-posting)

## Import a run of receipts

**Finances → Move books in → Import payments**.

For the payments you *do* want individually: a fee run exported from the bank, a season of cheques, the receipts behind an arrears figure.

Paste the CSV. **Each receipt keeps its own date** — the date the money moved, not the afternoon you did the import. That's the whole point of importing rather than keying: forty receipts spanning eleven months should not all land on today.

  1. **Paste and review**

   Every line is parsed and shown back to you before anything is posted.
  1. **Read the rejected lines**

   Unusable lines come back **by line number, with the reason** — not a count.
   "11 rows skipped" tells you nothing you can act on, and a partial import
   that reports success is how books quietly stop matching a bank.
  1. **Check the flagged duplicates**

   Rows that look like duplicates of each other are flagged and still
   imported. A corporation can genuinely receive two identical cheques in a
   day, and that call is yours rather than the parser's.
  1. **Post**

   The whole file posts as one batch.

> **Import is not reconciliation**
>
> Both take a pasted CSV and both talk about payments, so they're easy to confuse.
> **Import** *records* payments you haven't entered yet. **Reconciliation**
> *compares* a bank statement against what's already recorded and, where a line is
> genuinely missing, lets you record it. If the receipts are already in
> ManageStrata, you want [reconciliation](https://managestrata.ca/docs/finances/bank-reconciliation).

## Undoing a batch

An opening balance and an import are each **one batch** — one row standing for one deliberate act. So each is undone as the act it was, in a single step, rather than as a few hundred unrelated mistakes.

**Finances → Move books in** → whichever tool posted it, then **Undo this opening balance** or, beside the import in the list, **Undo this import**. You'll see a preview of every entry that will be reversed before you confirm.

A **reason** is required, and it's kept on the correction entries so the ledger explains itself later — *"Cutoff was wrong — restating as of June 30"*, *"Wrong file — imported the draft export"*. An undone batch stays listed with the date it was undone and that reason.

If someone else undid the same batch a moment before you, you're told it has already been undone — refresh the page to see where it stands. A batch can only be undone once.

> **Nothing is deleted**
>
> An undo **mirrors** every entry rather than erasing it. The original and the
> correction both stay readable, which is what an owner's right to inspect the
> records (s.36) assumes. Your ledger will show both — that is correct, and it is
> what you want when someone asks about it in two years.

Undoing an opening balance frees the slot, so you can state a corrected one.

## The order that works

  1. **Set the fiscal year and time zone**

   **Settings → Financial controls**. Everything below is dated
   against these. [Corporation settings →](https://managestrata.ca/docs/account/corporation-settings)
  1. **Check your lots and their unit entitlements**

   Arrears attach to lots, so the lots have to exist first. Registering the
   corporation creates them, numbered from 1, unless **Add my lots now** was
   unticked; check them on **Lots** and add the unit entitlements.
   [Lots →](https://managestrata.ca/docs/getting-started/add-units-and-lots)
  1. **State the opening balance**

   Funds and per-lot arrears as at the cutoff.
  1. **Import any receipts after the cutoff**

   Only those that fall after it — anything before is already inside the
   opening balance, and importing it too counts the same money twice.
  1. **Reconcile against the bank**

   The check that it all landed.
   [Bank reconciliation →](https://managestrata.ca/docs/finances/bank-reconciliation)
  1. **Close the prior year**

   Once the balances are right, so nothing can be posted back into it.
   [Statements and closing →](https://managestrata.ca/docs/finances/statements-and-closing)

## Common questions

**My operating fund is higher than my bank account.** The usual cause is arrears entered as cash. Undo the opening balance and re-enter it with the money owing in the arrears box rather than the fund box.

**Can I import expenses too?** Not through this screen — it imports receipts. [Record expenses](https://managestrata.ca/docs/finances/payments-and-expenses) as they happen from the cutoff forward.

**I imported the same file twice.** Undo one of the two batches. Both remain visible; the reversal is what makes the figures right.
