Skip to main content

​
1. Purpose

The Bank Statement Importer Module automates financial reconciliation by allowing accounting teams and project managers to upload raw bank statements (CSV, Excel, or OFX format) and match line-item transactions directly with recorded project deposits and expenses.
Bank Statement Importer Dashboard

Screenshot: Bank Statement Importer Dashboard

​
2. How It Works

  1. Statement Upload: Users drag and drop exported bank files into the importer interface.
  2. Automated Matching Engine: CoBuild Manager scans transaction amounts, dates, and payee text against existing deposit entries and expense records.
  3. Session Review & Confirmation: Matched transactions are flagged for 1-click confirmation, while unmatched items can be converted into new deposit or expense entries on the fly.

​
3. How It Helps

  • Eliminates Manual Data Entry: Automatically processes hundreds of bank transaction rows in seconds.
  • Prevents Duplicate Entries: Smart matching identifies existing entries to avoid double-counting funds.
  • 100% Financial Accuracy: Ensures your CoBuild Manager ledgers match bank account balances exactly.

​
4. Step-by-Step Actions

​
A. How to Import a Bank Statement

1

Open Bank Importer

Click Tools -> Bank Statement Importer in the main sidebar.
2

Upload File & Select Bank Account

Choose the target project, select the bank account, and upload your CSV, XLSX, or OFX statement file.
Bank File Upload Modal

Screenshot: Bank File Upload Modal

3

Map File Columns

Confirm column mappings (Date, Description, Withdrawal Amount, Deposit Amount).
4

Process Statement

Click Start Auto-Matching.

​
B. How to Review & Reconcile Import Sessions

1

Open Review Session

Go to Import Sessions and click Review Session.
Import Session Transaction Match Review

Screenshot: Import Session Transaction Match Review

2

Confirm Matches

Click Approve Match for matched transactions.
3

Convert Unmatched Items

For unlinked items, click Create Expense or Create Deposit to record them immediately.

​
C. How to Filter Import Records

  • Status Filter: Filter transaction rows by Matched, Unmatched, Ignored, or Manually Linked.
  • Search: Search transaction text by vendor name, reference number, or check number.

​
D. How to Cancel / Delete an Import Session

1

Select Session Options

From the import sessions list, click Discard Session.
2

Confirm Removal

Confirm in the popup dialog. Unconfirmed temporary import entries will be removed without affecting your main financial records.