Bank Reconciliation Statement


This query is : Resolved 

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

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 (Expert)
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

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!

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


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



Similar Resolved Queries


loading


Unanswered Queries



CCI Pro



Answer Query



Company
ARTICLESHIP 29 October 2026
Article Assistant (CA Inter / CMA Inter) - Thrissur

Varma Raja & Associates

Thrissur

CA Inter

View Details
Company
02 November 2026
Audit Executive

SRJP & Co LLP

Kochi

CA Inter

View Details
Company
12 November 2026
Auditor

Oz Taxation

Vijayawada

Graduate (Any)

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
12 November 2026
Tax Product Specialist

BharatX.ai

Gurgaon

B.Com

View Details
Company
ARTICLESHIP 17 November 2026
Vacancy for Articleship

Promptitude Accounting Services Private limited

Bengaluru

B.Com

View Details
Company
ARTICLESHIP 14 November 2026
Articleship Assistant

B Thejas and Associates

Bengaluru

CA Foundation

View Details