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
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
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!
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
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 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
Click here to login now
Similar Resolved Queries
Unanswered Queries
- About TDS & Income Tax
- Section 194JA & JB Income which ITR Form to use
- Pass word to open justification report for Q1 for FY 2026-27
- PPF interest-As Exempt Income disclosure
- Under construction property in ITR
- Scrutiny and reopening of past returns
- Booth for sales promotion
- Upload Level ValidationITR3Category of Defect B/D
- Building tax payment deduction in rental Income
- F & O PROFIT REPORTING FOR AY 2026-27
- Difference in GSTR3B system generated which is correct and actual Payment it asks
- Indian IT Portal issue in computing tax as per UK-India DTAA
- Capital Gains on sale of residential flat
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Taxation in the hands of Landowner under JDA
- Delisted shares sold in off market/ Rebate u/s87A
- In Exports Sales HSN details where to fill
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
