🏦 Banking — Statement Import

The Banking tab brings your bank statement into Pavilion so it can be checked off against the ledger on the Reconcile tab. Importing does not change your ledger — it just stores the bank lines ready to match.

Importing a statement

Click ⬆ Import statement to open the 3-step wizard:

1. Upload — choose a CSV file exported from your online banking, or paste the CSV text. Give the statement a name (e.g. “Barclays — April 2026”) so you can recognise it later.
2. Map columns — tell Pavilion which column holds the date, description, reference and amount. Pick the date format (UK statements are usually DD/MM/YYYY). Amounts can be a single signed column or separate Money In / Money Out columns — Pavilion tries to guess this for you from the headings.
3. Preview — check the rows look right, then click Import.

Duplicate protection

Each line is fingerprinted on its date, amount, description and reference. If you re-import an overlapping statement, lines you already have are skipped automatically and counted as duplicates.

The stat cards

• Imported lines — total bank lines stored.
• Unmatched — not yet reconciled (waiting on the Reconcile tab).
• Matched — linked to a ledger entry.
• Ignored — deliberately set aside.

Deleting a statement

Use the 🗑 icon next to an imported statement to remove the whole batch. Any ledger entries that were matched to it are left in place but un-reconciled, so you can match them again.

Automatic bank sync

Live daily sync via Open Banking (TrueLayer, Plaid, GoCardless Bank Account Data) is on the roadmap but not enabled on this site. CSV import is the supported method — every UK bank lets you export a statement as CSV.

Trying it out

Install the Accounts (bank rec) demo section in Settings → System → Demo Data, then download the example bank statement from that same page and import it here to see the whole flow working.

Common questions

Will importing change my ledger?

No. Importing only stores the bank lines. Your ledger is only touched when you confirm a match or create an entry on the Reconcile tab.

My bank exports separate "Paid in" and "Paid out" columns — is that OK?

Yes. On the Map columns step choose “Separate money in / out” and pick each column. Pavilion usually detects this automatically.

The dates came in wrong — why?

The date format on step 2 probably needs changing. UK statements are normally DD/MM/YYYY; US-style files are MM/DD/YYYY.

Can I import a PDF or OFX/QIF file?

Not yet — please export your statement as CSV, which all UK online banking supports.