06 July 2024
If you're encountering issues with adding details for an invoice with two types of GST rates (18% and 28%) in the E-Invoice Excel template provided by the government, and you're getting an error about the document number being repeated, here are some steps you can consider:
1. **Document Number**: Ensure that the document number (Invoice No.) is unique for each line item, even if they have different GST rates. Each line item in the E-Invoice template must have a unique combination of Invoice No. and Item Serial No. to avoid duplication errors.
2. **Item Classification**: Clearly classify each line item under the appropriate GST rate (18% or 28%). This helps in correctly applying the GST rates and ensures compliance with tax regulations.
3. **Item Serial No.**: Each line item should have a unique Item Serial No. This helps differentiate between items with different GST rates and prevents the system from treating them as duplicates.
**Excel Template Format**: Ensure that you're using the correct format as specified by the government for the E-Invoice Excel template. This includes correctly filling in all mandatory fields and using the correct data format (dates, amounts, etc.).
**Validation Errors**: If the error persists despite following the above steps, double-check the validation rules provided in the E-Invoice Excel template guidelines. Sometimes, errors can occur due to formatting issues or missing data in required fields.
**Technical Support**: If you continue to face issues, consider reaching out to the technical support provided by GSTN (Goods and Services Tax Network) or the E-Invoice portal helpdesk. They can provide specific guidance or troubleshooting steps based on your situation.
By ensuring each line item has a unique combination of Invoice No. and Item Serial No., and correctly classifying items under their respective GST rates, you should be able to resolve the issue of repeated document number errors in the E-Invoice Excel template.