Account Balance Function
Explanation of the function parameters.
| # | Parameter | Description |
| 1 | Company | QuickBooks company name to retrieve balances for |
| 2 | Report Period / Start Date | Named period (e.g. "Last Month") OR a specific start date |
| 3 | End Date | Required (and must be a date) if Parameter 2 is a start date; otherwise must be blank |
| 4 | Actual | "Actual", a Budget name, "Actual - Cash Method", "Actual – Accrual Method", or "Actual - Cash Flow" (for Cash Flow report movements) |
| 5 | Account | Account to retrieve balances for (see Account Balance Function docs for details) |
| 6 | Display Columns By | Optional. One of: Class, Department (aka Location), Customer, Vendor, Product/Service |
| 7 | Column Value | Required if Parameter 6 is set; valid value for that dimension |
| 8-12 | Filters (Class, Department/Location, Customer, Vendor, Product/Service) | Optional filters to restrict the report scope |
Note Display Columns By vs. Filters - a frequent point of confusion:
-
Display Columns By (Params 6–7): use when the report shows multiple values of a dimension across columns, with a balance returned for each.
-
Filters (Params 8–12): use when the entire report should be restricted to one dimension value. Typically shown once in the report header, with all Account Balance functions referencing that cell via the relevant filter parameter.