All Collections
Automation
Custom XBerts
Bank Statement Transaction
Bank Statement Transaction
Jhanav Lakhiani avatar
Written by Jhanav Lakhiani
Updated over a week ago

The Bank Statement Transaction represents a transaction made through a bank account, including detailed information such as dates, amounts, and transaction types. It also includes line items associated with the transaction.

The AI will only look back at 12 months' worth of data.

Key Properties:

  1. Transaction ID: A unique identifier for the transaction.

  2. Bank Account Name: The name of the bank account.

  3. Current Balance: The current balance of the bank account.

  4. Transaction Type: The type of transaction (e.g., Deposit, Withdrawal).

  5. Transaction Date: The date when the transaction occurred.

  6. Reference: A reference code or description for the transaction.

  7. Reconciled: Indicates if the transaction has been reconciled.

  8. Currency Code: The currency code (e.g., AUD).

  9. SubTotal: The subtotal amount before tax and other charges.

  10. Total Tax: The total tax amount for the transaction.

  11. Total Amount: The total amount of the transaction including tax.

  12. Creation Time: The date and time when the transaction was created.

  13. Has Attachments: Indicates if the transaction has attachments.

  14. Lines: A list of bank transaction line items detailing individual charges.

Example Alerts

Any transactions that are not reconciled and are older than five days.
Alert me if a transaction from ATO has not happened in Jan or Feb.
Alert me when the total amount for a transaction exceeds $10,000.
Alert me when any transactions are not reconciled and are older than 60 days.
Let me know when I do not have a payment from Superchoice in January, April, July or October.
Alert me when a client has significantly more money coming in this month compared to the last few months.
What are the 3 worst clients in terms of reconciling work that needs to be done.

Did this answer your question?