One can record the export of goods, sales, diff GST & exempt sales, deemed export, and so on using a sales voucher through SUVIT.
The data you want to upload should be in the first sheet.
Headers should be on the top (in the first row).
Please ensure the uploaded excel file does not contain the dot(.) and dollar ($) symbols in the column header, and other than the sales/purchase field, do not add anything above the title.
Invoice number should be filled in and must not be blank.
Same invoice number should be together, if require sort your data A-Z on the Invoice number.
Also, do not write any inappropriate data in the sheet. For example:- under GST Column, if GST number is not applicable, keep the cell blank; do not write NA, not applicable, or something else.
Date format should be DD/MM/YYYY (27-05-2022).
Delete Grand total or any extra data which otherwise is not required to be transferred to tally, if given in the sheet.
Transaction numbers can be up to 10,000 per sheet.
Add one Sales/Purchase Ledger column in the sheet according to GST Rate.
Must have SGST, CGST & IGST Ledger under Duties & Taxes in Tally for Mapping purposes.
All text should be in TEXT or General Format, and Numbers should be in Number format (how to change the format, visit the Link here
Add a Column with the name in Particular, where one can add details of the Sales Account ledger according to GST rate.
How to Upload Sales/Sales Purchase, click here.
