Bank Reconciliation

Overview

From the Bank Reconciliation endpoint, you can retrieve the accounting accuracy and descriptive statistics of a business. See Bank Reconciliation endpoint for more details.

❗️
Data Dependencies
Bank reconciliation requires active banking and accounting connections. Missing dependencies may result in incomplete fraud metrics.

Data Model

📘
The bank reconciliation object is part of an array of reports. See Reports data type for more details on the report structure and its meta-data.

Field	Type	Description
bankTransactionsCount	integer	The number of bank transactions inputed to the endpoint.
accountingTransactionsCount	integer	The number of accounting transactions inputed to the endpoint.
bankTransactionsAmount	decimal	Total net amount of bank transactions calculated through the sum of all debit and credit bank transaction amounts.
accountingTransactionsAmount	decimal	Total net amount of accounting transactions calculated through the sum of all debit and credit accounting transaction amounts.
bankTransactionsTotalValue	decimal	Total value of bank transactions calculated through the sum of the absolute value of all bank transaction amounts.
accountingTransactionsTotalValue	decimal	Total value of accounting transactions calculated through the sum of the absolute value of all accounting transaction amounts.
weightedPercentageError	decimal	Percentage value of reconciled transactions weighted by their transaction value against the total bank transaction value.
accuracyScore	decimal	Accuracy score in percentage, where 100% is a perfectly reconciled dataset.
bankTransactionsUnreconciledCount	integer	The number of unreconciled bank transactions.
bankTransactionsUnreconciledAmount	decimal	Sum of the absolute amount of unreconciled bank transactions.
dailyAccuracyScore	decimal	Similar to accuracyScore but based on a daily matching view in the range of 0 to 1.
unreconciledBankTransactions	array	An array of unreconciled bank transactions.
reconciledBankTransactions	array	An array of reconciled bank transactions.

Bank Transactions

Field	Type	Description
id	string	Bank transaction id.
date	string See Date	Bank transaction date.
amount	decimal	Bank transaction amount.

Example Data

{
  "data":
  [
    {
      "bankTransactionsCount": 35,
      "accountingTransactionsCount": 50,
      "bankTransactionsAmount": 105.5,
      "accountingTransactionsAmount": 750.5,
      "bankTransactionsTotalValue": 109.95,
      "accountingTransactionsTotalValue": 500.5,
      "weightedPercentageError": 1,
      "accuracyScore": 50.5,
      "bankTransactionsUnreconciledCount": 25,
      "bankTransactionsUnreconciledAmount": 109.95,
      "dailyAccuracyScore": 0.24,
      "unreconciledBankTransactions":
      {
        "id": "lPNjeW1nR6CDn5okmGQ6hEpMo4lLNoSrzqDje",
        "date": "2017-01-29",
        "amount": 1000
      },
      "reconciledBankTransactions":
      {
        "id": "lPNjeW1nR6CDn5okmGQ6hEpMo4lLNoSrzqDje",
        "date": "2017-01-29",
        "amount": 1000
      }
    }
  ]
}

Overview

❗️Data Dependencies

Data Model

📘

Bank Transactions

Example Data

❗️
Data Dependencies