The Bank Reconciliation Object
From the Bank Reconciliation endpoint, you can retrieve the accounting accuracy and descriptive statistics of a business.
️ Data Dependencies
- Bank Reconciliation requires active banking and accounting connections for each period.
- Bank Reconciliation will not be available if dependencies are missing or if the service provider connected does not support the data types required. See supported data types for more details.
The bank reconciliation object is part of an array of visualization reports. See Visualizations data type for more details on the report structure and its meta-data.
| Field | Type | Description |
|---|---|---|
| bankTransactionsCount | integer | The number of bank transactions inputted to the endpoint. |
| accountingTransactionsCount | integer | The number of accounting transactions inputted 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. |
Unreconciled Bank Transactions
| Field | Type | Description |
|---|---|---|
| id | string | Bank transaction id. |
| date | string See Date | Bank transaction date. |
| amount | decimal | Bank transaction amount. |
| accountType | string | Bank transaction account type |
| accountId | string | Bank transaction account id |
Reconciled Bank Transactions
| Field | Type | Description |
|---|---|---|
| id | string | Bank transaction id. |
| date | string See Date | Bank transaction date. |
| amount | decimal | Bank transaction amount. |
| accountType | string | Bank transaction account type |
| accountId | string | Bank transaction account id |
| accountingTransactionId | string | Transaction id |
| accountingTransactionType | string | Transaction Type |