The Balance Sheet is a financial statement that provides a snapshot of a business's financial position at a single point in time (a specific date). Each record represents one ledger account, with its classification, type, code, name and closing balance as at the report date. Use this data area to monitor equity, asset and liability accounts and to set up alerts on the balance of a named account or group of accounts - for example a non-zero suspense or tax-liability account, or total assets falling below a threshold.
The AI only holds the most recent balance sheet snapshot (the latest report date). It cannot compare values over time or across periods - for movement and variance questions use Profit and Loss or Account Variance instead.
Key Properties:
AccountClassification: The broad account grouping - one of Asset, Equity, Expense, Income, Liability or Unknown. Use this for high-level groupings such as all liability accounts; for finer sub-types use AccountType.
AccountType: The account sub-type within the classification, e.g. CURRLIAB (current liability), TERMLIAB (term liability), PAYGLIABILITY (PAYG withholding payable), SUPERANNUATIONLIABILITY (super payable), BANK, EQUITY, EXPENSE or REVENUE. Not every ledger populates these specific sub-types - fall back to matching AccountName when the type is generic or Unknown.
AccountCode: The account code from the chart of accounts (free text, e.g. '4000'). Tenant-specific and not a stable identifier across ledgers.
AccountName: The human-readable account name as it appears in the ledger chart of accounts (e.g. 'Wages Payable - Payroll', 'PAYG Withholdings'). This is the primary field for matching a named account from your question - matched case-insensitively / by substring.
AccountBalance: The closing balance of the account at the report date. This is a single point-in-time value, not a period movement or variance, and is the field used for threshold checks (e.g. is not 0, below 1 million).
ReportDate: The date the balance sheet figures are stated as at (the point in time of the snapshot). This is the primary date field for the data area.
AccountOnWatchlist: True if the account is on the firm's watchlist. Filter on this to monitor only watchlisted accounts.
SourceLink: A deep link / identifier back to the source balance-sheet account in the ledger. An opaque reference used for linking, not a value for threshold or matching checks.
📝 Example Alerts
Alert me when the Tax Liabilities account balance is not zero.
Alert me when the Unpaid Expense Claims account balance is greater than zero.
Alert me when the account named suspense is > 0 after the 30th of June.
Alert me when net assets on the balance sheet are negative.
Alert me when cash on hand is less than total outstanding creditors.