Extracting the Purchase Data for Matching with Supplier's Data

To extract your purchase information in the Purchase Register format provided by the tax authority, you use the Extract Purchase Register Data program (R75I826). The program extracts purchase and accounts payable transactions for a GST unit from the F75I807 table for a specified date range.

The extracted information must include the GSTIN of supplier, type of inward supplies from registered persons (B2B), Deemed Exports (DE), Document Type (Accounts Payable document descriptions), Document Number (Supplier Invoice Number), Document Date (Supplier Invoice Date), Taxable Value, Total Tax, Integrated Tax, Central Tax, State/UT Tax, and Cess. This program also prints eligible ITC amount.

The R75I826 program uses the BI Publisher for printing the extracted data in an Excel format.

The generated report includes two sections:

1. B2B Inward Supplies

   This section includes inward supplies (accounts payable and purchase transactions) from registered suppliers but excludes supplies attracting reverse charge and imports.

2. B2B Imports

   This section includes purchase orders and accounts payable transactions for imports that are retrieved for a GST unit from the F75I807 table for a specified date range.

   Transactions with reverse charge are excluded from this section.