Busy ERP & GST Workflows

Busy ERP to GSTR-2B Reconciliation: Step-by-Step Guide

By gstr2bmatch.in Editorial Team • Updated 21 October 2026 • 7 min read

Across India's manufacturing hubs, wholesale markets, FMCG distributors, and retail businesses, Busy Accounting Software (Busy ERP) is one of the most widely used enterprise software platforms. It manages complex inventory, multi-location stock, batches, and GST billing with exceptional speed.

Working with Tally as well? Our guide to GSTR-2B reconciliation in Tally Prime shows the full flow.

Yet, when the 14th of the month arrives and GSTR-2B is generated on the GST portal, thousands of Busy accountants hit an annoying operational roadblock: almost every third-party reconciliation utility on the internet is hardcoded specifically for Tally Prime.

If you run Busy, you are likely used to downloading a reconciliation macro or opening a portal, only to be hit with error messages like "Invalid Template Format" or "Missing Column: Voucher No". You are then forced into tedious 45-minute sessions cutting, pasting, and renaming Busy's Excel column headers to match some arbitrary Tally-standard format.

You don't need to do that anymore. In this step-by-step guide, we walk through how to execute a smooth busy erp gstr 2b reconciliation: the exact menu navigation path to export your purchase register from Busy, how to avoid common export pitfalls, and how automatic column detection lets you match records in seconds without reformatting.

Why Busy ERP Purchase Exports Confuse Generic GST Reconcilers

Busy organizes accounting and inventory data differently from Tally, Zoho, or SAP. When you export a standard GST Purchase Register from Busy ERP, the resulting Excel file has several structural characteristics that trip up rigid reconciliation tools:

  • Distinct Header Naming: Busy labels columns as Vch No., Party Name, Party GSTIN, and Bill No.. Generic tools expecting Tally's exact strings (Supplier Invoice No or GSTIN/UIN) simply throw validation errors.
  • Merged Title Blocks: Depending on your Busy display settings, the export often contains company header rows, date range banners, and blank separator lines above the actual column titles.
  • Tax Column Breakdowns: Busy frequently exports separate columns for IGST Amount, CGST Amount, SGST Amount, and Cess alongside Taxable Value and Total Amount. Many naive Excel formulas fail if these columns are in an unexpected order.

Understanding these quirks is key when setting up your non-Tally Excel reconciliation process.

Step 1: Exporting Your Purchase Register from Busy ERP

To get the cleanest data extract from Busy ERP that requires zero manual cleanup, follow this exact menu navigation path:

[Busy Main Menu] → [Display] → [GST Reports] ↓ [Export to Excel (Alt+E)] ← [GST Purchase Register] ← ↵

The Step-by-Step Navigation Path:

  1. Open your company in Busy ERP.
  2. From the main gateway menu, navigate to: Display > GST Reports > GST Registers > Purchase Register.
  3. Select Type: Item-wise or Voucher-wise (for GST reconciliation, select Voucher-wise or Bill-by-Bill to avoid duplicate invoice rows caused by multi-item bills).
  4. Set your Date Range: from the 1st of the month to the last day of the return period (e.g., 01-08-2026 to 31-08-2026).
  5. In the display configuration window, ensure the following fields are set:
    • Show Party GSTIN: Yes (Critical for reconciliation)
    • Show Original Bill No./Date: Yes (Essential if your internal voucher number differs from the supplier's printed bill number)
    • Show Tax Breakup (CGST / SGST / IGST): Yes
  6. Once the register loads on your screen, press Alt + E (or click the Export button in the top menu bar).
  7. Choose Excel File (*.xlsx / *.xls) as the format. Save the file to your desktop or downloads folder (e.g., Busy_Purchase_Register_Aug2026.xlsx).

Step 2: Download Your Official GSTR-2B from GSTN

Next, obtain the counterparty filing dataset directly from the GST Portal:

  1. Log in to gst.gov.in.
  2. Navigate to Return Dashboard → Select the Financial Year and Month.
  3. Under GSTR-2B (Auto-drafted ITC Statement), click Download.
  4. Download the Excel (.xlsx) version. The JSON download works too; the tool reads both.

Step 3: Drop Both Files Directly into gstr2bmatch.in

Here is where modern browser processing saves you hours. Instead of remapping columns or using complex VLOOKUP tables:

  1. Open your browser and navigate to gstr2bmatch.in.
  2. Drag your downloaded GSTR-2B Excel file as the GSTR-2B file. The tool reads the standard GSTN sheets (B2B, B2BA, CDNR).
  3. Drag your raw Busy ERP export file as the purchase register.

Why Automatic Column Detection Matters for Busy ERP Users

Traditional tools require you to manually map "Vch No." to "Invoice Number" and "Party GSTIN" to "Supplier GSTIN" every single month. Our smart column detection engine automatically identifies Busy's unique header formats, handles bill prefixes, and parses numeric values regardless of header order.

Reconcile Busy vs 2B →

Step 4: Reviewing Your Categorized Discrepancy Buckets

The matching runs in your browser and sorts every invoice into five buckets:

Reconciliation Bucket What It Means in Busy ERP vs GSTR-2B Required Action Before Filing GSTR-3B
Bucket A: Matched GSTIN and invoice number match (after spaces, symbols and leading zeros are ignored), and the tax amounts agree within ₹1. Claim in Table 4(A)(5) of GSTR-3B, once the other Section 16 conditions (goods received, not blocked) are also met.
Bucket B: Value Mismatch Invoice numbers and GSTINs match, but tax values or taxable amounts differ. Verify if Busy captured round-offs, freight, or discounts excluded by the supplier. Follow up with vendor.
Bucket C: In Books, Missing from GSTR-2B Recorded in your Busy ERP purchases, and the supplier's GSTIN does not appear in your GSTR-2B at all. The supplier has most likely not filed GSTR-1 / IFF. Do not claim in 3B. Send automated follow-up notice to supplier requesting urgent filing.
Bucket D: In GSTR-2B, Not in Books Reflected in GSTR-2B, but no matching purchase voucher exists in Busy ERP. Check if bill is sitting with procurement or pending approval in internal ERP workflows.
Bucket E: Likely IMS Pending Not in your GSTR-2B, but the same supplier has other invoices in it. Often the record is Pending on your IMS dashboard, or the supplier left out this one invoice. Check the IMS dashboard first. Accept if correct and goods are received, then recompute GSTR-2B. If it is not there, chase the supplier.

Common Busy ERP Reconciliation Pitfalls (And How to Fix Them)

1. Voucher Number vs Original Bill Number

Busy ERP allows two distinct numbering fields: the sequential internal Voucher Number (e.g., PUR-2026-0045) and the supplier's printed Bill Number (e.g., INV/892/26). If your Busy export only includes the internal Voucher Number, every single invoice will appear as a mismatch against GSTR-2B!

The Fix: In Busy's Display Configuration before export, always toggle "Show Original Bill No." to Yes. Make sure the invoice number column you load holds the supplier's bill number, not your internal voucher number, or every invoice will look missing.

2. Multi-Item Bills Generating Multiple Rows

If you export an "Item-wise" register from Busy, an invoice with five line items (e.g., 5 different spare parts) will export as five separate rows with the same invoice number. If an amateur reconciliation macro tries to match this row-by-row, it will flag severe value discrepancies.

The Fix: Either export Voucher-wise from Busy, so each bill is one row. gstr2bmatch.in does not add up item rows: if the same supplier and bill number appear twice, the first row is matched and the repeat is listed under Duplicates in books.

3. Date Format Clashes (DD-MM-YYYY vs YYYY-MM-DD)

Busy typically exports dates formatted as Indian standard DD-MM-YYYY, whereas some operating systems or Excel versions convert them to US formats or numeric serial values (e.g., 46289). The in-browser parser handles date serial numbers and multiple string formats deterministically without corrupting periods.

Exporting and Acting on Discrepancies

Once reconciliation is complete, download the Mismatch Summary Excel. Filter directly for Bucket C (in books, missing from GSTR-2B) to compile an immediate vendor communication list. By sending vendor payment hold notices before the 20th, you protect your company's cash flow and avoid paying unbacked GST in cash.

Last checked: 21 October 2026. Busy menu names can differ by release; follow your screen. Sources: GSTN FAQ on viewing GSTR-2B, GSTN IMS FAQ.

Related guides