Menu

Can I match imported bank transactions to invoices and payments without losing the reconciliation history?

Match bank activity and finish a balanced statement reconciliation

Nexus Banking imports bank or card transactions from CSV, lets staff match or categorize them, and reconciles selected cleared items to a statement balance. Saved statements retain their dates and cleared transactions; the latest statement can be reopened with a reason when a correction is needed.

Match bank activity and finish a balanced statement reconciliation

  1. Set up the bank or card account

    Create the account and link it to the appropriate general-ledger account. Enter the opening information needed by your accounting process and enable advanced accounting for Banking.

  2. Import the statement transactions

    Select the account and import a CSV containing the supported date, amount, description, and reference fields. Nexus checks imported transaction fingerprints to avoid adding the same existing rows again.

  3. Match or categorize each transaction

    Match an incoming receipt to the appropriate invoice or an existing recorded payment where available. For other transactions, choose the general-ledger account that explains the movement. Review the source and amount before confirming.

  4. Handle combined receipts and repeated transactions

    Split a receipt across selected invoice application amounts when one bank transaction covers several invoices. Save matching rules for repeated descriptions or amounts, then apply active rules to unmatched transactions.

  5. Reconcile the cleared items

    Enter the statement dates and opening and ending balances. Select the matched transactions that actually cleared. Finish reconciliation when the selected movement produces a zero difference; unselected transactions remain outstanding.

  6. Keep and correct the statement history

    Review saved statements and their cleared items. If the latest statement needs correction, enter the reason and reopen it before changing its reconciliation.

CSV import is the intake workflow

Import bank transactions from CSV. Linking a payout account does not enable a continuous bank transaction feed.

Existing payments and bank receipts can be matched

When a payment is already recorded, use the existing-payment match workflow to connect bank activity without treating it as another customer payment.

Transfers have a dedicated action

Select the destination bank account when recording a transfer. This keeps the movement between accounts identifiable instead of treating every withdrawal as an operating expense.

Before you get started

Questions about this workflow

Can I import bank transactions?

Yes. Select the mapped account and import a supported CSV file. Check the imported rows and match or categorize them before reconciliation.

Can one receipt cover several invoices?

Yes. Split the transaction into invoice application amounts and review the amounts assigned to each invoice.

What prevents an unbalanced reconciliation?

The finish action requires the statement balance difference to be zero and the selected transactions to be matched.

Can I correct a completed reconciliation?

The saved-statement section lets staff reopen the latest statement with a reason. Its history retains that reopening record.

Walk through your work in Nexus

Bring an example of the work you manage today. We’ll demonstrate the steps, customer view, and setup relevant to your team.