Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →
A consulting company with 80 active clients processes 400+ invoices per month. Approximately 35% of payments are partial — clients paying instalments, withheld amounts pending deliverable approval, or TDS-net payments where the tax deduction makes the payment look partial.
Manual allocation of these partial payments takes 8–10 days per month. And despite the time investment, the AR ledger still shows unexplained outstanding balances on invoices that the team believes are fully settled.
Why Partial Payment Allocation Fails in Indian AR Teams
The most common failure is the TDS ambiguity: a client pays ₹81,000 against a ₹90,000 outstanding balance (after applying a credit note). Is this a partial payment of ₹81,000, or a full payment of ₹90,000 with 10% TDS deducted?
The correct interpretation depends on whether TDS applies to this client, at what rate, and whether the client has indicated on the remittance advice that TDS was deducted. Without a structured allocation logic, the finance team makes a judgment call — and sometimes makes it wrong.
The Three Types of Partial Payment Situations
| Situation | Example | Correct treatment |
|---|---|---|
| True partial — instalment | Client pays ₹50,000 of ₹1,00,000 invoice | Close ₹50,000, leave ₹50,000 open |
| TDS-net — looks partial | Client pays ₹90,000 of ₹1,00,000 (10% TDS) | Close invoice, create ₹10,000 TDS receivable |
| Dispute-withheld | Client pays ₹90,000, withholds ₹10,000 pending dispute | Create ₹10,000 disputed balance, escalate |
| Multi-invoice payment | Client pays ₹2,50,000 across 3 invoices | Allocate using remittance advice |
Identifying which type each payment represents is the core of partial payment reconciliation.
Allocation Priority Rules
When a client payment does not match a single invoice exactly, the allocation engine applies priority rules to determine which invoices the payment applies to:
Rule 1 — Remittance advice match: If the client provides a remittance advice listing invoice numbers, apply the payment exactly as directed.
Rule 2 — FIFO (First In, First Out): In the absence of a remittance advice, apply the payment to the oldest outstanding invoice first. This is the standard accounting practice and is consistent with the ICAI guidance on debtors management.
Rule 3 — Proportional allocation: If the payment amount is a round percentage of the total outstanding (for example, exactly 50%), allocate proportionally across all open invoices.
Rule 4 — Largest invoice first: Some companies prefer to close the largest invoice first to reduce the number of open items. This is a valid alternative to FIFO — but it must be consistently applied.
TDS on Partial Payments: Step-by-Step
When a client makes a partial payment and deducts TDS, the allocation requires two calculations:
Step 1 — Gross the bank credit up to find the invoice amount being settled:
- Bank credit: ₹72,000
- TDS rate: 10%
- Grossed-up amount: ₹72,000 ÷ 0.9 = ₹80,000
Step 2 — Allocate the grossed-up amount to invoices:
- Apply ₹80,000 against the oldest outstanding invoice (FIFO)
- If ₹80,000 > invoice amount, close the invoice and carry the surplus to the next
Step 3 — Create TDS receivable:
- TDS receivable = ₹80,000 × 10% = ₹8,000
- Link to client TAN for Form 26AS matching
Step 4 — Verify against Form 26AS:
- When Form 26AS is updated, confirm ₹8,000 appears against the correct deductor TAN and section code
Open Balance Management
Partial payments create open balances — amounts remaining on invoices after a payment. Open balance management requires:
- Age classification: How long has the balance been outstanding? 0–30, 31–60, 61–90, 90+ days.
- Status classification: Is the balance genuinely outstanding, or is it pending TDS recovery from Form 26AS? The two require different actions.
- Dispute flagging: Balances that have been withheld by the client due to a dispute should be flagged separately from unpaid balances.
An AR ageing report that does not distinguish between “outstanding — normal collection” and “outstanding — awaiting TDS in Form 26AS” overstates the collection risk and produces incorrect bad debt provision calculations.
Partial Payment Reconciliation and GST Credit Notes
When a credit note is issued after a partial payment has been applied, the GST adjustment must track the credit note against the correct invoice — not against any invoice with the same client.
Example: Invoice ₹1,18,000 (₹1,00,000 + ₹18,000 GST). Client pays ₹59,000 (50% instalment). Credit note issued for ₹11,800 (₹10,000 + ₹1,800 GST) for returned goods. The net outstanding is now ₹47,200 (₹1,18,000 − ₹59,000 − ₹11,800). The GST credit note must be matched against the original invoice’s GST liability — not applied as a general credit.
Reconciliation software India that supports multi-invoice partial payment allocation — with configurable FIFO, proportional, or remittance-directed allocation rules — eliminates the manual judgment calls that create AR ledger errors.
TDS reconciliation software that automatically grosses up net-of-TDS partial payments and creates TDS receivable entries removes the most common cause of misclassification: treating a TDS-net full payment as an outstanding partial payment.
The Institute of Chartered Accountants of India publishes guidance on accounts receivable management and payment allocation as part of its standards for finance function management.