Between the 14th of the month (when Form GSTR-2B is generated) and the 20th (when Form GSTR-3B is due), finance teams face a strict compliance window. In Zoho Books, accountants must verify that inward purchase bills match government records before finalizing monthly tax liabilities. Claiming input tax credit on vendor bills that do not appear in GSTR-2B invites scrutiny notices, while overlooking eligible portal entries locks up working capital.
Many finance professionals struggle with API connection failures, OTP delays, and unbilled bills appearing in reconciliation dashboards. Whether you use Zoho Books direct API connector or prefer offline JSON file matching, establishing a structured reconciliation workflow eliminates month-end stress. For teams evaluating alternative software setups, our companion guide on how to reconcile GSTR-2B with accounting software outlines general ERP matching principles.
Statutory rules governing GSTR-2B reconciliation
Under the Goods and Services Tax framework, input tax credit eligibility is governed by strict statutory conditions:
- Section 16(2)(aa) of the CGST Act: A registered recipient can claim input tax credit only if the supplier has furnished invoice details in Form GSTR-1 or the Invoice Furnishing Facility, and those details have been communicated to the recipient in Form GSTR-2B.
- Rule 36(4) of the CGST Rules: Prohibits claiming provisional input tax credit. No ITC can be availed for invoices that do not appear in Form GSTR-2B.
- Rule 88D of the CGST Rules: When ITC claimed in Form GSTR-3B exceeds the eligible ITC auto-populated from Form GSTR-2B beyond specified limits, the portal issues Form DRC-01C. The taxpayer must pay the difference with interest under Section 50 or explain the variance within seven days.
Understanding these provisions confirms why matching inward bills in Zoho Books is not merely an internal accounting routine, but an enforceable legal requirement.
Common mistake: Claiming ITC in Form GSTR-3B based solely on entered Zoho Books bills without reconciling against GSTR-2B leads to automated DRC-01C intimations and mandatory 18 percent annual interest under Section 50(3).
Direct API sync vs manual GSTR-2B JSON file upload
Zoho Books provides two distinct technical routes to bring portal records into your reconciliation module. Choosing the right path depends on user permissions and portal stability.
| Feature | Direct GST Portal API Sync | Manual GSTR-2B JSON Upload |
|---|---|---|
| Setup requirement | API access enabled on GST portal with registered GSP | Standard GST portal login credentials |
| Authentication | Requires mobile OTP sent to primary authorized signatory | Standard portal login with username and password |
| Speed during peak days | Subject to gateway queues and API timeouts on 18th to 20th | Instant upload and local parsing without network lag |
| Suitability | In-house finance teams with direct signatory access | Tax consultants, external CAs, and multi-client practices |
Method 1: Direct GST portal API sync
If you have direct access to the registered mobile number for OTP verification, set up API access:
- Log into the GST common portal, go to My Profile, and select Manage API Access.
- Set API access to Yes and select a session duration of 6 hours or 30 days.
- In Zoho Books, navigate to Settings → Taxes → GST Settings and authorize the GSTN connection using your portal username.
- Navigate to GST Filing → GSTR-2B → Reconcile and click Pull from GSTN. Enter the OTP received on the registered mobile number.
Method 2: Manual GSTR-2B JSON file upload
When the authorized signatory is unavailable or API gateways experience downtime, manual file upload is the fastest alternative:
- Log into the GST portal, navigate to Services → Returns → Returns Dashboard, select the return period, and locate Form GSTR-2B.
- Click Download and choose Generate JSON File to Download. Download the resulting zip file and extract the JSON payload.
- In Zoho Books, go to GST Filing → GSTR-2B → Reconcile.
- Click the options menu and select Upload GSTR-2B JSON. Select your downloaded file to begin reconciliation.
For accountants who prefer working outside the accounting interface, our guide on how to reconcile GSTR-2B with Zoho Books without API access shows how to pair exported Zoho Books bill registers with GSTR-2B spreadsheets directly.
Understanding reconciliation statuses in Zoho Books
Once data is imported, Zoho Books compares records based on Supplier GSTIN, Invoice Number, Invoice Date, Taxable Value, and Tax Amounts (CGST, SGST, IGST). The system categorizes every record into specific statuses:
- Matched: Invoice numbers, dates, taxable values, and tax splits align within configured tolerance limits. These invoices represent eligible ITC ready to claim in Form GSTR-3B.
- Partially Matched: The supplier GSTIN matches, but minor variances exist in invoice numbering (such as slashes or leading zeros) or rounding differences exist in tax amounts.
- Missing in Zoho Books (Unbilled Bills): The invoice appears in GSTR-2B because the vendor filed Form GSTR-1, but no corresponding purchase bill exists in Zoho Books.
- Missing in GSTR-2B: A purchase bill is recorded in Zoho Books, but the vendor has not furnished the invoice on the GST portal.
Managing the unbilled bills workflow
One of the most frequent challenges in Zoho Books reconciliation is handling transactions marked as Missing in Zoho Books, often referred to as unbilled bills. This discrepancy arises when a vendor files an invoice on the portal, but your internal processing has lagged.
Common causes for unbilled bills include:
- Goods in transit: The vendor generated an e-invoice and dispatched materials on the 29th of the month. The vendor filed GSTR-1 on the 10th of the following month. However, the physical consignment and delivery challan have not yet cleared your warehouse goods receipt gate.
- Pending internal approvals: The bill was received by the procurement team but remains stuck in an internal departmental approval chain, preventing creation of a formal bill voucher in Zoho Books.
- Direct service billing: Recurring utility bills, corporate telecommunication charges, or annual software subscriptions were filed by vendors without sending a physical tax invoice copy to accounts.
Section 16(2)(b) receipt condition: Under Section 16(2)(b) of the CGST Act, a registered person is not entitled to credit unless goods or services have been received. Even if an unbilled bill appears in GSTR-2B, do not book the bill and claim credit until actual receipt occurs.
Standard operating procedure for unbilled bills in Zoho Books
Follow this procedure to resolve unbilled entries without distorting financial statements:
- From the reconciliation tab, filter by Missing in Zoho Books.
- Export the unbilled bills list containing Vendor GSTIN, Invoice Number, Date, Taxable Value, and Tax Component.
- Cross-reference each entry against warehouse Good Receipt Notes (GRN) and material intake registers.
- If goods were received during the period, click Create Bill directly inside the Zoho Books reconciliation window to generate the purchase voucher.
- If goods remain in transit, defer the bill. The credit will remain available on the GST portal until the time limit under Section 16(4) expires (30 November following the financial year end).
Worked reconciliation example with realistic rupee figures
Consider an engineering enterprise in Pune, Maharashtra, operating in October 2026. The purchase register in Zoho Books shows four inward bills with total tax of ₹1,26,000. Inward records in Form GSTR-2B show four entries totaling ₹1,08,000. Let us review the invoice-by-invoice reconciliation:
| Invoice Ref | Supplier GSTIN | Zoho Books Tax | GSTR-2B Tax | Reconciliation Status | Action Required |
|---|---|---|---|---|---|
| INV-101 | 27AAACG1111A1Z1 | ₹36,000 | ₹36,000 | Matched | Claim ITC in Table 4(A)(5) of Form GSTR-3B |
| INV-102 | 27AAACG2222B1Z2 | ₹54,000 | ₹54,000 | Matched | Claim ITC in Table 4(A)(5) of Form GSTR-3B |
| INV-103 | 27AAACG3333C1Z3 | ₹18,000 | ₹0 | Missing in GSTR-2B | Hold ITC; contact vendor to file in GSTR-1 or GSTR-1A |
| INV-104 | 27AAACG4444D1Z4 | ₹18,000 | ₹0 | Missing in GSTR-2B | Vendor filed as INV/104; manually pair in Zoho Books |
| UB-501 | 27AAACG5555E1Z5 | ₹0 | ₹18,000 | Missing in Zoho Books | Goods in transit; verify GRN before creating bill |
Arithmetical breakdown of the tax positions:
- Total tax recorded in Zoho Books bills:
₹36,000 + ₹54,000 + ₹18,000 + ₹18,000 = ₹1,26,000. - Total tax reflected in Form GSTR-2B:
₹36,000 + ₹54,000 + ₹18,000 (INV/104) + ₹18,000 (UB-501) = ₹1,26,000. - Directly matched eligible ITC:
₹36,000 + ₹54,000 = ₹90,000. - After manual pairing of INV-104 against portal record INV/104, matched ITC increases by ₹18,000:
₹90,000 + ₹18,000 = ₹1,08,000. - Ineligible credit held back due to missing supplier filing (INV-103): ₹18,000.
- Net ITC claimed in Table 4(A)(5) of Form GSTR-3B: ₹1,08,000.
By manually linking INV-104 and withholding INV-103, the accountant avoids claiming an unfiled invoice of ₹18,000, preventing a potential DRC-01C demand.
Pushing reconciliation discrepancies to purchase adjustments
When discrepancies occur, purchase ledgers must reflect accurate accounting realities. In Zoho Books, handle variances using standard journal entries and vendor communication:
1. Addressing invoice numbering discrepancies
Under Rule 46(b) of the CGST Rules, an invoice number can contain up to 16 characters including alphabets, numerals, hyphens, and slashes. When an accountant types hyphens while the supplier enters slashes, click Match Manually in Zoho Books. Search for the supplier GSTIN and link the corresponding records without altering historical book balances.
2. Handling tax value and rounding variances
Section 170 of the CGST Act mandates rounding off tax amounts to the nearest rupee. If a supplier calculates tax item-by-item while Zoho Books computes tax on the total bill, minor differences of ₹1 or ₹2 emerge. When adjusting small round-off amounts, post the variance to the Round Off Expense Account rather than adjusting raw tax ledgers.
3. Following up on missing supplier invoices
For invoices missing from GSTR-2B (such as INV-103 in our example), send a formal request to the vendor before return deadlines:
For detailed step-by-step guidance on pairing purchase records line by line, consult our tutorial on how to match purchase invoices with GSTR-2B.
Common pitfalls during Zoho Books reconciliation
Finance professionals should watch for several recurrent pitfalls during monthly matching cycles:
- Overlooking IMS Pending invoices: On 1 October 2024, GSTN introduced the Invoice Management System (IMS). If an invoice is marked as Pending on the IMS dashboard, it does not flow into GSTR-2B. Review your IMS dashboard at services.gst.gov.in before assuming a vendor failed to file.
- Disregarding Rule 37 payment aging: Under Rule 37 of the CGST Rules, if a vendor bill remains unpaid for more than 180 days from the invoice date, claimed ITC must be reversed with interest. Run aging reports in Zoho Books alongside your reconciliation.
- Confusing bill date with GSTR-2B tax period: A vendor filing quarterly returns under the QRMP scheme will not reflect monthly bills until the quarter closes, unless uploaded via the Invoice Furnishing Facility (IFF) by the 13th.
Frequently asked questions
How do you import a GSTR-2B JSON file into Zoho Books?
In Zoho Books, navigate to GST Filing, select GSTR-2B, click Reconcile, and choose Upload JSON File. Select the GSTR-2B JSON file downloaded from the GST portal to initiate offline matching without requiring GST portal API credentials or OTP verification.
What causes the unbilled bills status during Zoho Books reconciliation?
Unbilled bills or invoices in GSTR-2B not in Zoho Books occur when a supplier has filed their tax invoice in GSTR-1, but your purchase team has not yet recorded the corresponding vendor bill in your Zoho Books accounting records.
How does Zoho Books handle invoice number mismatches with special characters?
Zoho Books matching rules attempt to pair invoices by ignoring slashes and hyphens. However, if a supplier prefixes or drops financial year codes, Zoho Books classifies the record as Partially Matched or Missing in Zoho Books, requiring manual pairing.
Can you claim ITC on bills marked as missing in GSTR-2B?
No. Under Section 16(2)(aa) of the CGST Act and Rule 36(4), input tax credit cannot be availed in Form GSTR-3B unless the invoice details are furnished by the supplier in GSTR-1 and communicated in Form GSTR-2B.
What is the consequence of claiming ITC on mismatched purchase bills?
Claiming ITC in excess of GSTR-2B triggers an automated mismatch intimation in Form DRC-01C under Rule 88D. The taxpayer has seven days to either pay the differential tax along with interest under Section 50 or explain the discrepancy on the portal.
Verify your Zoho Books bills against GSTR-2B
Export your Zoho Books purchase bill register and match it against your GSTR-2B file in seconds. Your GSTR-2B and purchase register files are read in your browser and never uploaded to any server.
Last checked: 15 October 2026. Sources: CBIC CGST Act Section 16, CBIC Notification 40/2021-CT, GSTN Returns Portal Guide.