Bank Reconciliation Statement

This query is : Resolved

Share Report Follow Query Ask a Query

Garima Sachar

Garima Sachar (Querist)
Follow

02 October 2010 Sir,I want to know the easiest way to prepare a BRS if volume of transaction is very huge.

CMA Ramesh Krishnan

CMA Ramesh Krishnan (Expert)
Follow

03 October 2010 Dear Garima Sachar

The method of BRS is same for all even less or huge transactions, now days the accouting softwares providers having automatic method of BRS based on the some input, so try that or in files section you can download some useful BRS preparation files

SAMEER

SAMEER (Expert)
Follow

03 October 2010 It would be easier to first post all the bank related transactions in a BRS ledger account opened in addition to the Bank account and then transfer entries to bank account according to bank statement, Now the entries left in in the BRS account shall be your reconciliation statement

CA. Abhishek Sinha

CA. Abhishek Sinha (Expert)
Follow

04 October 2010 Hi dear, i am sharing my method.
first take 3 soft copies in excel.
Bank Statement, bank Book, Last month Bank Reco

Step1:- take soft copy of bank statement and sort bank charges items n put 2 ahead of respective cells.

Step 2:- compare Bank Statement n last month Bank reco for adjusting reco items. using ascending/decending or cntrl F and put reco as code in ahead of compared related cell.
when finish tally reco items by using filter.

Step3:- compare bank book n rest bank statement using ascending/decending or cntrl F and and put 1 as code in ahead of compared related cell

now use un coded data to prepare reco n you can cross check coded items in sheet by selection in excel.

Thanks!

Message likes : 1 times

NISHIT A. DOSHI

NISHIT A. DOSHI (Expert)
Follow

09 October 2010 Hi,

You can take the bank statements and bank book in the excel formate.

Then just use the "VLOOKUP" formula in order to reconcile the same.

This is the most simplest way to do reconciliation when you dont have any specific software for this.

REGARDS,
C.A.NISHIT DOSHI

Message likes : 1 times

You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

Join the CA Students WhatsApp Community for ICAI Updates, Trending Courses & Notes!

Similar Resolved Queries

Unanswered Queries

Popular
Recent

Trending Online Classes

Direct Tax Laws & International Taxation May 26,Sept 26 & Jan 27

CA Arvind Tuli

Enroll Now
Audit Fast Track Recorded Batch For May 26,Sept 26 & Jan 27

CA Aarti Lahoti

Enroll Now
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English

CA Bhanwar Borana & CA Shubham Keswani

Enroll Now

view all classess

Meet our CAclubindia PRO Members

venkanna setty

shubham agrawal

R.Prashanth

Nilesh Matekar

Jayesh Pipalwa

Subscribe Now

Bank Reconciliation Statement

Similar Resolved Queries

Trending Online Classes

Meet our CAclubindia PRO Members

Quick Links

Browse by Category

Latest Job Openings

Senior Executive

Manager- Finance and Compliance

GST CONSULTANT

GST CONSULTANCY

Accountant

CA Final

Article Assistant

Associate CA