1. How to Export Purchase Register from Busy to Excel
- Launch Busy Accounting and go to Display > GST Reports > GST Registers > Purchase Register.
- Select the relevant accounting period (e.g., Monthly or Quarterly).
- Choose the display format: Standard or Columnar. Ensure that "Bill No", "Party GSTIN", and tax bifurcation columns are included.
- Click on the Export (F2) button on the top-right and select MS Excel format.
2. Specific Challenges with Busy ERP Data
- Bill-by-Bill Reference vs Invoice No: In Busy, users frequently assign internal purchase bill numbers that differ from the physical supplier invoice.
- Item-Level Multi-Tax Rows: Multiple line items for different HSN codes can clutter the export.
- Merged Header Rows: Busy Excel exports often contain 2 or 3 header rows with company names and addresses before actual table data begins.
3. How GST-Hawk Streamlines Busy Reconciliation
GST-Hawk's universal parser is specially optimized for Busy exports:
- Header Auto-Offset: Automatically ignores top decorative title rows and detects the real data header line.
- Typo & Slash Normalization: Resolves discrepancies where Busy users typed
INV-12but the supplier uploadedINV/12. - Pre-Check Validator: Highlights any corrupt GSTINs or missing tax amounts before reconciliation begins.