1. How to Export Purchase Register from TallyPrime to Excel
Follow these quick steps to get a clean Excel export from TallyPrime:
- Open TallyPrime and press
D > A > P(Display More Reports > Account Books > Purchase Register). - Select the desired month (e.g., August 2026) and press
Enter. - Press
F12: Configureand set "Show Voucher Reference No." to Yes and "Show Supplier GSTIN" to Yes. - Press
Ctrl + E(Export), choose Format: Excel (Spreadsheet), and save the file to your computer.
2. Common Headaches When Matching Tally with GSTR-2B
- Voucher No vs Supplier Invoice No: In Tally, users often enter their internal serial voucher number instead of the vendor's actual tax invoice number.
- Debit Notes & Credit Notes: Tally stores credit notes in a separate register, causing net total mismatches against GSTR-2B Table 4.
- Round-off Differences: Tally rounded off to ₹1 while supplier billed exact paisa, leading to formula calculation errors.
3. Using GST-Hawk as Your Free GSTR-2B Excel Utility
GST-Hawk solves all Tally export quirks natively:
- Smart Auto-Header Detection: Whether your Tally header is "GSTIN/UIN", "Supplier GSTIN", or "Party GSTIN", the AI detects it instantly.
- Dynamic Value Tolerance: Configurable ₹1 or ₹2 tolerance absorbs round-off adjustments seamlessly.
- 19-Sheet Categorized Export: Download full supplier summaries ready for your monthly CA sign-off.
4. Frequently Asked Questions
Do I need to convert Tally Excel into a special CSV format?
No. GST-Hawk accepts both direct .xlsx/.xls files and .csv exports from TallyPrime without any manual reformatting.
Can I match Tally Purchase Register against GSTR-2A as well as GSTR-2B?
Yes. GST-Hawk supports both GSTR-2A and GSTR-2B file structures for multi-year retrospective audits.
💡 Recommended Reading: Detailed guide on GSTR 2B reconciliation with purchase register explains statutory Section 16(2)(aa) rules.