Retrieve Balance Sheet
This method is used to extract the customer's balance sheet data in order to determine their creditworthiness. The call is made through the GET /companies/{companyId}/data/financials/balanceSheet Codat endpoint. For detailed information returned by this method please see the Datamodel Accounting Balancesheet page.
Before calling this method, make sure that the Check Status Data result contains the following parameter response: "dataType": "balanceSheet" with "currentStatus": "Complete".
Request Example
Copy
{
"name": "GetBalanceSheet",
"request": {
"method": "GET",
"header": [],
"url": {
"raw": "https://app-ecos-apache-camel-test.azurewebsites.net/services/api/codat/getbalancesheet/78d790d2-6935-41f8-9331-3c0b06946e5f?periodLength=1&periodsToCompare=1",
"protocol": "https",
"host": [
"app-ecos-apache-camel-test",
"azurewebsites",
"net"
],
"path": [
"services",
"api",
"codat",
"getbalancesheet",
"78d790d2-6935-41f8-9331-3c0b06946e5f"
],
"query": [
{
"key": "periodLength",
"value": "1"
},
{
"key": "periodsToCompare",
"value": "1"
}
]
}
},
"response": []
}Copy
{
"currency": "GBP",
"reports": [
{
"date": "2022-02-28T00:00:00",
"assets": {
"accountId": "",
"name": "Assets",
"value": 2985325.71,
"items": [
{
"accountId": "",
"name": "Fixed Assets",
"value": 691101.57,
"items": [
{
"accountId": "724ca578-8b5d-4bdb-ad45-e3820eee9de9",
"name": "Office Equipment",
"value": 358086.78,
"items": []
},
{
"accountId": "be3eb911-034b-42de-95db-0d58ac978b7f",
"name": "Computer Equipment",
"value": 333014.79,
"items": []
}
]
},
{
"accountId": "",
"name": "Current Assets",
"value": 2294224.14,
"items": [
{
"accountId": "1b6266d1-1e44-46c5-8eb5-a8f98e03124e",
"name": "Accounts Receivable",
"value": 207101.98,
"items": []
},
{
"accountId": "22de1660-d745-4809-a363-16b134607e66",
"name": "Prepayments",
"value": 54192.89,
"items": []
},
{
"accountId": "",
"name": "Bank",
"value": 2032929.27,
"items": [
{
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918",
"name": "Business Current Account",
"value": 2032929.27,
"items": []
}
]
}
]
}
]
},
"liabilities": {
"accountId": "",
"name": "Liabilities",
"value": 216652.54,
"items": [
{
"accountId": "",
"name": "Current Liabilities",
"value": 86652.54,
"items": [
{
"accountId": "3a872b81-d1af-4d31-9bfa-a37280b8f68c",
"name": "VAT",
"value": 2325.54,
"items": []
},
{
"accountId": "d19852a2-e292-4eb9-a909-9dadb95c0e76",
"name": "Rounding",
"value": 0,
"items": []
},
{
"accountId": "9be6382f-6b33-402d-b448-0db1dbf67a98",
"name": "Historical Adjustment",
"value": 4642.44,
"items": []
},
{
"accountId": "53bf27a7-7497-4c61-9887-dfaad5c6d80a",
"name": "Accounts Payable",
"value": 79315.7,
"items": []
},
{
"accountId": "8852a857-aa9d-4706-839f-638e9d6b5a66",
"name": "Unpaid Expense Claims",
"value": 0,
"items": []
},
{
"accountId": "3b58f7ff-fa16-453a-9931-f020816d76e7",
"name": "Interest Payables",
"value": 199.11,
"items": []
},
{
"accountId": "8636effc-50fb-45ba-8b2b-18336fa29b6b",
"name": "John Smith",
"value": 169.75,
"items": []
}
]
},
{
"accountId": "",
"name": "Long Term Liability",
"value": 130000,
"items": [
{
"accountId": "55008233-40e7-41ac-84af-2255fa028c2e",
"name": "Loan",
"value": 130000,
"items": []
}
]
}
]
},
"netAssets": 2768673.17,
"equity": {
"accountId": "",
"name": "Equity",
"value": 2768673.16,
"items": [
{
"accountId": "39225d6f-3722-4508-ac3f-a2f6ec96ad31",
"name": "Retained Earnings",
"value": 2739526.61,
"items": []
},
{
"accountId": "78828dd9-6008-4662-b43c-e9d87907fd2b",
"name": "Current Year Earnings",
"value": 29146.55,
"items": []
}
]
}
},
{
"date": "2022-01-31T00:00:00",
"assets": {
"accountId": "",
"name": "Assets",
"value": 2957253.13,
"items": [
{
"accountId": "",
"name": "Fixed Assets",
"value": 741150.22,
"items": [
{
"accountId": "724ca578-8b5d-4bdb-ad45-e3820eee9de9",
"name": "Office Equipment",
"value": 341627.29,
"items": []
},
{
"accountId": "be3eb911-034b-42de-95db-0d58ac978b7f",
"name": "Computer Equipment",
"value": 399522.93,
"items": []
}
]
},
{
"accountId": "",
"name": "Current Assets",
"value": 2216102.91,
"items": [
{
"accountId": "1b6266d1-1e44-46c5-8eb5-a8f98e03124e",
"name": "Accounts Receivable",
"value": 560238.47,
"items": []
},
{
"accountId": "22de1660-d745-4809-a363-16b134607e66",
"name": "Prepayments",
"value": 103580.52,
"items": []
},
{
"accountId": "",
"name": "Bank",
"value": 1552283.92,
"items": [
{
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918",
"name": "Business Current Account",
"value": 1552283.92,
"items": []
}
]
}
]
}
]
},
"liabilities": {
"accountId": "",
"name": "Liabilities",
"value": 207694.08,
"items": [
{
"accountId": "",
"name": "Current Liabilities",
"value": 77694.08,
"items": [
{
"accountId": "3a872b81-d1af-4d31-9bfa-a37280b8f68c",
"name": "VAT",
"value": 1582.27,
"items": []
},
{
"accountId": "d19852a2-e292-4eb9-a909-9dadb95c0e76",
"name": "Rounding",
"value": 0,
"items": []
},
{
"accountId": "9be6382f-6b33-402d-b448-0db1dbf67a98",
"name": "Historical Adjustment",
"value": 1877.84,
"items": []
},
{
"accountId": "53bf27a7-7497-4c61-9887-dfaad5c6d80a",
"name": "Accounts Payable",
"value": 74044.43,
"items": []
},
{
"accountId": "8852a857-aa9d-4706-839f-638e9d6b5a66",
"name": "Unpaid Expense Claims",
"value": 0,
"items": []
},
{
"accountId": "3b58f7ff-fa16-453a-9931-f020816d76e7",
"name": "Interest Payables",
"value": 139.06,
"items": []
},
{
"accountId": "8636effc-50fb-45ba-8b2b-18336fa29b6b",
"name": "John Smith",
"value": 50.48,
"items": []
}
]
},
{
"accountId": "",
"name": "Long Term Liability",
"value": 130000,
"items": [
{
"accountId": "55008233-40e7-41ac-84af-2255fa028c2e",
"name": "Loan",
"value": 130000,
"items": []
}
]
}
]
},
"netAssets": 2749559.05,
"equity": {
"accountId": "",
"name": "Equity",
"value": 2749559.05,
"items": [
{
"accountId": "39225d6f-3722-4508-ac3f-a2f6ec96ad31",
"name": "Retained Earnings",
"value": 2739526.61,
"items": []
},
{
"accountId": "78828dd9-6008-4662-b43c-e9d87907fd2b",
"name": "Current Year Earnings",
"value": 10032.44,
"items": []
}
]
}
}
],
"mostRecentAvailableMonth": "2022-02-28T00:00:00",
"earliestAvailableMonth": "2017-03-01T00:00:00"
}