BANK RECONCILIATION

BANK RECONCILIATION


BANK RECONCILIATION

Go to Nominal>Cash Book>Bank Reconciliation


Total fields at bottom of the form is the sum of credits and debits


Account: Select the bank account to reconcile

From and to Dates – Search by Date tick box

Refresh Button: When date range is change select the refresh button to populate the form

Order by Ref: - Tick Box – Scroll to the right and there is a column with the tranref numbers in.

        Selecting this tic box will order by the tranref rather than date

Search by Amt Button: New Form opens


There are Debit and Credit Radio buttons but defaults to searching on both

Enter the amount searching for

Drop down menu:

Exact Match

Within 10 units of currency amount

Between Amounts opens another amount field




Report Button: Enter the Bank Account no. 

This gives you a report on the bank account showing transactions that need reconciled

Exactly the same as selecting the account in the bank reconciliation screen

Export Button: Exports all data in the grid to excel or a CSV file

Exit Button: Closes Bank Reconciliation

Cash Book Button: Select a row and press this button to see more details


Unreconcile Button: Opens a new form


  1. Prior to selecting this button the account must be selected in the bank reconciliation screen
  2. Change the date range to search for amounts that have been reconciled and press the Refresh Button
  3. Search by Amt Button – Works within the date range that is selected
  4. As in the bank reconciliation use the tick box to choose what is to be unreconciled
  5. Select the Save Button when finished
  6. Select a row and then press the Cash Book Button to see more details
  7. Export Grid Button – Self Explanatory
  8. Save Button – Saves all transactions selected 



Add Cash Payment Button: If there is a payment transaction that is on the statement but not in agility use this button. No need to go out of the screen to process a payment.

Add Cash Receipt Button: : If there is a receipt transaction that is on the statement but not in agility use this button. No need to go out of the screen to process a payment.



Process a Reconciliation:

To reconcile select the tick box next to the Credit column

Enter the date the amount is recorded on the bank statement or leave blank – Use the Date box on the form to enter the date in the column Bank Date. Cannot Type the date.

Save Button: When finished select the save button



    • Related Articles

    • Nominal - Adding a Bank Account

      INTRODUCTION In Agility you can have multiple Bank Accounts; Deposit, Current, Loan, Credit Card Accounts. CREATING A BANK ACOCUNT This is basically creating a 3 digit and then a name of the back, currency and type as mentioned above. The main part ...

    • Create a New Bank Account

      Create a New Bank Account    INTRODUCTION  Agility provides the function to have multiple bank accounts that reflect the business, Current Account, Deposit etc.    CREATE A BANK ACCOUNT  Bank accounts are linked to Nominal Codes, and this will need ...

    • EPOS - CASH UP Z Report Explanation

      INTRODUCTION This is a brief breakdown and explanation of the information that is printed out when a Z-read has been done. BREAKDOWN HEADER: Title: Till Cash Up Till Number: Name of the till doing the Cash Up User: Name of person doing the Cash Up ...

    • Purchases - Pay Suppliers

      INTRODUCTION After raising PO's, receiving goods into stock, adding invoices and credits there comes the time when these suppliers want payment for the goods and this is the process in Agility Professional. You can do this manually through Step ...

    • Nominal - Cash Account Transfer

      INTRODUCTION There may be times when it is required to move money between bank accounts whether this is moving from the till account to the actual bank after a lodgement has been made or transferring fund from one bank to another. This can be done by ...