Home Page : TallyERP9Book.Com Click...Order Now ! Click...Order Now ! Click....Book Contents !
Connect with ...

Calculation of Balance as per Bank in Bank Reconciliation Statement.


How is the Balance as per Bank calculated in the BRS Report in Tally.ERP 9?

Example: According to the books of ABC Company, the balance of their account with HSBC is Rs. 30, 00, 05,000. The Bank Pass Book shows Rs. 30, 00, 00,000. Further comparison between the two showed that rent of Rs.10000, paid using cheque dated 6.8.2011, and rent received Rs. 15000, as cheque dated 8.8.2011, were not reflected in the Bank Pass Book. How is Balance as per Bank arrived at?


To view the BRS Report in Tally.ERP 9, go to Gateway of Tally > Banking > Bank Reconciliation > choose the Name of the Bank for which reconciliation has to be done.

In the BRS Report,

(a)    Balance as per Company Books reflects the Bank Balance according to the Books of Accounts maintained by the Company. Here, the amount is Rs.30,00,05,000 (Debit Balance).

(b)    Amounts not reflected in Bank indicates the total debits and credits of Voucher Entries that are not reflected in the Bank Pass Book. Here, it is Rs.15000 (Debit) andRs.10000 (Credit)Net amount not reflected in bank is Rs.5000 (15000-10000) Debit.

(c)    Balance as per Bank is the net amount resulting from the set off between (a) and (b). In the example, the amount is Rs. 30,00,00,000, i.e.,

Balance as per Company Books (-) the debit amounts not reflected in the Bank Statement (+) the credit amounts not reflected in the Bank Statement = Balance as per Bank.

Therefore, Balance as per Bank is arrived at as follows:

30,00,05,000 -  5000 = 30,00,00,000, which is the amount reflected in the Bank Pass Book.

Company Information @ Tally.ERP9
Group & Ledger


Advanced Inventory / Stock
Order Processing
Re-Order Levels
Tracking Numbers
Batch-wise Details
Additional Cost Details
Bill of Materials (BOM)
Price Lists and Price Levels
Stock Valuation
Zero Valued Entries
Inventory Ageing Report
Actual and Billed Quantities
Advanced Usage of Vouchers
Maintain Bill-wise Details
Cost Center and Cost Category
Interest Calculation
Reversing Journals
Post-Dated Voucher
Memo (Memorandum) Voucher
Optional Voucher
Using Tracking Number
Tally.ERP9 Report
  1. Unit Objectives
  2. Modifying Reports (Options)
  3. Balance Sheet
  4. Profit & Loss Account
  5. Stock Summary
  6. Trial Balance
  7. Day Book
  8. Books of Accounts
  9. Statement of Accounts
  10. Inventory Books
  11. Statutory Reports
  12. List of Accounts ( Chart of Accounts)
  13. Exception Reports
  14. Printing Reports
Tally.ERP9 MIS and Other Reports
Statutory & Taxation
Utilities & Others @ Tally.ERP9
Credit Limits
Knowledge Base @ Tally.ERP9
Stock Items
Stock Groups
Inventory Masters
Inventory Vouchers
Inventory Report Statements
Balance Sheet
Accounting Reports
Accounting Vouchers
Interest Calculation
VAT-Value Added Tax
Service Tax
TDS (Tax Deducted at Source)

Enter your email address:
[ Get Tally.ERP 9 Questions & Knowledge Base Feed delivered by eMail ]

Delivered by FeedBurner

Disclaimer :

The names of Companies and persons used in this Website have been used for illustrative purposes only.
The visitors may visit www.tallysolutions.com , the web site of Tally Solutions Pvt. Ltd. for resolving their doubts or for clarifications

Trademark :

Tally, Tally 9, Tally9, Tally.ERP, Tally.ERP –9, Tally.Server 9, Tally.NET & Power of Simplicity are either registered trademarks or trademarks of Tally Solutions Pvt. Ltd. in India and/or other countries. All other trademarks are properties of their respective owners. This Website is not associated with any product or vendor mentioned in this Website.

TIPS & TRICKS @ Tally.ERP9 GST for Tally.ERP9
1 > Financial Statement Report 1 > Tips & Tricks @ Tally.ERP 9 1 >Introduction to GST ( IGST . CGST, SGST )
2 > Accounts Book & Register Report 2 > FAQ's @ Tally.ERP 9 2 >Calculation of GST ( IGST, CGST & SGST)
3 > Stock Register / Reports 3 > Short Cut Keys @ Tally.ERP 9 3 > GST on Tally.ERP 9 ( With Practical Assignment )
4 > Job Costing Reports 4 > Tips-Weekly Refresher @ Tally.ERP9 4 > Generate GSTR-1 Returns / Reports under Tally.ERP9
5 > Pay Roll Register Reports   5> Status Reconciliation (GSTR-1)
6 > Point of Sale Register Reports   6 > Challan Reconciliation Report for GST Payments
  8 > Excise - Manufacturer      
  9 > Technology / Utilities      
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...
Website Designed, Hosted, Owned by : www.BalasoreCity.Com