Bank Transactions
Overview
Bank Transactions include the Transactional banking data for a specific company and account.
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_idandcustomer_idproperties, 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 |