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:

📘

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.

7. 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

Aged Currency Outstanding

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.