Free tools Windows power users keep installed
One-click scans. No signup required.
iTechGuides is reader-supported. When you buy through links on our site, we may earn an affiliate commission. As an Amazon Associate I earn from qualifying purchases. Learn more
To reduce avoidable GST-refund friction in India, reconcile the same transaction population at four levels before you file or claim: invoices to GSTR-1, purchases to GSTR-2B, GSTR-1 to GSTR-3B, and the refund application to the underlying invoices and category-specific evidence. Correct missing, rejected, duplicated or misclassified records through the applicable portal process, then preserve an audit trail.
Reconciliation can prevent clerical and classification problems, but it cannot guarantee eligibility, approval or a processing time. Refund rules, portal behavior, due dates and documentary requirements can change, so verify the live GST Portal and current consolidated CBIC rules for your tax period and refund category.
What GST reconciliation actually checks
Reconciliation is a controlled comparison between your books, filed returns, portal-generated data and refund evidence. The goal is not merely to make totals agree. Each invoice must be in the correct period, under the correct GSTIN, with the correct taxable value, tax rate, tax amount, supply classification and document linkage.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Form GSTR-1 is the outward-supplies statement. The Goods and Services Tax Portal defines it as “a monthly/quarterly Statement of Outward Supplies to be furnished by all normal and casual registered taxpayers making outward supplies of goods and services or both and contains details of outward supplies of goods and services.” It contains invoice-level information for registered recipients, specified interstate supplies to unregistered recipients, exports, credit and debit notes, amendments and other listed categories.
#1 Best Overall
GSTR-2B is a read-only input-tax-credit statement built from supplier-filed information and other specified feeds. Its official FAQ says: “All the B2B information/documents (invoices, credit and debit notes) filed by suppliers in their monthly or quarterly GSTR-1/IFF/1A and GSTR-5 filed by NRTP taxpayers.” An invoice appearing in GSTR-2B is evidence of a supplier filing, not by itself a complete decision that the credit is legally available.
GSTR-3B is the summary return in which outward tax liability, zero-rated supplies, input-tax credit, reversals and ineligible credit are reported. A refund application must then tell the same story as these records and include the evidence required for its particular category.
Official material does not establish a current average delay, percentage of claims affected by mismatches or guaranteed refund timetable. Treat every claim as subject to the applicable rules, portal validation and any case-specific notice.
Quick wins for a faster PC:
Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →Scan for outdated or missing drivers - takes under a minuteDriver Scan →Set up a period-wise reconciliation file
Choose the tax period covered by the return or refund and freeze a source-data version before comparing anything. Keep the original accounting export, a working register, filed-return acknowledgements and a change log. Do not overwrite an invoice after filing; record the correction, date, responsible person and document used to support it.
Outward-supply register
Build the register from sales invoices, credit notes, debit notes, export documents, SEZ records and amendment history. At minimum, retain these columns:
| Field | What to capture | Why it matters |
|---|---|---|
| Document identity | Invoice, credit-note or debit-note number and date | Finds missing, duplicated and incorrectly linked documents. |
| Customer identity | Recipient GSTIN where applicable, legal name and state | Supports GSTIN validation and correct B2B or B2C classification. |
| Amounts | Taxable value, tax rate, IGST, CGST, SGST or UTGST and total | Explains differences between invoice-level records and return summaries. |
| Supply attributes | Place of supply, export or SEZ indicator, nature of supply and applicable return category | Prevents liability from being placed in the wrong return section. |
| History | Amendment reference, original document number, cancellation status and filing period | Shows which version belongs in the claim and avoids counting both versions. |
Purchase and ITC register
Import purchase invoices and notes from the books, then add supplier GSTIN, document date and number, taxable value, tax components, receipt or payment status where relevant to your eligibility review, the GSTR-2B period, and the decision to claim, defer, reverse or treat the credit as unavailable. Keep the supplier communication or corrected document that explains any change.
Refund evidence index
Create one row for every invoice included in the proposed claim. Add the evidence identifier that proves the relevant event: export invoice and shipping-bill information for goods, invoice and bank-realisation evidence for services, or the invoice statement and other documents required for an accumulated-ITC category. This index lets an officer trace a claim entry back to a source document without searching through an entire ledger.
Match sales invoices to GSTR-1
Perform this comparison before preparing the summary return and again after any amendment. The portal requires recipient GSTIN validation for invoice upload, and it provides processed, pending and errored records that must be reviewed.
- Extract the filed population. Download or otherwise preserve the GSTR-1 details for the period, including accepted, pending and errored records. Keep the portal-generated file with the date of download.
- Match document identity. Compare invoice and note numbers, dates and amendment references character for character, allowing only the formatting differences accepted by the portal. Look for duplicate numbers, cancelled documents still reported as active and amended documents counted twice.
- Validate the recipient. Confirm the GSTIN belongs to the customer and was valid for the transaction as recorded. A wrong digit can route a document to another taxpayer or cause upload rejection.
- Recalculate values. Reperform taxable-value and tax calculations from the invoice lines. Compare each tax component and rate, not only the grand total. Investigate rounding differences separately from substantive tax differences.
- Confirm the supply category. Check place of supply, B2B or relevant B2C classification, export or SEZ treatment and whether the document belongs in the period. A correct invoice in the wrong category can create a downstream GSTR-3B or refund mismatch.
- Resolve portal errors. Open every errored or pending record, read the portal message, correct the source data or use the permitted amendment route, and upload again. Do not assume that an invoice absent from the accepted list has been filed merely because it exists in your accounting system.
- Reconcile notes and amendments. Tie each credit or debit note to the original invoice and verify that the adjustment is reflected consistently in the period where the rules require it.
For registered recipients, GSTR-1 is invoice-level data; for specified interstate supplies to unregistered recipients and exports, use the relevant portal sections and preserve the supporting document population separately. The register should show which records were accepted, corrected, deferred or excluded and why.
Reconcile purchases to GSTR-2B before claiming ITC
GSTR-2B is useful for identifying what suppliers reported, but it is not a substitute for your own eligibility review. Compare the statement with purchase invoices and credit or debit notes, then apply the eligibility, timing, business-use and reversal rules that govern your taxpayer and period.
- Use the correct statement period. Download the GSTR-2B associated with the GSTR-3B period and retain the file. A supplier filing in a later period can explain a timing difference rather than a missing invoice.
- Match supplier and document details. Compare supplier GSTIN, invoice or note number, date, taxable value and tax amounts with the books. Check that your GSTIN was used by the supplier and that the document is not duplicated.
- Review available and unavailable sections. Investigate every entry placed in the unavailable section and do not claim it simply because tax appears on the invoice. Conversely, an entry in the available section still requires your separate legal and factual eligibility check.
- Follow up with suppliers. Where a document is missing, has the wrong GSTIN or has incorrect values, request the supplier’s correction in the applicable return or amendment process. Preserve the communication and identify the period in which the corrected document should appear.
- Post the decision to your ITC register. Mark each item as claimed, deferred, reversed or ineligible, with the reason and the GSTR-3B treatment. This prevents the same tax from being claimed in one period and reversed or deferred inconsistently in another.
Credit notes reduce the related credit or liability according to the applicable rules. Keep a link between the note, the original invoice and the amount reported in the return so that an apparent negative difference can be explained.
Do these 3 things before closing this tab:
1Repair Windows errors before they cause bigger problems2Fix the driver behind crashes, sound loss and screen glitches3Clear out junk files and repair common Windows errorsCross-check GSTR-1 against GSTR-3B
After invoice-level matching, aggregate the reconciled population by the categories used in GSTR-3B. Compare taxable values and each tax component, then investigate the reason for every difference. Do not force the invoice register to match a summary by making an unsupported journal entry.
Rank #3
- Ample Size and Quantity: with an appreciable size of about 9.8 x 11.7 inches, these alphabetical file dividers are large enough to cater for the organization of various forms of data, documents, and charts; The package includes 50 dividers in 12 assorted colors, providing sufficient quantity for individual usage as well as sharing with classmates, friends, colleagues, and others
- Durable Alphabetical Dividers: manufactured from 500g heavyweight cardboard, the A-Z alphabet file dividers are robust, sturdy, and not easily susceptible to deform, breaking or deformation; They can endure long term usage, making them a nice choice for organizing your important documents through time
- Unique and Stylish Design: these alphabetical dividers are finished in the charming fresh color palette, providing a stylish alternative to universal file folders; Comprising of 12 different beautiful colors, these dividers not only function to keep your files organized but also present a pleasing aesthetic value to your workspace
- Enhanced Efficiency and Convenience: each alphabetical file organizer is equipped with 1/5 cut top tabs preprinted with A-Z, allowing for easy classification, reduced searching time, and elevated productivity; They are designed for desktop and drawer filing, hence promoting a tidy and organized environment
- Extensive Applications: the A-Z tab dividers are not only suitable for office use but also for classrooms and study spaces; They can be applied to categorize or organize various materials including work documents, study materials, or even recipes; Their versatile nature brings about convenience and organization to your life
| Reconciliation layer | Compare | Investigate |
|---|---|---|
| Sales invoices to GSTR-1 | Number and date, recipient GSTIN, taxable value, tax, supply category, notes and amendments | Missing, duplicate, misclassified or rejected records; incorrect recipient details |
| Purchase invoices to GSTR-2B | Supplier documents and values against books; available and unavailable ITC sections | Supplier filing gaps, timing differences, wrong GSTIN or period and ineligible credit |
| GSTR-1 to GSTR-3B | Tax liability and supply-category totals | Wrong table or classification, omitted liability and inconsistent zero-rated reporting |
| Refund claim to records | Claim period, invoice population, tax and value totals and category evidence | Missing export, realisation or other required evidence; unsupported or inconsistent entries |
A CBIC circular documented a historical case in which export or SEZ details were present in GSTR-1 but placed in an incorrect GSTR-3B table, creating a portal validation problem during refund filing. That 2019 example is a reason to cross-check classifications; it is not proof that every mismatch delays a claim or that a historic workaround remains available. Use the current return instructions and portal behavior for your period.
Zero-rated totals deserve a separate tie-out
List exports and eligible SEZ supplies separately from domestic taxable supplies. For each line, compare the invoice value and tax treatment in GSTR-1, the corresponding GSTR-3B category and the refund schedule. If the same supply appears in two categories, determine which filing is legally correct and amend through the permitted route before submitting the claim.
Match the refund application to the same records
Identify the refund category first. The evidence, calculation and reporting path differ, so a document set that is adequate for one claim cannot automatically support another.
Export of goods
Reconcile the export invoice number, date, value and tax treatment with the shipping-bill information and the outward-supply return. Check that the goods, export period and claim population are the same in the refund statement and your register. Retain the shipping and export records required by the current rules and portal.
Export of services
Match each service invoice and value to the return and to evidence of receipt of payment in permitted foreign exchange, such as the applicable bank-realisation certificate or foreign-inward-remittance evidence. Verify that the service transaction meets the current export-of-services conditions before including it.
Accumulated ITC and other categories
For accumulated-ITC claims, prepare the invoice statement and the supporting purchase and GSTR-2B reconciliation required for the relevant category. Other categories, including supplies to SEZ units or developers, can require their own endorsements, declarations or invoices. Use the current CBIC rules and the case-specific portal checklist rather than copying evidence from an export-of-goods claim.
| Claim type | Core reconciliation | Evidence to verify before filing |
|---|---|---|
| Export of goods | Refund invoices, GSTR-1 and GSTR-3B zero-rated reporting | Export invoice and shipping-bill information, plus documents required by the current workflow |
| Export of services | Service invoices, return values and period of receipt | Invoices and applicable BRC/FIRC or other permitted realisation evidence |
| Accumulated ITC | Purchase register, GSTR-2B, ITC claimed or reversed and refund formula inputs | Invoice statement and category-specific declarations or supporting records |
| SEZ-related or other specified claims | Supply invoices, return classification and recipient or supply status | Endorsements, declarations and documents listed for that category in the current rules |
Before submitting, recompute the claim from the reconciled population and compare the result with the amount entered in the portal. Retain the calculation workbook, source invoices, return copies, evidence index and the ARN together.
The Tool Desk
Outbyte PC Repair FREERepair Windows errors before they cause bigger problemsFix Now →Outbyte Driver Updater FREEFix the driver behind crashes, sound loss and screen glitchesFind Drivers →Choose the appropriate zero-rated export route
For zero-rated exports, the GST Portal describes two broad routes. The right choice depends on eligibility, working-capital needs, transaction evidence and the rules applicable to the taxpayer and period.
| Route | Tax paid at export | Refund sought | Operational considerations |
|---|---|---|---|
| Export without payment of IGST | No IGST paid on the export under the permitted undertaking or procedure | Refund of eligible accumulated ITC | Requires a defensible ITC population, invoice statement and category-specific calculation; cash is not advanced as IGST on each export. |
| Export on payment of IGST | IGST paid and reported with the export | Refund of IGST paid after export | Requires correct export reporting, tax payment and matching export evidence; cash flow reflects the IGST paid until refund. |
Do not select a route solely because one appears faster. Check whether the taxpayer can use the route, whether the transaction evidence is complete, how ITC is accumulated, and what the current rules and portal permit for the relevant period.
Use portal data as a control, not as your accounting system
E-invoice integration reduces duplicate entry, but populated fields still require inspection. The GST Portal’s filing guidance states that e-invoice data is updated in GSTR-1 within two days. That is a portal workflow statement, not a refund-processing estimate; verify the live status for your period.
- Download the populated e-invoice data and compare it with the invoice register.
- Check that every expected document is present, in the correct table, with the correct GSTIN, value, tax and supply classification.
- Edit or add records through the permitted GSTR-1 function when the source is correct but the return is incomplete, and document why.
- Generate the return summary only after resolving errors and omissions.
- Review the generated summary against your independent reconciliation, then file and save the acknowledgement.
For monthly filers, the GSTR-1 guide gives the general due date as the 11th of the succeeding month; for quarterly filers, it gives the 13th after quarter-end. Government extensions can change these dates. They are filing deadlines, not refund service standards. Build an internal cut-off several days earlier so supplier follow-up and correction remain possible.
Diagnose common mismatches
| Symptom | Likely cause | Action |
|---|---|---|
| Invoice is in the books but absent from accepted GSTR-1 | Upload omission, validation error, wrong period or record left pending | Read the portal status, correct the source field, upload or amend through the permitted process, and retain the error message. |
| Customer cannot see a B2B invoice | Incorrect recipient GSTIN, wrong table or rejected record | Validate the GSTIN, inspect errored and processed records, and issue the permitted amendment rather than creating a second invoice number. |
| GSTR-1 total differs from GSTR-3B | Wrong supply classification, omitted note, period timing or summary-entry error | Re-aggregate the invoice register by return category and correct the return or subsequent amendment as allowed. |
| Purchase invoice is missing from GSTR-2B | Supplier has not filed, filed in another period or used the wrong GSTIN | Ask the supplier to correct its filing, mark the credit as deferred until eligible, and keep evidence of the follow-up. |
| Credit appears in GSTR-2B but should not be claimed | It falls in an unavailable section or fails your eligibility review | Do not claim it solely because it appears. Record the reason as unavailable, ineligible, deferred or reversed and reflect that decision in GSTR-3B. |
| Refund schedule does not tie to returns | Different claim period, invoice population, tax amount or zero-rated classification | Rebuild the schedule from the reconciled register and remove unsupported entries before submission. |
| Portal flags a zero-rated mismatch | GSTR-1 and GSTR-3B use different categories or historical data is inconsistent | Compare each export or SEZ line with the current table instructions and correct through the available process; do not rely on a historic workaround. |
Prepare for a deficiency memo or query
Keep a response folder that can be handed to the proper officer without reconstructing the claim. Include:
- Refund application acknowledgement or ARN and the filed return copies for the claim period.
- The period-wise outward and inward registers, with invoice-to-return matching status.
- GSTR-1, GSTR-2B and GSTR-3B downloads, including relevant error or amendment records.
- The refund calculation, invoice statement and a line-by-line evidence index.
- Shipping-bill and export documents for goods, or invoice and permitted realisation evidence for services, as applicable.
- Bank or account records and supplier or customer correspondence specifically requested by the notice.
- A concise reconciliation statement showing the disputed line, the source document, the filed value, the corrected value and the action taken.
Answer the notice using the exact period, invoice numbers and documents requested. If the notice concerns a classification or eligibility issue, explain the rule-based treatment and provide the contemporaneous record; do not send an unrelated bulk ledger that obscures the disputed entries. Follow the deadline and submission channel stated in the notice and current portal workflow.
Make reconciliation a recurring control
Monthly or quarterly close
Set an internal close before the statutory GSTR-1 deadline. Lock the sales and purchase registers, download portal statements, assign unresolved items to an owner and obtain supplier corrections early. Quarterly filers still benefit from monthly internal checks because errors compound across three months.
Maker-checker review
Have one person prepare the invoice and ITC matching and another review exceptions, zero-rated classifications, amendments and refund calculations. Require an explanation for every difference, even when the final treatment is to defer or reverse it.
Recommended Free Tools
Version and access control
Store read-only copies of filed returns, portal downloads, acknowledgement numbers and submitted refund schedules. Name files with GSTIN, period, return type and download date. Restrict edits to the working register and retain prior versions so the claim can be reconstructed if a notice arrives later.
Change monitoring
Before each claim, check current GST Portal instructions, notifications and consolidated CBIC rules for the taxpayer’s category. Due dates, table validations, evidence lists and correction mechanisms are not permanent; a procedure that worked for a historical period may not be available now.
What a defensible claim looks like
A strong reconciliation file lets a reviewer start with the refund amount, trace it to a claim line, trace that line to an invoice and export or purchase record, and then see the same value and classification in the relevant returns. It also shows how rejected, unavailable, amended, deferred or ineligible records were excluded. That chain of evidence addresses preventable data problems without implying that reconciliation alone determines eligibility or the time an authority will take to decide the refund.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
