GST Eway bill Compile error in Hidden module sheet 3 and date format error solved
Eway bill is a mandatory document for transporting goods, for which value consignment exceeds Rs. 50,000. It is now mandatory for both interstate and intrastate transaction. Generating an E way bill is only possible through the website - https://ewaybill.nic.in/ or https://ewaybillgst.gov.in/.
Tax payers have to login to the system and enter all the date required for E-way bill including Consignor or Consignee name , GSTIN, document or invoice number, date of invoice, commodity , quantity, HSN , rate of tax, taxable value, vehicle number or transporter id, approximate distance etc . After completing the data entry only eway bill will be generated.
Bulk tools are used for generating eway bills offline. These tools include three parts
Atrributes, Sample Json Files, Json preparation Tools.
Attributes and Sample Json Files
Attributes and Sample JSON files have only use in developing software applications for GST or working with GST invoices or other documents.
Now you can upload this JSON file to the Eway bill portal and the portal will generate eway bill for you. You can also create consolidated e-way bill, update vehicle, update transporter, create a Masters list ( Masters list - the Suppliers details, Customers details, Commodity details with HSN and packing unit, Transporter details to which you are frequently dealt with.so that data entry for eway bill become easier)
Json preparation Tools
Json preparation Tools is nothing but a Excel File with VBA Macro enabled file. If you don't have a software or billing software as described above, you can use these JSON preparation Tools. Simply enter the data into the tool (excel sheet) and click VALIDATE button and PREPARE JSON button. This will create a JSON file in your PC , in the same folder where the excel tool has been saved.
Now you can upload the data to the Eway bill portal and generate E-way bill. Same way you can create consolidated e-way bill, update vehicle, update transport,create a masters list etc. as above.
Errors of Bulk tool
"Compile error in Hidden module sheet 3" and date format incorrect , enter the date dd/mm/yyyy format are the common errors seen while using these bulk tools.
Compile error in Hidden module sheet 3
This is related to VB module in the Excel macro enabled files. The VBA causing the issue.This error normally happens if you are using a Windows 2007 system and MS Office 2007 system. I have recreated the files by solving the issues and provided those files that will run on Windows 2007 and MS office 2007 system. You can download these Five files from my Google Drive from the below link.
Date format in DD/MM/YYYY format
To resolve this issue please goto Control Panel > Regional and Language > Regional and Language settings > Date > Change the date format to English United Kingdom ( It may be either English (India) or English (UK ) in your system)
Then click Apply and then OK. The help files provided in the above link.
Please enable all Macros in your excel. To do that Click Microsoft Office Button ( Left Top Round button) > Excel Option > Trust Centre > Trust Centre settings > Macro Settings > Enable all Macros (not recommended) . Click OK.
The help files provided in the above link.
You can also watch my video in the below link.
Sales Tax Complex, Jawahar nagar
Kozhikode 673006, Kerala.