Offshore Charges / Convictions Spreadsheet (11/7/14)

I offer readers a spreadsheet (see instructions for download at end of this page) in which I compile certain data regarding the Government's charges and convictions in the offshore account initiative. I caveat the use of this spreadsheet in that the information is incomplete and perhaps even wrong in some of the particulars. I request that my readers to email me at jack@tjtaxlaw.com to advise of any information needed to make it more complete and accurate. As I am advised or have my own updates, I will post new versions of the spreadsheet.

The basic data is in the spreadsheets with the tabs titled "Indictment Data Table" and Financial Institution Data Table." Both tables are Excel tables that permit various database type functions. You can sort by the information in each column. In addition, you can display only limited subsets of the information in each column. For example, you can filter to see only the enablers that have been indicated or can filter based on the enablers banks.

Also, I have some statistical analyses the other spreadsheets with "Stats" tabs. The data from which the statistics are derived come from the two data tables. As noted above, the data tables may be incomplete or even inaccurate in some instances, although I am striving to refine the information. The statistics thus may not be perfect, but over time and with the help of readers and some self-help, I hope to make the spreadsheet better and, hopefully, more useful.

Thanks in advance for those of you who help me make this spreadsheet more accurate and complete.

DOWNLOAD INSTRUCTIONS

To download the spreadsheet in Excel 2010 format (.xlsx) in a ZIP file, click here (version as of 11/7/14) and download by clicking the download button in the upper right hand column.

An IRS compilation (apparently is ongoing and cumulative), titled Offshore Tax-Avoidance and IRS Compliance Efforts, is here

THE CURRENT SUMMARY STATS ARE:

All
Taxpayers
Enablers
# Uncertain
Charges (Indictments, Information, Complaint)
151
107
44
Charges with Taxpayer Entities Involved
91
91
N/A
5
Guilty Pleas
84
72
12
Guilty Verdicts
17
17
0
Acquittals
3
1
2
Dismissals
2
1
1
Cases Sentenced (Total)
71
63
8
Cases Pending (All Prior to Sentencing, incl. Fugitives)
77
43
34
Cases Pending (without Fugitives)
51
41
10
Cases Pending (Fugitives Only)
26
2
24