Income and work

Client paid less than the invoice? Finding where the gap went

A client paid less than the invoice? Check deductions at source, bank charges, forex, part payment and adjustments, then record the gap as a pending balance.

Editorial illustration for Client paid less than the invoice? Finding where the gap went

When a client pays less than the invoice, subtract the amount received from the invoice amount, then compare the gap with the usual causes: tax deducted at source, bank or gateway charges, currency conversion, a part payment, or an adjustment the client made. Most gaps are explained by one or two of these. Anything left over is a pending balance to ask about.

What are the usual reasons for a short payment?

CauseHow to recognise itWhat to ask for or check
Deduction at sourceA round amount missing, often matching a percentage of the invoiceThe client's remittance advice and, later, the certificate
Bank or gateway chargeA small odd amount, often the same each timeYour statement entry and the payer's charge details
Foreign exchangeInvoice in another currency, gap differs each timeThe rate used on the day and your bank's credit advice
Part paymentReceived roughly half or an instalmentWhether the client plans to send the rest, and when
Adjustment or disputeClient mentions revisions, a credit or a cancelled itemA written note of what they adjusted and why

How do I find the gap, step by step?

  1. Write down the invoice total and the amount that reached your account.
  2. Subtract to get the gap. Invoice ₹50,000 and received ₹44,950 leaves ₹5,050.
  3. Ask the client for the payment advice or remittance note. It often lists deductions.
  4. Match the gap to the causes. If the advice shows ₹5,000 deducted at source, the remaining ₹50 is probably a bank charge. Check: 5,000 plus 50 is 5,050.
  5. Record each piece separately so the arithmetic closes to zero.

How do I record it in the tracker?

Add columns after the invoice amount: received, deduction at source, charges, and pending balance. In the example the row reads: invoice 50,000, received 44,950, deduction 5,000, charges 50, pending 0 after the deduction is recorded as due against a certificate. The pending balance formula is:

=C2-D2-E2-F2

Here C is the invoice amount, D the amount received, E the deduction and F the charges. If the result is not zero, you have an unexplained gap and a question for the client.

How a deduction at source is treated in your tax records is a matter for your CA. Keep the remittance advice and the certificate, and let your CA tell you how to account for them. Rules and limits change, so confirm the current position with them or the official source.

What if the client simply paid part of the invoice?

Then it is a part payment, not a gap. Record the amount received on its date, keep the invoice open with the remaining balance, and send a reminder for the balance. Ask in writing when the rest will come. Do not close the invoice because most of the money has arrived.

Is the gap my fault?

Sometimes. A mistake on your invoice, such as the wrong amount, a missing line or a different name from the one on the purchase order, can make the client's accounts team pay a different amount. Read the invoice as the accounts team would. Match it to the order, the quote and any revisions.

When to ask for help

  • The gap is large and the client will not explain it.
  • A deduction was made but you cannot tell what it relates to. Ask your CA.
  • The client says the invoice was agreed at a lower amount. Look at what is in writing.
  • The gap repeats every month for the same client.

The credit amount in your statement is the starting point. If you import statements into SpendixAI, the exact credited amount and date are listed, which is helpful when you compare against the invoice.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports