Open receivables managed in Excel: a reliable structure for small businesses

The first question is always how solid the claim actually is. The focus: A reliable structure for small businesses. Separating the due date, proof of performance and the communication trail quickly shows whether this is a liquidity problem, a clarification problem or a process problem. This care costs minutes and saves days if the matter is ever disputed.

A uniform starting point for every case helps: same checks, same order, same filing. That makes processing predictable and the results comparable. Positions with no movement for several months belong on a separate review list. Standardisation reduces effort here far more than additional checking does.

Before escalating open receivables, the file has to be complete. That includes the contract or order confirmation, the invoice with all mandatory details, proof of delivery or performance and the full correspondence. If one element is missing, the evidential position shifts quickly against the creditor. What is prepared properly at this stage shortens every subsequent step.

In ongoing business relationships, filing by case rather than by customer works better. With several invoices open, it stays clear which document belongs to which amount. An open items list should show invoice number, due date, remaining balance, dunning level and last contact for every position. For the constellation set out here the rule is: A reliable structure for small businesses.

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.

Switching channel helps: what fails by email is often resolved in a few minutes by phone. The result of the call is then confirmed in writing. 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.

The most common mistake is waiting. Reacting only after months costs information, contacts and, in an insolvency, part of the dividend. Equally critical are vague deadlines such as "immediately", missing proof that the invoice was received, and reminders without an itemised breakdown. Settling this point once removes the need to renegotiate it in every individual case later.

The limitation period is often underestimated as well: the standard period is three years and starts at the end of the year in which the claim arose. Overlooking it means losing enforceable claims for no reason. A well-maintained open items list is the basis for every DSO and ageing analysis. For the situation described here, the task is this: A reliable structure for small businesses.

Bringing in a service provider makes sense as soon as a case is only being administered internally rather than actually worked. Fortis Inkasso GmbH & Co. KG can take over at this point, review the documents and run the further contact in a structured way. That keeps the case understandable for colleagues with no prior knowledge of it.

No promise about the outcome is possible, and this article does not replace case-specific legal advice. It does show which steps should sensibly be completed before instructing an agency. A monthly look at the age structure reveals shifts earlier than any individual case review. The effort is one-off; the benefit repeats with every case.