Reconcile

Overview

The “Reconcile” tab is where you can create new reconcile statements, as well as view previously created statements. Clicking a statement line item in the grid will display the relevant statement information in the upper right, as well as the information in the upper left that’s first set when creating the balance.

Detail

To view the cleared items of a statement:

-Click the statement in the grid on the reconcile statements

-Click the cleared items tab.

To insert a reconcile statement:

-Click the insert button

-Type a reference

-Choose the bank account being reconciled

This will affect what items show in the Cleared and Outstanding Items tabs

-Type the reconcile date

-Type the opening balance

-Type the ending balance

-Click the save button on the top toolbar

To manually clear items:

-Select or insert a reconcile statement

-Click the “Outstanding Items” tab

This display all items not yet part of a cleared statement.

-Select items to be cleared

The items listed can be selected with a shift+click, ctrl+click or individually selected

-Click clear selected items or press enter

To auto clear bank items:

-Click load bank file

-Select the CSV file

-Click process file

The “Message” field will load the results of processing the file and the items are now cleared.

Once items are cleared, they’re listed on the “Cleared Items tab.” You can review the current standing of Debits and Deposits with details on what’s been cleared.

Should you want to remove items that were cleared:

-Click the reconcile tab at the top of the module

-Click the cleared items tab

-Click the items you wish to un-clear

-Click the un-clear selected items or press enter