Tool reference
Reports
The trial balance, income statement, balance sheet and the dashboard's figures and monthly trend, each a REST route with the same parameters and the same answer.
trial_balance
Trial balance of one entity for [from, to): beginning balance, debits, credits, the year-end closing entry's debits and credits (closing_debits, closing_credits) and ending balance per account, posted entries only, as decimal strings. A debit balance is positive.
GET https://auth.42six.ai/functions/v1/api/v1/trial-balance| Parameter | Description |
|---|---|
| entityRequired | Entity id (uuid), from list_entities. |
| fromRequired | Start date, YYYY-MM-DD, inclusive. |
| toRequired | End date, YYYY-MM-DD, exclusive. |
| cursorOptional | The next_cursor of the previous page. |
| limitOptional | Rows per page, 1 to 1000 (default 1000). |
income_statement
Income statement (profit and loss) of one entity for [from, to): revenue, cost of goods sold, gross profit, operating expenses, operating income, other income and expense, separately stated items and net income, each block with its accounts, as decimal strings. Period activity only, the figures the 42six app shows.
GET https://auth.42six.ai/functions/v1/api/v1/income-statement| Parameter | Description |
|---|---|
| entityRequired | Entity id (uuid), from list_entities. |
| fromRequired | Start date, YYYY-MM-DD, inclusive. |
| toRequired | End date, YYYY-MM-DD, exclusive. |
balance_sheet
Balance sheet of one entity at the close of as_of: assets, liabilities and equity with their accounts, the net income since the last year-end close and whether it balances, as decimal strings. The figures the 42six app shows.
GET https://auth.42six.ai/functions/v1/api/v1/balance-sheet| Parameter | Description |
|---|---|
| entityRequired | Entity id (uuid), from list_entities. |
| as_ofRequired | Date, YYYY-MM-DD, inclusive. |
analytics
The dashboard's key figures for one entity over a preset window (mtd, qtd, ytd or t12, ending on as_of, default today in UTC): revenue, cost of goods sold, gross profit, operating expenses, total expenses, operating income, net income and bank cash (beginning, ending, change), each with the same window a year earlier, the change and the percentage change (null without a positive prior), plus gross, operating and net margins with their change in points. Decimal strings; the figures the 42six dashboard shows.
GET https://auth.42six.ai/functions/v1/api/v1/analytics| Parameter | Description |
|---|---|
| entityRequired | Entity id (uuid), from list_entities. |
| presetOptional | mtd, qtd, ytd (default) or t12: month, quarter or year to date, or the trailing twelve months. |
| as_ofOptional | The window's last day, YYYY-MM-DD, inclusive (default today in UTC). |
cash_flow
The dashboard's monthly trend for one entity over a preset window (mtd, qtd, ytd or t12, ending on as_of, default today in UTC): for each calendar month in [from, to), clipped to the window, its revenue, expenses (cost of goods sold plus operating expenses) and net income, and the window's totals, as decimal strings. The figures the 42six dashboard's chart shows.
GET https://auth.42six.ai/functions/v1/api/v1/cash-flow| Parameter | Description |
|---|---|
| entityRequired | Entity id (uuid), from list_entities. |
| presetOptional | mtd, qtd, ytd (default) or t12: month, quarter or year to date, or the trailing twelve months. |
| as_ofOptional | The window's last day, YYYY-MM-DD, inclusive (default today in UTC). |