Bank Reconciliations

A bank reconciliation makes sure that all the bank entries are captured correctly, by matching bank transactions to bank statement entries.

Before reconciling a bank account for the first time, complete these setup steps:

  1. Add the Bank module to a menu.
  2. Set User Access for the bank module: … Bank > Menu (button) > Edit User Access > Actions (button) > Add/Remove Users, then set each user’s access.
  3. Create statuses for the bank entries:
    1. … Bank > Menu (button) > Edit Statuses (Bank Header) > Add Default (button).
    2. … Bank > Menu (button) > Edit Statuses (Bank Item) > Add Default (button).

Bank Reconciliations and Bank Imports share the same interface, settings and statuses.

In a bank reconciliation, the reconciliation is treated as a bank transaction. The header has its own status, and the transactions added to the reconciliation are treated as items with their own statuses.

Transactions appear if:

  • One side of their entry is posted to the selected bank account.
  • The transaction has an accounting status.

Bank Reconciliations List View

Buttons Explained

Button Description
ViewShows a list of bank reconciliations and imports.
Arrow on View button > Reset Data FilterResets the selected data filters.
New

Creates a Bank Import or Bank Reconciliation, as selected from the dropdown list.

Needs header and item statuses. If either list is empty, the message “Invalid Setting Status. See Menu button > Settings > Edit Statuses (Header).” or “… Edit Statuses (Item).” appears.

Menu

Settings

Layout


Filters Explained

Filter Description
SetSelect a date option (No Date shows all the entries).
Date (radio button)

Works with the date.

Shows the entries created on that date (the date on which the reconciliation or import was created).

Updated (radio button)

Works with the date.

Shows the entries updated on that date (the date on which the reconciliation or import was updated).

DateEnter your own dates.
ArrowsAdjusts the dates in the direction of the arrows.
AccountSelect a bank account.
Status Checkboxes

Check one or more statuses to show only the entries with those statuses.

If no boxes are checked, all the entries appear.


Fields Explained

Field Description
Field Chooser (*)Add or remove columns.
StatusThe item’s status.
Bank No.The system-generated number allocated to the entry.
TypeWhether the entry is an Import or Reconciliation.
AccountThe name of the bank account.
Date Start

The start date of the reconciliation or import.

After the first import, this date is set automatically to the day after the previous import ended.

Date EndThe end date of the reconciliation or import.
Bank BalanceThe bank balance at the end of the period.
Ledger BalanceThe ledger balance at the end of the period.
VarianceThe difference between the bank and ledger balances.
CreatedThe date on which the reconciliation or import was created.
UpdatedThe date on which the reconciliation or import was last updated.
Updated ByThe user who last updated the bank reconciliation or import.
Widget

A context menu with the following options:

  • Edit: Opens the import or reconciliation for editing.
  • Delete: Deletes the import or reconciliation. Possible only if its header status is editable or cancelled.

Bank Reconciliations Edit View

Bank Reconciliation edit view, matching bank transactions to bank statement entries
Bank Reconciliation Edit View

Buttons Explained

Button Description
ArrowsGo to the previous or next bank reconciliation or import.
New

Creates a Bank Import or Bank Reconciliation, as selected from the dropdown list.

Needs header and item statuses. If either list is empty, the message “Invalid Setting Status. See Menu button > Settings > Edit Statuses (Header).” or “… Edit Statuses (Item).” appears.

SaveSaves any changes.
Output

Print, Preview and Email: Output the bank reconciliation with the Output Templates of the module Bank Reconciliation (Settings > Output Templates).

Unsaved changes are saved when the Output menu opens.

Actions
  • Insert/Update Bank Transactions: Lists the transactions posted to the bank account. When the amount of a linked transaction has changed, the bank item amount is updated and its status is set back to Pending. Possible only if the header status is editable or cancelled. Otherwise, “Insert/Update Failed. The selected Bank is not in an editable status.” appears.
  • Delete Bank Reconciliation: Deletes the bank reconciliation. Possible only if the header status is editable or cancelled. Otherwise, “Delete Failed. The selected Bank is not in an editable status.” appears.
Menu

Open Ledger: Opens the transaction in the ledger, or opens the ledger interface if there is no transaction.

Settings

Layout


Fields Explained: Header

Field Description
StatusSelect a header status from the dropdown list.
Status BarEnter a status note.
Bank No.The system-generated number allocated to the entry.
TypeWhether the entry is an Import or Reconciliation.
Account

Select a bank account from the dropdown list.

Prefilled with the bank account selected when you clicked New (button).

Only bank accounts with correctly completed Bank Profiles appear on the list.

StartThe start date of the reconciliation or import.
EndThe end date of the reconciliation or import.
Note FieldEnter a note (optional).
Bank Balance

The balance on the imported bank statement.

This field can be edited.

Ledger BalanceThe ledger balance at the end of the period.
VarianceThe difference between the bank and ledger balances.

Buttons Explained: Transactions

Button / Checkbox Description
Transactions
Synchronise Ledger (checkbox)If checked, opens the ledger transaction in the right panel.
Done

Changes the status of all the selected entries to Complete.

Needs a default Complete item status (Menu (button) > Edit Statuses (Bank Item)). Otherwise, “Bank Items default Complete Status has not been set.” appears.

Remove

Removes all the selected entries.

You can add these entries again with Actions (button) > Insert/Update Bank Transactions.

RefreshRefreshes the display after transactions are created.

Fields Explained: Transactions

Info

Fields marked in blue (✎) can be edited.

Field Description
Field Chooser (*)Add or remove columns.
IDThe system-generated number for the entry.
Status

The item’s status (each transaction is an item on the bank reconciliation).

Item statuses are not automatically updated if a transaction is edited or deleted.

DateThe date of the transaction.
CompanyThe name of the customer or supplier.
ReferenceThe transaction’s reference.
DescriptionThe transaction’s description.
AmountThe transaction amount.
Trans No.The Transaction Type code and number.
CreatedThe date on which the entry was created.
UpdatedThe date on which the entry was last updated.
Updated ByThe user who last updated the entry.
Widget

A context menu with the following options:

  • Done: Changes the selected entry’s status to Complete.
  • Open Ledger on Right: Opens the transaction in the right panel, or the ledger interface if no transaction exists yet.
  • Open Ledger on Left: Opens the same in the main panel (moved from the right panel when it is open there).
  • Remove Item: Removes the item from the bank reconciliation.

Report an issue with this page

For more useful feedback, select the text on the page you are reporting on, then click Feedback again — or continue without selecting anything.