Bank imports and reconciliation

Compare bank statement activity with recorded transactions and resolve unmatched items.

Needs: Pro · Accounting

Banking lets you import statement lines and match them to the books. It distinguishes the book balance from the cleared or reconciled balance, helping you see which recorded transactions have been checked against the statement.

Import a statement

Select the correct bank account and import a supported CSV. The parser recognizes Date, Description and Amount, or separate Debit/Credit columns. Try a small sample to check dates and the direction of positive and negative amounts.

Duplicate detection skips recognized rows. Still review the result when the bank has changed the format of its export, since differently formatted data may need closer checking.

Decide what to do with each line

Action	Use when
Match	The transaction already exists in the books
Add to books	The statement line needs a new supported accounting entry
Ignore	The line should be excluded from the current reconciliation workflow
Undo	A previous decision needs correction
Remove import	The imported batch itself was wrong; inspect the confirmation and consequences

Automatic matching looks for a unique transaction with the same amount within seven days before or after the statement date. If several entries could match, open them and identify the correct one.

Use Add to books only when the financial transaction has not already been recorded. If an invoice or purchase payment already exists, match it instead of creating another entry.

Review the balances

Compare the statement, book and cleared balances for the same account and period. Work through unmatched lines and check whether differences are caused by timing, duplicate entries or missing transactions.

A later change to a source posting can clear its bank match so the revised amount can be reviewed again. If a previously reconciled line becomes unmatched, inspect the source history before matching it a second time.