Skip to docs content

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.

REST
GET https://auth.42six.ai/functions/v1/api/v1/trial-balance
ParameterDescription
entityRequiredEntity id (uuid), from list_entities.
fromRequiredStart date, YYYY-MM-DD, inclusive.
toRequiredEnd date, YYYY-MM-DD, exclusive.
cursorOptionalThe next_cursor of the previous page.
limitOptionalRows 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.

REST
GET https://auth.42six.ai/functions/v1/api/v1/income-statement
ParameterDescription
entityRequiredEntity id (uuid), from list_entities.
fromRequiredStart date, YYYY-MM-DD, inclusive.
toRequiredEnd 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.

REST
GET https://auth.42six.ai/functions/v1/api/v1/balance-sheet
ParameterDescription
entityRequiredEntity id (uuid), from list_entities.
as_ofRequiredDate, 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.

REST
GET https://auth.42six.ai/functions/v1/api/v1/analytics
ParameterDescription
entityRequiredEntity id (uuid), from list_entities.
presetOptionalmtd, qtd, ytd (default) or t12: month, quarter or year to date, or the trailing twelve months.
as_ofOptionalThe 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.

REST
GET https://auth.42six.ai/functions/v1/api/v1/cash-flow
ParameterDescription
entityRequiredEntity id (uuid), from list_entities.
presetOptionalmtd, qtd, ytd (default) or t12: month, quarter or year to date, or the trailing twelve months.
as_ofOptionalThe window's last day, YYYY-MM-DD, inclusive (default today in UTC).