MRDP/DAC7 - Account Owner/Account CSV Ingestion Template Guide

Use this template for MRDP/DAC7 reporting workflows, specifically when you have information such as VAT, business registration numbers, or financial account details to provide.

Please see the table below for information on each field within the MRDP/DAC7 Account Owner / Account 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 MRDP/DAC7 can be found in the following guide: MRDP/DAC7 - Data Requirements

For more information on the Taxbit Account/Account Owner data models, please refer to the Account - Data Model and Account Owner - Data Model guides.

Field	Header	Format	Example
Client User ID/Account Owner Number	account_owner_id	String	12345678
Client User ID/Account Number	account_id	String	12345678
Email Address	email	String	taxbit@gmail.com
Phone Number	phone	String	8888888888
Account Owner Name	name	String	Chris P. Bacon
Address Line 1	address_first_line	String	123 Bitcoin Way
Address Line 2	address_second_line	String	Apartment 203
Address City	address_city	String	Seattle
Address State	address_state_or_province	String	WA
Address Country	address_country	String	US
Address Postal Code	address_postal_code	String	98101
Mailing Address Line 1	mailing_address_first_line	String	123 Bitcoin Way
Mailing Address Line 2	mailing_address_second_line	String	Apartment 203
Mailing Address City	mailing_address_city	String	Seattle
Mailing Address State	mailing_address_state_or_province	String	WA
Mailing Address Country	mailing_address_country	String	US
Mailing Address Postal Code	mailing_address_postal_code	String	98101
Tax Residence Country	tax_country_code	String	US
TIN	tax_id	String	123-45-6789
TIN Type	tax_id_type	Enum	SSN
Tax Residence Country 2	tax_country_code_2	String	CA
TIN 2	tax_id_2	String	123-45-6789
TIN Type 2	tax_id_type_2	Enum	SSN
Tax Residence Country 3	tax_country_code_3	String	CN
TIN 3	tax_id_3	String	123-45-6789
TIN Type 3	tax_id_type_3	Enum	SSN
Tax Residence Country 4	tax_country_code_4	String	FR
TIN 4	tax_id_4	String	123-45-6789
TIN Type 4	tax_id_type_4	Enum	SSN
Tax Residence Country 5	tax_country_code_5	String	NO
TIN 5	tax_id_5	String	123-45-6789
TIN Type 5	tax_id_type_5	Enum	SSN
Date of Birth	dob	M/D/YYYY	1/31/1990
City of Birth	birth_city	String	Seattle
Country of Birth	birth_country	String	US
VAT Country	vat_country_code	String	US
VAT Identification Number	vat_id	String	123-45-6789
Business Registration Number Country	brn_country_code	String	US
Business Registration Number	brn	String	123-45-6789
Financial Account Number	financial_account_id	String	12345678
Financial Account Holder Name	financial_account_holder_name	String	Chris P. Bacon
Tax Exempt Status	is_tax_exempt	TRUE/FALSE	TRUE
Physical Mail	prefers_physical_mail	TRUE/FALSE	TRUE
Account Owner Type	account_ownder_type	Enum	Individual
Account Type	account_type	Enum	US_IRA_TRADITIONAL
Filer ID**	filer_id	UUID	76477935-4dbc-434c-b5c6-4cc07481b630

**Filer ID: The Filer ID is a Taxbit-generated ID upon Filer creation. See “Filer Setup” in the Dashboard for this ID. If this field is left blank, the Account will be associated with the default fil

Please see below for a full list of currently supported enums that can be used.

Header	Enum
tax_id_type	SSN
tax_id_type	EIN
tax_id_type	ITIN
account_owner_type	Individual
account_owner_type	Entity
account_type	US_IRA_TRADITIONAL
account_type	US_IRA_ROTH
account_type	US_IRA_SEP
account_type	US_IRA_SIMPLE

Please note: There is a limitation of 500K rows for Account Owner/Accounts CSV data. If the file is larger than this limit, please split the file to successfully ingest the associated data.