Dear Sambaji,
We need itemwise tax breakup in invoice format.
Please help me in this regard. I tried this custom script. But no luck. Where these tax breakup data stored?
***Quick fix: This can be solved if we change tax breakup to text editor field.
Refer this post if you want to show tax breakup
It is really helpful
Thanks
Checked with our accountant and I think there is still some ambiguity with regards to SAC. GST portal has list of SAC, and then there is also thing about using Service Account Code as SAC.
Even if it is needed, would be fine it can make HSN also as HSN /SAC masters? You can add your required SAC code manually, if not readily available.
Hi,
In GST we require the invoices to show the breakup of taxes for the items. Whereas I can see them on the Sales Invoice document, I can’t figure out how to print them in a print format. Is there a way to do it?
regards,
Amit
@umair, @rmehta
Please help with this matter. I brought this issue up earlier as well. We need to show tax break up in print. If we can print Item wise tax break field which is now a code field, this can be sorted. What should we do?
Is there any reason tax rates are not picked up based on HSN Code?
We Just upgraded for GST feature. My understanding was that when we specify HSN code for an Item, corresponding tax rate (5, 12, 18 or 28) will be automatically picked up based on the Code.
Is there any reason we need to mention Tax Rate Itemwise?
Is there any reason why “In State GST” and “Out of State GST” rules have to be manually selected ?
Since we know the GSTIN of the Company and Customer, can it not be automatically decided and defaulted to either IGST or SGST while creating Sales Order or Sales Invoice.
As of now, we are required to select the rule manually.
@Sachin_Mane, is there any list from government website or official source, which gives HSN Code wise tax percentage?
@Pawan, To be frank I dont know if there is any such list. However even if such list is not available, we can maintain the TAX %age against the HSN code as a master data and apply it while creating order and invoice?
This will avoid effort duplication of updating the tax rate in each item for both - one time setup as well as any revision in future for tax rates.
Do we know for certain that every HSN code will use one and only one rate slab? Here is one example of where that is not particularly true at the 4 digit level.
8517 Majority of Networking products 18 percent
8517 Imported mobile phones 12 percent
I have not checked the 8 digit level.
I think Tax rates have to be fixed. Otherwise there is no meaning of classifying using HSN. Can you verify the full HSN code for above scenario?
HSN Codes can either be 2 digit, 4 digit, 6 digit, or 8 digit based on size. I don’t think we should assume that all users must use the 8 digit codes.
Tally doesn’t place rates at the HSN level, and I dont believe Quickbooks or SAP do either. (This conclusion is based on looking through their documentation on GST. If I am wrong, please feel free to correct me.)
Okay. I dont have reliable information to positively confirm this. But i am just imagining how complex it would be to reflect the tax rate in all items if any change happen for a particular HSN.
Anyways,
Do you have any comments on my second question about selecting “In State GST” or “Out of State GST” based on the State codes of Company and Customer automatically without human intervention?
This is not available yet. There are many users that have asked for this. But, there is no timeframe for this feature. If you can contribute resources to make this happen, that would be great!
Item wise tax details:
It would become quite problematic if we assign a tax rate to an item based on the HSN code because :
You will be forced to use the 8 digit HSN code - which is not mandatory for all tax payers, it is mandatory only for tax payers above a certain turnover.
Your IGST, CGST and SGST components will create a conflict - since CGST and SGCT divide the tax by half between them, you need to set in the right parameters and additional checks in your invoice item table.
You can use the following procedure, so that you dont have to choose the In State and Out State manually.
This can be solved in a very simple way using Tax Rule.
Create two customer groups - Out state Customers, In state Customers - make sure to put the customers on the right category.
Create two tax templates - Out state GST(with only IGST) and In state GST(with SGST and CGST)
Create two tax rules - Out state tax rule and In state tax rule.
In tax rule select your customer group and tax template and during your purchase and sales invoicing it gets automatically applied depending on the customer group.
Similarly create the rules for different tax rates and set the priorities for the tax rule.
I think this should solve the problem for the time being.
No you can’t base it on HSN code. Because there are few cases when same HSN code has different tax rate.
This issue has been raised on git hub, #9529
