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

Acer Nova

Upload Files for Reconciliation

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.

Mapping Remarks Explained

  • Matched: GSTIN and Invoice Number are concatenated to form a unique key. If these match between PR and 2B and all other fields (CGST, SGST, IGST, Date) also align, the record is marked as Matched.
  • Almost Matched: GSTIN + Invoice Number match perfectly, but one or more other fields (such as tax amounts or date) differ slightly. These are marked as Almost Matched.
  • Not Matched: The record exists only on one side — either Missing in GSTR-2B or Missing in Purchase Register.
×

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 (Recommended): 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 all column headers are in the 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 tax 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 must be uploaded in a single Excel file.
  • 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.