Bank Reconciliation

1.0. Bank Reconciliation

Bank Reconciliation


Alert
STEPS:
  1. Click NEW
  2. BANK select bank you would like to reconcile
  3. DATE select the month and enter the year
  4. Click GENERATE 
This will list out all the transactions relating to the bank for the period
> PREVIOUS ENDING BALANCE 
Check that this matches the opening balance of your statement received from the bank
> DEPOSIT
> WITHDRAWAL
> CURRENT ENDING BALANCE
The amounts here will add up when you tick on the list
> EXACT ENDING BALANCE enter the balance show on statement by the bank
> TICK on POST presented items
> DIFFERENCE
The objective is to tick on the presented items so that the Current Ending Balance matches the Exact Ending Balance.
This means the Difference will be zero, which means your bank is reconciled.
Note to ‘un-tick’ an item you have accidentally ticked, you can
Click on Presented Tab and tick on them. You will notice that it will roll back to the Un-Presented Tab list.
> DIFFERENCE with Green Color
There is no difference amount
> DIFFERENCE with Red Color
Amount not tally with bank statement
> Click ADD
    • Related Articles

    • 5.0. Opening for Bank

      STEPS: Click ADJUSTMENT activity Click OPENING GL module Click NEW Unpresented documents will be created 1 document per unpresented. Select Date and Account Code display on the top left module Enter value in Debit for Deposit Enter value in Credit ...
    • Bank Loan

      Scenario: You loan 100,000 from bank. there is also a monthly payment with interest. To begin we will need an account to hold the loan amount. we will also need an expense account to hold the interest value. you'll need to create the accounts if you ...
    • 5.0. Setting Bank, Mode & Business Partner in Foreign Multi Currency

      Creating a Bank Account in Foreign Multi Currency STEPS: Click SETUP activity Click ACCOUNTS Click CHART OF ACCOUNT module Select Bank 2 Click EDIT DESCRIPTION rename Bank USD CURRENCY select USD BANK INITIAL enter CITI REMARK enter 123-45678-9 Click ...
    • 8.0. Funds Transfer between Banks

      Funds Transfer between Banks STEPS: Click PURCHASES activity Click PAYMENT module Click NEW DATE select 10 Jan 2012 PAYEE TYPE select Bank PAYEE enter Your Company Name MODE select UOB Bank For Mode, note that this will be the where the funds will be ...
    • Bank Recon previous reconciled balance does not tally

      The Previous reconciled balance field is a calculated field base on the sum of the previous presented documents. when this field does not tally, and there is no red color document to indicate a change in value what commonly happen is a presented ...