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
      }
    }
  ]
}

Did this page help you?