For a client you bill the same way every month, use one template, number the invoices in sequence, and add a tick-box row that you complete when the bank credit arrives. Matching each tick to an actual credit in your bank statement stops months from drifting, where one invoice is quietly never paid.
What goes in the recurring template?
- Client name and billing details, fixed.
- Description of the retainer: for example, social media management for the month.
- Amount, fixed unless the contract says otherwise.
- The month it covers, written in words, so two invoices are never confused.
- Due date, following the payment term you agreed.
- Your invoice number, taken from the running series.
How do you track what has been paid?
Make a simple grid. Rows are clients, columns are months in the financial year April to March. In each cell write the invoice number and, when the money arrives, the date and a tick. A blank cell means no invoice went out, an invoice number without a tick means you are waiting. Colour the waiting cells yellow, so they stand out.
A worked example: a social media freelancer with three retainers
Say a freelancer bills three clients each month: ₹25,000, ₹18,000 and ₹12,000. Those add up to ₹55,000 a month. These are made up figures.
| Month billed | Client A, ₹25,000 | Client B, ₹18,000 | Client C, ₹12,000 |
|---|---|---|---|
| April | Paid 8 May | Paid 12 May | Paid 5 May |
| May | Paid 7 June | Paid 15 July, with June | Paid 10 June |
| June | Paid 6 July | Paid 15 July, with May | Paid 9 July |
The May invoice for Client B stayed unpaid until the client sent one credit of ₹36,000 on 15 July covering May and June, which is 18,000 plus 18,000. Without the grid, that single credit could look like a mismatch. With the grid, both months are ticked on the same bank line, and a note says so.
What if the credit is less than the invoice?
Sometimes a client pays slightly less, because of a deduction, a bank charge or a rounding. Record the actual credit, put the difference on a separate line with a note, and ask the client, or your CA if a deduction at source is involved, what it relates to. Do not tick an invoice fully paid when the bank shows less.
How do you match credits to invoices?
- Open the bank statement for the month and mark every credit from a client.
- Write the credit date and amount in the grid cell for the invoice it settles.
- Where one credit covers two invoices, note both numbers on the same credit.
- List unmatched credits separately and find out whom they belong to.
If you import statements into SpendixAI, credits and debits appear together under the account you chose, which makes the matching easier to review, but the invoice tracking itself lives in your sheet.
What if a client pauses or leaves?
Write the last billed month in the grid and mark the following cells as closed, with the date and reason. If a final month is part-worked, bill it as agreed and note the basis. Keep the grid row; a finished client still needs a clean history, particularly if the last invoice remains unpaid.
What if a retainer changes?
When rates or scope change, start the new rate from a named month, and keep the signed message or revised contract with the grid. Do not edit past invoices. Issue a fresh template with the new amount and a note of the effective month.
Monthly routine
- Issue all retainer invoices on the same day each month.
- Update the grid when each credit arrives.
- Chase anything past its due date.
- File invoices and proofs in client folders.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


