Books vs GST vs AIS Mismatch: How to Reconcile Turnover

Picture this everyday scenario:

It is a busy afternoon at your office. A client walks in, visibly anxious, holding a printout of an ASMT-10 notice from the GST department.

The notice says:

"Your turnover in the Audited P&L is ₹10 Crore, but your GST returns show ₹10.80 Crore, and your Income Tax AIS shows ₹11.10 Crore. Explain why you suppressed sales."

The client asks: "Sir, did our accountant make a mistake? Are we in trouble?"

If you practice in taxation, you see this situation almost every week.

Here is the truth you need to explain to your client and your accounting team: A mismatch between Books, GST, and AIS does not mean someone committed fraud or made an error.

These three systems simply speak different languages.

Once you understand why these differences exist, reconciling them takes minutes rather than days. Let us break down the exact reasons for these gaps and how to build a foolproof reconciliation sheet.

The Root Problem: Three Different Rulebooks

Think of your business as a cricket match. Books, GST, and Income Tax are three different umpires watching the same match, but each is reading from a completely different rulebook:

1. Your Books (P&L): Follow Accounting Standards. They only care about actual revenue earned by the business.
2. GST (GSTR-1 & 3B): Follows the CGST Act. It taxes any "supply"—even if you didn't make a profit, or if you simply moved goods to your own branch in another state.
3. AIS / TIS: Gathers data from banks, buyers, and GST bulk uploads. It often records the gross amount and sometimes records the same transaction twice.

When these three systems do not show the same number, the tax department's automated system flags it as suspicious. Your job is simply to build the mathematical bridge between them.

The 5 Most Common Reasons for Differences (With Simple Examples)

Let us take a simple business—Apex Enterprises—with an audited sales turnover of ₹10.00 Crore. Here is why its GST and AIS show higher numbers:

1. Sale of Old Machinery or Fixed Assets

• What Happened: Apex sold an old CNC machine for ₹20 Lakhs.
• In Books: You do not add ₹20 Lakhs to your sales turnover in the P&L. You reduce it from your Fixed Assets block in the Balance Sheet. Only the profit or loss on the machine goes to the P&L.
• In GST: The government treats this as a regular supply. You must issue a tax invoice and report the full ₹20 Lakhs in Table 4 of GSTR-1.
• The Result: GST turnover is ₹20 Lakhs higher than P&L turnover.

1. Sending Goods to Your Own Branch (Branch Transfers)

• What Happened: Apex sent goods worth ₹50 Lakhs from its factory in Bhopal to its sales depot in Raipur.
• In Books: You cannot sell goods to yourself. In financial accounting, internal transfers are completely cancelled out. P&L sales increase by ₹0.
• In GST: If your branches have different GSTINs (even under the same PAN), GST treats them as "distinct persons." You must issue a tax invoice with full GST.
• The Result: GST turnover is ₹50 Lakhs higher than P&L turnover.

1. Advance Money Received from Customers (Services)

• What Happened: In March, Apex received a ₹10 Lakh advance for an Annual Maintenance Contract (AMC) starting in April.
• In Books: This is unearned income. You record it as an Advance from Customer (a liability) in your Balance Sheet. It does not touch your P&L revenue yet.
• In GST: Under Section 13 of the CGST Act, GST on services must be paid the moment advance money hits your bank account.
• The Result: GST shows ₹10 Lakhs of turnover in the current year; your P&L will show it only in the next financial year.

1. Freight and Transportation Recoveries

• What Happened: Apex paid ₹5 Lakhs to a transporter and charged the exact same ₹5 Lakhs back to the buyer on the sales invoice.
• In Books: The accountant credited this ₹5 Lakhs directly to the "Freight Outward Expense" account to cancel out the transport cost. It was not added to gross sales.
• In GST: GST was charged on the entire invoice value, including freight.
• The Result: GST shows ₹5 Lakhs more turnover than the net sales in the P&L.

1. Duplicate Data Entry in AIS

• What Happened: Apex sold ₹25 Lakhs worth of metal scrap. The buyer deducted TCS under Section 206C.
• In AIS: The Income Tax portal received the GSTR-1 data push from the GST department. Simultaneously, it received the TCS return filed by the buyer and the high-value banking credit alert (SFT). The AIS portal counted this transaction twice.
• The Result: AIS shows ₹25 Lakhs of phantom turnover that does not exist in any bank account.

The Master Cheat Sheet: How to Reconcile the Numbers

When an officer asks why your figures do not match, never write long, confusing letters. Give them a clean mathematical statement like this:

Notice that the bottom line shows zero unexplained difference. When an assessing officer sees this sheet backed by documents, the scrutiny notice is dropped immediately.

4 Practical Rules Every Practitioner Should Follow

To keep your clients safe from automated notices, make these four habits part of your regular office routine:

1. Check GSTR-1 vs. GSTR-3B Every Month: Before filing, ensure your taxable turnover in GSTR-1 matches table 3.1 of GSTR-3B down to the last rupee. If these two do not match internally, your base data will be corrupt when it reaches the Income Tax portal.
2. Never Post Asset Sales Directly to Sales: Train your accounting staff to create a dedicated clearing account for any sale of scrap, old computers, or vehicles. Every asset sale must have both a GST invoice and an asset register entry.
3. Download AIS Every Quarter (Don't Wait for Year-End): Open your client's AIS quarterly. If you spot duplicate entries, wrong PAN credits, or incorrect figures, submit portal feedback right away. Select: "Information is duplicate" or "Relates to other PAN."
4. Prepare the Reconciliation Sheet While Finalizing the Audit: Do not wait for a notice to arrive two years later. Draft this reconciliation table on the day you finalize the tax audit report and keep it in your permanent audit file.

A Final Word for Practitioners

In automated tax compliance, the department's computers do not know accounting standards—they only compare numbers in fields.

When those numbers do not match, the computer assumes income was hidden.

As a professional, your value is not in making these numbers identical; they can never be identical by law. Your value lies in building the bridge, keeping the evidence ready, and giving your client complete peace of mind.