Bank Matching

Bank Matching lets you import a bank statement and check it against what you have recorded in Argo Books. Each line on the statement is matched to your recorded revenue and expenses, so you can confirm your books are complete and catch anything that is missing or entered twice. There are no bank connections to set up. You import a CSV or Excel statement that you download from your bank.

Bank statement lines are reference data only. Importing a statement never creates expenses or revenue, and it never changes your transactions. The only thing matching does is mark a record as matched to a statement line.

Looking to add transactions instead? Bank Matching only verifies your books. To create expenses and revenue from a statement, use Bank Statement Import.

How Bank Matching Works

  1. Open Bank Matching from the sidebar, under Transactions
  2. Click Import statement and choose a CSV or Excel file from your bank
  3. Argo Books reads the columns and automatically matches each line against your books
  4. Review the results: confident matches are confirmed for you, likely matches are suggested for you to accept, and anything left over is flagged as unmatched

Importing a Statement

The importer reads any CSV or Excel bank statement and maps its columns to the fields Bank Matching needs:

  • Date
  • Description
  • Amount (signed)
  • Debit / Credit (separate columns)
  • Balance
  • Reference

Column detection happens locally and instantly, recognizing common header names (and tolerating a few preamble rows). If your statement uses unusual or cryptic headers that can't be recognized, the AI smart importer is used as a backup to map the columns (this counts as one of your monthly AI imports). A statement only needs a date and either an Amount column or Debit/Credit columns.

Match Statuses

  • Matched: Confirmed and linked to a recorded transaction.
  • Suggested: One or more records were found. Accept the best one or choose another.
  • Unmatched: No matching record was found. This usually means a transaction you forgot to record.
  • Ignored: A line you have set aside (for example an internal transfer) that you do not want to track.

Missing from Statement Tab

The Missing from statement tab is the other side of the check: it lists your recorded revenue and expenses that no statement line matched. These are entries that may be missing from your bank statement, or that you may have recorded twice. Records with the same amount around the same date are flagged as a possible duplicate. You can search these records and filter them by date range and record type.

List and Calendar Views

Both tabs have a List and a Calendar toggle in the top right of the table, next to the search and filter buttons. List is the detailed table described above. Calendar gives you a year-at-a-glance overview, so you can see which months are fully checked and which still need attention.

The calendar shows a grid of all twelve months for one year. Use the arrows beside the year to step between years. Each month tile shows a count of how many lines (or records) are matched out of the total for that month, and is colored by status:

  • Green (Fully matched): every line that month is matched, or set aside.
  • Amber (Partially matched): some lines that month are still outstanding.
  • Red (Not matched): nothing that month is matched yet.
  • Grey: nothing recorded for that month.
Esc