Reports: Aged Debtors and Creditors
Generate Aged Debtors and Aged Creditors reports for a company
Overview
You can generate Aged Debtors and Aged Creditors reports for a company based on recently synced data from your customers' accounting platforms. Both of these reports are available in the Reports tab in the Codat portal.
- The Aged Debtors report shows the total outstanding balance due from customers to the business over time.
- The Aged Creditors report shows the total balance owed by a business to its suppliers over time.
Total assets or liabilities are grouped into 30-day periods for each customer or supplier, up to the current date. You can adjust the report date, period length, and number of periods to show on each report. The data can be grouped by customer or currency.
Write-offs
It is not guaranteed that write-offs are included in the Aged Debtors and Aged Creditors reports.
Underlying data
The Aged Debtors and Aged Creditors reports are generated from a set of required data types, as described in the table below.
To generate these reports, the underlying data types must have been synced within 24 hours of each other. Otherwise the following error is displayed when you try to run the report:


Sync the required data types by clicking the link in the error, and then run the report again.
The following table lists the required data types for each report:
Aged Debtors Report | Aged Creditors Report |
---|---|
Reports run on issue date
The Aged Debtors and Aged Creditors reports run based on the issue dates of the underlying data types rather than the due date.
Generating the Aged Debtors and Aged Creditors reports
- In the navigation bar, click Companies.
- Click the name of the company you want to generate the report for.
The company's data page is displayed. - Click the Accounting tab then click Reports.
- Select either Aged Debtors or Aged Creditors.
- (Optional) Edit the default reporting parameters.
- You can change the report date in the Date box. By default, the report includes transactions that occurred up to but not including today's date. To include transactions for today, enter tomorrow's date. For example, to include customer payments made today in the Aged Debtors report, enter tomorrow's date.
- In the Period Length Days box, select the default period length for each column (the default is 30 days).
- In the Number of Periods box, enter the number of periods to show as columns in the report (the default is 4 periods).
- To run the report, click Load aged debtors or Load aged creditors.


- The report is generated and displayed at the bottom of the page.
Accessing the Aged Debtors and Creditors Reports using the API
You can also return the Aged Debtors and Aged Creditors reports as JSON and query whether the reports are available.
Explore the Reports endpoints in Swagger.
The structure of the report will be as the example below:
Data Model
Field | Type | Description |
---|---|---|
generated | Date | Date that the report was generated or calculated from the underlying data |
reportDate | string | Date that the report was generated for. This can be specified when calling the API. |
Aged Debtors or Aged Creditors | string | Id and name of the customer or supplier that owes or is owed money. |
data.agedCurrencyOutstanding | array | An |
Aged Currency Outstanding
currency | string | The currency of the amount due from the customer or owed to the supplier |
agedOutstandingAmounts | array | Each |
agedOutstandingAmounts.fromDate | string | The start date of the period |
agedOutstandingAmounts.toDate | string | The end date of the period |
agedOutstandingAmounts.amount | decimal | The amount due or owed |
agedOutstandingAmounts.details | array | A list of summaries showing from where the money is due or owed. For example, whether the amount due is from outstanding invoices or unspent credit notes. |
agedOutstandingAmounts.details.name | string | The name of the type of record where the money is due or owed. For example |
agedOutstandingAmounts.details.amount | decimal | The amount due or owed |
Example data
{
"generated": "2022-09-16T09:45:08.5703344Z",
"reportDate": "2022-09-16T09:45:08.3551499Z",
"data": [
{
"customerId": "305ca5cf-497d-4fee-a161-cdb30e6be989",
"customerName": "Basket Case",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2022-08-16T00:00:00",
"toDate": "2022-09-16T00:00:00",
"amount": 794.55,
"details": [
{
"name": "CreditNotes",
"amount": -120
},
{
"name": "Invoices",
"amount": 914.55
}
]
}
]
}
]
}
]
}
The report will be grouped per customer or supplier and will be grouped depending on the periods requested. The details indicates whether the amounts owed come from outstanding invoices, bills, credit notes or bill credit notes.
Updated 4 months ago