Bank entry In tally

Quick Summary
This discussion explains how to accurately enter bank statement transactions in Tally, covering receipts, payments, and contra entries. It also details the process of bank reconciliation in Tally ERP9, including matching ledger entries with the bank statement and accounting for discrepancies like bank charges and interest. For high-volume statements, using Excel export to minimise errors and save time is recommended.

Originally posted by : Eswar Reddy S
Look at your replies in the past 4 months. One can find the quality of your answers.

Ji,

I know very well myself. Quality and Experience is my own. 

First of Look Your profile before my return to CCI.

How your profile came to list...

Think Yourself first You are professional or Fake ID master. After correction of this activity then come and criticize my activities. I Will give respect after that...

First you stop all unwanted messages and unrelated answers .

Hope you have made a call through another person recently.

I know your politics and trics.
Originally posted by : Eswar Reddy S
First you stop all unwanted messages and unrelated answers .Hope you have made a call through another person recently.I know your politics and trics.

Hello,

First You stop your fake activities... After that You will write msg against me....I

Call...???

Politics...???

 

Ohh god, I'm not the person...

I don't give call to anyone and it's not my duty. Also it's not required to me...

Really I'm not...

Please Check who is that stupid one...

Bank reconciliation in Tally basically means matching your book entries with the bank statement, then passing entries for anything missing, like bank charges, interest, or unrecorded deposits. Once every transaction on both sides matches, your reconciliation is complete. If the statement is large, doing this manually row by row gets tedious, so many accountants now convert the statement into ready to import Tally entries first, then reconcile.

It's easy! Create bank account in tally. 

A routine that keeps mistakes low, month after month:

 

1. Check the statement first. Opening balance + total credits - total debits should equal the closing balance, and it should agree with the bank ledger's balance at the start of the period. If it doesn't, find that difference before entering anything.

2. Classify each row: money out = Payment (F5), money in = Receipt (F6), cash withdrawal/deposit or transfer between the client's own banks = Contra (F4). Bank charges, interest, GST on charges, TDS and EMI rows usually have a fixed ledger, so set them once.

3. Rows you can't identify yet go to a Suspense ledger, not a guessed party. Your Suspense balance is then the list of questions to ask the client.

4. UPI narrations: the payee's UPI ID and the 12-digit reference identify the party far better than the truncated name.

5. Reconcile: open Banking > Bank Reconciliation for the bank ledger and enter the bank date for each entry. What's left (cheques not yet presented, deposits not yet credited) is your BRS.

6. Finally, the bank ledger's closing balance for the period should equal the statement's closing balance to the rupee.

 

For long statements, typing is where mistakes creep in, and converting the PDF and importing vouchers is faster. Disclosure: we build KhataSheet, a free in-browser converter that does this with a row-by-row balance check. We also wrote a month-end BRS checklist: https://khatasheet.com/guides/bank-reconciliation-checklist?utm_source=caclubindia&utm_medium=community&utm_campaign=2026-w43-launch

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
14 October 2026
GST & TDS ASSISTANT

AGGARWAL SANJAY & ASSOCIATES

New Delhi

B.Com

View Details
Company
19 October 2026
Accountants/Articles (Freshers/Experienced)

ADY & CO.

New Delhi

Graduate (Any)

View Details
Company
ARTICLESHIP 07 October 2026
Article Trainee/ CMA Trainee

RMA And Associates LLP

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 28 September 2026
Junior Accountant

J S P M & Associates LLP

Pune

B.Com

View Details
Company
14 October 2026
Asst. Manager/Dy Manager (Costing)

manufacturing

Pune

CMA

View Details
Company
ARTICLESHIP 07 October 2026
Article Assistant

Malhotra Rajesh & Associates

New Delhi

B.Com

View Details
Company
ARTICLESHIP 17 October 2026
Articled Assistant

RRPM & Associates LLP

Chennai

CA Inter

View Details