The Trial Balance is an account-level snapshot of every ledger account's debit and credit balances as at a specific date, prepared on an accrual basis. Unlike the Profit and Loss (which reports movement over a period), the Trial Balance is point-in-time, so you can look back to the historical position of any account on any past as-of date. Each record represents one account at one as-of date and carries the period debit and credit, the year-to-date debit and credit, the account classification (Asset, Liability, Equity, Income or Expense) and the account type.
This data area lets you build alerts for reconciliations, suspense-account watches, period-close validations, and year-on-year movement checks - for example confirming total debits equal total credits at month end, flagging a non-zero suspense account, or spotting an account whose balance has moved an unexpected direction.
The AI will only look back at 12 months' worth of data.
Key Properties:
SourceLink: A stable unique key for this account-period row, in the format 'tenantId|asOfDate|accountUid'.
OrganisationName: The trading or display name of the organisation (the accounting client) this trial balance belongs to.
OrganisationLegalName: The registered legal name of the organisation, which may differ from the trading name in OrganisationName.
OrganisationRegistrationNumber: The business registration identifier for the organisation, e.g. an ABN.
OrganisationTaxNumber: The tax registration identifier for the organisation, e.g. a GST/VAT number.
AccountClassification: The standard classification of the account - one of Asset, Liability, Equity, Income or Expense.
AccountType: The ledger-specific account type, e.g. BANK, CURRENT, EXPENSE or FIXED.
AccountCode: The ledger account code or number for this account, e.g. '1000'. Distinct from AccountName.
AccountName: The human-readable name of the ledger account, e.g. 'Business Bank Account' or 'Sales Revenue'.
AsOfDate: The as-of date for this trial balance snapshot.
DebitAmount: The period debit amount for the account.
CreditAmount: The period credit amount for the account.
YtdDebitAmount: The year-to-date debit amount for the account.
YtdCreditAmount: The year-to-date credit amount for the account.
BaseCurrency: The ISO currency code of the organisation's base/reporting currency, e.g. 'AUD'. All amounts on this row are in this currency.
AccountingMethod: The accounting basis for these balances - always 'ACCRUAL' for this data type.
📝 Example Alerts
Alert me when the Suspense account has a non-zero balance as of the last day of the month.
Alert me when total debits do not equal total credits on the trial balance at month end.
Alert me when any expense account year-to-date debit exceeds last year's full-year total.
Alert me when Accounts Receivable has a credit balance (which usually indicates overpayments or misallocations).
Alert me when the GST Liability account year-to-date credit is more than $50,000 above the year-to-date debit.