FATCA Reporting Data

This dataset provides detailed FATCA reporting records for US persons with foreign financial accounts, including Form 8966 submission data, withholding amounts, and IRS tracking. It enables regulatory compliance monitoring, risk analysis, and cross-border financial transparency for institutions and authorities.

  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Regulatory compliance monitoring for financial institutions

Sample rows

preview · 8 of 300 rows · all 25 columns
report_idstringaccount_typestringwithholding_amount_usdfloatreporting_entity_countrystringreporting_entity_idstringreporting_entity_namestringirs_giinstringus_person_idstringus_person_namestringus_person_tinstringus_person_date_of_birthdateaccount_numberstringaccount_open_datedateaccount_close_datedateaccount_balance_usdfloatform_8966_submission_datedateform_8966_statusstringirs_submission_idstringaccount_holder_address_streetstringaccount_holder_address_citystringaccount_holder_address_statestringaccount_holder_address_postal_codestringaccount_holder_address_countrystringreporting_period_startdatereporting_period_enddate
FATCA202400001investment32000USBANKUSA01First National Bank USAA1B2C3D4E5F6G7H8I9JUSP001James R. Smith5231047691971-03-11US987654322008-07-15blank1052100.352024-03-01acceptedIRS000011558 Parkside AveNew YorkNY10010US2023-01-012023-12-31
FATCA202400002checking0GBBNKUK002Global Trust UKB2C3D4E5F6G7H8I9J0KUSP002Emily L. Johnson1839475021992-05-23GB223344552021-08-01blank3200.52024-03-02pendingIRS0000248 St. Martin's LaneLondonLondonWC2N 4EAGB2023-01-012023-12-31
FATCA202400003savings0FRBNKFR003Banque de ParisC3D4E5F6G7H8I9J0K1LUSP003Michael T. Lee3948572611986-11-30FR998877662015-04-19blank82002024-03-03acceptedIRS0000322 Avenue Victor HugoParisÎle-de-France75008FR2023-01-012023-12-31
FATCA202400004savings0CABNKCA004Maple Financial CorpD4E5F6G7H8I9J0K1L2MUSP004Sarah G. Miller739201846blankCA112233442020-02-10blank12500.752024-03-04pendingIRS00004206 Queen St WTorontoONM5V 1Z2CA2023-01-012023-12-31
FATCA202400005investment50000USBANKUSA02Patriot Savings BankE5F6G7H8I9J0K1L2M3NUSP005Robert W. Brown6824739101964-08-19US876543212002-11-05blank14880002024-03-05acceptedIRS00005490 Lincoln BlvdChicagoIL60611US2023-01-012023-12-31
FATCA202400006investment22500DEBNKDE005Deutsche Finanz AGF6G7H8I9J0K1L2M3N4OUSP006Linda M. Davis879203516blankDE556677882010-05-15blank7800002024-03-06acceptedIRS00006Hauptstrasse 14FrankfurtHE60311DE2023-01-012023-12-31
FATCA202400007investment80000JPBNKJP006Sumitomo TrustG7H8I9J0K1L2M3N4O5PUSP007Brian K. Allen1928374651952-12-01JP112358132000-09-21blank2200000.422024-03-07acceptedIRS000072-3-5 MarunouchiTokyoTokyo100-0005JP2023-01-012023-12-31
FATCA202400008checking0CHBNKCH007Swiss Credit ZurichH8I9J0K1L2M3N4O5P6QUSP008Jessica M. White1019283741979-06-09CH334455662022-03-13blank15002024-03-08acceptedIRS00008Bahnhofstrasse 8ZurichZH8001CH2023-01-012023-12-31

What the 300 rows show

from the 300-row sample

Investment (account type) stands out: mean withholding_amount_usd is 39,318, against 0.0 for the rest.

  • 0median withholding_amount_usd
  • 4form 8966 statuses
  • 15account holder address countries
  • 63account holder address cities
  • 80account holder address states
  • 2,700median account_balance_usd
Mean withholding_amount_usd by account_type300 rows
020k40k0.0savings77 rows0.0checking97 rows39,318investme…84 rows0.0other42 rows
withholding_amount_usd300 rows, in bands of 10k
012024023114414119116040k80kwithholding_amount_usd →

Median 0, from 0 to 80,000.

reporting_entity_country300 rows · top 10 of 15 values
  1. US53
  2. CA28
  3. CH27
  4. FR26
  5. DE25
  6. SG24
  7. IE17
  8. AU16
  9. GB15
  10. JP15
25 columns by typefrom the column list below
  • string 17
  • float 2
  • date 6

Columns

25 columns in three groups
blueprint · 25 columns
columntypedescriptionexample
Text 17 columns
report_idstringUnique identifier for each FATCA report submissionuniqueFATCA202400001
reporting_entity_idstringIdentifier for the financial institution or entity submitting the reportBANKUSA01
reporting_entity_namestringName of the reporting financial institution or entityFirst National Bank USA
reporting_entity_countrystringCountry where the reporting entity is locatedUS
irs_giinstringGlobal Intermediary Identification Number assigned by the IRSoptionalA1B2C3D4E5F6G7H8I9J
us_person_idstringUnique identifier for the US person (account holder)USP001
us_person_namestringFull legal name of the US person (account holder)James R. Smith
us_person_tinstringTaxpayer Identification Number (TIN) of the US person523104769
account_numberstringForeign account number held by the US personUS98765432
account_typestringType of foreign account (e.g., savings, checking, investment)savings · checking · investment · otherinvestment
form_8966_statusstringStatus of the Form 8966 submission (e.g., accepted, rejected, pending)accepted · rejected · pending · correctedaccepted
irs_submission_idstringIRS submission identifier for trackingoptionalIRS00001
account_holder_address_streetstringStreet address of the US person (account holder)optional1558 Parkside Ave
account_holder_address_citystringCity of the US person (account holder)optionalNew York
account_holder_address_statestringState or province of the US person (account holder)optionalNY
account_holder_address_postal_codestringPostal code of the US person (account holder)optional10010
account_holder_address_countrystringCountry of the US person (account holder)optionalUS
Numbers 2 columns
account_balance_usdfloatAccount balance in USD as of reporting date0 or more1052100.35
withholding_amount_usdfloatAmount withheld in USD for FATCA compliance0 or more · optional32000
Dates and times 6 columns
us_person_date_of_birthdateDate of birth of the US personoptional1971-03-11
account_open_datedateDate the foreign account was openedoptional2008-07-15
account_close_datedateDate the foreign account was closed (if applicable)optional2023-04-19
form_8966_submission_datedateDate Form 8966 was submitted to the IRS2024-03-01
reporting_period_startdateStart date of the reporting period2023-01-01
reporting_period_enddateEnd date of the reporting period2023-12-31

Use it for

  • median withhol…0300 rowsmean withholding amou…0.0savi…0.0chec…39.3kinve…0.0other

    A finance dashboard

    Withholding_amount_usd by account_type and a breakdown of reporting_entity_country. Excel, Power BI or Tableau.

  • Why do the 84 investment rows have a mean withholding_amount_usd of 39,318?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable reports with reporting_entity_id, reporting_entity_name and reporting_entity_country to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 25 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset300 rows25 columns
Yours1,000 rows25 columnsreporting_entity_country: UK only

blueprint · fatca-reporting-data

Behind this dataset

Same schema. As many rows as you need.

These 300 rows came out of a blueprint — 25 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with
  • US person identification required
  • Account balance threshold: $50,000
  • TIN (SSN or EIN) collected
  • Self-certification form W-9 or W-8
  • Reportable income types identified
  • Withholding at 30% if non-compliant
  • Annual reporting to IRS via XML
  • Recalcitrant account procedures
Rows
Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
fatca-reporting-data

More in Finance

Browse all
Also in FinanceMerchant Transaction Risk ScoringAccounts Receivable and Aging AnalysisFinance Expense Categorization DatasetAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.