Reconcile a Bank Account

Last updated: 2026-06-02 Summary:

• Import a statement via CSV/XLSX using a PH bank preset.
• Match imported lines to ledger entries in a split-pane reconciler.
• A completed reconciliation is locked — it can’t be completed twice or quietly edited after.

Prerequisites

• A bank account exists under Banking → Bank Accounts.
• A statement file (CSV or XLSX). Presets exist for BDO, BPI, UnionBank, Security Bank, and RCBC.

Steps

1. Banking → Import — choose the bank account and upload the statement; pick the matching bank preset.
2. Review the parsed rows; fix any mapping the preset flags.
3. Open Reconciliation — the split-pane shows statement lines vs ledger entries.
4. Match lines (or apply categorization rules to auto-match); create entries for unmatched bank-only lines.
5. When the difference is zero, Complete the reconciliation.

Categorization rules

Rules auto-categorize recurring transactions (e.g. bank fees → an expense account). Matching posts an entry once; unmatching reverses it cleanly — no duplicate entries left behind.

See also

• Accounting model
• Run a P&L