Overview
Report tools generate financial statements and analysis from your General Ledger data.Available Tools
finance_report_trial_balance
Generate a trial balance report. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
posting_period_id | string | Yes | Accounting period ID |
include_zero_balances | boolean | No | Include accounts with zero balance |
finance_report_income_statement
Generate an income statement (profit & loss). Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
start_date | string | Yes | Start date (YYYY-MM-DD) |
end_date | string | Yes | End date (YYYY-MM-DD) |
posting_period_id | string | No | Filter by period |
finance_report_balance_sheet
Generate a balance sheet as of a specific date. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
as_of_date | string | Yes | Date for balance sheet (YYYY-MM-DD) |
posting_period_id | string | No | Filter by period |
finance_report_cash_flow
Generate a cash flow statement. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
start_date | string | Yes | Start date (YYYY-MM-DD) |
end_date | string | Yes | End date (YYYY-MM-DD) |
posting_period_id | string | No | Filter by period |
finance_report_general_ledger
Generate a detailed general ledger report for an account. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
account_id | string | Yes | Account ID |
posting_period_id | string | Yes | Accounting period |
finance_report_account_activity
Get account activity summary. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
account_id | string | Yes | Account ID |
start_date | string | Yes | Start date |
end_date | string | Yes | End date |
finance_report_aged_receivables
Generate accounts receivable aging report. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
as_of_date | string | No | Date for aging (default: today) |
bucket_size | number | No | Days per bucket (default: 30) |
buckets | number | No | Number of buckets (default: 3) |
finance_report_aged_payables
Generate accounts payable aging report. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
as_of_date | string | No | Date for aging (default: today) |
bucket_size | number | No | Days per bucket (default: 30) |
buckets | number | No | Number of buckets (default: 3) |
finance_report_budget_vs_actual
Compare budget to actual results. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
budget_id | string | Yes | Budget ID |
posting_period_id | string | Yes | Period to compare |
finance_report_custom
Generate a custom report with specified parameters. Parameters:| Parameter | Type | Required | Description |
|---|---|---|---|
report_type | string | Yes | Report type identifier |
parameters | object | Yes | Report-specific parameters |