Bank transactions
A record of money that moved in and out of your bank account
Explore the Bank Transactions endpoints in Swagger.
View the coverage for bank transactions in the Data Coverage Explorer.
Accessing Bank Accounts through Banking API
This datatype was originally used for accessing bank account data both in accounting integrations and open banking aggregators.
To view bank account data through the Banking API, please refer to the new datatype here
Overview
Transactional banking data for a specific company and account.
Bank transactions include the:
- Amount of the transaction.
- Current account balance.
- Transaction type, for example, credit, debit, or transfer.
Data model
Field | Type | Description |
---|---|---|
id | string | Identifier of the bank transaction that is unique to the company. |
accountId | string | Identifier of the bank account that is unique to the company. |
clearedOnDate | string | Date the transaction was cleared by the originating bank. |
description | string | Description of the bank transaction. |
counterparty | string | Name or description of the payee/payer |
reference | string | Additional information associated with the bank transaction. |
reconciled | boolean | If |
amount | decimal | Total amount of the transaction line item. |
balance | decimal | Current balance of the bank account, with the line item accounted for. |
transactionType | Type of transaction for the bank statement line, either:
| |
modifiedDate | string | Date the record was last updated in the Codat system. |
sourceModifiedDate | string | Date the record was last changed in the accounting system. |
Example data
[
{
"id": "9d419ff3-c0fb-43b7-a1d6-25d1406211b1",
"clearedOnDate": "2017-05-02T10:11:16.927Z",
"description": "Opening Balance",
"reconciled": true,
"amount": 0,
"balance": 33444.13,
"transactionType": "Unknown",
"sourceModifiedDate": "2017-05-02T10:11:16.927Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "99523acd-587c-47af-9e70-3163076acf30",
"clearedOnDate": "2017-10-21T12:12:26.729Z",
"description": "Payment from Fogforn Leghorn",
"counterparty" : "Mike's Musicians",
"reference" : "MM00001",
"reconciled": true,
"amount": 457.6,
"balance": 33901.73,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-21T12:12:26.729Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "ddf904e7-f477-437d-8bcf-d8c785d3f1b9",
"clearedOnDate": "2017-10-21T23:40:12.728Z",
"description": "Payment from Speedy Gonzales",
"reconciled": true,
"amount": 545.6,
"balance": 34447.33,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-21T23:40:12.728Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "cf41ffe2-f7d1-4472-9143-9812eb7c9e13",
"clearedOnDate": "2017-10-22T06:29:34.199Z",
"description": "Payment from Sylvester",
"reconciled": true,
"amount": 521.95,
"balance": 34969.28,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-22T06:29:34.199Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "340f0a23-b3b0-4476-9387-c08ad4cb0ec3",
"clearedOnDate": "2017-10-27T13:01:52.185Z",
"description": "Payment from Sylvester",
"reconciled": true,
"amount": 778.8,
"balance": 35748.08,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-27T13:01:52.185Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "80ee9d07-62ac-4b7f-a5e1-9f43f1d5ce3f",
"clearedOnDate": "2017-10-30T04:07:41.503Z",
"description": "Payment from Speedy Gonzales",
"reconciled": true,
"amount": 2038.3,
"balance": 37786.38,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-30T04:07:41.503Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "5af449d0-0736-4642-b6c3-23853875cb08",
"clearedOnDate": "2017-10-30T13:34:42.043Z",
"description": "Payment from Tweety",
"reconciled": true,
"amount": 411.4,
"balance": 38197.78,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-30T13:34:42.043Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "60c39d4e-1d54-4ed3-9632-d5d3b9f310a6",
"clearedOnDate": "2017-10-31T08:02:01.429Z",
"description": "Payment from Fogforn Leghorn",
"reconciled": true,
"amount": 319,
"balance": 38516.78,
"transactionType": "Credit",
"sourceModifiedDate": "2017-10-31T08:02:01.429Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "2b1d2fdb-4445-4c39-9d88-93b092492078",
"clearedOnDate": "2017-11-06T07:14:30.200Z",
"description": "Payment to ABC Dynamics",
"reconciled": true,
"amount": -228.8,
"balance": 38287.98,
"transactionType": "Debit",
"sourceModifiedDate": "2017-11-06T07:14:30.200Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
},
{
"id": "84acf7b4-2461-4944-a9f7-7456a0b9af64",
"clearedOnDate": "2017-11-06T09:42:17.739Z",
"description": "Payment from Porky Pig",
"reconciled": true,
"amount": 385,
"balance": 38672.98,
"transactionType": "Credit",
"sourceModifiedDate": "2017-11-06T09:42:17.739Z",
"accountId": "dbcaf288-2b39-4b95-8ab3-42202ab15918"
}
]
Updated 3 months ago