Skip to content
  • There are no suggestions because the search field is empty.

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