Codat Get Accounting Profit And Loss 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-profit-and-loss",
"method": "GET",
"path": "/companies/{companyId}/data/financials/profitAndLoss",
"summary": "Get profit and loss",
"requestExamples": [],
"responseExamples": [
{
"status": "200",
"contentType": "application/json",
"name": "Clear Books",
"example": {
"reports": [
{
"fromDate": "2023-03-01T00:00:00",
"toDate": "2023-03-31T00:00:00",
"income": {
"accountId": "",
"name": "Income",
"value": 146840.42,
"items": [
{
"accountId": "72df89d2-512b-4455-af51-a6b563733842",
"name": "Sales",
"value": 146840.42,
"items": []
}
]
},
"costOfSales": {
"accountId": "",
"name": "Cost of Sales",
"value": 29955.45,
"items": [
{
"accountId": "7403e960-5b72-42ff-abf4-c870ad8910bd",
"name": "Purchases",
"value": 29955.45,
"items": []
}
]
},
"grossProfit": 116884.97,
"expenses": {
"accountId": "",
"name": "Expenses",
"value": 62407.18,
"items": [
{
"accountId": "868591ad-f9c2-4956-a5ec-c32c1d48c6f3",
"name": "Advertising & Marketing",
"value": 24962.87,
"items": []
},
{
"accountId": "940c8a59-3348-4a0b-a1b1-781d9f29cc8b",
"name": "Depreciation Expense",
"value": 1550.12,
"items": []
},
{
"accountId": "e7ac3baa-cfbe-40c1-a172-83d22e84435b",
"name": "Entertainment-100% business",
"value": 1410.61,
"items": []
},
{
"accountId": "b5e801e8-8dbc-4390-ac99-3b0fff54a89f",
"name": "General Expenses",
"value": 1283.66,
"items": []
},
{
"accountId": "5360066d-1474-49f6-a7a5-c66d5f6032ba",
"name": "Light, Power, Heating",
"value": 1168.13,
"items": []
},
{
"accountId": "138a8eb3-5c08-4e59-a3bc-892119694447",
"name": "Motor Vehicle Expenses",
"value": 944.89,
"items": []
},
{
"accountId": "1734ff00-2a17-45b4-8db6-2dc2e832c460",
"name": "Postage, Freight & Courier",
"value": 977.96,
"items": []
},
{
"accountId": "7aa7988a-ff61-4cb8-bef3-15395355d108",
"name": "Printing & Stationery",
"value": 889.94,
"items": []
},
{
"accountId": "9cbe5fe4-ca60-4792-8bf1-de01fb7010aa",
"name": "Rent",
"value": 8000,
"items": []
},
{
"accountId": "04f7111b-55d4-4efc-b329-1bd5c791933a",
"name": "Repairs & Maintenance",
"value": 719.86,
"items": []
},
{
"accountId": "7d8d0322-f452-47de-a8e8-54b0130e6f38",
"name": "Subscriptions",
"value": 40,
"items": []
},
{
"accountId": "043b6bcb-dfe6-4c97-9b4c-f9b300fe3f03",
"name": "Telephone & Internet",
"value": 45,
"items": []
},
{
"accountId": "df62060b-41cc-4bf2-9de7-c7e537b5663a",
"name": "Travel - National",
"value": 6000.46,
"items": []
},
{
"accountId": "eef78ed1-dfed-447c-bdba-3a49fb2c044b",
"name": "Audit & Accountancy fees",
"value": 0,
"items": []
},
{
"accountId": "f3aa84fe-5c31-4107-b207-7e0419f636d7",
"name": "Bank Fees",
"value": 609.29,
"items": []
},
{
"accountId": "c16f5c35-8283-47da-9d09-5fecb183b0cb",
"name": "Cleaning",
"value": 130,
"items": []
},
{
"accountId": "fb3210ef-edeb-48af-bb49-b85d40c1e6bb",
"name": "Corporation Tax",
"value": 630.62,
"items": []
},
{
"accountId": "7f6a0e92-65be-4333-9a0a-d981b03bedd1",
"name": "Wages",
"value": 12000,
"items": []
},
{
"accountId": "e8a0a24e-2dab-46b1-bfe1-6e92551c04e8",
"name": "Purchase Discounts",
"value": 510.1,
"items": []
},
{
"accountId": "4378ddba-36b4-4b35-9970-bd972b20d137",
"name": "Amortization",
"value": 5.72,
"items": []
},
{
"accountId": "78785fd7-f197-4c34-aa17-6e76b9255d34",
"name": "Interest Paid (operating)",
"value": 527.95,
"items": []
}
]
},
"netOperatingProfit": 54477.79,
"otherExpenses": {
"accountId": "",
"name": "Other Expenses",
"value": 350.44,
"items": [
{
"accountId": "cbf82e0d-87a7-464d-b567-9274ea94a1c0",
"name": "Charitable and Political Donations",
"value": 350.44,
"items": []
}
]
},
"otherIncome": {
"accountId": "",
"name": "Other Income",
"value": 850.22,
"items": [
{
"accountId": "68794a8f-b22d-4520-b97b-025b7cb10f94",
"name": "Other Revenue",
"value": 850.22,
"items": []
}
]
},
"netOtherIncome": 499.78,
"netProfit": 54977.57
},
{
"fromDate": "2023-02-01T00:00:00",
"toDate": "2023-02-28T00:00:00",
"income": {
"accountId": "",
"name": "Income",
"value": 108461.81,
"items": [
{
"accountId": "72df89d2-512b-4455-af51-a6b563733842",
"name": "Sales",
"value": 108461.81,
"items": []
}
]
},
"costOfSales": {
"accountId": "",
"name": "Cost of Sales",
"value": 18438.51,
"items": [
{
"accountId": "7403e960-5b72-42ff-abf4-c870ad8910bd",
"name": "Purchases",
"value": 18438.51,
"items": []
}
]
},
"grossProfit": 90023.3,
"expenses": {
"accountId": "",
"name": "Expenses",
"value": 46096.28,
"items": [
{
"accountId": "868591ad-f9c2-4956-a5ec-c32c1d48c6f3",
"name": "Advertising & Marketing",
"value": 18438.51,
"items": []
},
{
"accountId": "940c8a59-3348-4a0b-a1b1-781d9f29cc8b",
"name": "Depreciation Expense",
"value": 669.33,
"items": []
},
{
"accountId": "e7ac3baa-cfbe-40c1-a172-83d22e84435b",
"name": "Entertainment-100% business",
"value": 609.09,
"items": []
},
{
"accountId": "b5e801e8-8dbc-4390-ac99-3b0fff54a89f",
"name": "General Expenses",
"value": 554.28,
"items": []
},
{
"accountId": "5360066d-1474-49f6-a7a5-c66d5f6032ba",
"name": "Light, Power, Heating",
"value": 448.35,
"items": []
},
{
"accountId": "138a8eb3-5c08-4e59-a3bc-892119694447",
"name": "Motor Vehicle Expenses",
"value": 412.48,
"items": []
},
{
"accountId": "1734ff00-2a17-45b4-8db6-2dc2e832c460",
"name": "Postage, Freight & Courier",
"value": 426.92,
"items": []
},
{
"accountId": "7aa7988a-ff61-4cb8-bef3-15395355d108",
"name": "Printing & Stationery",
"value": 388.49,
"items": []
},
{
"accountId": "9cbe5fe4-ca60-4792-8bf1-de01fb7010aa",
"name": "Rent",
"value": 8000,
"items": []
},
{
"accountId": "04f7111b-55d4-4efc-b329-1bd5c791933a",
"name": "Repairs & Maintenance",
"value": 314.25,
"items": []
},
{
"accountId": "7d8d0322-f452-47de-a8e8-54b0130e6f38",
"name": "Subscriptions",
"value": 40,
"items": []
},
{
"accountId": "043b6bcb-dfe6-4c97-9b4c-f9b300fe3f03",
"name": "Telephone & Internet",
"value": 45,
"items": []
},
{
"accountId": "df62060b-41cc-4bf2-9de7-c7e537b5663a",
"name": "Travel - National",
"value": 325.25,
"items": []
},
{
"accountId": "eef78ed1-dfed-447c-bdba-3a49fb2c044b",
"name": "Audit & Accountancy fees",
"value": 0,
"items": []
},
{
"accountId": "f3aa84fe-5c31-4107-b207-7e0419f636d7",
"name": "Bank Fees",
"value": 2600.97,
"items": []
},
{
"accountId": "c16f5c35-8283-47da-9d09-5fecb183b0cb",
"name": "Cleaning",
"value": 130,
"items": []
},
{
"accountId": "fb3210ef-edeb-48af-bb49-b85d40c1e6bb",
"name": "Corporation Tax",
"value": 239.41,
"items": []
},
{
"accountId": "7f6a0e92-65be-4333-9a0a-d981b03bedd1",
"name": "Wages",
"value": 12000,
"items": []
},
{
"accountId": "e8a0a24e-2dab-46b1-bfe1-6e92551c04e8",
"name": "Purchase Discounts",
"value": 220.26,
"items": []
},
{
"accountId": "4378ddba-36b4-4b35-9970-bd972b20d137",
"name": "Amortization",
"value": 5.72,
"items": []
},
{
"accountId": "78785fd7-f197-4c34-aa17-6e76b9255d34",
"name": "Interest Paid (operating)",
"value": 227.97,
"items": []
}
]
},
"netOperatingProfit": 43927.02,
"otherExpenses": {
"accountId": "",
"name": "Other Expenses",
"value": 350.44,
"items": [
{
"accountId": "cbf82e0d-87a7-464d-b567-9274ea94a1c0",
"name": "Charitable and Political Donations",
"value": 350.44,
"items": []
}
]
},
"otherIncome": {
"accountId": "",
"name": "Other Income",
"value": 850.22,
"items": [
{
"accountId": "68794a8f-b22d-4520-b97b-025b7cb10f94",
"name": "Other Revenue",
"value": 850.22,
"items": []
}
]
},
"netOtherIncome": 499.78,
"netProfit": 44426.8
}
],
"reportBasis": "Unknown",
"currency": "GBP",
"mostRecentAvailableMonth": "2023-03-01T00:00:00",
"earliestAvailableMonth": "2018-04-01T00:00:00"
}
},
{
"status": "200",
"contentType": "application/json",
"name": "Dynamics 365 Business Central",
"example": {
"reports": [
{
"fromDate": "2023-03-01T00:00:00",
"toDate": "2023-03-31T00:00:00",
"income": {
"name": "Income",
"value": 658.5,
"items": [
{
"name": "Sales Returns & Allowances",
"value": 0,
"items": [
{
"accountId": "8aba49ae-461a-ed11-90eb-000d3a873324",
"name": "0121 - ",
"value": 0,
"items": []
},
{
"accountId": "1e1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10400 - Sales Returns & Allowances",
"value": 0,
"items": []
}
]
},
{
"name": "Income, Services",
"value": 0,
"items": [
{
"accountId": "ac6a3a74-c69f-ec11-80f1-0022481b4546",
"name": "10005-1 - Child",
"value": 0,
"items": []
},
{
"accountId": "161217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10100 - Income, Services",
"value": 0,
"items": []
}
]
},
{
"name": "Income, Jobs",
"value": 0,
"items": [
{
"accountId": "1f2618f9-c79f-ec11-80f1-0022481b4546",
"name": "10005-2 - Child Child",
"value": 0,
"items": []
},
{
"accountId": "1a1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10250 - Job Sales",
"value": 0,
"items": []
}
]
},
{
"name": "",
"value": 0,
"items": [
{
"accountId": "de1cabee-4a33-ed11-97e8-0022481aa72d",
"name": "1005002 - Test account no cat 2",
"value": 0,
"items": []
},
{
"accountId": "b74b0c08-aa59-eb11-89f9-00224800a7ae",
"name": "1006 - Account without category Income ",
"value": 0,
"items": []
},
{
"accountId": "023a8eba-c12e-ed11-97e8-000d3a8753f5",
"name": "3213 - vdfgdf",
"value": 0,
"items": []
},
{
"accountId": "aa666f5a-c22e-ed11-97e8-0022480052b7",
"name": "TEST INCOME A/C - ",
"value": 0,
"items": []
}
]
},
{
"name": "Income, Product Sales",
"value": 658.5,
"items": [
{
"accountId": "181217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10200 - Income, Product Sales",
"value": 658.5,
"items": []
}
]
},
{
"name": "Sales Discounts",
"value": 0,
"items": [
{
"accountId": "1c1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10300 - Sales Discounts",
"value": 0,
"items": []
}
]
},
{
"name": "Job Sales Contra",
"value": 0,
"items": [
{
"accountId": "201217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10450 - Job Sales Applied",
"value": 0,
"items": []
}
]
},
{
"name": "Income",
"value": 0,
"items": [
{
"accountId": "221217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10500 - Interest Income",
"value": 0,
"items": []
}
]
}
]
},
"costOfSales": {
"name": "Cost of Goods Sold",
"value": 2735.64,
"items": [
{
"name": "Materials",
"value": 2735.64,
"items": [
{
"accountId": "281217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "20100 - Cost of Materials",
"value": 2735.64,
"items": []
}
]
},
{
"name": "Labour",
"value": 0,
"items": [
{
"accountId": "2a1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "20200 - Cost of Labour",
"value": 0,
"items": []
}
]
},
{
"name": "Jobs Cost",
"value": 0,
"items": [
{
"accountId": "2c1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "20300 - Job Costs",
"value": 0,
"items": []
}
]
}
]
},
"grossProfit": -2077.14,
"expenses": {
"name": "Expense",
"value": 41.77,
"items": [
{
"name": "",
"value": 0,
"items": [
{
"accountId": "e9b4e2c2-4b33-ed11-97e8-0022481aa72d",
"name": "1005003 - Expense Test account no cat",
"value": 0,
"items": []
},
{
"accountId": "1d60f4a2-6d19-ed11-90eb-002248009024",
"name": "1234512345 - Invalid VAT Posting Setup",
"value": 0,
"items": []
}
]
},
{
"name": "Interest Expense",
"value": 0,
"items": [
{
"accountId": "bd407350-340b-ec11-86bc-0022481a4971",
"name": "1093 - export with misc type",
"value": 0,
"items": []
},
{
"accountId": "381217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30300 - Interest Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Other Income & Expenses",
"value": 0,
"items": [
{
"accountId": "2e1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "20399 - Job Costs Applied",
"value": 0,
"items": []
},
{
"accountId": "4e1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31400 - Office Supplies Expense",
"value": 0,
"items": []
},
{
"accountId": "501217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31500 - Miscellaneous Expense",
"value": 0,
"items": []
},
{
"accountId": "521217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31600 - Depreciation, Equipment",
"value": 0,
"items": []
},
{
"accountId": "541217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31900 - Rounding",
"value": 0,
"items": []
}
]
},
{
"name": "Benefits Expense",
"value": 0,
"items": [
{
"accountId": "57a95f12-9ecf-ec11-8e7e-00224800faf5",
"name": "23 - test account",
"value": 0,
"items": []
}
]
},
{
"name": "Fees Expense",
"value": 0,
"items": [
{
"accountId": "3f6818aa-a4cf-ec11-8e7e-00224800faf5",
"name": "30 - test expenses 2",
"value": 0,
"items": []
},
{
"accountId": "3a1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30400 - Bank Charges and Fees",
"value": 0,
"items": []
},
{
"accountId": "3c1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30500 - Processing Fees",
"value": 0,
"items": []
}
]
},
{
"name": "Rent Expense",
"value": 0,
"items": [
{
"accountId": "341217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30100 - Rent Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Advertising Expense",
"value": 0,
"items": [
{
"accountId": "361217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30200 - Advertising Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Bad Debt Expense",
"value": 0,
"items": [
{
"accountId": "3e1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30600 - Bad Debt Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Salaries Expense",
"value": 0,
"items": [
{
"accountId": "401217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30700 - Salaries Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Payroll Expense",
"value": 0,
"items": [
{
"accountId": "421217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30800 - Payroll Tax Expense",
"value": 0,
"items": []
},
{
"accountId": "441217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "30900 - Workers Compensation ",
"value": 0,
"items": []
}
]
},
{
"name": "Insurance Expense",
"value": 41.77,
"items": [
{
"accountId": "461217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31000 - Health & Dental Insurance Expense",
"value": 41.77,
"items": []
},
{
"accountId": "481217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31100 - Life Insurance Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Repairs and Maintenance Expense",
"value": 0,
"items": [
{
"accountId": "4a1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31200 - Repairs and Maintenance Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Utilities Expense",
"value": 0,
"items": [
{
"accountId": "4c1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "31300 - Utilities Expense",
"value": 0,
"items": []
}
]
},
{
"name": "Travel Expense",
"value": 0,
"items": [
{
"accountId": "61d17174-61db-ec11-82f9-002248008de8",
"name": "999992 - Payhawk General",
"value": 0,
"items": []
},
{
"accountId": "3a37ed38-a6cf-ec11-8e7e-00224800faf5",
"name": "999998 - Payhawk General",
"value": 0,
"items": []
},
{
"accountId": "64ee049b-a1cf-ec11-8e7e-00224800faf5",
"name": "999999 - Payhawk General",
"value": 0,
"items": []
}
]
}
]
},
"netOperatingProfit": -2118.91,
"otherExpenses": {
"name": "Other Expenses",
"value": 0,
"items": []
},
"otherIncome": {
"name": "Other Income",
"value": 0,
"items": []
},
"netOtherIncome": 0,
"netProfit": -2118.91
},
{
"fromDate": "2023-02-01T00:00:00",
"toDate": "2023-02-28T00:00:00",
"income": {
"name": "Income",
"value": 414.51,
"items": [
{
"name": "Sales Returns & Allowances",
"value": -125.17,
"items": [
{
"accountId": "8aba49ae-461a-ed11-90eb-000d3a873324",
"name": "0121 - ",
"value": -125.17,
"items": []
},
{
"accountId": "1e1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10400 - Sales Returns & Allowances",
"value": 0,
"items": []
}
]
},
{
"name": "Income, Services",
"value": -10,
"items": [
{
"accountId": "ac6a3a74-c69f-ec11-80f1-0022481b4546",
"name": "10005-1 - Child",
"value": -10,
"items": []
},
{
"accountId": "161217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10100 - Income, Services",
"value": 0,
"items": []
}
]
},
{
"name": "Income, Jobs",
"value": -12.91,
"items": [
{
"accountId": "1f2618f9-c79f-ec11-80f1-0022481b4546",
"name": "10005-2 - Child Child",
"value": -12.91,
"items": []
},
{
"accountId": "1a1217b3-89d1-ea11-bbaa-000d3a2b9185",
"name": "10250 - Job Sales",
"value": 0,
"items": []
}
]
},
{
"name": "",
"value": 0,
"items": [
{
"accountId": "de1cabee-4a33-ed11-97e8-0022481aa72d",
"name": "1005002 - Test account no cat 2",
"value": 0,
"items": []
},
{
"accountId": "b74b0c08-aa59-eb11-89f9-00224800a7ae",
"name": "1006 - Account without category Income ",
"value": 0,
"items": []
},
{
"accountId": "023a8eba-c12e-ed11-97e8-000d3a8753f5",
"name": "3213 - vdfgdf",
"value": 0,
"items": []
},
{
# --- truncated at 32 KB (128 KB total) ---
# Full source: https://raw.githubusercontent.com/api-evangelist/codat/refs/heads/main/examples/codat-get-accounting-profit-and-loss-example.json