Sales/Purchase data with Multiple GST rates and with Common GST Tax tally ledgers

The data of sales/purchase/credit note/debit note with multiple GST % applicable need to be mapped in common GST tally tax ledgers. This article is curated to learn how to map such excel sheet.


Sales/Purchase data with Multiple GST rates and with Common GST Tax tally ledgers

If you have the sheet containing data where multiple GST % is applicable. Like below Image:

The Sale/Purchase ledgers must have GST % set already in your tally if you want to automatically calculate the tax amount. 1Image S6.png

In tax ledger mapping, the "Select ledger" will allow you to select ledgers which are there in your tally. Refer image below where common "Sgst", "Cgst" & "Igst" are selected and mapped: 2Common GST1.png

Your entry will look like in tally like this(Sample entry in tally). 3sample entry.jpg