Transaction Activity gives you one row per client for each calendar month, with a count of how many transactions of each type were created that month, calculated directly from the ledger. Each count is bucketed by the record's own event date - invoices by invoice date, bills by bill date, bank transactions by transaction date, payments by payment date, and so on - and deleted or voided records are excluded. Use this data area to alert on a client's monthly transaction volume: either the all-types total, or a chosen subset of types (for example, excluding the sales side by summing only bills, bank transactions and purchase orders).
It covers the 14 transactional types - invoices, credit notes, pre-payments, bills, bank transactions, fixed asset purchases, purchase orders, manual journals, quotes, bank statement lines, payments, pay runs, employees paid, and bank transfers - plus a TotalTransactionCount across all of them. Reference and snapshot data (chart of accounts, bank accounts, contacts, the organisation, balance sheet, profit and loss, budgets, employees, super funds and tracking categories) is not counted, because it has no monthly event. The most recent month may be the current month-to-date and therefore only partial, so exclude it when your alert is about completed months.
The AI will only look back at 13 months' worth of data.
Key Properties:
SourceLink: A stable unique key for this client-month row, in the format 'tenantId|YYYY-MM'.
OrganisationName: The trading or display name of the organisation (the accounting client) this row belongs to.
BaseCurrency: The ISO base currency code of the organisation, for example 'AUD', 'NZD' or 'GBP'.
CountryCode: The ISO country code of the organisation, for example 'AU', 'NZ' or 'GB'.
PeriodStart: The inclusive first day of the calendar month this row covers.
PeriodEnd: The inclusive last day of the calendar month this row covers. This is the date field to use for time-based questions on this data type (for example, 'last month' or 'the last 2 completed months').
InvoiceCount: The number of invoices dated in this month (by invoice date).
CreditNoteCount: The number of credit notes dated in this month (by credit note date).
PrePaymentCount: The number of pre-payments dated in this month (by pre-payment date).
BillCount: The number of bills dated in this month (by bill date).
BankTransactionCount: The number of bank transactions (spend or receive money) dated in this month (by transaction date).
FixedAssetCount: The number of fixed assets acquired in this month (by purchase date).
PurchaseOrderCount: The number of purchase orders dated in this month (by purchase order date).
ManualJournalCount: The number of manual journals dated in this month (by journal created date).
QuoteCount: The number of quotes dated in this month (by quote date).
BankStatementCount: The number of imported bank statement lines dated in this month (by statement transaction date).
PaymentCount: The number of payments dated in this month (by payment date).
PayRunCount: The number of pay runs paid in this month (by pay run payment date).
EmployeesPaidCount: The number of distinct employees paid in this month (across that month's pay runs). This is a headcount, not a document count, so it is not included in TotalTransactionCount.
BankTransferCount: The number of bank transfers dated in this month (by transfer date).
TotalTransactionCount: The total number of transaction documents in this month - the sum of every count above except EmployeesPaidCount. Threshold this for an 'all transaction types' monthly volume alert, or sum a chosen subset of the count fields for a per-type-scoped alert (for example, excluding the sales side).
📝 Example Alerts
Alert me once when a client has more than 350 transactions in total in a single calendar month.
Alert me when a client's total monthly transaction count exceeds 500 in either of the last 2 completed months.
Alert me when bills, bank transactions and purchase orders together exceed 300 in a month, ignoring the sales side.
Alert me when a client's total monthly transactions jump more than 50% above the same month last year.
Alert me when a client processes more than 200 invoices in a single month.