Skip to main content

Bank Feed Line

For monitoring unusual transactions.

Written by Marsha Galicia

The Bank Feed Line represents an individual line on a bank statement, such as a single payment, receipt or transfer. It captures the bank account it belongs to, the transaction date, signed amount, running balance, narration and reference, whether the line has been reconciled, and how it entered XBert. Use this data area to monitor unusual or unreconciled bank activity, watch for missing recurring transactions, and flag large or out-of-pattern movements.
​


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

Key Properties:

  1. Client: Name of the accounting client (tenant) this bank statement line belongs to.

  2. Bank_Account_Name: Name of the bank account this statement line was imported into (e.g. "Business Cheque").

  3. Bank_Account_Currency: ISO currency code of the bank account, e.g. "AUD", "USD", "GBP". Amount and Balance are in this currency.

  4. Transaction_Date: Date this transaction occurred on the bank statement. Use this for all time-based filtering, ageing, and for deriving the BAS/GST or VAT period (there is no separate period field).

  5. Amount: Signed value of this bank statement line in the account currency. Negative = money out (debit/payment), positive = money in (credit/receipt). This is the value of the transaction itself, not the running balance — use Balance for that.

  6. Description: Free-text narration/description of the transaction as it appears on the bank statement (e.g. "Payment Received").

  7. Reference: Free-text payment reference shown on the bank statement line (e.g. an invoice number or payee note).

  8. Is_Reconciled: Whether this bank statement line has been reconciled. A text value of either "Yes" or "No" (not a true/false flag). To find unreconciled lines, look for "No".

  9. Source: How the statement line entered XBert. One of "BankFeed", "Imported", "TransactionList" or "User".

  10. Balance: Running bank account balance after this statement line, in the account currency. This is not the value of this transaction — use Amount for that.

  11. AccountType: Type of bank account this line belongs to. One of "BANK", "CREDITCARD" or "PAYPAL".

📝 Example Alerts

Alert me when a bank statement transaction is unreconciled for more than 5 days
Alert me when there is no transaction from Microsoft in January or February
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.
Alert me when there is no payment to Superchoice in January, April, July or October
Related Articles
Did this answer your question?