Bank Reconciliation

Bank Reconciliation

Bank Reconciliation helps you match transactions from your bank statement to what’s recorded in your system (invoices, expenses, and other payments). It’s the quickest way to make sure your accounts are accurate and up to date.

What you can do with Bank Reconciliation

• Import bank transactions (for example from a CSV bank statement)

• Match transactions to invoices to mark them as paid

• Match transactions to expenses to confirm they were paid

• Create new records where needed (for example if an expense isn’t in the system yet)

• Reduce mistakes by using suggested matches based on dates, amounts, and references

How it works

1) Add Bank Account

Start by setting up the bank account you want to reconcile.

• Add your bank account
  Create an account so transactions can be stored and reviewed in one place.

• Map statement columns
  Choose which CSV columns match your statement fields (for example date, description, debit/credit, amount, balance). This is normally a one-time setup for that bank format.

• Import CSV statement
  Upload your bank statement file to bring transactions into the system.

2) Reconcile Transactions

Once imported, you can work through transactions and decide what each one relates to.

• Income transactions
  Match incoming payments to invoices (or mark as income where appropriate).

• Expense transactions
  Match outgoing payments to expenses (or create an expense if it doesn’t exist yet).

• Ignore/Delete transactions
  If a line is not relevant (duplicates, internal transfers, test entries), you can ignore it or delete it (depending on your permissions and settings).

Why it matters

Reconciling regularly helps you:

• keep invoice balances correct

• avoid missed payments or duplicates

• spot unexpected charges quickly

• stay confident that your reports match your actual bank balance