Statement Import reads a bank-download file (OFX, QFX, QBO, or CSV) and suggests matches against entries in your Bizuno register — so reconciliation becomes mostly “confirm” instead of “find and tick”.

How to get there #

Menu: Banking → Statement Import
Direct URL pattern: https://yourdomain.com/?bizRt=bnk/import/manager

What Bizuno can read #

• OFX / QFX — the standard financial-data format exported by most banks’ “Download Transactions” option.
• QBO — a QuickBooks-flavored OFX; works the same way.
• CSV — plain spreadsheet download. You’ll map columns (date, description, amount) the first time; Bizuno remembers the mapping per bank.

Downloading from your bank #

Every bank’s portal is different, but the pattern is usually:

1. Log in to your bank.
2. Go to the account you want to import.
3. Find Export / Download transactions.
4. Pick a date range (the reconciliation period) and format (OFX / QFX / QBO preferred; CSV as fallback).
5. Save the file to your computer.

Important: Don’t share bank download files over email or unsecured channels — they include account numbers and balances. Download directly to the machine running Bizuno.

Importing #

1. Click New Import.
2. Pick the Bank Account.
3. Upload the file.
4. Bizuno parses the file and shows every transaction in a staging grid with a Match Status column.
5. Review each row:
   • Matched (green) — Bizuno found a register entry with the same amount and a close date. Confirm or correct the match.
   • Suggested (yellow) — amount matches but date or description doesn’t; review carefully.
   • Unmatched (red) — no register entry fits. You’ll need to either pick the correct register entry from a dropdown, or Create a new register entry from this import row.
6. For unmatched rows, use Create to post:
   • A Cash Receipt (for incoming money),
   • A Pay Bills entry (for outgoing money to a vendor),
   • Or a Journal Entry (for fees, interest, transfers).
   Bizuno pre-fills amount and date from the import; you pick the other side of the entry.
7. Once every row is green, click Finalize Import. Bizuno marks the matched register entries as cleared.

Coming out of import into Reconciliation #

After a successful import, start a Reconciliation for that bank account. Most items will already be cleared — you’re just confirming the opening and closing balances and finalizing. Most reconciliations take 5 minutes this way.

CSV column mapping #

The first time you import a CSV from a given bank, Bizuno shows a mapping screen:

• Which column is the Date?
• Which column is the Amount (or two columns for Debit/Credit)?
• Which column is the Description?
• Which column is the Reference (check number, if present)?

Save the mapping; Bizuno reuses it next time you import from the same bank.

Matching rules Bizuno applies #

1. Exact amount match within ±3 days of the transaction date.
2. Check number match (for checks) regardless of date.
3. Merchant/payee string match + approximate amount.

Tips for Ridgeline Cycles #

• Import monthly right after the statement arrives — the import period should match the statement period exactly.
• Review Unmatched rows before creating anything. A surprising number are duplicates of items already in Bizuno but with a slightly different date or amount.
• For bank fees and interest, create one line per item during import — the Reconciliation “Service Charge” field is a shortcut but it lumps fees together; explicit entries are better for reports.
• Keep the downloaded file — attach it to the Reconciliation record in case you ever need to re-audit.

Where to go next #

• Reconciliation — finalize after a clean import.
• Bank Accounts — verify the running balance after import.
• Banking Reports — spot trends in fees or interest.