Free Excel kits for collections and financial management
Managing accounts receivable, monitoring overdue receivables and anticipating cash flow are critical issues for companies of all sizes. Many CFOs, credit managers and SME directors start by using Excel to organize their collections.
To help you, Aston AI provides a comprehensive library of free, ready-to-use Excel templates.
These Excel kits cover all the key stages of credit management:
- follow-up on reminders and collections,
- analysis of ageing balance and DSO,
- WCR calculation and cash flow forecasts,
- credit manager reporting,
- customer risk management,
- calculation of late payment penalties,
- preparation for electronic invoicing 2025.
Each kit includes a free Excel file + a user guide.
You can download them freely and use them as a starting point before moving on to an automated SaaS solution like Aston AI.
All Aston AI Excel Kits
Excel Collection & Dunning Kit
Monitoring overdue invoices is the cornerstone of effective credit management. This kit helps you centralize all your overdue invoices and dunning actions.
Kit contents :
- Table for tracking unpaid invoices,
- Log of reminders messages sent by e-mail, telephone or post,
- Recovery rate indicator.
Ageing Balance & DSO Excel Kit
The customer ageing balance enables you to break down your outstanding receivables by age, while the DSO (Days Sales Outstanding) measures the average payment time. This kit lets you combine these two essential tools.
Kit contents :
- Excel ageing balance model (0-30, 31-60, 61-90, +90 days),
- Automatic calculation of monthly DSO,
- Tracking graphs.
WCR & Cash Flow Excel Kit
WCR (Working Capital Requirement) is a key indicator for anticipating your financing needs. This Excel kit will help you calculate your normative WCR and project your cash flows.
Kit contents :
- Automatic calculation of normative WCR,
- Cash flow projections at 30/60/90 days,
- Liquidity ratios.
Electronic Invoicing & Compliance Excel Kit
The 2025 e-invoicing reform will transform the obligations of French companies. This Excel kit will help you keep track of your obligations and prepare for the transition.
Kit contents :
- PDP / PPF checklist,
- Track invoices in Factur-X format,
- Journal e-reporting TVA.
Excel Reporting Credit Manager Kit
Credit managers need to monitor their key indicators in order to make the right decisions. This kit provides you with a clear and efficient Excel reporting template.
Kit contents :
- Total customer outstandings,
- % of unpaid installments,
- Consolidated DSO,
- Litigation follow-up.
Customer Risk Management Excel Kit
Assessing the creditworthiness of your customers is essential to limit the risk of non-payment. This Excel kit provides you with a simple scoring and monitoring model.
Kit contents :
- Customer scoring model,
- Definition of credit limits,
- Outstanding vs. allocated limits.
Penalties & Interest on Arrears Excel Kit
The law allows late payment penalties to be applied in the event of unpaid invoices. This Excel kit will help you automate their calculation.
Kit contents :
- Setting the legal or contractual rate,
- Automatic calculation based on number of days overdue,
- Amount of penalties due per customer.
Why isn't Excel enough for the long term?
Excel is useful for getting started, but it quickly reaches its limits:
- Risk of manual errors,
- No automatic alerts,
- Data not connected to your actual invoices,
- Difficulty working with others.
With Aston Cash Collection, you switch to a SaaS platform that automates up to 80% of your reminders, calculates your KPIs in real time and secures your collections.
Take the next step with Aston AI Cash Collection software
Our free Excel kits are a first step.
But to really gain in efficiency, reduce your unpaid debts with Aston AI, the intelligent collection software.
Read more in the Aston AI Blog:
