latestOpenAPI 3.0.02026-08-10233809957.8 KB
5cdfae3fa1fa
Financial Ratios
List Financial Ratios
Supported for:
freshbooks quickbooks quickbooksDesktop xero dynamicsBusinessCentral zohoBooks byod
get/v2/analytics/financialRatios
Query parameters
connectionUuidstring required
Unique connection identifier.
reportFrequency'month' | 'quarter' | 'year' required
startDatestring
endDatestring
ratio'averageCollectionPeriod' | 'grossBurnRate' | 'inventoryTurnoverRatio' | 'assetTurnoverRatio' | 'payablesConversionPeriod' | 'accountsReceivableTurnoverRatio' | 'accountsPayableTurnoverRatio' | 'daysPayableOutstanding' | 'daysSalesOutstanding' | 'averageOutstandingPayablesBalance' | 'averageOutstandingReceivablesBalance' | 'churnRate' | 'equityToLTAssets' | 'shortDebtToEquityRatio' | 'debtToEquityRatio' | 'interestBankLoan' | 'interestCoverageRatio' | 'debtToAssetsRatio' | 'debtServiceCoverageRatio' | 'leverageIndex' | 'leverageRatio' | 'quickRatio' | 'absoluteLiquidity' | 'currentRatio' | 'grossBurn' | 'runway' | 'cashRatio' | 'freeCashflowRatio' | 'cashFlowCoverageRatio' | 'debtToEnterpriseValue' | 'returnOnAssets' | 'ebitda' | 'ebitdaMargin' | 'workingCapital' | 'freeCashFlow' | 'grossMargin' | 'netProfitMargin' | 'operatingMargin' | 'returnOnEquity' | 'revenueConcentrationIndex' | 'totalAccrualsTotalAssets' | 'sgaExpensesIndex' | 'salesGrowthIndex' | 'grossMarginIndex' | 'monthlyRecurringRevenue' | 'monthlyRecurringRevenueRate' | 'annualRecurringRevenue' | 'annualRecurringRevenueRate' | 'depreciationIndex' | 'assetQualityIndex' | 'daysSalesReceivablesIndex'
ratioType'credit' | 'efficiency' | 'leverage' | 'liquidity' | 'market' | 'profitability' | 'reliability'
offsetnumber
limitnumber
orderBystring
reconstruct'true' | 'false'
Railz reconstructed Financial Ratio
Response
Example response
{
"count": 1,
"ratios": [
{
"meta": {
"connectionUuid": "CON-396d5daa-26b2-4979-89b6-cafb2c298155",
"businessName": "Railz",
"serviceName": "xero",
"reportId": "5fad8a342a88364234392fb5",
"startDate": "2020-11-25T01:02:03Z",
"endDate": "2020-12-25T01:02:03Z",
"reportFrequency": "month",
"createdAt": "2020-11-25T01:02:03Z",
"updatedAt": "2020-11-30T01:02:03Z"
},
"data": {
"credit": {
"averageCollectionPeriod": 36.5
},
"efficiency": {
"grossBurnRate": 56223.25,
"inventoryTurnoverRatio": 2.78891542,
"assetTurnoverRatio": 3.83548112,
"payablesConversionPeriod": 83,
"accountsReceivableTurnoverRatio": 15.55,
"accountsPayableTurnoverRatio": 8.99,
"daysPayableOutstanding": 42.26,
"daysSalesOutstanding": 34.19,
"averageOutstandingPayablesBalance": 100.99,
"averageOutstandingReceivablesBalance": 29.01,
"churnRate": 1
},
"leverage": {
"equityToLTAssets": 0.26784885,
"shortDebtToEquityRatio": 0.87117832,
"debtToEquityRatio": 1.03899521,
"interestBankLoan": 1.03899521,
"interestCoverageRatio": 3.48778221,
"debtToAssetsRatio": 0.89995561,
"debtServiceCoverageRatio": 4.20509522,
"leverageIndex": 0.878,
"leverageRatio": 0.067
},
"liquidity": {
"quickRatio": 0.88811223,
"absoluteLiquidity": 530167.93,
"currentRatio": 1.10856651,
"grossBurn": 382071.92,
"runway": 12.84898122,
"cashRatio": 0.73314452,
"freeCashflowRatio": 0.45151529,
"cashFlowCoverageRatio": 0.09030305
},
"market": {
"debtToEnterpriseValue": 0.19155987
},
"profitability": {
"returnOnAssets": 0.09109873,
"ebitda": 278309.39,
"ebitdaMargin": 0.32309803,
"workingCapital": 78903.24,
"freeCashFlow": 129834.37,
"grossMargin": 0.48199755,
"netProfitMargin": 0.16412058,
"operatingMargin": 0.06156661,
"returnOnEquity": 0.15532511,
"revenueConcentrationIndex": 2.58889925,
"totalAccrualsTotalAssets": 0.044,
"sgaExpensesIndex": 1.11,
"salesGrowthIndex": 0.755,
"grossMarginIndex": 1.556,
"annualRecurringRevenue": 0.814,
"annualRecurringRevenueRate": 0.266,
"monthlyRecurringRevenue": 1.556,
"monthlyRecurringRevenueRate": 0.389
},
"reliability": {
"assetQualityIndex": 0.608,
"depreciationIndex": 0.801,
"daysSalesReceivablesIndex": 0.814
}
}
}
]
}