Accounts receivable
-
5
 min read

International Debt Collection Timeline Worksheet

An overdue foreign invoice earns a place in your cash forecast when you have evidence for both the amount and the payment date. A promise to pay can support a conditional entry. A court deadline or enforcement action gives you a date to follow up. Use this worksheet to track both, with a worked example for Germany and France.

By Lars Holdgaard, Founder & CEO of Debitura

International Debt Collection Timeline Worksheet

Copy the cross-border collection worksheet

Copy the table into your forecast notes. Use one copy per invoice and a separate receipt entry for each instalment. Give each date an owner and link it to the evidence in your case file.

Collection and cash forecast worksheet
FieldYour entry
Invoice[Debtor, country, invoice ID, due date, currency, outstanding balance, amount disputed]
Current stage[Pre-legal, payment order, contested proceedings or enforcement. Record the forum and asset location where known.]
Evidence[Source and date, such as a signed plan, proof of service, court notice, enforcement update or bank entry]
Next action[Action, owner, due or review date, and the event that would change the plan]
Expected cash[Conditional date or open, gross receipt, agreed deductions and expected net receipt]
Actual cash[Date cleared, net received and bank reference]
Costs[Approved amount, due date and whether payable if recovery is zero]
Limitation[Applicable law, trigger, confirmed cutoff, preservation action and owner]

Worked example for Germany and France

A Dutch exporter reviews two overdue invoices on 18 November. All dates and amounts in this example are fictional.

Germany · €12,000 undisputed

  • Source and trigger. A signed plan schedules two €6,000 instalments for 4 and 18 December.
  • Owner and next action. Credit control checks the bank on 4 December. If the first payment is missed, credit control follows up and revisits the second instalment before the next forecast update.
  • Cash treatment. Record two conditional net receipts of €6,000, assuming zero deductions. The downside forecast includes €0 from this invoice until payment evidence improves. Reconcile each instalment against cleared funds.

France · €18,000 disputed over delivery

  • Source and trigger. The debtor’s email disputes delivery. The contract, delivery records and correspondence form the review file.
  • Owner and next action. Finance sends the file on 20 November. Local counsel is due to report on 27 November on the proper forum, likely route, limitation cutoff and estimated costs.
  • Cash treatment. Leave the receipt date open and exclude the €18,000 from dated inflows until there is evidence for amount and timing. Record a review cost as a separate outflow once approved and due.

In the conditional December scenario, the German invoice contributes up to €12,000 before any new information. In the downside scenario, the two invoices contribute €0 in dated receipts. Finance assigns a limitation check for each invoice while the collection work continues.

Which event should change the forecast?

  • Pre-legal collection. Confirm the debtor’s identity and address, the claim documents and any reason given for non-payment. Use a written, credible payment plan to date conditional receipts. If the debtor stays silent, date the next follow-up and keep cash open.
  • Payment order. Track filing, issue, proof of service, the response deadline and the next step toward enforceability. Put procedural dates in the action calendar and revisit cash when the case file supports a receipt.
  • Contested proceedings. Record the amount disputed and the next evidence, cost or hearing milestone. Track any separately agreed payment only when its amount and timing are supported.
  • Enforcement. Confirm the enforceable title and asset location. Ask what the enforcement agent can do locally and, if funds are recovered, when and how much can be remitted. For a covered judgment enforceable in one EU Member State and taken to another, the enforcing state’s law governs the enforcement procedure. Brussels I Recast, Articles 39 to 43

Official court data for Germany and France

These figures describe first-instance litigious civil and commercial cases in 2024. The European Commission’s 2026 EU Justice Scoreboard reports disposition time, calculated as year-end unresolved cases divided by cases resolved during the year, multiplied by 365.

2024 first-instance disposition time, rounded to days
CountryDisposition time
Germany232 days
France434 days

Use these court-wide ratios as context when asking for a case-specific estimate. Both series cover a broad mix of disputes and exclude uncontested payment orders. For a receipt forecast, use evidence from the individual case, including any enforcement and remittance steps. European Commission, 2026 EU Justice Scoreboard, Figure 5 and CEPEJ data in the Commission workbook (ZIP).

Payment-order dates to confirm with local counsel

Germany’s national payment order

A German Mahnbescheid gives the debtor two weeks from service to pay or object. After that period, if the debt remains unpaid and no opposition prevents it, the creditor can apply for the Vollstreckungsbescheid. The debtor can still object to the first order until the enforcement order is issued. The enforcement order is provisionally enforceable and has a separate objection period, generally two weeks from domestic service. Record proof of service and ask counsel to confirm which step is next. German Code of Civil Procedure, §§ 692, 694 and 699–700 and § 339.

France’s national payment order

For an injonction de payer made on or after 1 September 2026, the creditor has three months from the order date to serve it. The ordinary opposition period runs for one month from service. If the debtor was served by a method other than personal service, opposition remains admissible for one month after the first act served personally or, failing that, the first enforcement measure that freezes all or part of the debtor’s assets. Enforceability requires two months from service and the end of the statutory grounds that suspend enforcement. Have counsel confirm service, opposition and enforceability before instructing enforcement. French Code of Civil Procedure, Articles 1411, 1416 and 1422, and Decree 2026-96, Article 9. See the French government payment-order reform guidance and the Court of Cassation’s reading of Article 1416.

European Payment Order

This route is designed for qualifying uncontested cross-border civil or commercial claims for a specific sum already due. At filing, at least one party must be domiciled or habitually resident in a participating EU Member State other than the one where the application is filed. Denmark does not participate. The court normally issues the order within 30 days of filing if the requirements are met, excluding time the applicant takes to complete, correct or modify the application. The debtor then has 30 days from service to send an opposition. If there is no timely opposition, the court declares the order enforceable after allowing time for a statement to arrive. Track filing, service and enforceability as separate events. European Payment Order Regulation, Articles 1 to 6, 12, 16, 18 and 21 and European Payment Order guide.

Confirm the deadline to preserve the claim

Ask counsel to confirm the governing law, the event that starts the limitation clock, the deadline and the action needed to preserve the claim. Where Rome I applies, the law governing the contract also governs limitation. Check how negotiations, acknowledgement or proceedings affect your case before relying on them. Put the confirmed cutoff and its owner on the worksheet, even if you are still pursuing voluntary payment. Rome I, Article 12(1)(d).

Submit an overdue business invoice

Have the invoice, contract, delivery evidence and dispute correspondence ready. Debitura matches eligible claims with vetted local collection agencies or law firms, subject to partner acceptance. Submit an overdue business invoice.

For collection options and local requirements, see the international debt collection guide and the country guides for Germany and France.

Subscription

Sign up to our newsletter

Get updated on best practices, tips and tricks about international debt collection and accounts receivable management.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.