Regular Transactions Schema for Egress

Schema

FieldTypeOptionalDescription
seriesIdString (UUID)NoThe ID of the regular transaction series.
accountIdStringNoThe ID of the account the transactions belong to.
userIdStringYesThe ID of the user the transactions belong to.
typeStringNoWhether the series contains income or payment transactions (one of: income, payment).
subtypeStringYesThe subtype of the series (one of: directDebit, standingOrder, frequentVisit, committedCardPayment, other).
frequencyStringNoThe frequency at which transactions occur in the series (one of: yearly, quarterly, monthly, fortnightly, weekly).
descriptionStringNoThe full description of the latest transaction in the series.
cleanedDescriptionStringNoThe cleaned description of the latest transaction in the series.
matchMethodStringNoThe method used to match transactions in the series.
stitchedBooleanNoWhether the series has been stitched together from multiple series.
numTxMatchedInSeriesIntegerNoThe number of transactions contained in the series.
gapLengthInFreqUnitsIntegerNoIf the series contains a gap, the number of whole frequency units that are missing.
dateAnomaliesCountIntegerNoThe number of date anomalies detected in the series.
numReturnedTxsIntegerNoThe number of returned transactions (reversed or declined) contained in the series.
lastDateString (Date)NoThe date of the latest transaction in the series.
predictedDateString (Date)NoThe predicted date of the next transaction in the series.
predictedDateEarliestString (Date)YesThe earliest predicted date at which the next transaction could occur in the series.
predictedDateLatestString (Date)YesThe latest predicted date at which the next transaction could occur in the series.
predictedDateMethodStringNoThe method used to predict the next transaction date.
predictedTxLateOrNotDetectedBooleanYesWhether the next predicted transaction is overdue or not detected.
predictedAmountNumberNoThe predicted amount of the next transaction in the series (in currency base units, e.g. pounds/dollars, not minor units).
predictedAmountLowerNumberYesThe lower bound of the amount predicted for the next transaction in the series (in currency base units).
predictedAmountUpperNumberYesThe upper bound of the amount predicted for the next transaction in the series (in currency base units).
predictedAmountMethodStringNoThe method used to predict the next transaction amount.
currencyStringYesThe currency code (e.g. GBP, USD).
predictedCategoryIdStringNoThe ID of the predicted category.
analysisCategoryStringYesThe analysis category for the series.
transactionsArray<Object>NoThe transactions contained within the series. Each object contains: uid, date, amount, categoryId, description, cleanedDescription.

Example

{
  "seriesId": "45f004dc-254f-5d09-b07f-8d4de4487781",
  "accountId": "090ea264-eb48-494c-9d59-1b10b322c3e1",
  "userId": null,
  "type": "payment",
  "subtype": "frequentVisit",
  "frequency": "quarterly",
  "description": "Dentist Checkup",
  "cleanedDescription": "Dentist Checkup",
  "matchMethod": "default",
  "stitched": false,
  "numTxMatchedInSeries": 4,
  "gapLengthInFreqUnits": 0,
  "dateAnomaliesCount": 0,
  "numReturnedTxs": 0,
  "lastDate": "2026-01-20",
  "predictedDate": "2026-04-20",
  "predictedDateEarliest": "2026-04-20",
  "predictedDateLatest": "2026-04-21",
  "predictedDateMethod": "sameDay",
  "predictedTxLateOrNotDetected": false,
  "predictedAmount": -65,
  "predictedAmountLower": -65,
  "predictedAmountUpper": -65,
  "predictedAmountMethod": "sameAmount",
  "currency": "GBP",
  "predictedCategoryId": "11",
  "analysisCategory": null,
  "transactions": [
    {
      "uid": "TXN-090ea264-775",
      "date": "2026-01-20",
      "amount": -65,
      "categoryId": "11",
      "description": "Dentist Checkup",
      "cleanedDescription": "Dentist Checkup"
    },
    {
      "uid": "TXN-090ea264-774",
      "date": "2025-10-20",
      "amount": -65,
      "categoryId": "11",
      "description": "Dentist Checkup",
      "cleanedDescription": "Dentist Checkup"
    },
    {
      "uid": "TXN-090ea264-773",
      "date": "2025-07-20",
      "amount": -65,
      "categoryId": "11",
      "description": "Dentist Checkup",
      "cleanedDescription": "Dentist Checkup"
    },
    {
      "uid": "TXN-090ea264-772",
      "date": "2025-04-20",
      "amount": -65,
      "categoryId": "11",
      "description": "Dentist Checkup",
      "cleanedDescription": "Dentist Checkup"
    }
  ]
}