Unable to Import the Data in Tally

When you are trying to import the data in Tally using XML file, make sure that option “Ignore errors during data import” is set to Yes.  This setting will allow Tally to import the matching data and generate the log/imp file with the summary of Imported data and not imported data with complete error description. On gateway of Tally, Press F12 > General See the below snapshot 

Continue reading

How to Control Duplicate Voucher Import in Tally

  Voucher number is the only check point for the Tally when you are importing any data from XML to Tally. In case your voucher numbering method is automatic than there is a high possibility that your data gets duplicated when the same XML or voucher has been imported in Tally. Solution To prevent duplication of vouchers keep your voucher numbering method as “Manual” with Prevent duplicate option as “Yes” Important Note In case if you are trying to modify the numbering method of your existing voucher type than their is a possibility that your old numbers...

Continue reading

Date Format Issue In Excel File

Refer below steps to resolve date formatting issue while processing data. Step 1:- First of all select the Columns containing the “dates”     Step 2: Select Text To Columns. You’ll find this on the DATA tab/menu, depending on which version of Excel you are using.     Step 3: Ensure that the original data type is set to Delimited and click Next     Step 4: Ensure that all the check boxes are clear and click Next     Step 5: Set the Column Data Format to DMY and Click Finish button this format is DD/MM/YYYY is format is correct date format.  

Continue reading

Error – No Accounting Allocation For!

You might have noticed error message “No Accounting Allocations For !” while importing XML data to Tally.ERP9   To resolve this error, set option “Enable Inventory Values are affected to Yes” The possible reason for this error is one of your vouchers in XML is having no accounting values. Refer below snapshot  

Continue reading

How to record TDS Deducted by Flipkart in Tally?

In the Finance Act 2020, the Government has introduced new rules in Section 194-O which provides a withholding of TDS by e-commerce companies for facilitating sale of goods and services of e-commerce participants through its marketplace. These rules are effective October 1, 2020. Many sellers like you have came across the query of how to account the same in Tally? Please refer the steps below to learn how to record TDS deducted by Flipkart in Tally. Recording TDS Receivable Entry Check for the TDS values in the settlement file you received as shown...

Continue reading

How to record TDS Deducted by Amazon in Tally?

In the Finance Act 2020, the Government has introduced new rules in Section 194-O which provides a withholding of TDS by e-commerce companies for facilitating sale of goods and services of e-commerce participants through its marketplace. These rules are effective October 1, 2020. Many sellers like you have came across the query of how to account the same in Tally? Please refer the steps below to learn how to record TDS deducted by Amazon in Tally. Recording TDS Receivable Entry Check for the TDS values in the settlement you received as shown in...

Continue reading

How to Record TCS deducted by the Flipkart in Tally?

Tax Collected at Source (TCS) under GST means the tax collected by an e-commerce operator from the consideration received by it on behalf of the supplier of goods, or services who makes supplies through operator’s online platform. TCS will be charged as a percentage on the net taxable supplies. Flipkart Tax Report contains the Invoice wise breakup of TCS deducted on each orders. In order to account the same in Tally, you will have to Debit the TCS Ledger and Credit the Flipkart Ledger. To account TCS entries in bulk on all...

Continue reading

How to Record TCS deducted by the Amazon in Tally?

Tax Collected at Source (TCS) under GST means the tax collected by an e-commerce operator from the consideration received by it on behalf of the supplier of goods, or services who makes supplies through operator’s online platform. TCS will be charged as a percentage on the net taxable supplies. Amazon Merchant Tax Report (MTR) contains the Invoice wise breakup of TCS deducted on the sale. In order to account the same in Tally, you will have to Debit the TCS Ledger and Credit the Amazon ledger. To account TCS entries in bulk...

Continue reading

Can’t Import Check Tally.IMP for details

Often you might have encountered this error message while importing data to Tally.ERP9. In this article I'll try to explain you the possible reason of getting this error message, how to identify and it's solution; What are the Possible Reason for this error? Following masters exists in your XML but missing in Tally data Item Master Ledger Master Unit of Measurement Godown Voucher Type Same Voucher number already exists (if prevent duplicate is set as Yes) Currency What is Tally.Imp file? Tally.Imp file is a nothing but a complete log file of...

Continue reading