Error :   Error while importing Sales with Inventory excel –  proper ref name is not given for retailer Solution :  Please fill data in column name Bill Ref No It should not blank, If you don’t have data for this column then, please copy Invoice No and  paste inBill Ref no then generate xml file again. Try importing the newly created ..

Read more

Issue :      Bank Statement xml Data Import in Tally Error – Proper Ref Name not given for ‘Suspense A/c’! Solution : 1.  Please fill data in column name ‘Bill Ref No‘ in Excel. It should not blank. 2.  Before Processing your excel data, make sure column  Transaction ID & Bill Ref No are not blank in excel, if yes, please ..

Read more

Issue :  Tally Import Error – Voucher totals do not match! Dr: 22,050.00 Dr Cr: 22,000.00 Cr Diff: 50.00 Dr Solution : 1.  Verify the excel data filled with proper Debit and Credit Amount 2.  Remove excel formula’s if any 3.  After correcting point 1,2 in excel, Please regenerate XML file using Excel4Tally 4.  Import newly created ..

Read more

Issue :     When Xml Data Import in Tally Error – The date 1-8-2017 is Out of Range! – Tally Books & financial Year Solution : 1. If your excel data date financial year 2017 & Tally books financial year 2018  Excel4Tally Support dd/mm/yyyy date format, Ex date : 27/01/2018 2. Please make sure your financial ..

Read more

Issue :     When Xml Data Import in Tally Error – Invalid date format in date OR Date Out Of Range Error Solution : 1.  One or More data specified in Excel file in not correct date format. 2.  Please make sure your date format is correct in excel file , we use DD/MM/YYYY. 3.  After correcting ..

Read more

Issue :  When Xml Data Import in Tally Error – Item does not exist in Tally. Solution : 1.  Please check if specified Item Name exist in Tally, 2.  if already exist, Please make sure there is no space before or after Item name in tally as Tally consider  it as different name.  3. if doesn’t ..

Read more