latestOpenAPI 3.0.02026-08-10233809957.8 KB
5cdfae3fa1fa
Balance Sheets
List Balance Sheets
Supported for:
freshbooks quickbooks quickbooksDesktop xero dynamicsBusinessCentral zohoBooks byod
get/v2/accounting/balanceSheets
Query parameters
connectionUuidstring required
Unique connection identifier.
accountingMethod'cash' | 'accrual'
reportFrequency'month' | 'quarter' | 'year' required
startDatestring
endDatestring
section'Assets' | 'Liabilities' | 'Equity'
subSection'Current Assets' | 'Non-Current Assets' | 'Current Liabilities' | 'Non-Current Liabilities' | 'Equity' | 'Other Assets' | 'Other Liabilities' | 'Expenses'
groupstring
subGroupstring
accountIdstring
subAccountIdstring
accountstring
valuenumber float
offsetnumber
limitnumber
orderBystring
Response
Example response
{
"reports": [
{
"meta": {
"connectionUuid": "CON-396d5daa-26b2-4979-89b6-cafb2c298155",
"businessName": "Railz",
"serviceName": "xero",
"reportId": "5fad8a342a88364234392fb5",
"status": "success",
"reportFrequency": "month",
"currency": "USD",
"createdAt": "2020-11-25T01:02:03Z",
"updatedAt": "2020-11-30T01:02:03Z",
"startDate": "2020-11-25T01:02:03Z",
"endDate": "2020-12-25T01:02:03Z",
"accountingMethod": "accrual"
},
"data": [
{
"section": "Assets",
"subSection": "Current Assets",
"fullyQualifiedName": "Expenses : Transportation : Car Mileage",
"depth": 3,
"group": "Cash And Cash Equivalents",
"subGroup": "Utilities",
"accountId": "3928",
"subAccountId": "231",
"account": "Checking",
"subAccount": "Checking",
"value": 990,
"classification": "Assets",
"type": "Fixed Assets",
"subType": "Fixed Assets"
}
]
}
]
}