The Journal Transaction represents a journal posted to the ledger, including manual journals, general journal entries and the journals generated behind accounts payable, accounts receivable and bank-transfer activity. It captures the journal's source/type, dates, references, status and reversal information, along with the individual journal lines that make up the entry.
It supports alerts about how and when journals are posted - for example manual journals left in draft, journals posted around a period boundary, journals against a particular account, or entries that are posted and then reversed.
The AI will only look back at 12 months' worth of data.
Key Properties:
JournalSource: The source/type of the journal, such as a manual journal (MANJOURNAL), a general journal entry (JOURNALENTRY), accounts payable (ACCPAY), accounts receivable (ACCREC) or a bank transfer (TRANSFER).
PostedDate: The accounting/effective date the journal is posted to the ledger. This is the date used for all period, quarter, financial-year and time-based reporting.
CreatedDate: The date the journal record was created in the ledger. This is distinct from the PostedDate, which is the accounting/effective date.
ManualJournalStatus: The status of a manual journal - DRAFT, POSTED, VOIDED, DELETED or ARCHIVED. Only meaningful for manual journals (JournalSource = MANJOURNAL).
ManualJournalNarration: The free-text narration or memo for a manual journal, often the only place the journal's purpose (e.g. "Corporation Tax Q3") is described.
JournalNumber: The sequential journal number assigned by the ledger (e.g. JN123). This is not the user reference - see Reference.
Reference: The user or system reference for the journal (the "reference ID"). May be empty when no reference was supplied. This is distinct from the sequential JournalNumber.
OrganisationName: The name of the organisation/entity that owns this journal. This is not a supplier or customer name, and not an account name.
BaseCurrency: The base (home) currency code of the ledger this journal is posted in, in ISO 4217 format (e.g. AUD, USD). This is the ledger currency, not the currency of an individual line.
IsReversed: Indicates whether this journal has a matching reversal entry (a later journal that cancels it out). Currently populated for bank-transaction journals only.
ReversalDate: The posted/effective date of the reversing journal that cancels this entry, or empty when it has not been reversed. Compare against PostedDate to detect a reversal shortly after a reporting boundary.
SourceLink: A direct link to the journal in the source accounting system.
JournalLines: A list of the individual journal lines that make up the entry.
JournalLine
ManualJournalLineItemDescription: The description of the journal line.
LineItemNetAmount: The net amount of the line, before tax.
LineItemGrossAmount: The gross amount of the line, including tax.
LineItemTaxAmount: The tax amount for the line.
LineItemTaxTypeName: The tax type applied to the line.
TaxTypeName: The tax type name for the line, as a string (e.g. GSTonExpenses, GSTonIncome, NoTax).
AccountClassification: The broad classification of the account on the line (e.g. Income, Expense, Asset, Equity, Liability).
AccountType: The more specific type of the account on the line (e.g. BANK, CURRENT, FIXED, EXPENSE).
AccountCode: The code of the account on the line (e.g. 6100).
AccountName: The name of the account on the line.
TrackingCategories: A list of tracking category items applied to the line.
TrackingCategoryItem
TrackingCategoryName: The name of the tracking category.
TrackingCategoryOption: The selected option for the tracking category.
📝 Example Alerts
Alert me when a manual journal is posted on 30 June.
Alert me when a manual journal has been sitting in draft for more than 5 days.
Alert me when a journal line is posted to account code 6100.
Alert me when a journal is posted and then reversed within 3 days.
Alert me when a manual journal has no reference.