Reconcile imported transactions

You have two options:

1 Do a manual bank reconciliation or

2 Import a bank statement (formats available: CSV, QIF, OFX)

NOTE: when you import bank statements, please import for a date range which starts at leave 10 days before the start of the last reconciled statement. Consider the following example:

1 You have completed and reconciled a bank statement for the period 1 June 2023 to 14 June 2023.

2 You now wish to reconcile transactions from 15 June to 21 June 2023. Select a bank file for the date range 9 June to June 21 - or June 1 to June 21. The reason is because banks sometimes process credit card / debit card transactions late eg you could have a debit card charge dated 14 June is posted on 17 June in the bank statement.

You can save a bank reconciliation half way through and continue later. You can delete accepted bank reconciliations and redo them.

This page is about the process of importing a bank statement and reconciling it

Reconcile Imported Transactions

Transactions are available for reconciling - what do all the colours mean?

Green colour - JobBag has managed to find a matching item.

Red Colour - JobBag has not found a possible item to match the bank transaction

Status of Transactions in the Bank Reconciliation

Green Colour

JobBag had found an item which matches the bank transaction. However, it is worth checking to see if the item is the correct one eg there could be a long list of client invoices which are being paid and a few of the amounts are the same - so it is worth checking the reconciliation against your client's remittance advice.

Click on the search icon