Mandatory things to check before using Purchase/Purchase Return module

---

Checklist for Excel sheet Before Using Purchase/Purchase Return Module

1. The data you want to upload should be in the first sheet.

2. Headers should be on the top (in the first row).

3. Ensure the uploaded Excel file does not contain dot (.) or dollar ($) symbols in the column header. Do not add anything above the title other than the sales/purchase field.

4. The Invoice Number field must be filled in and should not be blank.

5. Ensure the same invoice number appears together. If required, sort your data A-Z based on the Invoice Number.

6. Avoid writing inappropriate data in the sheet:

   • For example: Under the GST column, if a GST number is not applicable, leave the cell blank. Do not write NA, not applicable, or other text.

7. Use the DD/MM/YYYY format for dates (e.g., 27-05-2022).

8. Remove Grand Total or any extra data that is not required to be transferred to Tally.

9. Limit transactions to 10,000 per sheet.

10. Add one Purchase/Purchase Ledger column in the sheet according to the GST rate.

11. Ensure SGST, CGST, and IGST ledgers are created under Duties & Taxes in Tally for mapping purposes.

12. Format data appropriately:

    • Text fields should be in TEXT or General format.
    • Numeric fields should be in Number format.
      To learn how to change the format, visit the
      Microsoft Support Link.

13. Add a column named Particular, where you can add details of the Purchase Account Ledger according to the GST rate.
    For example: If the GST rate is 18%, mention the Ledger name where the 18% GST rate is defined.

14. Save the document in Excel Workbook format.

How to prepare excel Sheet Click here.

You may find this useful :

• Learn how to upload Purchase/Purchase return data, Learn more.