Operating context · TallyPrime
Compare purchase records with GSTR-2B, classify mismatches and create a defensible input-tax-credit review file.
Start with the business or technical outcome
A purchase may be in the books but absent from GSTR-2B, present under a different document number, duplicated, dated in another period or recorded with an incorrect GSTIN. The useful way to learn this process is to see its trigger, hand-offs, controls and close condition. Input tax credit review fails when every difference is treated as the same problem.
Reconciliation is an evidence process, not a button that guarantees eligibility. The accounting record, supplier document, portal-derived statement and applicable compliance rules each answer a different question. The learner’s job is to bring them together without changing valid books simply to create a visual match.
Use masked or fictional invoices. Record the return period, company GST registration and extraction date. If rules or portal behavior affect a live filing, involve a qualified tax professional and verify the current official guidance.
What to understand before opening the tool
Before matching, standardise GSTIN, invoice number, invoice date, taxable value and tax components. A formatting difference such as spaces or prefixes may be harmless, while a wrong GSTIN or tax amount needs investigation. Define tolerances deliberately rather than letting approximate matches hide material errors.
Know the distinction among an accounting correction, a supplier follow-up, a timing item and a tax-position decision. Only the first belongs directly in the books; the others need tracking, evidence or professional review.
Purchase Register
Use it for: provide the book-side invoice population and tax values Keep as evidence: period export with voucher references
GSTR-2B Data
Use it for: provide the statement-side documents available for review Keep as evidence: dated source file
Reconciliation View
Use it for: group matches and exceptions for investigation Keep as evidence: status-wise exception report
Supplier Ledger
Use it for: trace invoice, credit note and payment context Keep as evidence: voucher drill-down and correspondence reference
The process should finish with a supplier-wise GSTR-2B reconciliation with matched items, exception reasons, correction actions and reviewer notes. Treat every hand-off as a possible control point. Note who supplies the input, who approves an exception and which report or record proves completion. This turns a memorised transaction into an operating procedure that another person could follow.
Run the process from trigger to close
Build a repeatable match process so the same invoice cannot quietly move between categories without explanation.
- Freeze the source filesExport the purchase population and obtain the relevant GSTR-2B data for the same registration and period.Checkpoint: Read-only copies with period and extraction date.
- Validate the populationCheck GSTIN format, document type, date range, duplicates, cancelled vouchers and debit or credit notes.Checkpoint: A data-quality log before matching starts.
- Run deterministic matchesMatch strong keys first: supplier GSTIN, normalised invoice number, date and tax amount.Checkpoint: A matched set with rule used for each record.
- Classify every exceptionSeparate missing supplier uploads, timing differences, book omissions, number mismatches, value mismatches and duplicates.Checkpoint: An exception ageing by reason and supplier.
- Correct only supported errorsAlter book records only when the source document and approval prove the accounting entry is wrong.Checkpoint: Correction voucher reference and reviewer approval.
- Close the review trailAssign supplier follow-ups, record tax-review decisions and preserve the final reconciliation.Checkpoint: A signed summary tying back to both source totals.
A reliable operator knows where the process can pause without corrupting later work. Mark those points, define the owner and write the condition that allows work to continue.
Control points for reliable execution
Different mismatch classes need different owners and actions.
| Decision or signal | Action to take | Evidence to retain |
|---|---|---|
| Books only | Verify supplier filing/timing; do not invent a portal match | Invoice, ledger and supplier follow-up |
| GSTR-2B only | Search omitted or differently numbered book entries and duplicates | Statement row plus book search result |
| Tax amount differs | Compare invoice, taxable value, rate and credit-note treatment | Document copy and calculation |
| GSTIN differs | Confirm supplier registration and voucher master data before correction | Official invoice and vendor record |
| Duplicate candidate | Check invoice identity across periods and voucher types | Duplicate-review note and retained record |
Exceptions an operator must be ready to handle
These shortcuts make reconciliation appear cleaner while weakening the audit trail.
- Fuzzy matching everything: Approximate rules can link unrelated invoices; reserve them for reviewed candidates.
- Changing invoice numbers to force a match: Preserve the legal document reference and investigate normalisation separately.
- Ignoring credit notes: They can change eligible amounts and must be linked to the correct supplier and period.
- Mixing GST registrations: Reconcile each GSTIN independently so totals and ownership remain clear.
- Treating matched as automatically eligible: Eligibility depends on current law and facts beyond a technical match; obtain qualified review.
Turn the exercise into credible portfolio evidence
Build a 30-invoice fictional dataset containing clean matches, timing items, duplicates, credit notes and deliberate master-data errors. Present a reconciliation dashboard showing matched value, exception value and supplier follow-up ageing.
Include your normalisation rules and explain two cases where you refused to auto-match. That judgment demonstrates data quality and accounting control better than a perfect-looking match percentage.
Explain it clearly in an interview
Explain why you match strong identifiers first, how you distinguish a timing issue from a book error, and which evidence you retain before changing an accounting voucher.
Peer review before calling the work complete
Ask another learner to inspect the result without watching you build it. Give them the original scenario—a purchase may be in the books but absent from GSTR-2B, present under a different document number, duplicated, dated in another period or recorded with an incorrect GSTIN.—and the evidence pack, but not your intended conclusion. They should be able to trace the input, identify the main decision and locate the proof of the output. If they cannot, improve the labels, timestamps or explanation instead of adding decorative screenshots.
Use this acceptance condition during the review: Both source totals are preserved, every exception has one reason and owner, and book changes can be traced to authentic documents and approval. Record one question the reviewer raised and the change you made in response. That small feedback loop makes the TallyPrime GSTR-2B reconciliation exercise more credible, easier to maintain and easier to explain under interview questioning.
Questions learners ask
What is GSTR-2B reconciliation?
It compares purchase and tax records with statement data to identify matches and exceptions for compliance review.
Should every books-only invoice be deleted?
No. It may be a timing or supplier-reporting issue. Investigate the document and current rules before any action.
Can invoice numbers be normalised?
Yes for matching logic, provided the original legal reference remains unchanged and the rule is documented.
Who decides ITC eligibility?
Eligibility is a tax decision based on current law and transaction facts; software matching supports but does not replace qualified review.
Use current product guidance
Menus, fields, permissions and service behavior can change between product versions or tenant configurations. Check the official TallyHelp documentation before applying version-sensitive steps in a live environment.
Build the complete skill path
Learn accounting foundations, voucher logic, GST workflows, inventory controls and report verification through guided TallyPrime practice.
Final perspective
The real value of TallyPrime GSTR-2B reconciliation is the ability to complete a controlled task and defend the result with evidence. A learner who can show the input, explain the decision, verify the output and describe one realistic exception demonstrates far more than someone who has only memorised a menu path or definition.