Upload Bulk Purchase Invoice into GSTZen

You can upload your Purchase Invoices into GSTZen server in 5 quick and easy steps. This video and step by step instructions will help you in uploading your Purchase Invoices into GSTZen.

  • Step 1 - Click on Purchase Invoices and Upload Purchase Invoices XLS

Purchase Invoices

Purchase Invoices

Upload Purchase Invoice XLS

Upload Purchase Invoices in XLS format

  • Step 2 - You can either drag and drop or upload the file from your computer. Click on Drag and Drop file and choose the file of your choice.

    (Note - GSTZen importer only allows you to choose XLSX file)

    XLS Data Format - Choose a file type depending on your Purchase Invoice format. Either Tax rates as a single column with each row being a different tax rate (OR) Each column is a single tax rate.

    Click on Upload Purchase Invoices XLS File.

Upload Purchase Invoice Page

Upload Purchase Invoice excel file

  • Step 3 - Choose the sheet you want to upload from the list shown by clicking Use this Sheet. This will upload the sheet into GSTZen.

Purchase Choose Sheet Page

Choose the Purchase Invoice sheet

  • Step 4 - The importer shows the columns present in your excel sheet

Invoice Column Mapping

Map columns according to the excel file

Mapping - Map the columns to the respective fields shown in the importer.

(Note - The red * denotes mandatory fields).

To map columns, click on the drop down and choose the column in the sheet that matches to the field. This mapping is a one time job. GSTZen will save the mapping and will use it when you upload files later.

  1. Map only the GST Tax Rate % field (OR)

  2. Map IGST Rate %, IGST Amount, CGST Rate %, CGST Amount, SGST Rate %, SGST Amount

Invoice GST Tax Rate

Choose the GST Tax Rate type

  • Step 5 - Click on Process file upload

GSTZen uploads the file and displays a summary.

Upload Summary Page

Verify the numbers and Confirm upload

Click Confirm and upload after verifying if the summary matches your excel data.

Upload Final Page

Invoices are now successfully uploaded into GSTZen server

Please read the article, To know how to Uploading your Sales and Purchase Credit/Debit Notes into GSTZen