Bank Reconciliation

Bank Reconciliation

Bank Reconciliation

Creating/Opening

Start by choosing a GL Account, after choosing one, the system will try to load an existing open statement (only one can exist for each account at a time).
If one does not exists set the Statement Reference, the Ending Balance, and then the Statement Date. Once the date is set the system will create/save the Statement. The system will load all un-reconciled entries for that account up to and including the statement date.







Match entries

You can reconcile a statement by moving the entries from the Unreconciled Entries list (Top) to the Matched Entries list Bottom). To move things between the 2 lists we have three options:
  1. Double clicking on an item will move the item to the other list.
  2. Highlight one or more lines(green) and click the “Match Selected” or “Removed Selected” Button.
  3. Filter the list to show the entries you want to move and click the “Match Filtered” or “Removed Filtered” buttons.

Reload entries

To reload the entries list (in case you created new ones, in a different window) hit the yellow “Refresh Entries” button.

Reconcile

Once the Matched Balance (Purple) equals the Statement Balance (Orange) the Reconcile button will become available, the remaining amount is displayed in pink.

The Matched Entries will indicate when they have not been saved, a yellow exclamation icon will be visible (circled in blue), before you leave or when you are ready to reconcile click “Save”.




Upload statement (CSV, or Excel)

·         To process by uploading a csv or excel file, choose the Statement type you are uploading and then drag the file to the drop zone to upload the file. If a file is already uploaded for this session, the green plus button above the drop zone appears so that you can reopen it without having to re-upload the file.

·         At the top of the uploaded statement there is aggregate data to show you how many items the system has matched to the uploaded document, the percentage of the statement that matches and the value of the entries that do not have a match.

·         For entries with “No Match” or an “Unbalanced Multiple” (yellow instead of green) there may be 3 buttons to allow you to easily create a transaction (Red)

o   CT – Custom Transaction, AP – Liability,

o   CE – Cash Entry

o   An “Unbalanced Match” is where an entry in the upload has 2 or more matches in the system, but not the same amount in the upload, or the reverse where there are 2 or more in the upload but less in the system

·         Beside Each green match type indicator e.g. “Single” there may be up to 2 icons (bright purple), a warning indicator, saying that the entries it matches are not in the matched list , or a not equals sign, just to indicate a “fuzzy” match, e.g. the day does not exactly match based on the match settings in finance settings

·         To retry matching the upload with possibly newly created entries hit the “Rematch Upload”

·         The “Match Successes” button will move all matched, Green “Single or “Multiple” entries from the un-reconciled list to the matched list.



    • Related Articles

    • Create or Edit GL account

      To create or edit existing GL accounts, you need to first put your Chart of Accounts in Edit Mode. To do this first click the "Pencil" icon in the top right corner. When in edit mode, clicking on a GL account will bring you into it's properties and ...