Open receivables in e-invoicing: data quality and automatic allocation

The focus: data quality and automatic allocation. What matters for creditors is which change directly affects deadlines, interest or evidence obligations, and by when it has to be reflected in their own systems.

The cut-off date matters: the rate applicable during the relevant period of default is the one that counts. Where default runs across a cut-off date, the calculation is split into sections. Open receivables are reconciled with bank transactions monthly so that phantom balances never reach a reminder letter. In practice, reliability pays off faster than pressure.

Practically every company that works with payment terms is affected, from trades businesses through retail and e-commerce to service providers and SaaS vendors. The difference lies less in the sector than in the volume and structure of receivables.

Business-to-business trade partly uses different values than dealings with consumers. Anyone serving both groups should hold two separate rule sets in the system. A well-maintained open items list is the basis for every DSO and ageing analysis. The thread running through it stays the same: data quality and automatic allocation.

For day-to-day operations this mainly means rework on master data and templates. Interest calculation, reminder letters, instalment plans and every report built on open items and days in default are affected.

Anyone handing receivables to a service provider should supply the calculation basis with them. Otherwise reconciliation work arises that slows the whole process. A monthly look at the age structure reveals shifts earlier than any individual case review. Small improvements here work through the entire receivables portfolio.

A sequence with few, clearly timed stages works best. After the due date comes a short reminder, a few days later a formal reminder with a specific date, then the announcement of handover. Each stage is documented before the next begins. A fixed cycle is more effective than a review that only happens when someone asks for it.

Every stage should state the outstanding amount, the invoice number and the new deadline unambiguously. Collective reminders without a breakdown reliably produce queries rather than payments. Positions with no movement for several months belong on a separate review list. The link to the subject of this article is direct: data quality and automatic allocation.

A fixed calendar slot helps: review interest rates and templates twice a year, assess the age structure of open items every quarter. That keeps open receivables manageable rather than reactive.

The information in this article reflects the position at the date of publication. For a specific application, current values and the individual case should be checked. An open items list should show invoice number, due date, remaining balance, dunning level and last contact for every position. That keeps the case understandable for colleagues with no prior knowledge of it.