Bank Guide

SBI Bank Statement to Tally: Direct Import Guide

Import SBI (State Bank of India) Excel bank statement directly to Tally using Synergy Automation. Step-by-step guide.

How to Download SBI Statement as Excel

Where to find it: SBI Online / YONO → Account Statement → Excel / CSV format

File format: SBI exports statements via YONO or SBI Online. Columns: Txn Date, Value Date, Description, Ref No./Cheque No., Debit, Credit, Balance.

Step-by-Step: SBI Statement to Tally

  1. Download your SBI statement
    Go to SBI Online / YONO → Account Statement → Excel / CSV format. Select your date range and download as Excel (.xlsx or .xls).
  2. Open Synergy Automation
    Make sure Tally is open with the correct company. Make sure the Synergy Connector is running on the same PC.
  3. Upload the Excel file
    Drag and drop your SBI Excel file into Synergy Automation. The system auto-detects the format. You will see all transactions parsed and listed.
  4. Review every entry
    Check narrations, amounts, dates. Assign Tally ledger accounts. Skip any entries you do not want in Tally.
  5. Post to Tally
    Click Post. Entries appear instantly in your open Tally company as bank payment and receipt vouchers. No XML, no file, no import dialog.

SBI-Specific Notes

  • SBI narrations are often long — include branch name and transaction reference
  • SBI CSV exports sometimes have extra header rows — use the Excel (.xlsx) download from net banking for cleanest results
  • Account statement from SBI branch (physical) often comes as PDF — convert to Excel first
  • Passbook entries and digital statement may differ in narration format

Common Ledger Assignments for SBI Transactions

Narration ContainsSuggested Tally Ledger
UPIUPI Expenses or specific party
RTGSParty ledger mentioned in narration
INT.Bank Interest Received
CHRGBank Charges
ATMCash Account

Use these as a reference when assigning ledgers in the review table before posting to Tally.

Frequently Asked Questions

Q: Does Synergy Automation work with SBI statement format?

Yes. Synergy Automation automatically detects the SBI Excel statement format and parses columns correctly. No manual column mapping needed.

Q: Do I need to convert SBI statement to XML before importing to Tally?

No. Synergy Automation posts entries directly from Excel to Tally — no XML file is created or needed. This is faster and simpler than traditional XML import methods.

Q: Is this free for SBI statements?

Yes. Synergy Automation is free to use. No limits on banks, entries, or companies.

Try with Your SBI Statement — Free

Upload your SBI Excel statement. Review entries. Post directly to Tally Prime or ERP 9.

Get Free Access