Skip to main content
August 26, 2020
Question

While importing bulk sales invoices there is no bifrucation into CSGT/SGST/IGST in sample report. How to do it?

  • August 26, 2020
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

August 26, 2020

Welcome to QuickBooks Community, @srdfpushkar.

 

I'm here to share details about importing your sales invoices in QuickBooks Online (QBO). This way, you'll be able to identify how the process works and make sure the details included in your sample report are managed accordingly.

 

Currently, there isn't a bifurcation into CSGT/SGST/IGST when you import your sales invoices using the sample report or spreadsheet. However, you can still include the CSGT/SGST/IGST information by filling in the ItemTaxCode column. 

 

First, you'll have to prepare the report or spreadsheet accordingly to successfully perform the import process in QBO. I'd recommend taking a look first at what's required to import invoices and downloading the sample spreadsheet to map each of your column headings to the invoice fields during the import process. Here are six required columns when importing your sales invoices in bulk, namely:

  • Invoice number
  • Customer
  • Invoice date
  • Due date
  • Item amount
  • Item tax code

 

The second step is to turn on the Custom transaction numbers feature in the Sales menu from the Account and Settings page. This is applicable once you use numbers to track your invoices in QBO. Once everything is all set, you can start with the import process. Let me guide you how.

  1. Go to the Gear icon.
  2. Select Import Data.
  3. Choose Invoices.
  4. (Optional) Under the Browse button, you can add new customers, products, and services.
  5. Select Browse and then find and select the spreadsheet of your invoices. 
  6. Click Next.

 

To continue with the procedure, kindly refer to this article's Step 4 - 5 for the step-by-step guide: Import multiple invoices at once. It also contains information about what you can and can’t import and additional reminders for GST in the Notes section.

 

Additionally, your invoices need to be GST-compliant. With this, QBO lets you customise your invoices to include GST-specific information. You can learn more about it by checking out this article: Customise invoice for GST. It includes steps about enabling customer GSTIN and HSN/SAC column in the printed invoice.

 

Please let me know if you have other concerns. I'm just round to help. Take care always.