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:

768768

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

Field

Type

Description

generated

Date

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

reportDate

string
See date

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

Aged Debtors
data.CustomerId
data.CustomerName

or

Aged Creditors
data.SupplierId
data.SupplierName

string

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

data.agedCurrencyOutstanding

array

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

Aged Currency Outstanding

currency

string
See currency

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

agedOutstandingAmounts

array

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

agedOutstandingAmounts.fromDate

string
See date

The start date of the period

agedOutstandingAmounts.toDate

string
See date

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 Invoices, CreditNotes, Bills or BillCreditNotes

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.


Did this page help you?