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
Return on Investment (ROI) of Debt Collection Software
Today, most invoice reminders are handled manually, and that means high costs and a lot of time. Discover the ROI benefits of invoice reminder software. For more information, read our guide: Debt Collection Software: The Complete Guide. Invest in automated
ASTON AI presents its new software for collection agencies
ASTON iTF presents its new software for collection agencies at the SAR Congress on June 17. The collection software developed by Aston iTF allows you to digitalize the processes of collection agencies: automate 80% of collection reminder tasks. White-labeled with your name or the names of your customers. Share information with your customers on a collaborative platform.
360° View of the Customer Account: Consolidating Collections, Credit Management, and DSO on a Global Scale
For international groups, accounts receivable are often spread across multiple subsidiaries, multiple ERP systems, multiple currencies, and multiple countries. This fragmentation complicates the work of credit management, collections, and finance teams. As a result, it becomes difficult to gain a
