Reconcile GST returns by matching your sales and purchase records to the relevant portal statements at document level, investigating timing and data differences, and then checking tax and input tax credit (ITC) eligibility before finalizing GSTR-3B. GSTR-1, GSTR-2B, GSTR-3B and your books serve different purposes; a difference is a signal to investigate, not a reason to change a figure blindly.
This guide covers India’s GST system. Filing options, portal procedures and tax treatment can change and depend on the taxpayer and tax period, so confirm current GST Portal instructions and applicable law before filing.
As an Amazon Associate I earn from qualifying purchases.
What each record is for
| Record | What it does in reconciliation |
|---|---|
| Sales register and books of account | Your accounting record of transactions. Use the underlying invoices, notes and other records to establish what was supplied and when. |
| GSTR-1 | Reports details of outward supplies, including specified invoice-level information, credit and debit notes, amendments and summaries. |
| GSTR-3B | Summarizes supplies, ITC and tax liability for the return period and is used to declare and pay tax. |
| Purchase register and source documents | Your record of inward supplies, supported by supplier invoices, notes and other relevant documents. |
| GSTR-2B | An auto-drafted statement of specified supplier and other information used as an input when reviewing ITC. It is not, by itself, a final decision that credit is eligible. |
The Government of India has said that GSTR-1, GSTR-3B and books should ideally be synchronous. Their layouts and level of detail differ, so the goal is to explain the movement from transaction records to return totals—not to make every form match line for line.
Prepare the records for the same reconciliation
Before comparing figures, define the GSTIN and tax period, the accounting period covered, and the filing frequency that applies to the taxpayer. Download or retain the relevant portal data and export sales and purchase records for the corresponding scope. Keep invoice date, accounting date, return period and portal statement period as separate fields where they can differ.
#1 Best Overall
- AN EASY & EFFICIENT WAY TO CONTROL YOUR FINANCES: Created for both small business and personal use, this horizontal accounting ledger book has spacious pages to log payments and deposits, so that you can monitor your finances and spot errors easily.
- LARGE FORMAT LEDGER WITH PLENTY OF WRITING SPACE: This accounting book ledger comes in a large format, measures 10 by 7 inches, and has 129 pages with 3,100 entry lines total.
- TRACK ACTIVITY IN MULTIPLE ACCOUNTS WITH JUST ONE BOOK: This accounting log book will be perfect if you want to track activity in multiple accounts. To do so, use the dedicated column to add the bank account number every time you make a record.
- PREMIUM DESIGN FOR COMFORTABLE DAILY USE: This accounting journal book has a durable eco-leather hardcover, thick 120gsm paper, sturdy elastic closure, pen loop, ribbon bookmark, and back pocket for extra notes, checks, and receipts.
- 60-DAY MONEY-BACK GUARANTEE: We will exchange or refund your small business log book if you aren’t satisfied with your business bookkeeping ledger for any reason. Reach out to us via message to refund your monthly accounting ledger book.
- Include source documents and adjustments, not only ledger totals: invoices, credit and debit notes, amendments and relevant advances or adjustments.
- Separate late-filed documents and amendments so a timing difference is not mistaken for a permanent omission.
- Use a consistent basis for comparing taxable value, tax amounts, tax heads, recipient or supplier GSTIN, document number and date.
- Preserve the original exports and record when they were obtained, so later changes can be traced.
Do not assume every business follows the same monthly or quarterly cycle. Eligible taxpayers may opt for quarterly filing under applicable portal arrangements; confirm current eligibility and filing options for the GSTIN and period.
How do I reconcile GSTR-1 with my sales register?
1. Establish the sales population
Start with issued tax invoices and other outward-supply records for the period. Include relevant credit and debit notes, amendments, exports or supplies to SEZs, and exempt, nil-rated or non-GST supplies. The required reporting treatment depends on the transaction and current return instructions.
2. Match the register to GSTR-1
Match invoice-level records where supplies are reported individually. For consolidated reporting, compare totals by the relevant supply category and tax rate. Check recipient GSTIN, document number and date, taxable value, tax arithmetic, place of supply, tax-rate and supply-category coding, and the treatment of notes and amendments.
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 →Rank #2
- Refined Financial Management: Our ledger books for bookkeeping can be used to track personal bills and budgets and serve as book keeping log for small business.Helps you keep track of your expenses and income for effective financial planning.
- Adequate Ledger Entries: Dimensions are 8.4 x 6.1 inches, making it easy for you to take anywhere. This accounting ledger comes with 3304 entry spaces (120 pages) so you can record all your financial information in one place, with easier access to track transaction types and dates.
- Elegant & Exquisite Design: Our ledger notebook adopts a classic waterproof material cover, which is not easy to wear. Gold double spiral binding makes flipping through easy. This bookkeeping book is also designed with practical inner pockets and bookmark elastic bands.
- Flexible & Thick Paper: Our accounting book is made of 100gsm non-bleeding paper, perfect for fountain pens, ballpoint pens and other pen types. Convenient to write on, so you no longer have to worry about bleeding ink.
- Perfect For Gift Giving: As you would expect, the cover of the book keeping book is beautifully designed with gold foil lettering and floral patterns. Perfect as a gift for parents and friends, or as a business ledger for small business.
Use a stable document key where possible, such as GSTIN plus document type, number and date. Where numbering formats differ between systems, retain a documented normalization rule rather than treating similar-looking records as an automatic match.
3. Explain every difference before comparing with GSTR-3B
- In the sales register but not GSTR-1: check whether the document was omitted, reported in another period, grouped into a summary, or altered through an amendment.
- In GSTR-1 but not the register: verify the source document and accounting entry; investigate duplicates, wrong GSTINs and posting to a different period.
- Amounts or tax heads differ: compare the source invoice and filed details, including taxable value, arithmetic, tax rate and place of supply.
- Notes or amendments differ: trace both the original entry and its adjustment to confirm the period and value reported.
Once GSTR-1 differences are understood, reconcile its reported outward-supply information to the relevant liability figures in GSTR-3B and to the books. GSTR-3B is a summary, so use the sales detail and a reconciliation schedule to show how the summary was derived.
What is GSTR-2B?
GSTR-2B is an auto-drafted statement that brings together specified information used when reviewing inward supplies and ITC. It can include supplier-furnished invoice and note details through GSTR-1, GSTR-1A or the Invoice Furnishing Facility (IFF), specified information from GSTR-5 and GSTR-6, and IGST on imports sourced from ICEGATE. Its sections identify credit shown as available or not available in specified situations.
Rank #3
- Easy To Track Your Finances: HAUTOCO accounting ledger book keeps you on top of your expenses and income! Help you keep your money organized, spend well, and set and achieve financial goals
- Premium Material: The A5 accounting ledger book has a total of 120 pages and 2040 lines of entries. It is made of 100gsm thick paper to reduce ink leakage; it is equipped with a waterproof and sturdy PP cover to protect the inner pages
- Practical Design: Compact 8.3 x 6.2'' expense tracker notebook is easy to carry and features information pages, 2025 calendar, yearly financial goals page, and PVC pocket for storing important tickets and loose items
- Manage Your Finances Effectively: Undated accounting books with number, date, description, account, payment or deposit amount, and total balance. You will be able to easily analyze your financial activities and quickly prepare accurate financial statements
- Ideal For Small Business or Personal Use: An accounting log journal can track your business or personal financial status. With a clear record of transactions, you can find unnecessary expenses or fraudulent charges
The labels are not a substitute for the taxpayer’s own eligibility assessment. The GST Portal cautions that provisions beyond the situations it marks can also make ITC unavailable, and places responsibility on the taxpayer to self-assess.
Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Fix the driver behind crashes, sound loss and screen glitchesFind Drivers →Clear out junk files and repair common Windows errorsFree Scan →How to reconcile purchases and ITC
1. Match purchase records to GSTR-2B and source documents
Compare the purchase register to GSTR-2B using supplier GSTIN, document type, number, date, taxable value and tax amounts. Check the corresponding supplier invoice, debit or credit note and other relevant source documentation. Reconcile imports and other categories using the records and portal information applicable to them.
2. Classify unmatched records
- In the books, absent from the expected GSTR-2B: verify the supplier GSTIN and invoice details, ask whether the supplier filed or amended the document, and check the statement cut-off and subsequent periods.
- In GSTR-2B, absent from the books: verify whether the supply was received and recorded, whether the document belongs to the correct GSTIN, and whether it falls in a different accounting period.
- Values or tax heads differ: compare the source document with portal details, including taxable value, tax, place of supply, amendments and notes.
- Credit appears but eligibility is uncertain: assess statutory conditions, restrictions and any required reversal separately from the matching result.
3. Check timing before calling an invoice an error
A supplier’s filing date can affect the GSTR-2B period in which a document appears. Documents filed after a relevant cut-off may show in a later open statement. The portal guidance also says that a supplier’s GSTR-1A addition or amendment can be reflected in the recipient’s next-period GSTR-2B. Check the applicable filing and statement timing for the specific period before deciding that a missing document is a permanent mismatch.
Rank #4
- PU Leather Cover with Gold Foil: Ledger book features a finely textured black pebbled PU leather cover with exquisite gold foil stamping. This not only provides a non-slip, wear-resistant feel but also exudes a luxurious and sophisticated look. The durable material protects the inner pages from damage and is suitable for various scenarios, including business office work and personal finance.
- Portable Size: Columnar book 7 x 9.25 inches, is compact and space-saving, easily fitting into a briefcase, tote bag, or backpack. Whether for business trips, field reconciliation, or everyday carry, it allows for recording income and expenses anytime.
- Large Capacity: Record per book contains 50 sheets of 80g double-sided offset paper. Each page features 30 clear lines of writing and a 3-column categorization layout. Double-sided color printing ensures clear and smudge-proof text. The notebook includes a marker bar for quickly marking important items or reconciliation points. With a total of 1500 writing positions, it meets daily, monthly, and even annual accounting needs, eliminating the need for frequent notebook replacements.
- Eye-friendly Inner Pages: Budget book's inner pages feature a soft, eye-friendly green background with double-sided color printing, effectively reducing visual stimulation from strong light reflection. This minimizes eye fatigue even during extended writing sessions, reflecting a healthy and thoughtful design consideration, making it suitable for those who frequently keep track of their expenses.
- Comfortable Writing Experience: Logs book's spacious line spacing provides ample space for writing, allowing for clear categorization of income, expenses, and balances, resulting in more organized budgeting. It also ensures clear and neat handwriting, enhancing writing fluency and overall page neatness.
Determine net ITC separately from the match
After matching, review eligibility under the law applicable to the tax period. Section 16 of the Central Goods and Services Tax Act sets the general framework for ITC on qualifying business-use supplies, subject to conditions. Other rules can restrict credit or require apportionment or reversal. Relevant checks may include the required documentation, receipt and use of the supply, payment-related conditions, time limits and blocked-credit provisions.
Keep distinct workpaper totals for portal-reported information, potentially eligible credit, ineligible credit, reversals and any credit reclaimed when the applicable conditions are met. Reconcile those amounts to the ITC figures reported in GSTR-3B using the current return instructions. Circular 170/02/2022-GST addresses reporting and reversal or reclaim treatment; apply the provisions and reporting procedure in force for the period rather than relying on a generic mapping.
Resolve exceptions and retain an audit trail
Maintain an exception register until each material difference is resolved. For every item, record the document reference, customer or supplier GSTIN, relevant periods, source of the mismatch, value and tax impact, supporting evidence, assigned owner, follow-up and resolution.
Best Value
- [A Value Set]: Our Accounting Ledger Paper notebook comes with 100 sheets/200 pages ledger papers and a PU leather 3 ring binder. Extra Movable Monthly Tabs
- Thick Paper: These 3 column ledger paper are 100 gsm, Can be written smoothly to prevent ink bleeding. Both sides can be used
- [Size]: The size of the columnar pad paper is 8.5" X 11". The black 3-ring binder can be used for 8.5X11 refill paper
- [3-Ring Binder & Movable Monthly Tabs]: Binder accounting ledger notebook can be added, deleted, and re-arranged pages easily. The month tabs make it easy to organize the same months from different years
- Application: The ledger paper notebook is perfect for bookkeeping, accounting or other numeric data. it can be used by accountants, teachers, student
Correct books or return data only through a procedure available for the relevant period, and keep evidence of the correction. GST Portal guidance describes GSTR-1A as an optional facility for adding or amending records after GSTR-1 is available and before GSTR-3B filing; changes made there flow to that supplier’s GSTR-3B, while recipient ITC is reflected in the next-period GSTR-2B. Confirm live portal instructions and the applicable period before using it.
A mismatch can point to tax payable or tax paid in excess, depending on the facts. Do not force totals to agree by changing a figure without identifying the transactions and retaining a reasoned record.
Common reconciliation mistakes
- Comparing only headline totals and missing invoice omissions, duplicates, notes or amendments.
- Treating GSTR-2B’s available label as conclusive proof that ITC can be claimed.
- Assuming every absent invoice is permanently lost instead of checking supplier filing and statement timing.
- Mixing invoice date, accounting period and return period without documenting why they differ.
- Changing a return or ledger total simply to match another total, without tracing the underlying documents.
- Relying on an old threshold, annual-return rule or portal procedure as if it were necessarily current.
Choosing a manual or software-assisted process
A spreadsheet may be workable when invoice volume is low and the business can preserve source exports, matching rules and exception history. A reconciliation tool may be worth evaluating when recurring or high-volume matching makes manual review difficult. Assess options against the business’s actual workflow rather than assuming a product will resolve tax questions automatically.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
- Can it import the relevant GST Portal statements and accounting exports?
- Does it match at invoice level and preserve amendments and history?
- Can staff assign, comment on and track exceptions through resolution?
- Are workpapers exportable and access controls suitable for the records involved?
- Are data handling practices, current capabilities and total costs clear?
Regardless of method, retain portal statements, source documents, reconciliation workpapers and exception decisions in a form that can be retrieved later.
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.
