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.