How to use the Auto Bank Reconciliation feature in Tally.ERP 9, applicable from Series A Release 3.6

For Auto Bank Reconciliation in Tally.ERP 9, ensure that the following configuration have been made in the Bank’s Ledger Master (Creation/Alteration mode):

  • Set/Alter Banking Configuration

  • Select Bank for the Ledger

Select the relevant bank for the bank Ledger from the available List of Banks

  • Activate Auto Reconciliation

Set the option Activate Auto Reconciliation? to Yes

Auto Reconciliation of the Bank Statement with the Company Books

Go to Gateway of Tally > Banking > Bank Reconciliation

  • Select the required bank from the List of Banks that is displayed

The Bank Reconciliation screen for the selected Bank appears:

  • Click on B: Bank Statement or press Alt+B

The Select File screen appears:

  • Press Backspace to select the relevant File Type for the bank statement being imported

  • Select the required file (Bank Statement) for reconciliation

  • Press Enter

A message appears, indicating the Total Entries in Bank Statement, number of Reconciled transactions, and Additional Bank Entries

  •  Press any key to view the Bank Reconciliation with reconciled and additional transactions
  • The reconciled transactions will appear with the Bank Date filled automatically upon import of the bank statement
  • The additional entries present in the bank statement will be reflected under Amounts not Reflected in Company Books

Reconciliation of Amounts not Reflected in Company Books

Amounts not Reflected in Company Books can be Reconciled in two ways:

Reconcile Unlinked:

  • Place the cursor on the required transaction, and click on R: Reconcile Unlinked or press Alt+R

The Unreconciled Amounts screen appears, displaying all those transactions for which auto reconciliation hasn’t been done

  • Place the cursor on the required transaction and press Enter

The selected transaction under Amounts not Reflected in Company Books and the transaction chosen from Unreconciled Amounts will get reconciled

Create Voucher:

Entries like Bank Charges, which appear in the bank statement but not in the Company Books, can be created from the Bank Reconciliation screen.

  • Place the cursor on the required transaction, and click on C: Create Voucher or press Alt+C

  • The Voucher Creation screen appears
  • The amount field and the narration field appears automatically filled with details captured from the bank statement
  • Select the required Ledger
  • Instrument number in the bank statement will be automatically captured in the Bank Allocations screen

  • Press Enter to Accept the Voucher Creation  
 
 
 
Company Information @ Tally.ERP9
 
 
 
Group & Ledger
Introduction
1. THE GROUP
2. THE LEDGER
3. VOUCHERS TYPES
Advanced Inventory / Stock
Meaning
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
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)
 
 
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 GST,TallyERP9 GST, 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.

GETTINGS STARTED @ Tally.ERP 9
QUESTIONS BASE @ Tally.ERP 9
REPORT GENERATES @ Tally.ERP 9
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      
SWAYAM EDUCATION
Mandal Bagicha, Hemkapada,
Sunhat, Balasore-756002 ( Odisha )-India
eMail ID : tallyerp9bookorder@gmail.com
Web : www.tallyerp9book.com
Mob : 09437264738
Get Updated ...