When a client pays two invoices in one transfer, split the single credit in your sheet into one row per invoice, using the remittance note to decide how much goes where, and check that the rows add up to the bank credit. Keep the same bank reference on every row. If there is no note, ask the client before you guess.
What does the problem look like?
Say you are a consultant and you raised two invoices: INV-014 for ₹45,000 and INV-015 for ₹30,000. Your bank statement shows one credit of ₹75,000 on a Tuesday, from the client's company. Your invoice sheet still shows both invoices as unpaid, because you have nothing to tick against a single line. Left alone, you end up chasing a client for money they already paid, which is embarrassing for both sides.
Splitting the credit gives each invoice its own paid date, its own amount and its own proof. It also means your list of outstanding invoices is true on any day, so that when you plan the month's spending you know exactly which money has arrived and which is still pending.
How do I split the credit?
- Copy the bank credit into your payment sheet with its date, amount and bank reference.
- Open the client's remittance note, an email or message that names the invoices paid.
- Add one row per invoice, with the invoice number, the amount applied, and the same bank reference.
- Confirm that the rows add up to the bank credit.
- Mark each invoice paid, with the date the money arrived, not the date you noticed it.
| Payment row | Invoice | Amount applied | Bank reference |
|---|---|---|---|
| Credit of ₹75,000 | INV-014 | ₹45,000 | NEFT ref 7731 |
| Same credit | INV-015 | ₹30,000 | NEFT ref 7731 |
| Check: rows total | Both | ₹75,000 | Equals the bank credit |
What if the amount does not equal the invoices?
Suppose the client sends ₹70,500 against the same two invoices. The remittance note shows a deduction of ₹4,500 on INV-014. Then INV-014 receives ₹40,500 against ₹45,000 and shows ₹4,500 as a short payment that you must understand. It may be a deduction the client made, a disputed item or an error. Your CA can tell you how to record the difference. Until then, write it as 'short paid, awaiting clarity' instead of closing the invoice.
Which spreadsheet formulas help?
In Excel or Google Sheets, keep the payments in columns A to D (date, invoice number, amount applied, bank reference), with the data in rows 2 to 200. Put invoice numbers in column F of your invoice list and invoice totals in column G.
- Paid so far, in H2: =SUMIFS($C$2:$C$200,$B$2:$B$200,F2)
- Balance, in I2: =G2-H2
- Check the split, in a spare cell, for one bank reference: =SUMIFS($C$2:$C$200,$D$2:$D$200,"NEFT ref 7731")
SUMIFS takes the range to add first, then each range and the condition for it. Drag the first two down for every invoice and any non-zero balance becomes your list of follow-ups.
What if there is no remittance note?
Do not assume which invoice was cleared. Ask the client in a short message: 'We received ₹75,000 on Tuesday. Could you confirm which invoices it covers?' Writing 'oldest first' is a common habit, but it is your habit, not the client's decision. Park the credit as Unallocated until you hear back.
Where does SpendixAI fit?
If you import your bank statement into SpendixAI, the client's credit appears as a single row you can review and categorise as client receipts. The split across invoices stays in your invoice sheet, because the app does not do invoicing or invoice matching.
A short closing checklist
- One bank credit, one reference, as many rows as invoices.
- Rows add up to the credit.
- Short payments are written as short payments, not ignored.
- The remittance note is saved with the statement.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

