Bank Statement Import from Excel to Tally.ERP 9

Bank Statement Import in Tally.ERP from Excel
LOGO Import Bank Statement into Tally.ERP9 From Excel

ANY e-Bank Statement Import Excel to Tally.ERP9

EazyAUTO4 Excel to Tally Data Converter: has introduced a new unique feature. Now you can directly import your any e-bank statements as is downloaded from bank's website. You don’t have to change anything in excel sheet. Just import bank statement & directly book entries in Tally 6.3 onwards. These all entries will be posted to suspense Account. Afterward you can alter these entries in Tally.

If you want to post bank entries to their relative accounts then you can alter bank statement and add ledger name column to statement sheet. And select ledger names from unique Ledger List provided by EazyAUTO4. To use this ledger list anywhere in excel Activate is by clicking on "Activate LedList in Excel" from main screen of EazyAUTO4. And now just press "~" (tilde) key to get this list.

  • Simple, User friendly & Fast.
  • You can manage multiple Banks as per your requirement
  • Four predefined banks like ICICI Bank Limited , State Bank of India (SBI), Industrial Development Bank of India (IDBI) and Axis Bank Limited
  • NO Programming / XML / TDL knowledge required.
  • You can alter / add Ledger column to book these entries to their relative a/cs
  • No Need to Copy & Paste from your actual excel sheet to any excel format.
Advance Features:
  • Automatic voucher mode detection for contra
  • Automatic voucher mode detection for payment
  • Automatic voucher mode detection for receipt
  • Automatic ledger creations
  • 100% Tallied as per your excel entries.
  • Any bank’s statement can be imported.
  • Preview/validation of data before booking entries
  • Condition creation [AUTO ledgers replace as per condition set on descriptions]
  • Combine Narration/Particular/ Bank Description and Cheque/Reference number in Narration
  • Effect in Tally’s Bank Reconciliation window
  • New Ledger Detection before posting
  • New ledger creations if not exist in Tally with your permission.
  • Create Multiple/Unlimited Bank formats
  • Cash book also imported
  • Single Amount Columns Can be used for (ICICI/Axis)
  • Supported data formats XLS, XLSX, CSV, HTML, TXT
  • Sheet Selection while importing workbook
  • Data Mapping
  • Support to use Manual Or Automatic voucher numbering method in Tally.
  • Book entries in respective ledger account heads.
  • If ledger heads are not provided in excel it will take "Suspense A/c" ledger automatically.
  • No need to delete unwanted columns from your actual data sheet
  • Bank wise multiple conditions can be created
  • You can create, alter, and delete conditions
  • Undo Entries Option
How to Import Bank Statement Excel to Tally?
  • Open Tally and Select desire company in Tally
  • Open EazyAUTO4 and Select Tally Company in EazyAUTO4 which is already opened in Tally
    • Excel to Tally
    • Bank Statements
    • Select Your Bank Name
    • Click on Import Statement
    • Select Excel Workbook/Sheet & Open
    • Book in Tally, it will show booking processing bar.
    • After posting entries switch to Tally and its done!