Start Free Trial
Help Center / Bank Reconciliation / Importing Bank Statements (CSV/Excel) and Matching Records
Bank Reconciliation • 6 min • Verified for CFO OS V2

Importing Bank Statements (CSV/Excel) and Matching Records

Upload bank statement exports from BCA KlikBisnis, Mandiri MCM, BRI, or Wise and reconcile transactions.

What You Will Accomplish

Eliminate manual bookkeeping by importing official bank feed files and executing intelligent 1-click transaction reconciliation.

Prerequisites:
  • Exported CSV or Excel (.xlsx) file from your Indonesian internet banking portal
  • Assigned bank account created in CFO AI Accounts

Step-by-Step Instructions

1

Navigate to Bank Import

Click 'Bank Reconciliation' in the sidebar, then select the 'Import Feed' tab.

2

Select Target Account

Choose which configured bank account corresponds to the file you are uploading.

3

Upload Statement File

Drag and drop the CSV/Excel statement file. The parser detects standard date, description, debit, and credit columns.

4

Review Matched Transactions

Review suggested matches with your existing invoices and manual receipts. Click 'Confirm Match' or 'Create New Ledger Entry'.

app.cfo-ai.site / bank-import VERIFIED V2 UI
Importing Bank Statements (CSV/Excel) and Matching Records

Expected Result

Statement transactions transition from 'Pending Match' to 'Reconciled'. Your runway and P&L charts update automatically.

Common Errors & Troubleshooting

• Unrecognized date format in CSV

Indonesian banks frequently use DD/MM/YYYY. If your export uses custom formats, verify the column mapping preview before clicking Import.

Was this guide helpful?