Why the totals matter
A bank statement is often the first document checked when someone else needs to understand your money: a tax practitioner preparing your return, an auditor, a bank processing a loan, or a court looking at maintenance or a recovery claim. Before reading individual entries, they want three numbers for the period:
- Total deposits (credits): everything that came into the account
- Total withdrawals (debits): everything that went out
- Opening and closing balance: and whether opening + credits − debits = closing
Where these numbers are used
- Income tax returns: total credits are compared with declared turnover or income. Large gaps prompt questions.
- Presumptive taxation (44AD): the higher turnover limit applies only if cash receipts are within 5% of total receipts, so you need receipts split by mode.
- AIS and high-value transactions: banks report cash deposits and some other transactions above set thresholds. Your statement totals help you check that what the department sees matches reality.
- Tax audit and GST: bank credits are reconciled with sales and GSTR-1 turnover.
- Loans: lenders look at average balance, credits per month and bounces.
Why adding up a statement is harder than it looks
Bank statements are made for reading, not calculating. Copying one into a spreadsheet usually brings problems with it:
- Narrations wrap onto two or three lines and push amounts into the wrong rows.
- Reference numbers and cheque numbers look like amounts and get added in.
- Some banks use one "Amount" column with Dr/Cr markers, others use separate Debit and Credit columns.
- Page headers, "balance brought forward" lines and page subtotals repeat on every page.
- Scanned or photographed statements have no text at all until OCR is run.
- Indian formatting (1,23,456.78) is not always recognised by spreadsheets as a number.
A reliable method
- Get the right file. Download the statement as a PDF from net banking for the exact period you need. A downloaded PDF has real text and is far more accurate than a scan. If it is password-protected, unlock it first (the password is often a mix of name and date of birth or customer ID).
- Identify the columns. Find the Date, Debit/Withdrawal, Credit/Deposit and Balance columns. Only amounts under the Debit and Credit headers should be counted.
- Total page by page. Calculate credits and debits for each page separately. If something goes wrong, you then know which page to look at.
- Check the running balance. For every entry, previous balance + credit − debit should equal the balance printed on that line. Any entry that breaks the chain has been read wrongly.
- Tie up the whole statement. Opening balance + total credits − total debits must equal the closing balance. If it does, your totals are right.
- Note what needs explaining. Large cash deposits, round-sum transfers from relatives, loan credits and refunds are not income, but they will be asked about.
Our Bank Statement Calculator follows exactly this method in your browser: it reads only the Debit, Credit and Balance columns, totals each page, checks the running balance on every line, and lets you correct any entry. The file never leaves your device.
Classifying credits for a tax return
Once the totals are right, the credits usually need to be split so the return tells the true story:
| Type of credit | Usual treatment |
|---|---|
| Salary, fees, sales receipts | Income (salary, profession or business) |
| Interest on savings and FDs | Income from other sources |
| Transfers between your own accounts | Not income: exclude from both sides |
| Loan disbursements, repayments received | Not income, but keep the loan documents |
| Gifts from relatives | Generally exempt for specified relatives; keep a note |
| Income-tax refunds | Not income (the interest on a refund is taxable) |
| Sale of investments or property | Capital gains are computed separately on the transaction |
Frequently asked questions
Can I use a scanned bank statement?
Yes, but it needs OCR (text recognition) first, and the result must be checked more carefully because OCR can misread digits. A statement downloaded from net banking is always better.
Why don't my totals match the bank's summary?
Usually because a wrapped narration pushed an amount into the wrong column, or a reference number was counted as an amount. A running-balance check on every line finds the exact entry.
Is it safe to upload my bank statement online?
Only use tools that process the file in your browser or that you trust with financial data. Our Bank Statement Calculator works entirely in your browser; the PDF is not sent to any server.
Upload a PDF statement and get page-by-page and total deposits and withdrawals, checked against the running balance. Open Bank Statement Calculator →
Sources and further reading
This guide explains the law and portal procedures as they stood on the date shown above. Rates, forms and due dates change; check the official sources before filing. It is general information, not professional advice for your particular case.