Bank transactions

Explore BankTransactions endpoints in Swagger.

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
See date

Date the transaction was cleared by the originating bank.

description

string

Description of the bank transaction.

reconciled

boolean

If true, then the bank transaction is reconciled with the bank statement, and the accounting platform matches the bank statement.

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:

  • Unknown
  • Credit
  • Debit
  • Int
  • Div
  • Fee
  • SerChg
  • Dep
  • Atm
  • Pos
  • Xfer
  • Check
  • Payment
  • Cash
  • DirectDep
  • DirectDebit
  • RepeatPmt
  • Other

modifiedDate

string
See date

Date the record was last updated in the Codat 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",
    "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"
  }
]

Did this page help you?