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

Payments - Transactions CSV Ingestion Template Guide

Use this template for payment-only transactions, specifically for MRDP/DAC7 or US income reporting (e.g., Forms 1099-MISC, 1099-K, etc.). This template only includes the received side of the transaction model.

Please see the table below for information on each field within the Payments - Transactions Template. The CSV template is also attached to the bottom of this article.

Please note: Only the Account ID is required for ingestion; however, for more information on all of the data requirements for specific form types, please refer to this guide: Data Requirements Overview

For more details on the Taxbit Transaction data model, please refer to this guide: Transactions - Data Model.

Field Headers Format Example
Client User ID/ Account Number account_id String 12345678
Transaction ID transaction_id String 12345678
Date and Time date_time UTC Time in ISO-8601 Format 2020-01-01T00:00:00.000Z
Transaction Type transaction_type ‘Income’ Income
Transaction Subtype transaction_subtype Enum Airdrop
Gross Received Quantity received_quantity Number 10
Fee Quantity fee_quantity Number 10
Withholding Quantity withholding_quantity Number 10
Withholding Regime Type withholding_regime_type Enum us-federal
Currency currency String USD

 

Please see below for the enums available for each of the applicable fields. 

Header Enum
transaction_subtype See Taxbit Transaction Types for the acceptable subtypes when Income is the transaction type.
withholding_regime_type us-federal
eu-dac7


Please note: There is a limitation of 30M rows for Transaction CSV data, and 10M for Transaction JSON data. If the file is larger than this limit, please split the file to successfully ingest the associated data.


Payments_Transactions_Ingestion_Template.csv