Bank Reconciliation

Bank Reconciliation in JobBag

Bank reconciliation can be done in two ways:

1. Manual reconciliation
2. Importing a bank statement (CSV, QIF, or OFX formats)

1. Importing a Bank Statement

When importing a bank statement, select a date range that starts at least 10 days before the last reconciled statement. This accounts for late postings such as debit or credit card transactions.

Example:

• Last reconciled period: 1 June – 14 June 2023
• Next reconciliation period: 15 June – 21 June 2023
• Suggested import date range: 9 June – 21 June or 1 June – 21 June

Steps:

1. Highlight the bank account and click Import a bank statement.
2. Select the file type (CSV, QIF, OFX) from the dropdown list.
3. Click Import the specified file.
4. Select your file and click Open.
5. Click Reconcile transactions.

Tip: You can save a reconciliation midway and continue later. Accepted reconciliations can be deleted and redone if needed.

2. Understanding Transaction Colours

• Green: JobBag has found a matching transaction. Always verify against client remittance advice, as multiple invoices may have the same amount.
• Red: JobBag could not find a match or no transaction exists (e.g., currency differences).

3. Reconciling Transactions

Green Transactions:

1. Click the search icon to confirm JobBag’s suggested match.
2. Verify the selection is correct.

Red Transactions:

1. Click the green plus sign to manually create a receipt transaction.

Once a transaction is matched and reconciled, it will turn green.