Month-end exception worksheet for collection agencies
Check late receipts, disagreements between case and bank records, and unresolved platform invoices with an agency exception register.
By Lars Holdgaard, Founder & CEO of Debitura

At month-end, compare the case record with the underlying payment and invoice evidence. Work from one exception queue with a named owner. Keep debtor receipts, money due to a creditor and charges to the agency in separate fields.
Worked example
The fictional euro balances below belong to three different cases. The agency uses 31 October as its own reporting snapshot. Verify the currency, recipient, bank value date, case recording date and invoice reference on each item.
| Exception | Evidence to match | Amount and conclusion | Owner and next action |
|---|---|---|---|
| AG-031 · late-recorded receipt | Bank value date 31 October, case entry 2 November, transfer reference TR-305 matches the debtor remittance. | €900 matched. Record the two dates and send the timing difference to the period-close owner. | Payment operations sends the bank trace and case record to finance. Finance confirms how its reporting period treats the item. |
| AG-042 · creditor receipt mismatch | Creditor’s bank evidence shows €1,200 paid directly. Case payment record shows €1,000. | €200 difference is open. Keep the creditor’s receipt and the current case record side by side. | Case owner verifies allocation and recipient with the creditor and routes any supported correction through the appropriate workflow. |
| AG-053 · platform invoice query | Partner Balance lists INV-P53 at €180. The internal approved amounts tied to the line total €150. | €30 remains under review. The debtor receipt and creditor payout lines are separately matched. | Agency finance checks the invoice, eligible items and agreed terms, then routes the €30 evidence to the billing owner. Keep the exception open until reconciled. |
Close an exception when the evidence agrees
Compare the same reporting cut, currency and reference. One late date can explain an apparent mismatch. Keep an unresolved amount visible with a next review date rather than forcing balances to agree.
Keep a record of who received the money
Debitura’s guidance describes different workflows when the debtor pays the agency or the creditor. Use the recipient shown by your evidence and check the current source workflow before changing a case record.
Copy the worksheet
| Exception ID | Case ID | Currency | Recipient | Bank date and reference | Platform record date and ID | Invoice or payout reference | Amount in ledger | Amount in source | Difference | Owner | Next action | Review date | Disposition |
|---|
If your agency is preparing to receive international cases, Explore the collection partner network.
References
Partner Balance fields · Partner billing and reconciliation · Debtor payment flows
-min.webp)
Sign up to our newsletter
Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

.webp)