Accounting Discrepancies Explained: Types, Causes, Fixes

Introduction

"Discrepancy" is one of the most searched and least explained words in bookkeeping. Accountants use it constantly, usually to mean a difference that needs explaining. Business owners meet it as an unexplained red number on a reconciliation, a variance flagged by an auditor, or a till that is ₹200 short at closing time.

This guide defines the term precisely, separates the different kinds of discrepancy you will meet (reconciliation, cash, balance, document and intercompany), shows worked examples with the journal entries, explains where discrepancies come from, and sets out a repeatable method for resolving them. It ends with controls to reduce how often they occur.

Note: This is educational information. Correcting entries, materiality thresholds and any suspicion of fraud should be handled with your accountant or auditor.

Table of Contents

1. What Is a Discrepancy in Accounting?
2. Discrepancy, Error, Variance and Fraud Are Not Synonyms
3. The Main Types of Discrepancy
4. Reconciliation Discrepancies
5. Cash Discrepancies: Over and Short
6. Balance Discrepancies
7. Document Discrepancies: The Three-Way Match
8. Intercompany and Tax Discrepancies
9. Inventory Discrepancies: Book Versus Physical
10. Payroll and Statutory Discrepancies
11. E-Commerce and Payment Gateway Discrepancies
12. A Simple Discrepancy Log Template
13. Warning Signs That a Discrepancy May Be Something Worse
14. Where Discrepancies Come From
15. A Seven-Step Method to Resolve Any Discrepancy
16. Correcting Entries and Documentation
17. Materiality: When Is a Difference Worth Chasing?
18. Controls That Prevent Discrepancies
19. FAQ
20. Conclusion

What Is a Discrepancy in Accounting?

A discrepancy in accounting is a difference between two records, amounts or documents that should agree. The two things being compared can be:

• The bank statement and the ledger cash balance.
• A supplier's statement and your accounts payable balance.
• A customer's statement and your accounts receivable balance.
• The cash counted in a drawer and the cash the sales records say should be there.
• A purchase order, a goods receipt and a supplier invoice.
• Two group companies' records of the same intercompany balance.
• Your purchase ledger and the tax authority's record of the supplier invoices you can claim credit for.

The key idea is expectation. If two records are supposed to tell the same story and they do not, you have a discrepancy. The size is the difference; the cause is what you must find.

Discrepancy, Error, Variance and Fraud Are Not Synonyms

People use these terms loosely, which causes confusion in conversations with auditors.

A discrepancy can arise from any of the last four. That is why it should never be "plugged" with an unexplained adjustment: you would be burying the evidence of what went wrong.

The Main Types of Discrepancy

Reconciliation Discrepancies

Reconciliation discrepancies are the unexplained differences left after you compare two sets of records and account for ordinary reconciling items. The classic case is the bank reconciliation.

Normal reconciling items are not discrepancies once identified:

• Deposits in transit: recorded in your books, not yet credited by the bank.
• Outstanding payments: cheques or transfers recorded, not yet cleared.
• Bank charges and interest shown on the statement, not yet booked.
• Returned cheques (dishonoured), not yet reversed.

A true reconciliation discrepancy is what remains. Suppose the adjusted bank balance is ₹5,15,000 but the adjusted book balance is ₹5,12,300. The unexplained ₹2,700 is a discrepancy. To find it, use the pattern clues covered in our step-by-step guide to bank reconciliation in Zoho Books: a difference divisible by 9 suggests transposed digits (for example, 5,400 keyed as 4,500); a difference equal to twice an amount suggests a deposit entered as a payment or vice versa. For the underlying concept, see what a bank reconciliation is and our reconciliation best practices.

Cash Discrepancies: Over and Short

A cash discrepancy is the gap between the cash that should be on hand according to records and the cash counted.

• Cash short: counted cash is less than expected.
• Cash over: counted cash is more than expected.

Worked example (retail till). Sales records show cash sales of ₹12,500 for the day. The opening float was ₹5,000 and stays in the till. The cashier counts ₹17,480 in the till at close. Expected cash = ₹5,000 + ₹12,500 = ₹17,500. Counted cash less float = ₹12,480.

• Expected cash sales: ₹12,500
• Cash actually banked: ₹12,480
• Shortage: ₹20

Typical entry, recording the deposit and the shortage:

If the till had been over by ₹20, the Cash Over and Short account would be credited instead. This account is a summary of small differences; over a period its balance should hover near zero. A persistent debit balance suggests recurring shortages (process or theft); a persistent credit balance suggests under-ringing of sales or careless change-giving.

Petty cash works the same way under an imprest system: a fixed float is topped up to its original amount against vouchers. Cash plus vouchers should always equal the float. Any gap is a discrepancy to record and explain.

Balance Discrepancies

A balance discrepancy arises when a balance in one record differs from the balance in another that should match. The two most common versions:

1. Control account versus subsidiary ledger. The accounts receivable control account in the general ledger should equal the sum of individual customer balances. If it does not, someone posted directly to the control account, an invoice was posted twice, or a customer ledger entry was edited after posting.

2. Your ledger versus a third-party statement. A vendor statement shows you owe ₹1,48,000; your payable ledger shows ₹1,40,500. The difference of ₹7,500 is typically one of:

• An invoice you have not recorded.
• A payment you made that the vendor has not applied.
• A credit note you have recorded and they have not (or vice versa).
• A disputed or duplicate invoice.

Request the vendor's transaction-level statement and compare line by line. The same logic applies to customers' statements against your AR aging report.

Presenting a trial balance is the system-wide balance check: total debits must equal total credits. If they do not, you have a posting-level discrepancy that needs tracing. See what a trial balance is.

Document Discrepancies: The Three-Way Match

In accounts payable, the control is the three-way match: compare the purchase order (what you ordered), the goods receipt or delivery note (what arrived) and the supplier invoice (what you are asked to pay). Discrepancies show up as:

• Price: invoice price differs from the PO.
• Quantity: invoice bills more than was received.
• Terms: payment terms differ from the agreement.
• Duplicate: the same invoice number submitted twice.
• Tax: wrong tax rate or tax identifier.

The right response is to hold payment, log the discrepancy, and get a credit note or corrected invoice before posting. Paying first and chasing later is how overpayments and fraud slip through. Our guides on accounts payable best practices and vendor fraud prevention go deeper.

Intercompany and Tax Discrepancies

Intercompany. In group accounts, one company's receivable from another should equal the other's payable. Typical gaps come from timing (invoice recorded in different months), currency (each side translates at a different rate), unrecorded charges (management fees booked by one side only) and disputes.

Worked example. Company A shows a receivable from Company B of ₹10,00,000. Company B shows a payable to A of ₹9,85,000. The ₹15,000 difference: a service charge A invoiced on the 30th and B recorded on the 2nd of next month. This is timing; B should accrue the charge in the earlier period so that both records agree at the reporting date.

Indirect tax credits. For GST or VAT, the credit you claim should agree with supplier-reported data. In India, for example, businesses compare their purchase register with the tax portal's auto-generated statement of supplier invoices (GSTR-2B). Differences arise when suppliers file late, report the wrong GSTIN, or amend invoices. Persistent mismatches affect cash because unclaimed credit is money tied up. See our article on common GST mistakes for Indian startups.

Inventory Discrepancies: Book Versus Physical

Inventory is the classic balance discrepancy for product businesses. The perpetual records say one quantity; a physical count says another.

Worked example. Book quantity of a product: 1,200 units at a cost of ₹250 each (book value ₹3,00,000). Physical count: 1,176 units.

• Shortage: 24 units
• Value of shortage: 24 × ₹250 = ₹6,000
• Shrinkage rate: 24 / 1,200 = 2.0%

Entry to write inventory down to the counted quantity:

Before posting, check the usual causes: receipts not yet recorded, sales shipped but not invoiced, returns not restocked, transfers between locations, damaged goods not written off, and count errors. Only the unexplained remainder is shrinkage. Track the rate over time and by location. Our guide to Zoho Inventory for e-commerce shows how stock adjustments are handled in software.

Payroll and Statutory Discrepancies

Payroll creates three checkpoints that should agree every month:

1. Payroll register (gross, deductions, net pay) against bank payments to employees.
2. Deductions withheld (income tax, provident fund, insurance and similar) against the amounts remitted to the authorities.
3. Employer contributions accrued against what was paid.

Any gap means a payment was missed, a deduction was miscalculated, or a mid-month joiner or leaver was handled inconsistently. Statutory liabilities left unreconciled accumulate penalties and interest, so these checks deserve a fixed place in the month-end routine.

E-Commerce and Payment Gateway Discrepancies

Online sellers see discrepancies between orders, settlements and bank credits. Typical reasons: gateway fees deducted before settlement, refunds and chargebacks netted from later payouts, cash-on-delivery remittances arriving in batches, and returns-to-origin that reverse a sale after revenue was booked. A three-way view helps: orders (what customers bought), settlements (what the gateway or courier reports as paid) and bank credits (what arrived). Differences between the first two are usually fee and return effects; differences between the last two are timing. See our guide to RTO and COD reconciliation for D2C brands.

A Simple Discrepancy Log Template

Keep one log for the business and review it monthly.

After three months, sort by root cause. The top two causes tell you where to put your next control.

Warning Signs That a Discrepancy May Be Something Worse

Most discrepancies are innocent. These patterns deserve independent review:

• The same person records transactions, handles the cash and reconciles the account.
• Round-number adjustments posted repeatedly to plug differences.
• Backdated entries or edits to closed periods.
• Missing documents for payments, or invoices from vendors you cannot verify.
• Vendors with the same address or bank account as an employee.
• Cash shortages that cluster on one person's shifts.
• Reluctance to take leave or to let others see records.
• Differences that always fall in one direction.

If you see these, preserve the records, limit access, and involve your accountant or an independent reviewer before confronting anyone. See vendor fraud prevention for payables-specific checks.

Where Discrepancies Come From

Almost every discrepancy traces back to one of ten root causes.

1. Timing: items recorded in different periods by each party.
2. Data-entry errors: wrong amount, date, account or tax code.
3. Transposition and slip errors: digits swapped or dropped.
4. Duplicates: the same transaction posted twice (often from importing the same statement or entering a bill and a bank line).
5. Omissions: unrecorded charges, receipts or credit notes.
6. Direction errors: a receipt entered as a payment, or the reverse.
7. Cut-off errors: transactions in the wrong accounting period.
8. System or integration issues: sync failures, bank feed gaps, currency rounding.
9. Unauthorised or backdated edits after a period closes.
10. Fraud or misappropriation: rare, but the reason investigations must be thorough.

A Seven-Step Method to Resolve Any Discrepancy

1. Define the two records and the period. Be exact: "bank statement for 1-30 September versus ledger account 1010."
2. Quantify the difference and note its direction (which side is higher).
3. Remove timing items. List deposits in transit, outstanding payments and cut-off differences, and confirm they clear after period end.
4. Test for pattern errors. Is the difference an exact transaction amount, double an amount, divisible by 9, or a round number?
5. Trace the largest items to source documents: invoices, receipts, statements, delivery notes.
6. Look for omissions and duplicates with a transaction-by-transaction comparison. Sorting both lists by amount and date makes gaps visible.
7. Correct and document. Post the correcting entry with a reference and explanation, obtain approval for anything above your threshold, and record the root cause.

If after reasonable effort the remainder is small and below your materiality threshold, many businesses post it to a clearly labelled "reconciliation differences" account with an approval note. Do that sparingly and review the balance monthly. If it grows, it is hiding something.

Correcting Entries and Documentation

Principle: do not delete or silently edit posted transactions in a closed period. Correct with a transparent adjusting entry.

Example: transposed amount. A supplier bill of ₹5,400 was posted as ₹4,500 to office supplies, and paid ₹5,400 from the bank. The vendor payable is understated by ₹900.

Narration: "Correct bill 1042 posted at 4,500 instead of 5,400."

Example: unrecorded bank charges.

Every correcting entry should carry: the date, the accounts, the amount, a plain-language reason, the supporting document and the approver. Our guide to the journal entry covers the mechanics. Keep a discrepancy log with date found, accounts involved, amount, cause, resolution and owner. Patterns in the log tell you which controls to strengthen.

Materiality: When Is a Difference Worth Chasing?

Materiality is the idea that small differences do not change decisions. There is no universal figure; it depends on the size of the business and the account. A practical approach for internal reconciliations:

• Set a de minimis threshold for differences that need no investigation (for example, below a rounding amount that you document).
• Set an investigation threshold above which you trace to source.
• Set an escalation threshold above which the owner or accountant must approve.
• Aggregate small items. Many small differences in one direction add up.

Apply stricter thresholds to cash and to anything touching related parties, where even small amounts matter for control. Auditors set their own materiality for financial statements; do not assume yours is the same.

Controls That Prevent Discrepancies

• Separate duties: the person who records cash should not be the only one who reconciles it.
• Regular reconciliation: monthly for the bank; weekly for high-volume accounts; daily cash counts at tills.
• Close the period: lock posted periods and require approval to reopen. See our month-end bookkeeping checklist.
• Three-way matching before paying invoices.
• Use bank feeds and rules to reduce manual entry, and review rule-created entries.
• Sequential numbering for invoices, receipts and vouchers, with gaps investigated.
• Imprest petty cash with vouchers and surprise counts.
• Vendor and customer statement reconciliations at least quarterly.
• A discrepancy log reviewed monthly by someone independent.

Our broader guide to internal controls and fraud prevention for small businesses shows how these fit together.

FAQ

Conclusion

A discrepancy is simply a question your records are asking you: "why do these two things disagree?" The disciplined answer follows the same path every time. Define the records, quantify the gap, strip out timing items, test for the common error patterns, trace what remains to documents, correct with a transparent entry and log the cause. The businesses that do this consistently see fewer discrepancies over time because the log shows them which control to fix: a missing review step, an unreliable import, an undefined cut-off.

If your books are carrying unexplained differences, or you would like a second pair of eyes on a reconciliation that will not close, get in touch for a free consultation. Our bookkeeping services include monthly reconciliations with documented review.

Sources

• Zoho Books Help: Reconcile an account