GET /bankReconciliation
Changed onGets banking reconciliation summary metrics and data accuracy score.
Request
- Base URLhttps://api.railz.ai
- AuthHTTP bearer
Query parameters
Unique business name identifier.
Name of accounting service provider.
The start date of the Transaction report frequency in the format: YYYY-MM-DD.
The end date of the Transaction report frequency in the format: YYYY-MM-DD.
The offset is the position in the dataset of a particular record.
This is the size of the results set you would like (default: 100).
Response
Example response
{
"count": 1,
"reports": [
{
"meta": {
"reportId": "5fad8a342a88364234392fb6",
"serviceName": "xero",
"businessName": "Railz",
"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."
}
}
]
}
]
}
]
}Changes
- info
api tag
Bankadded
- info
- breaking
removed the enum value
plaidfrom thequeryrequest parameterserviceName - breaking
removed the enum value
shopifyfrom thequeryrequest parameterserviceName - breaking
removed the enum value
squarefrom thequeryrequest parameterserviceName - breaking
removed the enum value
wavefrom thequeryrequest parameterserviceName - breaking
added to the
/////response propertyoneOflist for the response status - breaking
added to the
/////response propertyoneOflist for the response status - breaking
added to the
/////response propertyoneOflist for the response status - breaking
added to the
/////response propertyoneOflist for the response status - breaking
the
////response's property type changed from no type toarrayfor status - breaking
the
////response's property type changed from no type toarrayfor status - breaking
the
/////response's property type changed fromobjectto no type for status - breaking
the
/////response's property type changed fromobjectto no type for status - breaking
the
////response's property type changed from no type toarrayfor status - breaking
the
////response's property type changed from no type toarrayfor status - breaking
the
/////response's property type changed fromobjectto no type for status - breaking
the
/////response's property type changed fromobjectto no type for status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - breaking
removed the required property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
removed the optional property
//////from the response with the status - warning
added the new
byodenum value to the///response property for the response status - warning
added the new
byodenum value to the///response property for the response status - warning
added the new
dynamics365Financeenum value to the///response property for the response status - warning
added the new
dynamics365Financeenum value to the///response property for the response status - warning
added the new
dynamicsBusinessCentralenum value to the///response property for the response status - warning
added the new
dynamicsBusinessCentralenum value to the///response property for the response status - warning
added the new
freshbooksenum value to the///response property for the response status - warning
added the new
freshbooksenum value to the///response property for the response status - warning
added the new
myobenum value to the///response property for the response status - warning
added the new
myobenum value to the///response property for the response status - warning
added the new
oracleNetsuiteenum value to the///response property for the response status - warning
added the new
oracleNetsuiteenum value to the///response property for the response status - warning
added the new
quickbooksenum value to the///response property for the response status - warning
added the new
quickbooksenum value to the///response property for the response status - warning
added the new
quickbooksDesktopenum value to the///response property for the response status - warning
added the new
quickbooksDesktopenum value to the///response property for the response status - warning
added the new
sageBusinessCloudenum value to the///response property for the response status - warning
added the new
sageBusinessCloudenum value to the///response property for the response status - warning
added the new
sageIntacctenum value to the///response property for the response status - warning
added the new
sageIntacctenum value to the///response property for the response status - warning
added the new
waveenum value to the///response property for the response status - warning
added the new
waveenum value to the///response property for the response status - warning
added the new
xeroenum value to the///response property for the response status - warning
added the new
xeroenum value to the///response property for the response status - warning
added the new
zohoBooksenum value to the///response property for the response status - warning
added the new
zohoBooksenum value to the///response property for the response status - info
removed from the
////response propertyoneOflist for the response status - info
removed from the
////response propertyoneOflist for the response status - info
removed from the
////response propertyoneOflist for the response status - info
removed from the
////response propertyoneOflist for the response status - info
added the required property
to the response with the status - info
added the required property
to the response with the status
- breaking