Sign in
latestOpenAPI 3.0.02026-08-10233809957.8 KB

5cdfae3fa1fa

Bank Reconciliation (Accuracy Score)

List Banking Reconciliations

Supported for:

freshbooks quickbooks quickbooksDesktop xero oracleNetsuite sageBusinessCloud sageIntacct dynamicsBusinessCentral myob

get/v2/analytics/bankReconciliation

Query parameters

connectionUuidstring required

Unique connection identifier.

startDatestring

The start date of the Transaction report frequency in the format: YYYY-MM-DD.

endDatestring

The end date of the Transaction report frequency in the format: YYYY-MM-DD.

offsetnumber

The offset is the position in the dataset of a particular record.

limitnumber

This is the size of the results set you would like (default: 100).

orderBystring

Response

countnumber required

Example response

{
  "count": 1,
  "reports": [
    {
      "meta": {
        "connectionUuid": "CON-396d5daa-26b2-4979-89b6-cafb2c298155",
        "businessName": "Railz",
        "serviceName": "xero",
        "reportId": "5fad8a342a88364234392fb6",
        "startDate": "2020-11-25T01:02:03Z",
        "endDate": "2020-11-30T01:02:03Z",
        "createdAt": "2020-11-25T01:02:03Z",
        "updatedAt": "2020-11-30T01:02:03Z"
      },
      "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,
              "accountType": "investment, credit, depository, loan, brokerage, other",
              "accountId": "onD7kPQJ98cDejlnXpZeHeqp1qBlX5TogLqxW",
              "description": "BMO Bank of Montreal"
            }
          ],
          "reconciledBankTransactions": [
            {
              "id": "lPNjeW1nR6CDn5okmGQ6hEpMo4lLNoSrzqDje",
              "date": "2017-01-29",
              "amount": 1000,
              "accountType": "investment, credit, depository, loan, brokerage, other",
              "accountId": "onD7kPQJ98cDejlnXpZeHeqp1qBlX5TogLqxW",
              "description": "BMO Bank of Montreal",
              "subTotal": 300.5,
              "transactionNumber": "INV-001",
              "transactionReportId": "5fad8a342a88364234392fb6",
              "accountRef": {
                "id": "1334",
                "name": "Account Receivable",
                "section": "Assets",
                "subSection": "Current Assets",
                "group": "Cash And Cash Equivalents",
                "subGroup": "Cash And Cash Equivalents"
              },
              "entityRef": {
                "id": "233",
                "name": "Railz Inc."
              }
            }
          ]
        }
      ]
    }
  ]
}