When the project invoice disappears into the inbox
You know the situation: a partial invoice is due, the client has a retainer, communication runs across multiple email addresses — and suddenly there is an open‑item list with unclear allocations. Reminders are sent twice or mistakenly withheld, partial payments land unclearly in the account. For agencies and IT service providers this means extra effort, delayed cash flows and irritating reconciliations.
Why a structured on‑prem solution helps
A clear, auditable open‑item workflow reduces manual allocation, prevents duplicate reminder runs and makes retainer accounts as well as milestone due dates controllable. Debentra as self‑hosted software provides exactly these building blocks: a central overview of customers, invoices, payments and partial payments on your own infrastructure — with options for automated rules and manual approval.
The two central advantages for agencies
- Automatic allocation of partial payments to milestones: Partial payments are booked specifically to defined milestones instead of ending up as general credits.
- Prevention of duplicate reminders: Reminder runs take payment status, retainer balance and already scheduled dunning into account, so no redundant messages are sent.
Concrete setup: step by step
The following steps describe a pragmatic on‑prem configuration for agencies, IT service providers and consultants who want to use Debentra.
1. Create retainer accounts
- Create a retainer account for each client or contract. This account shows deposits, expenditures and current balance.
- Define booking rules: incoming payments are booked against the retainer first, provided there is an active contract.
- Practical tip: Use a field for contract reference or project ID so automatic allocation rules can work reliably later.
2. Configure split invoices
- Create templates for split invoices: standard portion (e.g. deposit), milestone parts and final invoice.
- Define for each partial invoice the associated milestone due date and any payment terms (e.g. 14 days net).
- Practical tip: For recurring projects create templates with placeholders for milestone number, project name and retainer balance.
3. Milestone due dates and automatic allocation
- Create milestone entries per project (name, amount, due date, priority).
- Activate the rule: partial payments are allocated in the following order – open milestones by due date, specific milestones when payment includes a reference, otherwise retainer consumption.
- Practical tip: Allow a manual rebooking with a comment in case of uncertainties so traceability is maintained.
4. Configure reminder and dunning logic to avoid duplicates
- Define reminder steps (e.g. 7, 21, 35 days) and link them to rules: no reminder if a partial payment is in progress or a retainer settlement is planned.
- Set deduplication rules: emails are scheduled once per invoice/milestone ID; additional channels (e.g. API notification) are marked as subsequent events.
- Practical tip: Mark reminders as "approval required" so accounting briefly reviews before sending – automation without loss of control.
Templates and communication: simple and professional
Good templates reduce inquiries. Pay attention to these points in email and PDF templates:
- Clear subject line: Client/Project – Invoice X (Milestone Y) – Due on DD.MM.YYYY
- Transparent payment information: stated milestone amount, partial payments already made, and current retainer balance.
- Concrete call to action: payment deadlines, accepted payment methods and reference for the transfer.
- Attachment: an allocation table as PDF (Milestone | Amount | Due Date | Status) helps the recipient allocate payments correctly.
Reporting: Which analyses are truly helpful?
Reporting is not a gimmick but a tool for management. You should use these reports regularly:
- Open items by project and milestone – shows exactly which project phases are outstanding.
- Retainer burn rate – how quickly is the retainer balance being consumed?
- Partial payment allocations – verifiable history of which payment was assigned to which milestone.
- Reminder effectiveness – number of reminders sent vs. payments within 7/30 days.
Practical tip: Export the core reports automatically once a week as CSV for accounting and as a PDF summary for account management.
Practical example: Agency project with retainer and three milestones
A project has a retainer of 5,000 EUR, milestones A (2,000 EUR, due 01.06.), B (3,000 EUR, due 01.07.), C (completion). Debentra posts incoming retainer payments to the retainer account. When milestone A becomes due, the system generates the partial invoice. If a partial payment of 2,000 EUR is received and the purpose is clear, it is automatically assigned to milestone A and the due status is adjusted. If the payment is unclear, the item remains under internal review – no reminder is sent until the allocation is approved.
Implementation: short to‑do list for IT operators
- Install Debentra on‑prem according to your infrastructure standards.
- Create tenants, customers and project templates.
- Set up retainer accounts and booking rules.
- Define milestones and split‑invoice templates.
- Configure reminder runs including deduplication and approval workflows.
- Set up regular reports and export jobs.
Control remains with you
Important: automation does not mean complete autonomy. In the setup you can configure approval processes for payment reminders and rebookings. This lets the finance team retain control over customer communication and sensitive postings – automation supports the processes but does not replace professional judgement.
Why on‑prem makes sense
For companies with their own IT operations, the self‑hosted variant offers clear advantages: full data sovereignty, integration into internal security and backup processes, and customization options for workflows and reporting. Debentra is available in three editions: BASIS, PRO (enables, among other things, reduced manual allocation work) and PREMIUM (with extended integration options for accounting).
Conclusion and next steps
For agencies, IT service providers and consultants, targeted configuration of retainer accounts, split invoices and milestone workflows pays off: less manual rework, better per‑project transparency and a lower risk of duplicate reminders. Start with manageable rules for retainer postings and milestone allocation, gradually add automatic reminder rules with approval processes and build reporting jobs for your finance team.
Test now: Choose the appropriate edition and configure your on‑prem setup – select edition: https://debentra.de
Next step
Try Debentra yourself
Central overview and process control for outstanding items and payments with full data sovereignty; reduces manual allocation work (PRO) and enables integrated accounting (PREMIUM); selectable installation and licensing models.