Consolidated Audit Trail LLC FY2020 filing

Claim this org

(tell your story, add context, and more)

What claiming does How does your 990 look to donors? Take the 10-Question Audit

See description reported on schedule o.

$1.3M paid to officers and key staff.
Mission: Form 990 Part I, line 1 · Pay: Part VII

Before you give

FY2020 · Form 990Independent: from IRS data, not the org
Download 990
IRS status
501(c)(6)
not on the IRS revocation list
Looks good: listed by the IRS and not on the revocation list.
IRS BMF · Auto-Revocation List
Latest return
FY2024
latest Form 990
Looks good: the latest return is for FY2024, 2 tax years back; within 2 tax years.
IRS e-file · Filing history
Surplus or deficit
1 of 5
filings with a surplus
Average deficit $93.4M a year · 130% of revenue · last 5 filings
Concern: a surplus in 1 of the last 5 filings.
Pt I · Ln 19 · 5 filings
Pay to officers and key staff
$1.3M
to officers and key staff · 2% of spending
Looks good: pay to officers and key staff is 2% of spending; 15% or less.
Pt VII · Sec A
<1 mo
of spending, in cash
Worth a look: 0.9 months of spending in cash; under 1.
Pt X · Ln 1–2 · Pt I · Ln 18
Liabilities
$137.3M
382% of total assets
Concern: liabilities are 382% of assets; over 80%.
Pt X · Ln 26
Independent board members
9
of 9 voting members
Looks good: 9 of 9 voting members are independent, a majority.
Pt VI · Ln 1a–1b
Looks goodFineWorth a lookConcernNo data yetTap a box for the reason.
Revenue
$433K
Spent
$84.5M
Net assets
−$101.4M
By yearFY2020–FY2024
Revenue
$433K
FY2020
Tap a bar for its year
Revenue by fiscal year
FY2020$433K
FY2021$0
FY2022$0
FY2023$0
FY2024$359.5M
Expenses
$84.5M
FY2020
Tap a bar for its year
Expenses by fiscal year
FY2020$84.5M
FY2021$146.5M
FY2022$186.4M
FY2023$195.4M
FY2024$214.2M
Net assets
−$101.4M
FY2020
Tap a bar for its year
Net assets by fiscal year
FY2020−$101.4M
FY2021−$247.8M
FY2022−$434.2M
FY2023−$629.5M
FY2024−$484.3M

From the FY2020 Form 990 · figures checked against the IRS filing · see the original

Give Claim
You’re viewing the FY2020 filing — not the latest on file. See the latest (FY2024) →

Is it real?

Yes. Never revoked by the IRS. Latest filing on record: FY2024. IRS ruling in Feb 2020.

IRS Pub. 78 · IRS Auto-Revocation List · IRS Business Master File

Who runs it and what they're paid

12 people listed on the 990; $1.3M paid to officers and key staff.

Part VII, Section A · reportable compensation
Chief Compliance Officer
$641,580Pt VII · Sec A
Chief Information Security Officer
$429,008Pt VII · Sec A
Chair, Operating Committee
$233,463Pt VII · Sec A
Operating Committee Member
$0Pt VII · Sec A
Operating Committee Member
$0Pt VII · Sec A
Operating Committee Member
$0Pt VII · Sec A
Operating Committee Member
$0Pt VII · Sec A
Operating Committee Member
$0Pt VII · Sec A

Compensation history total reportable pay by year · 6 named individuals · Part VII

NameFY2024FY2023FY2022FY2021FY2020
A Duer Meehan$617,612$756,953$574,034$542,211$641,580
David Yacono$471,284$449,948$445,214$426,688$429,008
Michael Simon——$254,985$198,390$233,463
Brandon Becker Eff 21423—$139,370———
Brandon Becker$134,984————
Michael Simon Eff 21423—$82,622———

Total reportable compensation (Form 990 Part VII column D / Schedule J column E) by filing year, matched by name within this organization. The Schedule J base / bonus / deferred breakdown is not parsed into this dataset.

See Consolidated Audit Trail LLC executive salaries →

On this list? Claim this org

Something off? Claim to add context

Questions the 990 asks

The form asks each of these directly. These are the filed answers.

  • Family or business ties among officersPt VI · Ln 2No
  • Top official's pay set by an independent reviewPt VI · Ln 15aYes

Programs and updates

Provides resources and support to those in need.

Questions for Consolidated Audit Trail LLC

Tap to ask. Consolidated Audit Trail LLC sees how many people are interested.

Your first name shows with your question. Consolidated Audit Trail LLC answers here, for everyone.

Provided by the organization

Know this org? Add your story

3 programs · in their own filed words · FY2020
01

Development of software. As of 12/31/20, completion of milestone 5.2.6 for industry member 2a - (equities) file submission and data integrity (including error correction) - go-live and completion of milestone 5.5.5 for industry member full 2a equities go-live (all linkage incl. 2a3 - inter-firm and 2a4 - exchange and TRF).

Pt IX · col B
02

Development of software. As of 12/31/20, start of 5.2.4 milestone for industry member - industry test, including reporting relationships, ats order type management, basic reporting statistics, SFTP data integrity feedback, and error correction.

Pt IX · col B
03

Development of software. As of 12/31/20, completion of 4.3.7 for options linkage release 3 go live.

Pt IX · col B

By the numbers

The FY2020 990, line by line.

1The main four
Money inPt VIII
$433K
Ln 12
Fees for servicesLn 2g$424K
Investment incomeLn 3$9K
Money outPt IX
$84.5M
Ln 25
Owns and owesPt X
−$101.4M
net assets · Ln 32
Cash and savingsLn 1–2$6.4M
Total assetsLn 16$35.9M
LiabilitiesLn 26$137.3M
PeoplePt VI, VII
12
listed · VII A
PaidVII A3
Voting boardVI 1a9
IndependentVI 1b9
2In more detail
Revenue in detailPt VIII
Fees for servicesLn 2g$424K
Investment incomeLn 3$9K
Total revenueLn 12$433K
Assets in detailPt X, end of year
CashLn 1$6.4M
Cash and savings togetherLn 1–2$6.4M
Other assetsLn 15$0
Total assetsLn 16$35.9M
LiabilitiesLn 26$137.3M
Net assetsLn 32−$101.4M
OperationsPt I, VI
EmployeesI 50
VolunteersI 60
Fiscal year endsHeaderDecember
Conflict-of-interest policyVI 12aNo
Whistleblower policyVI 13No
Records policyVI 14No
3Year over year
Balance sheet, start vs end of yearPt X · col A, B
LineStart FY20End FY20
Cash and savingsLn 1–2$1.3M$6.4M
Total assetsLn 16$16.4M$35.9M
LiabilitiesLn 26$33.7M$137.3M
Net assetsLn 32−$17.3M−$101.4M
4Every line
Statement of functional expensesPt IX · every line
LineTotalProgramsManagementFundraising
Legal feesLn 11b$6.5M
Accounting feesLn 11c$188K
Other fees for servicesLn 11g$419K
Information technologyLn 14$71.1M
Depreciation, depletion and amortizationLn 22$4.0M
InsuranceLn 23$967K
Other expenses (24a–d)Ln 24$1.4M
Total functional expensesLn 25$84.5M

Filing history

YearMoney inMoney outIn minus outNet assetsDownload
FY2024 Latest $359.5M$214.2M$145.2M−$484.3M 990 PDF
FY2023 $0$195.4M−$195.4M−$629.5M 990 PDF
FY2022 $0$186.4M−$186.4M−$434.2M 990 PDF
FY2021 $0$146.5M−$146.5M−$247.8M 990 PDF
FY2020 Viewing $433K$84.5M−$84.1M−$101.4M 990 PDF

More to add? Claim this org

Schedules filed Part IV

III · Programs R · Related orgs G · Fundraising L · Interested persons I · Grants A · Public support J · Pay O · Explanations
See the full FY2020 990 (6 parts)
Part I · Summary $433,209 revenue, 12 lines filed
I-8 Contributions and grantsPrior year $0$0
I-9 Program service revenuePrior year $88,205$424,494
I-10 Investment incomePrior year $0$8,715
I-11 Other revenuePrior year $0$0
I-12 Total revenuePrior year $88,205$433,209
I-13 Grants and similar amounts paidPrior year $0$0
I-14 Benefits paid to membersPrior year $0$0
I-15 Salaries and benefitsPrior year $0$0
I-16a Professional fundraising feesPrior year $0$0
I-17 Other expensesPrior year $17,356,463$84,538,619
I-18 Total expensesPrior year $17,356,463$84,538,619
I-19 Revenue less expensesPrior year −$17,268,258−$84,105,410
Part VI · Governance 9 of 9 board members independent, 3 to look at
VI-1a Voting members of the governing body9
VI-1b Independent voting members9
VI-12a Written conflict of interest policyNo
VI-13 Written whistleblower policyNo
VI-14 Document retention and destruction policyNo
VI-2 Family or business relationship among officers or directorsNo
VI-15a Process for setting top official's payYes
Part VIII · Statement of revenue $433,209 across 3 lines filed
VIII-2a-f Program service revenue, itemized rows (sum of 2a–2f as filed)Related to mission $424,494$424,494
VIII-3 Investment incomeExcluded from tax $8,715$8,715
VIII-12 Total revenueRelated to mission $424,494 · Unrelated business $0 · Excluded from tax $8,715$433,209
Part IX · Statement of functional expenses $84,538,619 across 7 lines filed
IX-11b Legal fees$6,531,202
IX-11c Accounting fees$188,405
IX-11g Other fees for services$419,463
IX-14 Information technology$71,106,488
IX-22 Depreciation, depletion and amortization$3,967,638
IX-23 Insurance$966,974
IX-24 Other expenses (24a–d)$1,358,449
IX-25 Total functional expenses$84,538,619
Part X · Balance sheet $35,903,805 assets, 10 lines filed
X-1 Cash, non-interest-bearingStart of year $1,271,661$6,385,235
X-9 Prepaid expenses and deferred chargesStart of year $560,266$569,390
X-14 Intangible assetsStart of year $14,214,500$28,949,180
X-15 Other assetsStart of year $391,880$0
X-16 Total assetsStart of year $16,438,307$35,903,805
X-17 Accounts payable and accrued expensesStart of year $10,428,627$25,781,366
X-26 Total liabilitiesStart of year $33,706,565$137,277,473
X-27 Net assets without donor restrictionsStart of year −$17,268,258−$101,373,668
X-32 Total net assets or fund balancesStart of year −$17,268,258−$101,373,668
X-33 Total liabilities and net assetsStart of year $16,438,307$35,903,805
Part XI · Reconciliation of net assets −$101,373,668 net assets at year end
XI-1 Total revenue$433,209
XI-2 Total expenses$84,538,619
XI-3 Revenue less expenses−$84,105,410
XI-4 Net assets at start of year−$17,268,258
XI-9 Other changes in net assets$0
XI-10 Net assets at end of year−$101,373,668

Form 990 e-file (XML) FY2020 from the IRS · Classification, formation year and address from the IRS Business Master File

Similar organizations you could support · Compare with another nonprofit

Names, privacy, and removal requests More

The names, titles, and compensation shown on this page are reproduced from IRS Form 990 filings, which are public records.

Philanthropy.org does not alter the content of those filings. All information appears exactly as reported by the filing organization for the tax year shown.

We publish only information contained in the public IRS filing — and less than the filing contains. Our profile pages do not display street addresses, telephone numbers, personal email addresses, or other personal contact information, even where the filing includes them.

Many people share the same name. A name shown on this page reflects only what one organization reported in one IRS filing for one tax year. It should not be interpreted as identifying any other individual with the same or a similar name.

If you are no longer affiliated with the organization, your name will generally stop appearing in future IRS filings once the organization no longer reports you. Pages for tax years in which you were reported remain published because those filings remain part of the public record.

Philanthropy.org does not alter or remove IRS filing records. Removing a page from this website would not remove the underlying IRS filing, which remains publicly available from the IRS and other publishers of the same information.

If you believe the IRS filing itself is inaccurate, corrections must be made by the filing organization or the IRS directly.

Your org? Add context

Made it to the end? Claim this org

All figures are derived from public IRS Form 990 filings and are presented without evaluation of any organization. philanthropy.org does not rate, score, or rank organizations, including the pay comparisons above.