Bank Reconciliation

Bank Reconciliation

Bank Reconciliation


Info
Location
Adjustment > Closings > Bank Reconciliation
Info
Action
> Click NEW
> BANK select bank you would like to reconcile
> DATE select the month and enter the year
> 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

    • Opening for bank

      Let's assume From Bank Statement : Bank balance as at 31 Dec 2015 is 10,000 System balance as at 31 Dec 2015 is 9,900 Important to note the difference. Bank balance is the balance from the bank. system balance is the figure from the system. Openings ...
    • 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 ...
    • Multi Currency / Setting Bank, Mode & Business Partner in Foreign Multi Currency

      Creating a Bank Account in Foreign Multi Currency Location > Setup > Chart of Account Action > Click SETUP activity > Click ACCOUNTS > Click CHART OF ACCOUNT module > Select Bank 2 > Click EDIT > DESCRIPTION rename Bank USD > CURRENCY select USD > ...
    • Multi Currency / Funds Transfer between Banks

      Funds Transfer between Banks Type Purchases> Payment Action > 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 ...
    • 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 ...