---
title: Account Balance Function
description: Claude skill explanation of the Account Balance function parameters
---

[Skip to content](https://help.finaticalsoftware.com/en/home/skill-account-balance-function#main-content)

![Finatical Software](https://help.finaticalsoftware.com/hs-fs/hubfs/finatical-software.png?width=400&height=69&name=finatical-software.png)

Open main navigation

Close main navigation

 How can we help you?

- There are no suggestions because the search field is empty.

1. [Knowledge Base](https://help.finaticalsoftware.com/en/home?hsLang=en)
2. [Flash Reports Claude Skill](https://help.finaticalsoftware.com/en/home/flash-reports-claude-skill?hsLang=en)

# 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.

- [Documentation](https://help.finaticalsoftware.com/en/home/documentation?hsLang=en#main-content)

    - [Support](https://help.finaticalsoftware.com/en/home/documentation?hsLang=en#support)
- [FAQ](https://help.finaticalsoftware.com/en/home/faq?hsLang=en)
- [Support](https://help.finaticalsoftware.com/en/home/support?hsLang=en)
- [Flash Reports Claude Skill](https://help.finaticalsoftware.com/en/home/flash-reports-claude-skill?hsLang=en)

[![Finatical Software](https://help.finaticalsoftware.com/hs-fs/hubfs/finatical-software.png?width=200&height=35&name=finatical-software.png "Finatical Software")](http://finaticalsoftware.com)

<https://www.youtube.com/@finaticalsoftware/videos> <https://www.facebook.com/profile.php?id=61564155983162> <https://www.linkedin.com/company/finatical-software>

Copyright © 2025, Finatical Software