Reports: Aged Debtors and Creditors

Generate Aged Debtors and Aged Creditors reports for a company


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.



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:


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

  1. In the navigation bar, click Companies.
  2. Click the name of the company you want to generate the report for.
    The company's data page is displayed.
  3. Click the Accounting tab then click Reports.
  4. Select either Aged Debtors or Aged Creditors.
  5. (Optional) Edit the default reporting parameters.
    1. 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.
    2. In the Period Length Days box, select the default period length for each column (the default is 30 days).
    3. In the Number of Periods box, enter the number of periods to show as columns in the report (the default is 4 periods).
  6. To run the report, click Load aged debtors or Load aged creditors.
  1. 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






Date that the report was generated or calculated from the underlying data


See date

Date that the report was generated for. This can be specified when calling the API.

Aged Debtors


Aged Creditors


Id and name of the customer or supplier that owes or is owed money.



An agedCurrencyOutstanding object will be returned for each currency that money is due or owed.

Aged Currency Outstanding


See currency

The currency of the amount due from the customer or owed to the supplier



Each agedOutstandingAmount object contains a 30 day period detailing the monies due or owed from that period.


See date

The start date of the period


See date

The end date of the period



The amount due or owed



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.


The name of the type of record where the money is due or owed.

For example Invoices, CreditNotes, Bills or BillCreditNotes



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.