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.