Skip to main content

2P: Upload Methods

The application provides three methods to upload 2P purchase register data. Choose based on your organisation’s IT setup, data volume, and upload frequency.

Manual upload through the application

Suitable for organizations with low data volumes that prepare purchase data in-house and can export it to the standard input format.

There are some points to follow while preparing upload data manually:

  • Download the relevant GSTR2 input format Excel file(s) from the application (available in the More section at Resources tab > Input Format Files).
  • Enter the return period in cell B1 in MMYYYY format — e.g. 072026 for July 2026. Do not edit cell B2; it is pre-filled as GSTR2.
  • Enter invoice data from Row 4 onwards, one row per line item. Do not leave blank rows between data rows.
  • Save Tab 1 (Input Format tab) only as CSV. If multiple form types are needed, save each as a separate CSV and ZIP them together.

API integration

Preferred for high data volumes or high upload frequency where manual intervention is not practical. The API accepts the same structured data as the CSV input format or json format and applies identical validation rules. Authentication is via API keys issued by Sovos. Once configured, uploads run automatically on a defined schedule (daily, weekly, or on-demand). Contact the Sovos implementation team for API documentation and credentials.

SFTP (Secure File Transfer Protocol)

Suitable for organisations that do not want direct integration with ERPs but still want some automation for data delivery. At the time of onboarding, Sovos provides the relevant details for SFTP setup. Once the setup is done, the client drops CSV files into a designated SFTP directory at a scheduled time; the application picks them up and processes them. Custom file processing is also supported — Sovos’s online transformation tool can convert the file into the standard format. SFTP server details are provided during onboarding. An email notification is sent on upload success or failure.

Garnet: Data Transformation Tool

This desktop based transformation tool helps the users who wants to do manual data upload but they have their own customized format. So with help of this transformation tool they can easily transform their custom data into the standard input format.

As part of the onboarding process, the Sovos customer solutions team performs a data analysis and mapping activity to configure Garnet for the client’s ERP output. Garnet currently accepts CSV files as input. This is one time activity. And Customer solution team provides the Garnet rule file to user.

Once configured, User just need to upload their custom ERP output and Garnet rule file provided by customer solution team in Garnet desktop tool and run the tranformation and upload process. Garnet reads the client’s raw data, applies the defined column mapping and transformation rules (date reformatting, field splitting, conditional derivation, default values), and produces a CSV in the standard format with no ongoing manual effort.