Back to Tools Open GSTR 2B → Tally Purchase XML
GSTR 2B Bank Statement Sales / Purchase Job Work + TDS GSTR 1 JSON GST2B Recon
GSTR 2B TOOL GUIDE

GSTR 2B → Tally Purchase XML

Import your GSTR-2B purchase data directly into Tally Prime / ERP 9 with accurate supplier invoice mapping, GST tax breakdown, ITC reconciliation, and automated party ledger handling.

Input: .json / .xlsx / .xls Output: Tally Purchase XML Suspense Party Support

Supported Input Files

  • Direct GSTR-2B JSON (.json): Downloaded directly from the GST Portal. When uploading a JSON file, column mapping is completely automated!
  • GSTR-2B Excel (.xlsx / .xls): Downloaded from GST Portal, Cleartax, or accounting software. You can customize the Excel column letters if your format differs from the default.

Key Features & Settings

Use Suspense Party (Recommended for Clean Ledgers)

When enabled, all purchase transactions are temporarily credited to a single Suspense Party ledger in Tally, while keeping the original supplier name and GSTIN preserved in the Narration. This keeps your Tally Chart of Accounts clean and avoids auto-creating hundreds of one-off vendor ledgers.

Auto-Create Party Ledgers

When "Use Suspense Party" is turned OFF, VinTax automatically includes <LEDGER ACTION="Create"> instructions in the XML for every supplier, placed under Sundry Creditors with State and Country details.

Supplier Invoice & Reference Date

VinTax embeds <REFERENCE> and <REFERENCEDATE> tags. When imported, Tally Prime displays the supplier's actual bill number and bill date under the "Supplier Invoice No." fields.

Step-by-Step Walkthrough

  1. Upload your GSTR-2B file (.json or .xlsx).
  2. If using Excel, verify column letters (A, B, C...). If using JSON, column mapping is bypassed automatically.
  3. Verify your Tally ledger names (Purchase, CGST, SGST, IGST, Round Off).
  4. Choose whether to enable Use Suspense Party or Auto-Create Party Ledgers.
  5. Click Generate Purchase XML.
  6. Review the summary report (monthly statistics and any skipped rows).
  7. Click Download Full XML.

How to Import in Tally Prime

  1. Open your Company in Tally Prime.
  2. Press Alt + O (or click Import from top menu).
  3. Select Transactions.
  4. Choose File Format: XML and enter/browse to the downloaded XML file path.
  5. Press Enter to import. Check the Tally Event Log / Calculator pane (Ctrl + N) for confirmation.
Launch GSTR 2B → Tally Purchase XML Now