pandusubbu
2

Hi All,
I want to learn bank reconcilation statements. kindly send me the example statements and material. plz help me.actully i am working in billing section.my manager asking do the bank reconcilation and preapre the statments
Thanks & Regards,
Subramanyam

From India , Hyderabad
mystsm
1

Dear Mr subramanyam

This is a very simple procedure. There are only 4 steps to be followed for preparing the bank reconciliation. Bank reconciliation is done where there is a difference in balance as per your books of accounts with the balance as per the bank statement. In short it is reconciliation between two balances.

You may start as follows :

1. Start ticking the debit entries in your books with the credit entries in bank book (as you are aware that the debit in your book is the credit in the bank statement).

2. After completing the ticking of all the debit entries in your book, start ticking the credit entries in your book with the debit entries in the pass Statement).

Now you are left with unticked entries, both debit and credit entries. That shows these entries do not reflect in the one of these two account.

No preparation of BRS STATEMENT.

BALANCE AS PER YOUR BOOK (closing balance) 000000

Add : AMT CREDITED BY BANK NOT ACCOUNTED BY U. 00000
ADD : CHEQUES ISSUED BY YOU NOT PRESENTED. 00000 00000
------ -------
000000
LESS : CHEQUES DEPOSITED NOT CLEARED IN BANK 00000
LESS : AMT DEBITED BY BANK NOT ACCOUNTE BY YOU 00000 00000
------ -------
BALANCE AS PER BANK STATEMENT 000000
-------

Hope the above is clear to you.

Regards...RK

From India , Bangalore
mystsm
1

This is a very simple procedure. There are only 4 steps to be followed for preparing the bank reconciliation. Bank reconciliation is done where there is a difference in balance as per your books of accounts with the balance as per the bank statement. In short it is reconciliation between two balances.

You may start as follows :

1. Start ticking the debit entries in your books with the credit entries in bank book (as you are aware that the debit in your book is the credit in the bank statement).

2. After completing the ticking of all the debit entries in your book, start ticking the credit entries in your book with the debit entries in the pass Statement).

Now you are left with unticked entries, both debit and credit entries in your books and in bank statement. That shows these entries do not reflect in the one of these two account.

No preparation of BRS STATEMENT.

BALANCE AS PER YOUR BOOK (closing balance)

Add : AMT CREDITED BY BANK NOT ACCOUNTED BY U.
(total of unticked credit amount in bank statement)

ADD : CHEQUES ISSUED BY YOU NOT PRESENTED.
(total of unticked credit entry in your books)


LESS : CHEQUES DEPOSITED NOT CLEARED IN BANK
(total of unticked debits in your books)

LESS : AMT DEBITED BY BANK NOT ACCOUNTE BY YOU
(total of unticked debit entries in bank statement)

The balancing figure will be the BALANCE AS PER BANK STATEMENT


Hope the above is clear to you.

Regards...RK

From India , Bangalore
Johnbhushee
pls. post your custom need / requirement at Opex Solution - Excel Solutioning for Free and we would develop your requirement in excel for free
From India , Mumbai
ankur jana
Hi, frind can any one provide me a excel formate on numarical number to inwards automatically.
From India , Calcutta

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

Add Reply → Start New →






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2022 Cite.Co™

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server