Archive for 4. How to Use

Excel to Tally ERP 9 – Accounts Only Version How to Use

Excel to Tally ERP 9 – Accounts Only Version How to Use


Excel to Tally ERP 9 – Accounts Only Version How to Use will make you understand how to use Excel to Tally ERP 9 – Accounts Only Version How to Use.
Excel to Tally ERP 9



1)      Configure Date Format in Control Panel (Recommended)

Excel to Tally uses DD/MMM/YYYY format for date for example 05/Apr/2013. To set this format in your computer follow these steps

a)      Windows XP

i)        Start Menu > Control Panel > Regional & Language Option > Regional Option > Customized > Date > Short Date Format > DD/MMM/YYYY > OK > OK

b)      Windows 7

i)        Start Menu > Control Panel > Regional & Language Option > Short Date Format > DD/MM/YYYY > OK

2)      Configure Tally ERP 9 (Mandatory)

Open any Company

a)      Port Setting: Port 9000

i)        Open: Gateway of Tally > F12: Configure > Advanced Configuration

ii)      Tally Acting as : Both

iii)    Enable ODBC Server: Yes

iv)    PORT: 9000

b)      Master Export XML Setting

i)        Open Gateway of Tally > Display > List of Accounts

ii)      Press Alt + E

iii)    Press N

iv)    Language: Default

v)      Format: XML

vi)    Press Ctrl + A

vii)  Yes > Yes

3)      How to Export Entry from Excel to Tally ERP 9

a)      Copy Paste from Other Excel File

i)        Take your Tally Company Back Up (Recommended)

ii)      Open Tally ERP and Company in which you want to Export Entries from Excel to Tally

iii)    Make Sure that only one Tally is Open and Only One Company is Open

iv)    Now Open You Excel File which contains data you want to transfer to tally

v)      And then Open Excel To Tally ERP 2014-1.exe

vi)    A Excel File Will open

vii)  Do Not Enter any data in 1st two columns i.e. “STATUS” AND “REMARKS”

viii)         Explanation to Remaining Columns

(1)   VCH Type: Paste Here Voucher Type Column

(2)   VCH No.: Paste Vch No. If Manual in Tally

(3)   Ref. No.: Paste Ref. No. for Sales / Purchase

(4)   Date: Paste Date (DD/MMM/YYYY)

(5)   Narration

(6)   Cr. Account & Cr. Amount

(7)   Dr. Account & Dr. Amount

(8)   For More than one Dr / Cr in single transaction use other Dr / Cr Columns given and leave empty for those not required

ix)    Click Export to Tally

x)      After Clicking Export to Tally if you see any message and some cells turned to YELLOW it means these ledgers are not Created in Tally. To Create it Click on Create Ledger, Define Group Name and Click Export to Tally.

b)      Direct Entry in Excel to Tally

i)        Follow above steps but instead of Copy Paste Type Entries in Excel to Tally

Excel to Tally How to Use for Tally ERP 9

Excel to Tally How to Use for Tally ERP 9


Excel to Tally How to Use for Tally ERP 9 will make you understand how to use Excel to Tally for Tally ERP 9.

Excel to Tally Downloads

Excel to Tally ERP 9



a) Open desired company in Tally.ERP 9
  • In Windows Vista / Windows 7, Excel to Tally and Tally.ERP 9 shall be opened in RUN as Administrator mode (i.e. right click on ICON, Click on Run as Administrator)

b) Open Excel to Tally from desktop shortcut
  • In Windows Vista / Windows 7, Excel to Tally and Tally.ERP 9 shall be opened in RUN as Administrator mode (i.e. right click on ICON, Click on Run as Administrator)

c) Click on Excel to Tally for Receipt, Payment, Contra and Journal OR Sales & Purchase 1, 2, 3 as the case may be
  • In case of Sales & Purchase 1, 2, 3

  1. Select Sales / Purchase
  2. If VAT is applicable select YES in Enable VAT
  3. If ADDITIONAL VAT / SURCHARGE is applicable select YES in Enable ADDITIONAL VAT / SURCHARGE
  4. and select Type of Additional VAT / Surcharge i.e. ADDITIONAL VAT or SURCHARGE
  5. If Entries are to be done with inventory select YES in Enable Inventory
  6. Click on Proceed

d) Now you will see DATA ENTRY SHEET where you have to copy paste or type your DATA as per columns given in DATA ENTRY Sheet. Paste DATA Column wise i.e. first copy date and paste in excel to tally then narration, ref. no and so on
e) Click on
  • Export to Tally in case of Receipt, Payment, Contra and Journal
  • VALIDATE in case of Sales & Purchase 1, 2, 3

f) Possible Alerts
  • RED Highlighted Cells are those cell which must contain some data
  • YELLOW Highlighted Cells are Cell Containing Ledger, Stock Item or Unit of Measure Name not available in TALLY. Stock Items and Unit of Measure will be created automatically but for LEDGERS user have to click on CREATE LEDGER Button
  • Row having GREEN Highlighted Cells says that total of Debit and Credit is not equal

g) If there are no alerts or only alert of Stock Item and Unit of Measure not available in tally user has to click on Export to Tally Button otherwise CREATE LEDGER or VALIDATE Button as the case may be
h) User has to cross tally number of entries exported to tally and Export Report Generated.

Excel to Tally How to Use for Tally 7.2 and Tally 9

Excel to Tally How to Use for Tally 7.2 and Tally 9


Excel to Tally How to Use for Tally 7.2 and Tally 9 will make you understand how to use Excel to Tally for Tally 7.2 and Tally 9.

exceltotally72andtally9

Excel to Tally 7.2 and Taly 9


  1. Open Excel to Tally
  2. Provide Tally Version viz. Tally 7.2 or Tally 9 or Tally.ERP 9 whichever you are using.
  3. Selection Year Type viz. Financial (1st April to 31st March) or Calendar (1st January to 31st    December).
  4. Open Tally
  5. Close all open Company in Tally
  6. Open the company to which you want to Export Data
  7. Come back to Excel to Tally
  8. For exporting transactions
    1. Click on ALL VCH TYPE
    2. Enter your data in given format or copy paste data in given format (Right Click > Paste Special > Paste Value > OK ; OR Right Click > Paste Special > Text > OK)
    3. Click on Validate
    4. If some or All Ledgers are not available in Tally.
      1. Click on Create Ledger
        1. Provide Name of Group and Opening balance if any (For Debit Opening Balance put minus sign before Amount eg. -1000)
        2. Click on Export to Tally
      2. OR
      3. Make appropriate change in Tally and / or Excel Sheet and Click on Import Ledger List
        1. Click on Validate
        2. Click on Export to Tally
    5. See Tips and Tricks page for more clarifications (important to follow for accurate data export)
  9. For exporting only list of ledger
    1. Click on Create Ledger
    2. Enter name of Ledger, Name of Group of Ledger and Opening balance if any (For Debit Opening Balance put minus sign before Amount eg. -1000)
    3. Click on Export to Tally
    4. See Tips and Tricks page for more clarifications (important to follow for accurate data export)