Article: AR18776 - How to Process Bank Reconciliation
Article Information
Product Agility
Category General Ledger Article # AR18776
Details

HOW TO PROCESS BANK RECONCILIATION 

Navigate to 

Accounts Payable > Check Administration > Bank Reconciliation 
OR
Accounts Receivable > Payments > Bank Reconciliation 

Step 1. Choose the Cash account to be reconciled

  1. Enter in the Cash G/L Account to be reconciled. 
    The default Cash account will populate automatically. 
    You can select the double (red and blue) arrow icon to see the full Cash G/L Account if it does not default in that way.

Step 2. Entering the Bank Statement information 

  1. Enter your Beginning and Ending Balance from your Bank Statement. 
    Enter the Statement Date from your Bank Statement
    Specify your Reconciliation Date (defaults to today’s date)
  2. Click Search

Step 3. Reconcile your Deposits (A/R Cash or Debits to Cash)

  1. Click on the Deposits Tab
  2. Highlight the desired Deposit Batch(es) and click on the arrow pointing to the right to select for reconciliation. 
  3. In this window, you can also select specific Payments from a Batch.
    Highlight the related Batch in the Available Deposits – Batches grid and then select “Batch Details”. This will provide the Available Deposits – Payments within the selected Batch in the lower grid.
  4. Highlight the desired Deposit(s) and click on the arrow pointing to the right to select for reconciliation.  

Step 4. Reconcile your Payments (A/P Cash or Credits to Cash)

  1. Click on the Payments Tab
  2. Highlight the desired Payment(s) and click on the arrow pointing to the right to select for reconciliation.  

Step 5. Review the Bank Reconciliation 

  1. Click back on the Criteria Tab to review your Balance Summary
  2. Once all Deposits/Payments have been selected for reconciliation, the Criteria Tab should ideally display a Difference of 0.00 if everything that is selected ties out to your Bank Statement.

* Note that if there are Deposits/Payments in Month A that did not clear the Bank until Month B, you should only select those Deposits/Payments for reconciliation once they appear on the Bank Statement you’re reconciling to. Due to timing at Month End, you may see some variances/discrepancies between Agility Deposits/Payments and what has posted/cleared at the Bank. *

Step 6. Finalize/Reconcile Bank Reconciliation 

  1. Click on the G/L Cash Transfer to transfer money between Cash Accounts. 
    Ex. If you transfer money from one Bank Account to another, you should represent that within Agility to ensure your Cash G/L Accounts remain in balance with your Bank Accounts.
  2. Click on Service Charge Entry to enter any Bank Service charges/fees
    Ex. If you have a line on your Bank Statement related to Checking/Savings/Business Bank Account Fees, you can specify those here.
  3. Click on Cash Against G/L Account to enter any Cash received from non-Accounts Receivable sources.
    Ex. Interest for a money market account.
  4. One your difference presents 0.00 (or you understand/noted the reason for the difference), you can click on Reconcile to complete the Bank Reconciliation.
Note that you can instead select “Finish Later” if you want to save and finish your reconciliation at a later time.
Note that we do not recommend that more than one user access and/or work within Bank Recon at one time.  
Attachment Word Doc Office 2007 Word Document How to Process Bank Reconciliation.docx (1116.16 KB)
Attachment PDF PDF Document How to Process Bank Reconciliation.pdf (412.83 KB)
Attachment PPT
Rate Article
* All Files - Portal None     
No records to display.
Related Articles
* Approved Internal Articles None     
No records to display.