The aged trial balance and DSO (Days Sales Outstanding) are among the tools most frequently used by credit managers and finance departments to manage receivables. They are used to measure the quality of collection and the speed with which receivables are converted into cash. For many SMEs and ETIs, Excel remains the primary solution for calculating these indicators. To save time and secure your calculations, we offer you a ready-to-use Excel template, free of charge and easy to use.
What are customer ageing scales?
An aged trial balance is a table that breaks down customer invoices by age. Receivables are grouped by age: 0-30 days, 31-60 days, 61-90 days and over 90 days. This tool is essential for identifying late payments and focusing collection efforts on the most at-risk customers. In practical terms, it enables a CFO or credit manager to see at a glance which customers are weighing most heavily on cash flow.
For example, if a large proportion of invoices are in the +90 days bracket, this indicates a high risk of non-payment. The aged trial balance also serves as a basis for internal reporting and discussions with sales teams.
Practical example in Excel
Our Excel aged trial balance template automatically sorts your invoices by age. Simply enter the customer, due date and invoice amount. The file divides receivables into the right intervals and generates summary indicators.
Example: a service SME can use this table to monitor all its outstanding invoices. If it finds that 40% of its invoices are more than 60 days overdue, it can alert its collection team and follow up more intensively with the customers concerned.
Founded in 2011, ASTON AI, voted Fintech of the Year 2015, has revolutionized the receivables management market in ten years by offering a high-performance, simple, comprehensive and innovative platform. ASTON AI platforms benefit from 10 years of continuous technological development and an in-house R&D department dedicated to digital services.
Download our Excel Aged Balance & DSO template
We provide a free Excel file combining the aged trial balance and DSO calculation. This model is designed to be immediately operational and adapted to all company sizes. It includes :
- An aged scale with four standard slices.
- Automatic DSO calculation based on your sales and work-in-progress.
- Tracking graphs to visualize the evolution of delays.
Download the Excel Aged Balance & DSO template now and simplify your analyses.
How do I calculate DSO in Excel?
DSO (Days Sales Outstanding) measures your customers’ average payment time. It is calculated by dividing outstanding customer accounts by daily sales (annual sales / 360 days). Our file directly integrates this formula and updates the DSO according to your actual data.
Example: if you have €300,000 in receivables and annual sales of €3.6 million, your DSO will be 30 days. Thanks to the Excel model, this calculation is made automatically and adjusted according to your cash inflows.
Excel's limitations and the SaaS alternative
Excel may be handy for getting started, but it quickly reaches its limits: files become unwieldy, input errors multiply and manual updating is time-consuming. Above all, Excel doesn’t allow you to automate reminders or share data in real time.
That’s where Aston AI comes in. Our SaaS collections software integrates aged trial balance, DSO and many other indicators in real time. AI helps you prioritize your dunning actions, forecasts late payments and automates up to 80% of tasks. In this way, you move from descriptive monitoring (Excel) to predictive and collaborative management.
Take the next step with Aston AI
The Excel Aged Trial Balance & DSO template is an excellent first step in structuring your analyses. But for real efficiency gains, discover Aston AI: intelligent collection software that automates your reminders, reduces payment times and secures your cash flow.
Request a free demo today.
Browse the Aston AI blog
Credit management
Credit management Contents : What is credit management? What is the role of a credit manager? What are the key credit management indicators? Every business relationship has its share of difficulties. Some companies take out customer receivablei.e. the non-recovery of
Le Nouvel Économiste and Aston AI: Customer risk management, the culture of anticipation
ASTON iTF interviewed by Le Nouvel Economiste: As a fintech, the company has focused on the challenge of accelerating the conversion of customer invoices awaiting payment into cash. 25% of SMEs go bankrupt due to insufficient cash flow, and according to several studies, late payments weigh on the French economy to the tune of several tens of billions of euros," notes Amaury de la Lance, the company’s CEO.
Centralizing customer responses: a game changer for collections
Centralize customer email and SMS responses in Aston AI, our collection software, to improve the responsiveness of reminders. 👉 If you’re looking for concrete, measurable results, discover our powerful collection softwareto significantly improve your cash flow. And what if your
