Hi Raghav,
For GSTR 2A reconciliation in Business Central, here's a simple overview of the process to upload the Excel file:
🔹 Steps to Create and Import GSTR 2A File:
1. Go to: GST → GSTR 2A Reconciliation.
2. Choose "Import from Excel".
3. Format your Excel file properly with required columns. The usual expected columns include:
Supplier GSTIN
Invoice Number
Invoice Date
Invoice Value
Taxable Value
Tax Amount (IGST, CGST, SGST, CESS)
4. Make sure column headers in your Excel file match exactly with what BC expects. Even small mismatches can block upload.
5. File must be in .xlsx format (not .csv or older Excel formats).
6. If you're not sure about format, export a sample from the system (if available), or ask your partner to share the template used for import.
❗ Common Issues:
Header mismatch
Wrong data types (e.g., dates as text)
Empty or duplicate invoice numbers
If the Import action doesn’t respond or shows error silently, check Job Queue log entries or event viewer for import failure logs.
✅ Mark this answer as verified if it helps you.
