GST Refund JSON Generation

Budget: ₹600 - ₹1500

All my purchase- and sales-related figures for the refund period are already organised in one consolidated Excel workbook. What I now need is a clean, GST-Offline-Tool–ready JSON file so I can upload it straight to the portal without edits or error messages.

Before the file is generated, every line item must be run through the standard GST schema checks—tax rates, HSN/SAC codes, invoice numbers, dates, place-of-supply flags, and any other validations the offline tool normally insists on. Please highlight and correct any issues you find, then document the fixes so I can keep my source sheet fully compliant in future periods.

Deliverables • Validated Excel sheet with corrections tracked or clearly commented • Final.json file produced by (or fully compatible with) the GST Offline Tool and passing its built-in validation • Brief log summarising the validation process and any changes made

If you have a preferred script, macro, or utility that speeds things up, feel free to use it—the important part is that the JSON uploads without a single error prompt.