Affordability

The affordability object includes a summary of financial position, assets, liabilities, with links to an income object and an expenses object, for an individual user for account and transaction data stored against that user

📘

PDF response also available

The affordability API returns a JSON response by default however you can specify to return a PDF report version of the affordability summary

👍

Sandbox testing the Affordability endpoint

You will need to create a user and create or refresh all connections before creating an affordability resource. Use the Wentworth-Smith test credentials to create a connection for our test institution AU00000 before calling the Affordability endpoint. See our testing section for more information.

Attributes
typeValue of this resource is "affordability"
idThe identifier of the affordability resource to be retrieved.
fromMonthStart month for the period for which the Affordability summary is generated. The period of time relates to the account and transaction data used as input into the report.
toMonthEnd month (usually the current month) for the period for which the Affordability summary is generated.
coverageDaysNumber of days included in the report period.
generatedDateDate the report was generated. e.g. "2018-09-12T00:59:28"
Summary
assetsTotal of cash based assets
liabilitiesTotal of account based liabilities split into credit and loan liabilities
netPositionTotal assets minus total liabilities
creditLimitTotal credit limit across all credit cards and overdrafts
regularIncomeProvides an average of monthly - avgMonthly regular income calculated over the previous 3 month period previous3Months.For example:
"regularIncome": {
"previous3Months": {
"avgMonthly": "5000.00"
}
}
expensesProvides an average of monthly expenses calculated for the whole period of data retrieved (e.g. 13 months)
savingsAverage of monthly savings calculated for the whole period of data retrieved (e.g. 13 months)
Assets
typeValue of this resource is "account"
currencyThe currency in which the account is recorded.
balanceThe balance at the time of the query.
availableFundsThe available funds at the time of the query.
accountIdentifies the type and product of the account:
  • type (values as defined in class object Account Type in Accounts

  • product (as defined by the institution)

institutionThe name of the financial institution with whom the account is held.
previous6monthsIncludes minimum and maximum balances recorded in the account of the queried period.
  • minBalance

  • maxBalance

Credit Liabilities
currencyThe currency in which the account is recorded.
balanceThe balance at the time of the query.
availableFundsThe available funds at the time of the query.
accountIdentifies the type and product of the account:
  • type (values as defined in class object Account Type in Accounts

  • product (as defined by the institution)

institutionThe name of the financial institution with whom the account is held.
previousMonthA summary of the credit facility activity of the previous month, consisting of:
  • totalCredits

  • totalDebits

  • minBalance

  • maxBalance

previous6monthsAcknowledges any cash advances made in the previous 6 months:
  • cashAdvances - value of cash advances in period
creditLimitTotal credit limit available for the specified credit facility.
Loan Liabilities
currencyThe currency in which the account is recorded.
balanceThe balance at the time of the query.
availableFundsThe available funds at the time of the query.
accountIdentifies the type and product of the account:
  • type (values as defined in class object Account Type in Accounts

  • product (as defined by the institution)

institutionThe name of the financial institution with whom the account is held.
previousMonthA summary of the credit facility activity of the previous month, consisting of:
  • totalCredits

  • totalDebits

  • totalInterestCharged

  • totalRepayments

changeHistory
  • direction - debit or credit

  • amount - amount loan-interest or loan-repayment

  • date - date e.g. "2019-03-15T17:00:00"

  • source - cleaned transaction description

previous6monthsAcknowledges if the account is in repayment arrears:
  • arrears - has the loan been in arrears in the past 6 months - returned as a string value (true or false or null)
📘

External Relationships new

New Affordability feature to surface external relationships (e.g. Latitude Loans) that are held externally to the bank accounts that have not been disclosed or linked by the user e.g. surfacing buy now pay later services. These are now represented now as external payments rather than living expenses. Identified external relationships are grouped under this new attribute external. The first version of this feature is for a selection of the 32 most common merchants for small pay-day loans, buy now pay later services and collections agencies.

External
sourceSource of external payment (cleaned transaction description).
paymentsAggregated attributes relating to payments for this source (identified as an external)
  • first - date of first payment e.g. "2019-03-15"

  • last - date of last payment e.g. "2020-03-15"

  • noOccurrences - number of occurrences for same source (in this group)

  • amountAvg - average amount of payment e.g. "-50.50"

  • amountAvgMonthly - average monthly payment amount e.g. "-20.00"

  • total - amount of total payments identified for source in the affordability snapshot e.g. "-146.50"

changeHistoryEach transaction (repeated for each source ordered by most recent):
  • amount - amount of payment

  • date - date e.g. "2019-03-15"

  • source - full transaction description

Links
linksA links object containing the following members:
  • self - link to the affordability resource

  • income - income

  • expenses - expenses

  • accounts - an array of accounts
    links

🚧

You will need to create a user and create or refresh all connections before creating the affordability resource.

Returns

Returns a created affordability resource, if the operation succeeded. Returns an error if the post failed (e.g. not supplying required properties).

{
  "type": "affordability",
  "id": "s55bf3",
  "fromMonth": "2019-03",
  "toMonth": "2020-03",
  "coverageDays": 392,
  "generatedDate": "2020-03-26T06:56:44",
  "summary": {
    "assets": "59983.11",
    "liabilities": "-323946.20",
    "netPosition": "-263963.09",
    "creditLimit": "20000.00",
    "expenses": "-12046.00",
    "savings": "93.00",
    "regularIncome": {
      "previous3Months": {
        "avgMonthly": "18098.00"
      }
    }
  },
  "assets": [
    {
      "currency": "AUD",
      "balance": "35298.67",
      "availableFunds": "35298.67",
      "institution": "Hooli",
      "type": "account",
      "account": {
        "product": "Hooli Saver",
        "type": "savings"
      },
      "previous6Months": {
        "minBalance": "32427.79",
        "maxBalance": "34798.67"
      }
    },
    {
      "currency": "AUD",
      "balance": "24684.44",
      "availableFunds": "24684.44",
      "institution": "Hooli",
      "type": "account",
      "account": {
        "product": "Hooli Transaction",
        "type": "transaction"
      },
      "previous6Months": {
        "minBalance": "10032.81",
        "maxBalance": "38309.44"
      }
    }
  ],
  "liabilities": {
    "loan": [
      {
        "currency": "AUD",
        "balance": "-312233.00",
        "availableFunds": "87767.00",
        "institution": "Hooli",
        "account": {
          "type": "mortgage",
          "product": "Hooli Home Loan"
        },
        "previousMonth": {
          "totalCredits": "5768.00",
          "totalDebits": "-4303.50",
          "totalInterestCharged": "-4303.50",
          "totalRepayments": "5768.00"
        },
        "changeHistory": [
          {
            "direction": "debit",
            "amount": "-4220.75",
            "date": "2019-03-19",
            "source": "Mortgage Interest Payment 746833"
          },
          {
            "direction": "credit",
            "amount": "5768.00",
            "date": "2019-03-31",
            "source": "Transfer Platnm Homeloan 346454"
          },
          {
            "direction": "debit",
            "amount": "-4228.50",
            "date": "2019-04-19",
            "source": "Mortgage Interest Payment 746833"
          }
        ],
        "previous6Months": {
          "arrears": false
        }
      }
    ],
    "credit": [
      {
        "currency": "AUD",
        "balance": "-11713.20",
        "availableFunds": "8286.80",
        "institution": "Hooli",
        "creditLimit": "20000.00",
        "account": {
          "type": "credit-card",
          "product": "Hooli Visa"
        },
        "previousMonth": {
          "totalCredits": "0.00",
          "totalDebits": "-8287.10",
          "minBalance": "-3174.16",
          "maxBalance": "-12329.16"
        },
        "previous6Months": {
          "cashAdvances": "-2053.50"
        }
      }
    ]
  },
  "external": [
    {
      "source": "afterpay",
      "payments": {
        "first": "2019-11-15",
        "last": "2019-11-15",
        "noOccurrences": 2,
        "amountAvg": "-146.50",
        "amountAvgMonthly": "-12.00",
        "total": "-146.50"
      },
      "changeHistory": [
        {
          "amount": "-146.50",
          "date": "2019-11-15",
          "source": "AFTERPAY MELBOURNE VI AUS Card xx3854 Value Date: 10/11/2019"
        },
        {
          ...
        }
      ]
    }
  ],
  "links": {
    "self": "https://au-api.basiq.io/users/25c8d1ed77/affordability/s55bf3",
    "income": "https://au-api.basiq.io/users/25c8d1ed77/income/s55bf4",
    "expenses": "https://au-api.basiq.io/users/25c8d1ed77/expenses/s55bf5",
    "accounts": [
      "https://au-api.basiq.io/users/25c8d1ed77/accounts/20024b08",
      "https://au-api.basiq.io/users/25c8d1ed77/accounts/64880430",
      "https://au-api.basiq.io/users/25c8d1ed77/accounts/55bf3089",
      "https://au-api.basiq.io/users/25c8d1ed77/accounts/6jk43056"
    ]
  }
}