The Bank Account data area holds information about each bank account in the accounting system — its name, type, currency, current balance and how recently it has had bank-feed activity. Use it to write alerts that watch for dormant or stale accounts, unexpected balances, missing bank feeds, or unusual transaction volumes.
The AI will only look back at 12 months' worth of data.
If you want the individual transactions that have happened in a bank feed, use the Bank Transactions data area instead. This data area is about the bank account itself.
Key Properties:
SourceLink: A link to this bank account in the accounting system, used as the unique reference for the account.
BankAccountName: The human-readable name of the bank account as it appears in the accounting system (e.g. "Orange Business").
Status: The activation state of the account in the ledger — one of ACTIVE, ARCHIVED or EMPTY. Archived accounts are typically dormant or closed.
AccountType: The kind of bank account — one of BANK, CREDITCARD or PAYPAL. For a CREDITCARD a negative balance is normal; for a BANK account a negative balance signals an overdraft.
CurrencyCode: The ISO currency code of the account (e.g. "AUD", "USD"). All money fields (CurrentBalance, ThreeMonthAverage) are denominated in this currency.
CurrentBalance: The balance as of the most recent imported bank-feed statement line (or the ledger balance for non-Xero systems). It may lag the live balance by the feed delay, and is denominated in CurrencyCode.
LastTransactionDate: The date of the most recent bank-feed / statement line on the account. This is the last time the bank feed had a transaction, not the last reconciled ledger transaction — use it for staleness or last-upload checks.
ThreeMonthTransactionCount: The number of bank-feed transactions on the account over the last 90 days. This is a count, not an average and not a dollar value; it is 0 when the account has no recent feed activity.
ThreeMonthAverage: The average signed dollar value of bank-feed transactions on the account over the last 90 days. It can be negative and is not an average balance and not a count. Denominated in CurrencyCode.
HasImportedTransactions: Whether the account has at least one imported / bank-feed transaction in the look-back window. It is false when none are found or no feed is connected.
📝 Example Alerts
Create an alert if the last transaction date is older than 20 days.
Create an alert if a bank account's current balance drops below $3000.
Alert me when a bank account has had no transactions in the last 30 days.
Alert me when the balance of an account named "Main Operating" drops below $100,000.
Alert me when a bank account's 3-month transaction count exceeds 500.
Alert me when an archived bank account still has a non-zero balance.