GST Invoice Extraction Guide: Converting Supplier Bill PDFs to Excel Ledger

In India, companies claiming Input Tax Credit (ITC) must match their supplier purchase logs with the auto-populated GSTR-2B statement. This requires tax teams to manually verify hundreds of incoming PDF invoices from various vendors, check HSN/SAC code mappings, and verify tax divisions.

This compliance guide details how to extract GST invoice data into Excel ledgers programmatically.

1. The Anatomy of an Indian GST Invoice Schema

Under GST Rule 46, a tax invoice must contain specific fields to be valid for ITC claims:

1. Supplier Details: Legal name, address, and GSTIN (GST Identification Number).

2. Invoice Number & Date: Unique sequential document numbers.

3. Consignee / Billed-To Details: Buyer's legal name, address, and GSTIN.

4. HSN/SAC Codes: Harmonized System of Nomenclature (for goods) or Service Accounting Codes (for services).

5. Itemized Grids: Description, quantity, unit price, and discount.

6. Tax Divisions:

• CGST & SGST: For intra-state sales (divided equally, e.g., 9% each).
• IGST: For inter-state transactions (applied fully, e.g., 18%).

7. Total Invoice Value & GST Amount.

2. Reconciling Supplier Bills with Excel

To automate purchase ledger auditing:

1. Parse Invoices: Upload vendor PDFs to GoluPDF's Table Extractor. Choose the "Invoice Preset" to map columns.

2. Isolate CGST, SGST, and IGST: The engine parses CGST and SGST into separate columns, ensuring clear accounting entries.

3. Match with GSTR-2B: Import the Excel ledger into accounting systems to match GSTINs, invoice dates, and tax amounts with government portal entries.

4. Reconciliation Formula: Audit that:

$$\text{Taxable Value} + \text{CGST} + \text{SGST} + \text{IGST} = \text{Total Invoice Value}$$

3. Client-Side Security for Invoice Records

Corporate invoice ledgers contain supplier lists, contract values, and pricing. GoluPDF runs entirely browser-side using local WebAssembly. This ensures that sensitive supplier relationships and purchase volumes remain secure on your own device.