Overview - Integrations by Commenda

The Bank Transactions Data Model simplifies the management and retrieval of transaction information across different accounting platforms.

Unified transaction properties: The model consolidates essential transaction details such as transaction date, amount, type, and status, making it easier to work with transaction data from various platforms.
Linked account and customer data: Transactions are associated with specific accounts and customers through the account_id and customer_id properties, facilitating easier tracking and reporting.
Currency support and exchange rates: The data model includes the transaction currency and exchange rate, enabling accurate representation of multi-currency transactions and conversions.

Properties Supported

Property	Type	Description
platform_id	string	The Platform’s ID for the transaction
account_id	string	Platform ID for the account to which this transaction belongs
from_account_id	string	Platform ID of the bank account to which this transaction is sent from
to_account_id	string	Platform ID for the bank account to which this transaction is sent to
contact_id	string	The platform’s ID for the contact to that made the transaction
currency_id	string	The platform’s ID of the currency for the transaction
transaction_date	date	Date of the transaction
amount	float	The total transaction amount
type	string	The type of the transaction
status	string	The status of the transaction
currency_rate	float	Rate between the currency of the payment and the base currency
debit_or_credit	string	The type of transaction. Values are: `DEBIT`, `CREDIT`
updated_at	date	The date at which the transaction was updated on the accounting platform

Expandable Attributes

You can expand the following attributes to get the related data

Property	Data Model	Description
account	Accounts	The chart of account associated with this transaction
from_account	Bank Accounts	The bank account to which this transaction is sent from
to_account	Bank Accounts	The bank account to which this transaction is sent to
contact	Contacts	The contact that made the transaction
currency	Currencies	The currency of the transaction

{
  "platform_id": "3770712000000811013",
  "account_id": "3770712000000493001",
  "contact_id": "3770712000000080069",
  "currency_id": "3770712000000000099",
  "to_account_id": "3770712000000080063",
  "from_account_id": "3770712000000493001",
  "transaction_date": "2022-02-17T00:00:00.000Z",
  "amount": 1234.0,
  "type": "Sales Return",
  "status": "Manually Added",
  "currency_rate": 80.0,
  "debit_or_credit": "CREDIT",
  "updated_at": "2022-02-17T00:00:00.000Z"
}

​Properties Supported

​Expandable Attributes

Properties Supported

Expandable Attributes