Acer GST ↔ PR vs. 2B Reconciliation
Home Login Subscribe

Acer Nova (Beta Version)

GST Reconciliation - Purchase Register vs. GSTR 2B

Upload your GSTR-2B and Purchase Register. For GSTR-2B, please specify if it's the original file from the GST Portal or a custom file with headers in the first row. The program will automatically identify and suggest columns for mapping. After uploading, click the button to proceed to the verification step.

GSTR-2B

Reads B2B & B2B-CDNR sheets.

Purchase Register

Requires .xlsx or .xls file.

GSTR-2B Format

Select the header format of your GSTR-2B file.

×

File Upload Instructions

To ensure the highest accuracy, please prepare your files according to the guidelines below.

GSTR-2B File Requirements

You have two options for your GSTR-2B file. Please select the correct format on the upload page:

  • GST Portal Format: Use the original, unmodified Excel file from the GST Portal where headers are on rows 5 and 6.
  • Custom Format: If using a modified file, ensure to upload the 2B file as per the format provided and with headings in first row.

For both formats, your file must contain sheets named exactly "B2B" and/or "B2B-CDNR".

Purchase Register (PR) File Requirements

  • File Type: Must be an Excel file (.xlsx or .xls).
  • Headers: Use simple, clear, and generic headers in the first row (e.g., "Invoice Number", "Supplier GSTIN", "Invoice Date", "CGST").
  • Essential Data: The file must contain columns for the supplier's GSTIN, invoice number, invoice date, taxable value, and CGST, SGST and IGST amounts.

General Tips for Data Accuracy

  • Date Format: Ensure all dates are in the DD-MM-YYYY format (e.g., 25-11-2025) for best results.
  • Clean Numeric Values: All monetary columns (Taxable Value, CGST, etc.) must contain only numbers. Remove currency symbols (₹), commas, and text.
  • Correct GSTINs: Double-check that all GSTINs are in the correct 15-character format without extra spaces or special characters.
×

Custom GSTR-2B Format Instructions

If you are using the Custom Format option, please follow these strict guidelines:

How to fill the data:

  • Unified Data: All Invoices, Credit Notes, Debit Notes, and Import of Goods data, if any, must be uploaded in a single Excel sheet.
  • Sheet Name: The data must be placed in a specific sheet named exactly "B2B".
  • Headers: Please use the attached format. Do not change the header names in the first row.

Download the Excel Template:

Download Custom Format (.xlsx)

Files Missing

Please upload both the GSTR-2B and Purchase Register files to proceed.

Notice

Confirm Consolidation