Transactions - Data Model
The table below summarizes each field in the Taxbit Data model. The * symbol denotes fields that are always required. Additional fields may be required, based on other details provided (e.g., Transaction Type).
|
Field |
Description |
|
Transaction ID* |
Unique ID for the Transaction |
|
Account ID* |
Account ID associated with the Transaction |
|
Date and Time* |
The date/time of the Transaction in UTC. For an acquisition (e.g., a Deposit Transaction), this is typically the moment the Account Owner has access to the assets, even if prior to the transaction being finalized. Must be in ISO 8601 format: YYYY-MM-DDTHH:mm:ss.SSSZ Example: 2024-01-31T00:00:00.000Z |
|
Transaction Type* |
Determines the tax treatment for the Transaction, including the cost basis calculation. See Taxbit Transaction Types. |
|
Transaction Subtype |
Additional clarity regarding the Transaction Type, typically to assist in determining which tax form the Transaction is ultimately reported on. For example, a Transaction Type of Income with a Subtype of Payment-Services will be reported on the Form 1099-K, assuming the Account Owner is a US tax resident and the relevant transactions meet the applicable threshold. |
|
Received Quantity |
Quantity of the asset received, prior to removing any fees |
|
Received Currency |
Currency of the asset being received (e.g., BTC) |
|
Sent Quantity |
Quantity of the asset sent, prior to adding any fees |
|
Sent Currency |
Currency of the asset being sent (e.g., USD) |
|
Fee Quantity |
Quantity of the fee being charged to the Account for the Transaction |
|
Fee Currency |
Currency of the fee asset (e.g., ETH) |
|
Transaction Value* |
Where applicable, this field should reflect the value of the Received Quantity/Asset in USD. Where no asset is received, this should reflect the value of the Sent Quantity/Asset in USD. Note – For data sent via API, the rate of the asset must be provided for each asset in the transaction, allowing for a higher level of precision. |
|
Fee Value |
Value of the Fee Quantity/Asset in USD |
|
Counterparty Account ID |
For a transaction that occurs between two different accounts on the platform, this is to identify the account on the other side of the transaction. This is specifically for CESOP reporting only. |
|
Counterparty Transaction ID |
For a transaction that occurs between two different accounts on the platform, this is to identify the other side of the transaction. This is specifically used for the Deposit > Internal-Personal and Deposit > Gift transaction type. |
|
Disposition Method |
The disposition method used for individual transactions. |
|
Regime Type |
Tax regime type for withholding purposes. Enums: us-federal, us-state, eu-dac7 |
|
Withholding |
Represents the quantity of the received or sent asset that was withheld by the platform for purposes of remitting to a tax authority. |
The tables below provide examples for each transaction type we currently support, in the format of the Taxbit Data Model.
|
Field |
Buy |
Sell |
Trade |
Income |
Expense |
Deposit |
Withdraw |
Card Reward |
|
Received Quantity |
1 |
100 |
1 |
1 |
N/A |
1 |
N/A |
1 |
|
Received Currency |
BTC |
USD |
BTC |
BTC |
N/A |
BTC |
N/A |
BTC |
|
Sent Quantity |
100 |
1 |
0.75 |
N/A |
1 |
N/A |
1 |
N/A |
|
Sent Currency |
USD |
BTC |
ETH |
N/A |
BTC |
N/A |
BTC |
N/A |
|
Fee Quantity |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
|
Fee Currency |
BTC |
BTC |
BTC |
BTC |
BTC |
BTC |
BTC |
BTC |
|
Transaction Value |
100 |
100 |
100 |
100 |
100 |
N/A |
N/A |
N/A |
|
Fee Value |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
1 |
|
Field |
Cost Basis Transfer |
Deposit > Internal Transfer |
Inheritance Received |
Deposit > Gift |
Unlock Asset |
Lock Asset |
|
Received Quantity |
1 |
1 |
1 |
1 |
1 |
N/A |
|
Received Currency |
LUNA |
BTC |
BTC |
BTC |
BTC |
N/A |
|
Sent Quantity |
1 |
N/A |
N/A |
N/A |
N/A |
1 |
|
Sent Currency |
LUNC |
N/A |
N/A |
N/A |
N/A |
BTC |
|
Fee Quantity |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
0.01 |
|
Fee Currency |
BTC |
BTC |
BTC |
BTC |
BTC |
BTC |
|
Transaction Value |
N/A |
N/A |
100 |
100 |
N/A |
N/A |
|
Fee Value |
1 |
1 |
1 |
1 |
1 |
1 |
|
Counterparty Transaction ID |
N/A |
[Transaction ID] |
N/A |
[Transaction ID] |
N/A |
N/A |