Skip to content

GST and tax reconciliations

RefinePoint has a template for each GST and TDS check. Choose the question, add the files, and the reconciliation is ready to run with every column already mapped.

  1. On the Reconciliations page choose New process, then GST and tax, guided.
  2. Choose what you are reconciling. Search works with the names you know: 2B, GSTR-1, e-invoice, 26AS.
  3. Add a file for each side. RefinePoint checks each file is the right one and says so if it is not. If you already have a data source made from the same template, pick it instead.
  4. Choose Create reconciliation, then Reconcile now on its page.
The GST and tax reconciliation page: a list of questions on the left and the files to add on the right.

You can also pick any of these from New process in the template list, filtered by India · GST or India · Income tax.

Your question Template Files
Can I claim this credit? Which invoices are missing from 2B? GSTR-2B against purchase register GSTR-2B, purchase register
Which suppliers have not filed? GSTR-2A against purchase register GSTR-2A, purchase register
Is every sale reported in GSTR-1? GSTR-1 against sales register GSTR-1, sales register
Does every invoice have an IRN? E-invoices against sales register E-invoice list, sales register
Does GSTR-1 agree with the e-invoices? GSTR-1 against e-invoices GSTR-1, e-invoice list
Did I pay the tax I reported? GSTR-3B against GSTR-1 GSTR-3B, GSTR-1
Did I claim more credit than 2B allows? GSTR-3B against GSTR-2B GSTR-3B, GSTR-2B
Is there an e-way bill for every invoice? E-way bills against sales invoices E-way bill report, sales register
Is the TDS my customers deducted in my 26AS or AIS? TDS and TCS: Form 26AS or AIS against books Form 26AS or AIS, TDS receivable ledger
Is my purchase register safe to claim credit on? ITC eligibility check Purchase register only
File Where to download it
GSTR-1 GST portal, Returns, choose the period, GSTR-1, Download (JSON).
GSTR-2B GST portal, Returns, choose the period, GSTR-2B, Download (JSON or Excel).
GSTR-2A GST portal, Returns, choose the period, GSTR-2A, Download (JSON).
GSTR-3B GST portal, Returns, choose the period, GSTR-3B, Download the filed return (JSON). Or use a sheet with Month, Table, Taxable Value, Integrated Tax, Central Tax, State/UT Tax and Cess.
E-invoices Invoice Registration Portal (IRP), e-invoice Reports (Excel), or the e-invoice JSON your billing software keeps.
E-way bills E-way bill portal, Reports, EWB generated by me (Excel).
Form 26AS TRACES, View Tax Credit (Form 26AS), choose the year, Export as Text.
AIS Income-tax portal, AIS, the year, Download (JSON or CSV).
Purchase and sales registers Your books: Tally, Zoho Books, Busy, SAP or any other, as Excel or CSV.
TDS receivable ledger The ledger of TDS your customers deducted, from your books (Excel or CSV).
  • Key. Supplier or customer GSTIN, document number and date. Numbers are compared as letters and digits only, without leading zeros, so INV/0042 is inv-42. A date that differs, or a number written differently, matches as a probable match for you to confirm.
  • Amounts. Taxable value and each tax are compared; a difference of a rupee or so passes. A difference makes the match partial and names the tax that differs.
  • Credit notes count as negative, on both sides, so they net against invoices. In books, a voucher type containing credit note, debit note or return is read as a reduction.
  • Carried forward. Documents that do not match this period stay open and match when the other side shows up, which is how timing differences clear.

Open items are labelled with the reason accountants use, so you can work through them by reason.

Reason Meaning
Not in portal In your books, not on the portal: the supplier has not filed, filed late or used another GSTIN.
Not in books On the portal, not in your books: record it, or reject it if it is not yours.
Supplier not filed GSTR-2A says the supplier has not filed GSTR-1, so the credit waits.
Rate or tax head The tax differs: a different rate, or IGST booked as CGST and SGST.
Amendment An amended document: compare it with the original.
Credit note A credit or debit note: reverse or adjust the credit.
Credit not available The portal marks the credit as not available (its reason is shown).
Reverse charge Credit is available only after the tax is paid.
No IRN and Late IRN An invoice without an IRN, or an IRN generated more than 30 days after the invoice.
No e-way bill An invoice of 50,000 or more with no e-way bill.
Not final in 26AS The booking status is not F: the deductor has not finalised the credit.

This one needs only your purchase register. It flags:

  • invoices not paid within 180 days of the invoice date (rule 37): reverse the credit and claim it again when paid;
  • ledgers that may be blocked credit under section 17(5): motor vehicles, food, club, health, beauty, gifts;
  • reverse charge purchases, where credit comes after payment of the tax;
  • invalid supplier GSTINs, missing details, invoices booked twice and tax that does not add up;
  • invoices past the claim deadline, 30 November after the financial year of the invoice (section 16(4)).

Add a Payment Date column to the register if you can: without it, every invoice older than 180 days is flagged.

GSTR-3B against GSTR-1 adds up outward supplies by month and compares each tax head: IGST, CGST, SGST and cess. Credit notes and advances adjusted reduce GSTR-1. Small B2C sales and advances are included by their totals. A month where GSTR-3B is lower than GSTR-1 shows the shortfall.

GSTR-3B against GSTR-2B compares the net credit in table 4(C) with the credit GSTR-2B shows as available, by month. Credit claimed above 2B is at risk.

Both files give one row per deduction, so either can be the first side. Deductions are matched to your TDS receivable by the deductor’s TAN, the amount and the date, several deductions to one entry when you book them together. Use the TDS receivable ledger template for your side.