How to track invoice returns for prepayments? What to watch when payment is made but the invoice has not arrived
There is only one key action:Establish a pending invoice receipt record at the moment of payment., rather than waiting until month-end reconciliation to discover that invoices have not arrived. The ledger should include an expected invoice return date, and overdue items should automatically remind the specific person—without these two things, invoice return tracking is just a slogan.
What fields should the pending invoice ledger have?
| Field | Function |
|---|---|
| Supplier | Determine whom to remind |
| Payment order number | Linked to the original payment request |
| Payment amount | Total amount of invoices to be received |
| Payment date | Starting point for calculating aging |
| Expected invoice return date | Basis for judging overdue |
| Amount of invoices received | Cumulative total of invoices received in installments |
| Balance of invoices not yet returned | Amounts that truly need to be chased |
| Handler | Person responsible for collection |
Here, two fields are most easily omitted:Expected invoice return date and Handler. Without the former, you cannot determine overdue status; without the latter, you do not know whom to contact—and in the end, finance alone is left chasing all suppliers.
How to write off invoices received in installments
Prepayments are rarely invoiced all at once. If rent is prepaid for one year, invoices may be issued quarterly; for project prepayments, invoices are often issued in installments according to progress.
Points to note in write-off logic:Invoices must be able to be associated with a specific payment document, rather than only being attached under the supplier's name。The same supplier may have multiple prepayments; if they are not distinguished, which one an invoice offsets becomes a muddled account.
How to set up overdue warnings
Three things must be clearly defined: how many days overdue counts as overdue, who gets the reminder, and how often to remind.
Common configurations are:15 days after the expected invoice return date, first remind the handler; 30 days, remind the handler and department head; 60 days, enter the finance key focus list. Escalating level by level is more effective than constantly reminding the same person.
The content of the reminder must be specific to the document—"Your payment document FK20260815003, supplier so-and-so, amount 50,000 yuan, expected invoice return date has passed by 20 days." Saying only "you have 3 invoices awaiting return" will not prompt the recipient to take any action.
Leave information at the payment approval stage
In many companies, invoice collection cannot be tracked because the expected invoice collection date is not recorded at the payment approval stage. The payment application form should have this required field, filled in by the handler, as the basis for subsequent tracking.
The cost of this step is almost zero—just filling in one more date during approval—but it determines whether all subsequent tracking work can be automated.If information is not captured at the source, later it can only rely on people's memory。
Relationship with aging analysis
Invoice return tracking addresses "whether a single transaction should be chased," while aging analysis addresses "how serious the overall situation is." The two use the same source data but serve different purposes: the former is for daily use by handlers and finance, while the latter is for management to see trends and risks.
If only aging analysis is done without single-item tracking, an awkward situation will arise—the report shows 800,000 yuan of invoices not returned for more than a year, but no one knows exactly which documents they are or whom to contact.
How is this scenario handled in Kailing Technology's expense control system?
When applying for payment, the expected invoice return date and handler are required, and a pending invoice return record is automatically generated after payment is completed. Invoices are linked to specific payment orders, supporting partial write-off for invoice returns in installments, with the uninvoiced balance updated in real time. Overdue reminders are escalated at 15 days, 30 days, and 60 days to the handler, department head, and finance, with reminder content specific to the document and amount.
Learn about the Kailing Technology expense control and reimbursement system →
Common Questions
Start from payment approval. The expected invoice return date and handler must be filled in on the payment application form. If information is not left at the source, later it can only rely on people's memory.
Offset the unreceived invoice balance by usage. The key is that invoices must be linked to specific payment orders; multiple prepayments to the same supplier cannot be mixed together.
Escalate level by level: remind the handler at 15 days, add the department head at 30 days, and add to the finance key list at 60 days. Reminding the same person continuously loses effectiveness.
Required. Aging analysis tells you how serious the overall situation is, but only single-item tracking tells you which specific orders are involved and whom to contact.