get budget vs actuals
get_budget_vs_actualsGenerate the QuickBooks budget vs actuals report. Returns { columns, column_types, rows }: each row has a type (section | data | total), a depth, and values aligned to columns (Money cells as numbers, first cell is the label on summary reports); id is the label cell's QuickBooks record id (e.g. the account); on detail reports ids aligns to values instead. All-zero rows are omitted and counted in hidden_zero_rows. filters lists the filters QuickBooks confirms it applied (a parameter it ignored is absent), and no_data: true means the period has nothing to report.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| params | No | QuickBooks report query parameters. All four are required: budget (a Budget Id, from search_budgets), start_date, end_date (YYYY-MM-DD) and rowaxis ('primary' for accounts). Optional: summarize_column_by (Total|Month|Quarter|Year|Classes|Departments|Customers), accounting_method (Cash|Accrual). QuickBooks answers 'Permission Denied' when the budget id is missing or unknown, so read it with search_budgets first. | |
| company | No | Which connected QuickBooks company to use (name, realm id, or connection id). Optional when only one company is connected. |