QuickBooksHelp
Intuit
Intuit
‎September 25, 2019 09:11 PM

JSON errors in GSTR1, GSTR3B

While exporting a JSON file from the GSTR1 and/or GSTR3B reports, QuickBooks may throw an error if the contents of the reports do not meet JSON validation guidelines. This article will help you identify these errors and rectify them in QuickBooks.

Should QuickBooks find an error while compiling the JSON file for you, it will display an error prompt. Read on to find out how you can resolve these errors.

GSTR1 JSON Error List

JSON error What this means What you need to do Do this in QuickBooks
Invalid company GSTIN The business' GSTIN is incorrect or incomplete. Please provide the registration number you have received in the GST Registration Certificate, also known as Form GST REG-06.
  1. In the left navigation bar, click Taxes.
  2. Select GST from the Tax dropdown.
  3. Click Edit GST and then Edit settings.
  4. Enter your GSTIN and click Save.
Company GSTIN is not present The business' GSTIN has not been entered in QuickBooks. Please provide the registration number you have received in the GST Registration Certificate, also known as Form GST REG-06.
  1. In the left navigation bar, click Taxes .
  2. Select GST from the Tax dropdown.
  3. Click Edit GST and then Edit settings.
  4. Enter your GSTIN and click Save.
Invalid Customer GSTIN in Section 4 One or more customers to whom sales were made in the period have an incorrect or incomplete GSTIN. Please obtain the correct GSTIN from the customer that they've got in Form GST REG-06.

Also, the GSTIN should be capitalised.

 Open the error text file and note the customers for whom the GSTIN is said to be invalid.
  1. In QuickBooks, go to the Sales tab, and select Customers.
  2. Locate and click the customer.
  3. In the customer details section, click Edit.
  4. Update the GSTIN and click Save.
HSN missing in section 12 An Inventory/Non-Inventory item does not have an HSN code associated with it. Obtain HSN codes for all inventory/non-inventory items that you buy or sell.
  1. In the left navigation bar, click Sales .
  2. Select Products and Services.
  3. Locate items of the type Inventory and Non-Inventory for which the HSN/SAC column is blank.
  4. Click Edit in the Action column, update the HSN code and click Save.
Quantity missing in section 12 Quantity for Inventory/Non-Inventory items is not available. In Company Settings, the option named Track quantity and price/rate MUST be turned on.
  1. Click the gear icon and select Company Settings.
  2. Select Sales.
  3. Click Products and services.
  4. Ensure that the option Track quantity and price/rate is checked.
  5. Click Save.
Invoice Number missing in section 4, 5 and 6 One or more invoices or sales receipts during the period have been generated without an invoice/sales receipt number. Locate invoices and sales receipts that do not have a number and re-save them with an invoice/sales receipt number respectively.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate invoices and sales receipts which do not have a number in the No. column.
  4. Click to open the transaction, enter the Invoice no. or Sales Receipt No. and select Save and close.
Invoice number exceeding 16 character in section 4,5,6 and 13 Invoice numbers and Sales Receipt numbers with more than 16 characters have been recorded for the period. Locate Invoices and Sales Receipts and shorten Invoice and Sales Receipt numbers that are over 16 characters. 16 characters includes spaces and permitted special characters.

Permitted special characters are
Hyphen -
Forward slash /

Backward slash \ is not permitted.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Invoices and Sales Receipts which have more than 16 characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Invoice no. or Sales Receipt no. and select Save and close.
Invoice number contains special character in section 4, 5, 6 and 13 Invoice numbers and Sales Receipt numbers can only contain letters, digits, hyphen and forward slash, i.e. (A to Z, 0 to 9, - , / )

Backward slash \ is not permitted.

 Locate Invoices and Sales Receipts using a sales report and truncate numbers that contain non-permitted special characters
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Invoices and Sales Receipts which have non-permitted special characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Invoice no. or Sales Receipt no. and select Save and close.
Place of supply missing in section 4, 5 and 7 One or more sales transactions in the period have been entered without a Place of Supply. Locate invoices and sales receipts using a sales report and enter a Place of Supply in transactions devoid of one.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Click the gear icon in the report and tick POS. This will include the Place of Supply column in the report.
  4. Locate invoices and sales receipts which do not have an entry in the POS column.
  5. Click to open the transaction, select a Place of Supply from the dropdown and select Save and close.
Description exceeds 30 character in section 12 Item description should be less than 30 characters long. Ensure that the sales description of the Inventory/Non-Inventory item does not exceed 30 characters. 30 characters includes spaces.
  1. In the left navigation bar, click Sales.
  2. Select Products and Services.
  3. Locate items of the type Inventory and Non-Inventory for which the Sales Description is greater than 30 characters. (Assuming 5 characters to a word, this would work out to approximately 6 words in Sales Description.)
  4. Click Edit in the Action column, update the Sales Description and click Save.
From or To transaction number missing in section 13 If the first Invoice (or Sales Receipt) created during the month or the last Invoice (or Sales Receipt) created during the month does not have a transaction number, this error will be thrown.

Section 13 also considers transactions of the type Credit Note, Expense, Cheque, Refund Receipt. If any of these transactions is missing a transaction number, the error would continue to be displayed.

 Locate Invoices, Sales Receipts, Credit Notes, Expenses, Cheques, Refund Receipts that do not have a number and re-save them with a transaction number.

 
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Date and run this report for the same period as the GSTR1.
  3. In the Group by dropdown, select Transaction Type and click Run Report.
  4. Locate invoices, sales receipts, credit notes, expenses, cheques, refund receipts which do not have a number in the No. column.
  5. Click to open the transaction, enter the transaction number, i.e. Invoice no. / Sales Receipt No. / Credit Note No. / Ref No. / Cheque No. / Refund Receipt No. and select Save and close.
Invoice Number in one of the Credit Notes is missing in Section: 9B(Unregistered) Credit note not linked to source invoice. Please locate the credit note(s) that do not have an invoice linked and update them accordingly.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type GSTR1 and select GSTR1 - Summary Of Outward Supplies and run this report for the same period.
  3. Click into Section 9B. Credit/Debit Notes (Unregistered)
  4. Locate credit notes that have a blank entry in the Invoice No. column.
  5. Edit these linked invoices and update them with an invoice number each.
Credit Note Number missing in Section: 9B (Unregistered) Credit note number is left blank. Please enter a credit note number for each of the credit notes listed in this report.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type GSTR1 and select GSTR1 - Summary Of Outward Supplies and run this report for the same period.
  3. Click into Section 9B. Credit/Debit Notes (Unregistered)
  4. Locate credit notes that have a blank entry in the Credit Note No. column.
  5. Edit these credit notes and update them with a transaction number each.
Invalid Invoice Number:1234ABC in Section:9B(Registered) Invoice numbers  can only contain letters, digits, hyphen and forward slash, i.e. (A to Z, 0 to 9, - , / )
Backward slash \ is not permitted.		 Locate Invoices using a sales report and truncate numbers that contain non-permitted special characters
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Invoices which have non-permitted special characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Invoice no.  and select Save and close.
Invoice number is too long in Section:9B(Registered) Invoice numbers with more than 16 characters have been recorded for the period. Locate Invoices and shorten Invoice numbers that are over 16 characters. 16 characters includes spaces and permitted special characters.

Permitted special characters are
Hyphen -
Forward slash /

Backward slash \ is not permitted.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Invoices which have more than 16 characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Invoice no.  and select Save and close.
Credit Note number is too long in Section: 9B(Unregistered) Credit Note numbers with more than 16 characters have been recorded for the period. Locate Credit Notes shorten Credit Note numbers that are over 16 characters. 16 characters includes spaces and permitted special characters.

Permitted special characters are
Hyphen -
Forward slash /

Backward slash \ is not permitted.

.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Credit Notes which have more than 16 characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Credit Note no.  and select Save and close.
Credit Note Number:1234ABC in Section:9B(Unregistered) The Credit Note number can only contain letters, digits, hyphen and forward slash, i.e. (A to Z, 0 to 9, - , / )
Backward slash \ is not permitted.		 Locate Credit Notes using a sales report and truncate numbers that contain non-permitted special characters.
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Transaction List By Customer and run this report for the same period as the GSTR1.
  3. Locate Credit Notes which have non-permitted special characters in the No. column.
  4. Click to open the transaction, truncate or enter a new Credit Note no.  and select Save and close.

GSTR3B JSON Error List

JSON error What this means What you need to do Do this in QuickBooks
Invalid company GSTIN The business' GSTIN is incorrect or incomplete. Please provide the registration number you have received in the GST Registration Certficate, also known as Form GST REG-06.
  1. In the left navigation bar, click Taxes.
  2. Select GST from the Tax dropdown.
  3. Click Edit GST and then Edit settings.
  4. Enter your GSTIN.
  5. Click Save.
Company GSTIN is not present The business' GSTIN has not been entered in QuickBooks. Please provide the registration number you have received in the GST Registration Certficate, also known as Form GST REG-06.
  1. In the left navigation bar, click Taxes.
  2. Select GST from the Tax dropdown.
  3. Click Edit GST and then Edit settings.
  4. Enter your GSTIN.
  5. Click Save.
Place of supply missing in section 3.2 Place of Supply has not been entered in Invoices contributing to Section 3.2, i.e. interstate sales. Look up a report that contains interstate transactions, ensure that a tax name (to trace IGST transactions) column is added along with Place of Supply (POS). If POS in blank, complete it wherever applicable and re-download the GSTR3B JSON
  1. In the left navigation bar, click Reports.
  2. In the Go to report search box, type Sales by Customer Detail and run this report for the same period as the GSTR1.
  3. Click the gear icon in the report and tick POS and Tax Name. This will include the Place of Supply and the Tax Name columns in the report.
  4. Locate invoices and sales receipts which have an IGST rate in Tax Name and do not have an entry in the POS column.
  5. Click to open the transaction, select a Place of Supply from the dropdown and select Save and close.