Income and work

A client paid by UPI with no invoice reference: how to match it

A client paid by UPI with no invoice reference: match the credit using amount, date, payer name and chat history, then ask for the invoice number next time.

Editorial illustration for A client paid by UPI with no invoice reference: how to match it

To match a UPI payment that has no invoice reference, compare the credit's amount and date against your open invoices, check whether the payer name matches the client or someone who works there, and confirm with a short message to the client. Then record the match and ask them to put the invoice number in the payment note next time.

How do I match a credit to an invoice?

  1. Note the credit's date, amount and the payer name or ID shown on your statement. How much detail appears depends on your bank, so look at your own statement.
  2. List your open invoices and look for an exact amount match.
  3. If there is no exact match, look for a combination of invoices that add up to the amount, or an amount minus a likely deduction or charge.
  4. Look at your chat or email history around that date. A message such as sent just now often settles it.
  5. If two invoices could fit, ask the client which one it is for.

What if the amount equals two invoices added together?

Hypothetical: a credit of ₹26,500 arrives on the 14th. Open invoices are INV-40 for ₹17,000 and INV-41 for ₹9,500. 17,000 plus 9,500 is ₹26,500, so the client probably paid both together. Write both matches down and confirm with a message before closing either one.

What if two invoices have the same amount?

Hypothetical: a credit of ₹18,000 arrives from a person named R Menon. You have INV-31 for ₹18,000 to Menon Interiors and INV-33 for ₹18,000 to Kiran Foods. The name points to INV-31, but names can mislead, since people pay from personal accounts or on behalf of colleagues. Check the chat history, and if you are still unsure, send a short note: received ₹18,000 on the 14th from this account, please confirm which invoice it covers.

What you seeLikely meaningWhat to do
Exact amount match, name matchesProbably that invoiceRecord it and confirm in a line if the amount is large
Exact amount, two open invoicesCould be eitherAsk the client
Sum of two invoicesCombined paymentMatch both and note it
Slightly less than an invoiceDeduction or chargeAsk for the payment advice
No match at allAdvance, wrong account or another clientAsk before you assume

How do I record the match in the tracker?

Add three columns to your invoice list: matched credit date, matched amount and confirmed with client (yes or no). A credit without an invoice stays on a separate unmatched list until it is cleared. If you bring statements into SpendixAI, the credit shows with its date and amount, which makes the list of unmatched credits short enough to work through each week.

A wrong match also hurts the other way. If you mark INV-31 as paid when the money was for INV-33, you may chase Kiran Foods for a payment they already made. One line of confirmation is cheaper than an awkward apology.

How do I stop this happening again?

  • Put the invoice number on every invoice in large type, near the amount.
  • Ask clients to write the invoice number in the UPI payment note. Whether the note shows up on your statement depends on your bank, so check what you receive.
  • Include a line in your payment instructions: please add the invoice number as the payment reference.
  • Where possible, ask for a short payment confirmation by email or chat, with the invoice number and the amount.

Checklist for an unknown credit

  1. Write down date, amount and payer name.
  2. Look for exact and combined matches.
  3. Read the chat around the date.
  4. Confirm with the client for larger or unclear amounts.
  5. Record the match and ask for the invoice number next time.
SPENDIXAI JOURNAL

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

Explore your reports