How to Reconcile GST Returns, Invoices & Accounting Records

Updated 13 November 2026 · Standard formula, shown below

Reconciling your GST returns with your invoices and accounting records ensures that the sales, purchases, and taxes you report to the GST portal match what is actually recorded in your books. This process catches mismatches, avoids notices, and helps you claim accurate input tax credit. You will need your GSTR-1, GSTR-3B, purchase and sales registers, and a copy of your accounting software’s trial balance.

What You’ll Need

GST login credentials (GSTIN and password) to view filed returns.
Copies of GSTR-1 and GSTR-3B for the period being reconciled.
Sales and purchase registers from your accounting software (e.g., Tally, Zoho, QuickBooks, or Excel).
Trial balance or general ledger for the same period.
GST reconciliation statement template (or a spreadsheet) to list differences.
Copies of invoices, debit notes, credit notes, and payment vouchers.

Step-by-Step

Export your GSTR-1 and GSTR-3B data. Log in to the GST portal, go to ‘Returns Dashboard’, select the financial year and period, and download the filed GSTR-1 and GSTR-3B in Excel or PDF format. If you have not filed yet, prepare a draft from the portal.
Pull your accounting records for the same period. Run a sales register (invoice-wise) and purchase register from your accounting software. Ensure the date range matches the return period (e.g., July 2024). Export these to Excel as well.
Reconcile outward supplies (sales). Compare the total taxable value and GST amount in GSTR-1 with the sales register. Match invoice-by-invoice: invoice number, date, GSTIN of the buyer, taxable value, rate, and tax amount. Flag any invoice that appears in one but not the other.
Reconcile inward supplies (purchases). Compare the purchase register with the GSTR-2B (auto-drafted from your suppliers’ GSTR-1) and with the input tax credit (ITC) claimed in GSTR-3B. Verify that each purchase invoice is eligible for ITC (goods/services received, tax paid to supplier, supplier has filed GSTR-1, and you possess the invoice).
Check GSTR-3B summary. Ensure that the total taxable value and tax payable in GSTR-3B (Table 3.1) match the GSTR-1 totals. Also, verify that the ITC claimed in Table 4A of GSTR-3B does not exceed the eligible ITC from GSTR-2B plus any reversed ITC.
Identify and list differences. Create a reconciliation statement with columns: source (GSTR-1/GSTR-3B/books), invoice number, date, party name, taxable value, tax rate, tax amount, and remarks. For each mismatch, note the reason (e.g., invoice not uploaded, wrong rate, missing credit note).
Investigate each difference. For sales: check if the invoice was omitted from GSTR-1, if the buyer’s GSTIN is incorrect, or if the invoice was cancelled after filing. For purchases: verify if the supplier has actually filed GSTR-1, if the invoice is genuine, or if the tax was paid to the supplier but not reported.
Correct errors in the current or next return. If you missed an invoice in GSTR-1, include it in the next month’s GSTR-1 as an amendment (if the original was filed) or as a new entry (if not filed). For GSTR-3B, adjust the tax liability and ITC in the month you discover the error, using Table 4 or 5 as applicable.
Update your accounting records. Make journal entries to correct any errors in your books—e.g., reverse an incorrect ITC claim, record a missing purchase, or adjust a sales invoice. Ensure your books now match the corrected returns.
Document and retain the reconciliation. Keep a signed copy of the reconciliation statement along with supporting documents. This is useful for audit or departmental queries.

Common Mistakes

Comparing GSTR-3B directly with GSTR-1 without considering amendments or credit notes.
Ignoring time limits: ITC can be claimed only up to the due date of filing the return for September of the next financial year.
Forgetting to reverse ITC on credit notes or on invoices where payment is not made within 180 days.
Mixing up taxable value and total invoice value (including GST).
Assuming all purchases in the books are eligible for ITC (e.g., personal use or exempt supplies).
Not checking the GSTIN of the supplier—if it is inactive or invalid, ITC may be denied.

Tips

Reconcile monthly, not annually, to catch errors early.
Use GST reconciliation software or Excel formulas (VLOOKUP, IF) to match invoice numbers quickly.
Keep a separate register for advances received and adjusted against invoices.
Always reconcile GSTR-2B with purchase register before claiming ITC in GSTR-3B.
If you have multiple GSTINs, reconcile each separately.
Set a reminder for the 180-day payment rule for ITC reversal.

Troubleshooting

GSTR-1 and GSTR-3B do not match: This is common because GSTR-1 is invoice-level and GSTR-3B is summary. Check if you have included amendments or if there are unadjusted advances. The difference should be zero after considering all adjustments.
ITC claimed is more than GSTR-2B: This happens when you claim ITC on purchases where the supplier has not filed GSTR-1. You cannot claim such ITC in the current period; either wait for the supplier to file or reverse the excess in GSTR-3B.
Invoice appears in books but not in GSTR-1: Check if the invoice was accidentally missed during filing. You can include it in the next return as an amendment, but late fees may apply if the original due date has passed.
Invoice appears in GSTR-1 but not in books: This could be a duplicate entry or a data entry error. Verify the invoice physically; if it is a mistake, remove it from the next GSTR-1.
Credit note not reflected in GSTR-1: Ensure you have issued the credit note in the portal and that the buyer has accepted it (if required). The credit note will reduce your liability in the month it is issued.

Frequently Asked Questions

Q: What is the due date for GSTR-1 and GSTR-3B?
A: GSTR-1 is due by the 11th of the next month (for monthly filers) and GSTR-3B by the 20th. For the quarterly filing scheme, the due dates are different; check the notification for your turnover.

Q: Can I claim ITC if my supplier has not filed GSTR-1?
A: No, you can only claim ITC if the supplier has filed GSTR-1 and the invoice appears in your GSTR-2B. You can claim it in a later month once the supplier files, but before the September deadline.

Q: What happens if I do not reconcile and have mismatches?
A: The department may issue a notice demanding tax, interest, and penalty. Regular reconciliation helps avoid such issues.

Q: How do I handle an invoice that was cancelled after filing GSTR-1?
A: You can issue a credit note and report it in the month of cancellation. The credit note will reduce your tax liability in GSTR-1 and GSTR-3B for that month.

Q: Is it mandatory to reconcile every month?
A: Not legally mandatory, but it is a best practice. The GST law requires you to maintain accurate records, and reconciliation helps you do so.

Q: What is the 180-day rule for ITC?
A: If you do not pay the supplier within 180 days of the invoice date, you must reverse the ITC claimed on that purchase, along with interest. You can reclaim it when you actually make the payment.

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.