Codat Get Accounting Aged Creditors Report Example is an example object payload from Codat, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
operationIdmethodpathsummaryrequestExamplesresponseExamples
Example Payload
{
"operationId": "get-accounting-aged-creditors-report",
"method": "GET",
"path": "/companies/{companyId}/reports/agedCreditor",
"summary": "Aged creditors report",
"requestExamples": [],
"responseExamples": [
{
"status": "200",
"contentType": "application/json",
"name": "Clear Books",
"example": {
"generated": "2023-05-02T16:05:21.7545859Z",
"reportDate": "2023-05-02T16:05:21.7016767Z",
"data": [
{
"supplierId": "owQ2Gqgj9f",
"supplierName": "Abshire - Kshlerin",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -78.12,
"details": [
{
"name": "BillCreditNotes",
"amount": -78.12
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 375.6,
"details": [
{
"name": "Bills",
"amount": 375.6
}
]
}
]
}
]
},
{
"supplierId": "FyUkHbZxhn",
"supplierName": "Arjun Kuvalis",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -3782.27,
"details": [
{
"name": "BillCreditNotes",
"amount": -3782.27
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 8556.1,
"details": [
{
"name": "Bills",
"amount": 8556.1
}
]
}
]
}
]
},
{
"supplierId": "gxazX5hqx4",
"supplierName": "Bernier Inc",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 213.19,
"details": [
{
"name": "Bills",
"amount": 213.19
}
]
}
]
}
]
},
{
"supplierId": "ro8nWYGzlg",
"supplierName": "Botsford - Hickle",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2242.95,
"details": [
{
"name": "Bills",
"amount": 0
},
{
"name": "BillCreditNotes",
"amount": -2242.95
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 838.67,
"details": [
{
"name": "Bills",
"amount": 838.67
}
]
}
]
}
]
},
{
"supplierId": "D4Q4iYwHou",
"supplierName": "Breitenberg, Emard and Schiller",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -276.5,
"details": [
{
"name": "BillCreditNotes",
"amount": -276.5
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 46060.53,
"details": [
{
"name": "Bills",
"amount": 46060.53
}
]
}
]
}
]
},
{
"supplierId": "9436ead6-545e-4e8c-8444-0220047c5a38",
"supplierName": "Champlin LLC",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 22726.97,
"details": [
{
"name": "Bills",
"amount": 22726.97
}
]
}
]
}
]
},
{
"supplierId": "O6jExrbN3v",
"supplierName": "Collins - Anderson",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -19.39,
"details": [
{
"name": "BillCreditNotes",
"amount": -19.39
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "9d4b61a4-4ce3-4d90-8d6b-66614694dc27",
"supplierName": "Crona - Adams",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 302.8,
"details": [
{
"name": "Bills",
"amount": 302.8
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": []
}
]
}
]
},
{
"supplierId": "ad8f4ee1-7a04-415f-b3dc-365d41d8d4f0",
"supplierName": "Cronin, Kunde and Tremblay",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -3271.91,
"details": [
{
"name": "BillCreditNotes",
"amount": -3271.91
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 3479.78,
"details": [
{
"name": "Bills",
"amount": 3479.78
}
]
}
]
}
]
},
{
"supplierId": "8GeHBdBZiZ",
"supplierName": "DuBuque, Goyette and Franecki",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -16511.91,
"details": [
{
"name": "BillCreditNotes",
"amount": -16511.91
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "XOPP3v2lQu",
"supplierName": "Fisher and Sons",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 238599.9,
"details": [
{
"name": "Bills",
"amount": 238599.9
}
]
}
]
}
]
},
{
"supplierId": "0a7b0432-7de3-4e29-bf15-4e7ca0722384",
"supplierName": "Flatley - Kirlin",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -113.59,
"details": [
{
"name": "BillCreditNotes",
"amount": -113.59
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 910.45,
"details": [
{
"name": "Bills",
"amount": 910.45
}
]
}
]
}
]
},
{
"supplierId": "HrGZeW4I51",
"supplierName": "Frami, Simonis and Krajcik",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2070.59,
"details": [
{
"name": "BillCreditNotes",
"amount": -2070.59
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "SFmBGSHLQ3",
"supplierName": "Gottlieb LLC",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -105.07,
"details": [
{
"name": "BillCreditNotes",
"amount": -105.07
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "unNIu8Uyap",
"supplierName": "Hahn and Sons",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -297.78,
"details": [
{
"name": "BillCreditNotes",
"amount": -297.78
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 2095.75,
"details": [
{
"name": "Bills",
"amount": 2095.75
}
]
}
]
}
]
},
{
"supplierId": "GTGS3Sx241",
"supplierName": "Harvey Predovic",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 3612.41,
"details": [
{
"name": "Bills",
"amount": 3612.41
}
]
}
]
}
]
},
{
"supplierId": "w07H3CBm5P",
"supplierName": "Hayes, Predovic and Ruecker",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -11662.51,
"details": [
{
"name": "BillCreditNotes",
"amount": -11662.51
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 393776.18,
"details": [
{
"name": "Bills",
"amount": 393776.18
}
]
}
]
}
]
},
{
"supplierId": "92144542-2227-409e-8f5b-fc73260e670b",
"supplierName": "Hettinger, Schmitt and Will",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 3433.54,
"details": [
{
"name": "Bills",
"amount": 3433.54
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": []
}
]
}
]
},
{
"supplierId": "rpLhEYz0ML",
"supplierName": "Hickle - Buckridge",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -7484.88,
"details": [
{
"name": "BillCreditNotes",
"amount": -7484.88
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "d2056eb9-649e-4808-8f96-d8ea4dac71fe",
"supplierName": "Hodkiewicz Group",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -6627.16,
"details": [
{
"name": "BillCreditNotes",
"amount": -6627.16
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 18266.27,
"details": [
{
"name": "Bills",
"amount": 18266.27
}
]
}
]
}
]
},
{
"supplierId": "s3WcvMyVdR",
"supplierName": "Howe - Ruecker",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 4042.16,
"details": [
{
"name": "Bills",
"amount": 4042.16
}
]
}
]
}
]
},
{
"supplierId": "b60XbI9zhE",
"supplierName": "Jenkins Inc",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -12938.29,
"details": [
{
"name": "BillCreditNotes",
"amount": -12938.29
},
{
"name": "Bills",
"amount": 0
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 18360.8,
"details": [
{
"name": "Bills",
"amount": 18360.8
}
]
}
]
}
]
},
{
"supplierId": "OtXKRTOcQc",
"supplierName": "Jensen Steuber",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 190.16,
"details": [
{
"name": "Bills",
"amount": 190.16
}
]
}
]
}
]
},
{
"supplierId": "c02bc2f1-631d-4721-aec1-a190d63e8322",
"supplierName": "Jones - Zulauf",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -69.05,
"details": [
{
"name": "BillCreditNotes",
"amount": -69.05
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 51357.36,
"details": [
{
"name": "Bills",
"amount": 51357.36
}
]
}
]
}
]
},
{
"supplierId": "c02382bd-ff23-4b34-bfd7-8dce15fa7d6a",
"supplierName": "Keara Leffler",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -2496.69,
"details": [
{
"name": "BillCreditNotes",
"amount": -2496.69
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 1519.74,
"details": [
{
"name": "Bills",
"amount": 1519.74
}
]
}
]
}
]
},
{
"supplierId": "d3tf43eghS",
"supplierName": "Klocko - Keebler",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": 0,
"details": []
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 12367.4,
"details": [
{
"name": "Bills",
"amount": 12367.4
}
]
}
]
}
]
},
{
"supplierId": "7GObELDcsE",
"supplierName": "Lakin, Schmeler and Kihn",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -318.71,
"details": [
{
"name": "BillCreditNotes",
"amount": -318.71
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "gO8p5O3Mvy",
"supplierName": "Lehner Group",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -1042.8,
"details": [
{
"name": "BillCreditNotes",
"amount": -1042.8
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "62229022-713f-4c64-84f2-63cf6dd11443",
"supplierName": "Littel - Cole",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -7.5,
"details": [
{
"name": "BillCreditNotes",
"amount": -7.5
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "39b32019-c5d0-4db3-ae83-f0a644e614ef",
"supplierName": "Marvin - Schaden",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -1611.56,
"details": [
{
"name": "BillCreditNotes",
"amount": -1611.56
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"toDate": "2023-04-02T00:00:00.0000000",
"amount": 0,
"details": [
{
"name": "Bills",
"amount": 0
}
]
}
]
}
]
},
{
"supplierId": "8635b986-048f-424c-985d-912576c004d9",
"supplierName": "Mills, Bechtelar and Wintheiser",
"agedCurrencyOutstanding": [
{
"currency": "GBP",
"agedOutstandingAmounts": [
{
"fromDate": "2023-04-02T00:00:00.0000000",
"toDate": "2023-05-02T00:00:00.0000000",
"amount": -604.41,
"details": [
{
"name": "BillCreditNotes",
"amount": -604.41
}
]
},
{
"fromDate": "0001-01-01T00:00:00.0000000",
"
# --- truncated at 32 KB (218 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/codat/refs/heads/main/examples/codat-get-accounting-aged-creditors-report-example.json