Filers - CSV Ingestion Template Guide
Use this template to create or update filers in bulk in the Taxbit Dashboard. To create a new filer, leave filer_id blank and provide filer_name. To update an existing filer, provide the existing Taxbit-generated Filer ID in filer_id. A filer can be created with only a name, but additional information may be required before Taxbit can generate forms for the filer.
For more information about the fields required for a specific reporting workflow, please refer to the Filer - Data Model.
Please see the table below for information on each field within the Filer CSV template.
The CSV template is also attached to the bottom of this article.
|
Field |
Headers |
Format |
Example |
|
Filer ID |
filer_id |
UUID |
123e4567-e89b-12d3-a456-426614174000 |
|
Filer Name |
filer_name |
String |
Example Filer LLC |
|
Address Line 1 |
address_first_line |
String |
123 Bitcoin Way |
|
Address Line 2 |
address_second_line |
String |
Suite 100 |
|
City |
address_city |
String |
Seattle |
|
State or Province |
address_state_or_province |
String |
WA |
|
Country |
address_country |
String |
US |
|
Postal Code |
address_postal_code |
String |
98101 |
|
Contact Name |
contact_name |
String |
Jane Doe |
|
Contact Title |
contact_title |
String |
Tax Department |
|
Contact Email |
contact_email |
String |
tax@example.com |
|
Contact Phone |
contact_phone |
String |
+1-555-123-4567 |
|
Tax Country Code |
tax_country_code |
String |
US |
|
TIN |
tin |
String |
123-45-6789 |
|
EIN |
ein |
String |
123456780 |
|
VAT Country |
vat_country |
String |
DE |
|
VAT ID |
vat_id |
String |
DE123456789 |
|
RTN |
rtn |
String |
987654321 |
|
GIIN |
giin |
String |
ABCDEF.12345.TA.001 |
|
ARN |
arn |
String |
123456789012 |
|
CRA Account Number |
cra_account_number |
String |
123456789 |
|
CRA Account Number Type |
cra_account_number_type |
Enum |
BN9 |
|
CRA Representative Identifier |
cra_representative_identifier |
String |
A1B2C3D |
|
DAC7 Receiving Member State |
dac7_receiving_member_state |
Enum |
FR |
|
Disposition Method |
disposition_method |
Enum |
FIFO |
|
Form 1099-K Filer Type |
form_1099_k_filer_type |
Enum |
PAYMENT_SETTLEMENT_ENTITY |
|
Form 1099-K Transaction Type |
form_1099_k_transaction_type |
Enum |
PAYMENT_CARD_TRANSACTIONS |
|
PSE Name |
pse_name |
String |
Example PSE |
|
PSE Telephone Number |
pse_telephone_number |
String |
+1-555-999-8888 |
|
Form 1042-S Chapter 3 Status |
form_1042_s_chapter_3_status |
Enum |
CORPORATION |
|
Form 1042-S Chapter 4 Status |
form_1042_s_chapter_4_status |
Enum |
ACTIVE_NFFE |
Please see below for the enums available for each of the applicable fields.
|
Header |
Enum |
|
cra_account_number_type |
BN9 |
|
BN15 |
|
|
Trust |
|
|
NR4 |
|
|
dac7_receiving_member_state |
AT, BE, BG, HR, CY, CZ, DK, EE, FI, FR, DE, GR, HU, IE, IT, LV, LT, LU, MT, NL, PL, PT, RO, SK, SI, ES, SE |
|
disposition_method |
HIFO |
|
FIFO |
|
|
LIFO |
|
|
LOFO |
|
|
form_1099_k_filer_type |
PAYMENT_SETTLEMENT_ENTITY |
|
ELECTRONIC_PAYMENT_FACILITATOR_OR_OTHER_THIRD_PARTY |
|
|
form_1099_k_transaction_type |
PAYMENT_CARD_TRANSACTIONS |
|
THIRD_PARTY_NETWORK_TRANSACTIONS |
|
|
form_1042_s_chapter_3_status |
See the Tax Classification Enums for supported values. |
|
form_1042_s_chapter_4_status |
Please note: disposition_method cannot be changed through a bulk update, and form_1099_k_transaction_type cannot be changed after it has been set. If an update conflicts with the existing value for one of these fields, the row is rejected.
Filers.csv