Aged Debtors and Creditors Template

Aged Debt, Lifetime Sales, Last Sales activity and average days to pay for every Debtor and Creditor from Xero Financial data.

Laszlo Molnar avatar
Written by Laszlo Molnar
Updated over a week ago

The first two reports present aged debtors and creditors information. Totals are calculated for aged debt (or credit) at due, 30d, 60d and 90d intervals. Invoices that make up the amounts filter depending on selection and with one click link you back to the Xero invoice. Lifetime Sales Values and individual debtor days per Customer/Supplier are calculated.

The third report - When Revenue is Collected - plots debtor days against revenue/payments made in a Financial Year. Bars are coloured depending on the performance of debtors current fiscal year payment days vs the previous year. Those improving are green, whilst those worsening are red. This allows the easy identification of customers payment history and trend.

Test drive this template

You can click on the screen shots below to test drive the template with Demo Company data in Microsoft Power BI online.

Download the template

Click the button below to download this template.

Once downloaded, open the template in Microsoft Power BI Desktop and connect to your Connectorly database.

Key Tables

This template makes use of Invoices and Contacts tables.

See how to bring your data into the Power BI desktop

Did this answer your question?