01-projects / financials / tax-prep / 2025

document summary

Sun Apr 05 2026 20:00:00 GMT-0400 (Eastern Daylight Time) ·tax-prep ·status: in-progress

2025 Tax Document Summary

Filing status: Married Filing Jointly (MFJ) Taxpayers: Benjamin A. Wilson (SSN xxx-xx-4122) & Michelle M. Wilson (SSN xxx-xx-2360) Dependent: Sophia Wilson (born 2023) State: Florida (no state income tax) Prepared: 2026-04-06


1. W-2 — Ben’s Wages (Ray Data LLC)

File: w2-bw.pdf Employer: Ray Data LLC, EIN 87-4413391 Issued via: Gusto

BoxDescriptionAmount
1Wages, tips, other compensation$57,500.00
2Federal income tax withheld$4,946.38
3Social security wages$57,500.00
4Social security tax withheld$3,565.00
5Medicare wages and tips$57,500.00
6Medicare tax withheld$833.75
12(no entries)
14Other(blank)

Notes:


2. 1099-NEC — Mammoth Growth (S-Corp Revenue)

File: 1099-nec-mammoth-growth.pdf Payer: Mammoth Growth LLC, 145 Corte Madera Town Center #445, Corte Madera CA 94925 Payer TIN: 83-4208114 Recipient: Ray Data LLC, 1212 South Suffolk Drive, Tampa FL 33629 Recipient TIN: XX-XXX3391 (EIN) Account number: 831372550 Calendar year: 2025

BoxDescriptionAmount
1Nonemployee compensation$201,396.00
4Federal income tax withheld$0.00

Notes:


3. Form 8879-CORP — S-Corp E-file Authorization

File: 8879-corp-business-taxes.pdf Entity: Ray Data LLC, EIN 87-4413391 Form type: 1120-S (S-Corporation) Tax year: 2025 ERO firm: Collective HUB Inc. Officer signature: Benjamin Andrew Wilson, CEO, dated 04/10/2026

Part I LineDescriptionAmount
3Total income (loss) — Form 1120-S, Line 6$199,521

Notes:


4. 1099-WF-BW-1 — Wealthfront Brokerage (Ben, Account 8W14YTCT)

File: 1099-wf-bw-1.pdf (16 pages) Account: 8W14YTCT — Benjamin A Wilson Statement date: 02/11/2026, Document ID: 7U90 109 B805 Payer TIN: 27-1967207

Summary Totals

1099-DIV:

BoxDescriptionAmount
1aTotal ordinary dividends$19.94
1bQualified dividends$15.69
7Foreign tax paid$0.12

1099-INT: All zeros (no interest income)

1099-B Summary (proceeds/gains/losses):

TermForm 8949 TypeProceedsCost BasisWash Sale DisallowedNet G/L
ShortA (basis reported)$1,752.73$1,861.74$0.00-$109.01
LongD (basis reported)$0.00$0.00$0.00$0.00
Grand total$1,752.73$1,861.74$0.00-$109.01

Foreign income (from page 14):

Management fees paid (informational, not IRS reported): $1.56

Notes:


5. 1099-WF-BW-2 — Wealthfront Brokerage (Ben, Account 8W1067NV)

File: 1099-wf-bw-2.pdf (6 pages) Account: 8W1067NV — Benjamin A Wilson Statement date: 02/11/2026, Document ID: 26F3 6H6 J7T2 Payer TIN: 27-1967207

Summary Totals

1099-DIV:

BoxDescriptionAmount
1aTotal ordinary dividends$10.25
1bQualified dividends$7.11
All other boxes$0.00

1099-INT: All zeros

1099-B: All zeros (no sales)

Dividend detail:

Management fees paid: $0.00

Notes:


6. 1099-WF-BW-3 — Wealthfront Brokerage (Ben, Account 8W108343)

File: 1099-wf-bw-3.pdf (24 pages) Account: 8W108343 — Benjamin A Wilson Statement date: 02/11/2026, Document ID: 2ES1 9E6 VQF6 Payer TIN: 27-1967207

Summary Totals

1099-DIV:

BoxDescriptionAmount
1aTotal ordinary dividends$4,071.54
1bQualified dividends$2,220.86
3Nondividend distributions$0.72
5Section 199A dividends$48.96
7Foreign tax paid$152.21
12Exempt-interest dividends$4.12

1099-INT: All zeros

1099-B Summary:

TermForm 8949 TypeProceedsCost BasisWash Sale DisallowedNet G/L
ShortA (basis reported)$19,559.64$19,953.56$0.00-$393.92
LongD (basis reported)$10,248.37$10,108.23$0.00+$140.14
Grand total$29,808.01$30,061.79$0.00-$253.78

Foreign income (from page 20):

Management fees paid (informational): $330.38

Notes:


7. 1099-Cash-WF-BW — Wealthfront Cash Account (Ben & Michelle, Account 8W539966)

File: 1099-cash-wf-bw.pdf (6 pages) Account: 8W539966 — Benjamin A Wilson / Michelle Wilson (joint) Statement date: 01/27/2026, Document ID: SKJH G1G KW5G Payer TIN: 27-1967207

Summary Totals

1099-DIV: All zeros

1099-INT:

BoxDescriptionAmount
1Interest income$1,932.96
All other boxes$0.00

1099-B: All zeros

Interest detail (monthly, all labeled “Interest”): Jan $43.32 | Feb $87.21 | Mar $105.82 | Apr $119.64 | May $163.35 | Jun $246.89 | Jul $234.69 | Aug $208.36 | Sep $209.02 | Oct $196.34 | Nov $168.01 | Dec $150.31 = $1,932.96

Notes:


8. 1099-WF-MW — Wealthfront Brokerage (Michelle, Account 8W286673)

File: 1099-wf-mw.pdf (18 pages) Account: 8W286673 — Michelle M Whidden (maiden name used) Statement date: 02/11/2026, Document ID: 5743 7SM 3XA7 Payer TIN: 27-1967207 Recipient TIN: XXX-XX-2360 (Michelle’s SSN)

Summary Totals

1099-DIV:

BoxDescriptionAmount
1aTotal ordinary dividends$729.39
1bQualified dividends$516.68
5Section 199A dividends$8.73
7Foreign tax paid$32.63
12Exempt-interest dividends$186.87

1099-INT: All zeros

1099-B Summary:

TermForm 8949 TypeProceedsCost BasisWash Sale DisallowedNet G/L
ShortA (basis reported)$4,943.31$5,057.52$0.00-$114.21
LongD (basis reported)$4,539.23$4,580.30$0.00-$41.07
Grand total$9,482.54$9,637.82$0.00-$155.28

Notable transactions:

Notes:


9 & 10. 1099-INT Chase — Michelle (Two Files)

Files: 1099-int-chase-mw.pdf and 1099-int-mw-chase.pdf

Duplicate Analysis

Both files are identical documents — same account, same amounts, same payer. The scanned version (1099-int-chase-mw.pdf) and the digital version (1099-int-mw-chase.pdf) contain the same data. Use only once — do not double-count.

Payer: JPMorgan Chase Bank, N.A., Federal ID: 13-4994650 Recipient: Michelle Margaux Wilson, 1212 S Suffolk Dr, Tampa FL 33629-4228 Recipient TIN: XXX-XX-2360 Account: 122705370 (SAVINGS)

BoxDescriptionAmount
1Interest income$1.02
4Federal income tax withheld$0.19
All other boxes$0.00

Notes:


11. 1099-INT Schwab — Ben & Michelle Joint (Account 5373-5670)

File: 1099-int-schwab-bw.PDF (9 pages) Account: 5373-5670 — Schwab One account of Benjamin Wilson & Michelle Margaux Wilson JT TEN Date prepared: January 23, 2026 Payer: Charles Schwab & Co., Inc., Federal ID: 94-1737782 Recipient TIN: XXX-XX-4122 (Ben’s SSN used as primary)

Form 1099-DIV:

BoxDescriptionAmount
1aTotal ordinary dividends$12.59
1bQualified dividends$12.59
All other boxes$0.00

Dividend detail: Apple (AAPL) $9.19 + Nvidia (NVDA) $3.40 = $12.59 (all qualified)

Form 1099-INT:

BoxDescriptionAmount
1Interest income$0.13
All other boxes$0.00

Interest detail: Deposit interest $0.13

Management fees (informational): Margin interest charged $1.36

Notes:


12. CTK Charitable Contributions

File: CTK-charitable-contributions.pdf Organization: Christ the King Catholic Church, 821 S Dale Mabry Hwy, Tampa FL 33609 Donor: Mr. and Mrs. Benjamin Wilson, 1212 S Suffolk Dr, Tampa FL 33629 Account #: 3766 Reporting period: 01/01/2025 to 12/31/2025 Date printed: 01/15/2026

Total Contributions: $3,105.00

Confirmation statement: “No goods or services were received in exchange for these contributions.”

Contribution types observed (partial detail shown):

Notes:


13. Small Blessings Preschool — Tuition Statement (Sophia)

File: small-blessings-tuition-2025.pdf Institution: Small Blessings Preschool, 500 W. Platt Street, Tampa FL 33606 Tax ID: 59-0714823 Student: Wilson, Sophia — Older Twos TTH (Tuesday/Thursday), Ms. Elena Period: 1/1/2025 to 12/31/2025 Issued: 1/15/2026

Charges breakdown:

DateDescriptionAmount
2/10/2025Fall Tuition 2s TH — August$407.00
2/10/2025Registration — New Student 25/26 SY$275.00
2/18/2025Card Processing Fee$22.17
8/4/2025Security Fee (annual)$300.00
8/11/2025Card Processing Fee$9.75
8/14/2025SB Tote Bag$20.00
8/27/2025Fall Supply Fee$225.00
9/4/2025Fall Tuition — September$407.00
9/4/2025Card Processing Fee$21.19
9/19/2025Fall Tuition — October$407.00
10/1/2025Card Processing Fee$13.23
11/3/2025Fall Tuition — November$407.00
11/3/2025Card Processing Fee$13.23
12/1/2025Fall Tuition — December$407.00
12/4/2025Card Processing Fee$13.23
12/4/2025Santa Breakfast (3 tickets)$75.00
Total charges$3,022.80
Total payments$2,947.80
Balance remaining$75.00

Net tuition paid in 2025 (excluding non-education fees):

Tax credit analysis — Child and Dependent Care Credit (Form 2441):


14. 1040-ES Q1 — Estimated Tax Payment

File: 1040ES-Q1-2025.pdf Confirmation: 222-5505-6341-9538 Date paid: April 14, 2025 Amount: $3,900.00 Bank: Evolve Bank and Trust (acct xxxxxx8324) Taxpayer: Benjamin Wilson


15. 1040-ES Q2 — Estimated Tax Payment

File: 1040ES-Q2-2025.pdf Confirmation: 222-5557-6458-9879 Date paid: June 5, 2025 Amount: $3,900.00 Bank: Column NA Mercury (acct xxxxxxxxxxx9402) Taxpayer: Benjamin Wilson


16. 1040-ES Q4 — Estimated Tax Payment

File: 1040ES-Q4-2025.pdf Confirmation: 222-5758-6061-4708 Date paid: December 23, 2025 Amount: $5,000.00 Bank: Column NA Mercury (acct xxxxxxxxxxx9402) Taxpayer: Benjamin Wilson

Note: No Q3 estimated tax payment document was provided. Verify whether a Q3 payment was made.


Consolidated Income Summary

Wages & S-Corp Income

SourceAmountNotes
W-2 wages (Ben, Ray Data LLC)$57,500.00Box 1
1099-NEC (Mammoth Growth to Ray Data LLC)$201,396.00Corporate revenue, not personal
K-1 Box 1 ordinary income (Ray Data LLC)UNKNOWN — obtain K-1Est. ~$120,000–$130,000
SEHI deduction (above-the-line)UNKNOWN — obtain K-1/recordsEst. ~$15,000–$16,000

Interest Income

SourceAccountAmountType
Wealthfront Cash (Ben/Michelle joint)8W539966$1,932.96Ordinary interest
Chase Savings (Michelle)122705370$1.02Ordinary interest
Schwab joint5373-5670$0.13Ordinary interest
Total interest$1,934.11

Dividend Income

SourceAccountOrdinaryQualifiedSec 199ATax-ExemptForeign Tax Paid
WF BW-1 (8W14YTCT)Ben$19.94$15.69$0.00$0.00$0.12
WF BW-2 (8W1067NV)Ben$10.25$7.11$0.00$0.00$0.00
WF BW-3 (8W108343)Ben$4,071.54$2,220.86$48.96$4.12$152.21
WF Cash (8W539966)Ben/MW joint$0.00$0.00$0.00$0.00$0.00
WF MW (8W286673)Michelle$729.39$516.68$8.73$186.87$32.63
Schwab joint (5373-5670)Ben/MW$12.59$12.59$0.00$0.00$0.00
Totals$4,843.71$2,772.93$57.69$190.99$184.96

Capital Gains / Losses

SourceAccountShort-TermLong-TermWash Sales
WF BW-1 (8W14YTCT)Ben-$109.01$0.00$0.00
WF BW-3 (8W108343)Ben-$393.92+$140.14$0.00
WF MW (8W286673)Michelle-$114.21-$41.07$0.00
Totals-$617.14+$99.07$0.00
Net capital gain/loss-$518.07

Notes:

Estimated Tax Payments

QuarterDateAmount
Q1April 14, 2025$3,900.00
Q2June 5, 2025$3,900.00
Q3NOT PROVIDED
Q4December 23, 2025$5,000.00
Total confirmed$12,800.00

W-2 federal withholding (Box 2): $4,946.38 Chase backup withholding: $0.19 Total payments confirmed: $12,800.00 + $4,946.38 + $0.19 = $17,746.57

Charitable Contributions

Dependent Care / Tuition


Missing / Action Items

  1. K-1 from Ray Data LLC 1120-S — Critical. Must obtain from Collective HUB to determine:
    • Box 1: Actual ordinary business income
    • Box 17: W-2 wages paid by S-Corp (for QBI limitation)
    • Any distributions
    • SEHI premium amount included in compensation
  2. Q3 estimated tax payment — No document provided. Verify whether $3,900 or other amount was paid in September 2025.
  3. SEHI confirmation — Confirm exact health insurance premium amount paid through Ray Data LLC for Ben in 2025. This is a critical above-the-line deduction and also reduces QBI base.
  4. Wealthfront MW tax-exempt interest — $186.87 is tax-exempt; confirm state of issuance if any AMT exposure (none expected for FL residents).
  5. Dependent care credit eligibility — Confirm with preparer whether Small Blessings qualifies as dependent care (vs. education) for Form 2441.
  6. Section 199A dividends ($57.69) — Small amount of REIT dividends eligible for 20% QBI deduction separate from S-Corp QBI.

Tax Return Estimate

IMPORTANT CAVEAT: This estimate uses an assumed K-1 ordinary income because the actual K-1 was not available in the documents provided. The estimate will need to be revised once the K-1 is obtained. All other numbers are from source documents.

Assumptions Used


Step 1: Gross Income

Income ItemAmount
W-2 wages (Ben)$57,500.00
K-1 ordinary business income (estimated)$126,021.00
Total interest$1,934.11
Total ordinary dividends$4,843.71
Net capital loss (capped at $3,000 deductible)-$518.07
Gross income$189,780.75

Step 2: Above-the-Line Deductions (to arrive at AGI)

DeductionAmountNotes
SEHI deduction (self-employed health insurance)-$15,000.00Estimated — confirm from K-1/S-Corp records
Adjusted Gross Income (AGI)$174,780.75

Step 3: Standard Deduction vs. Itemized

Standard deduction (MFJ 2025): $30,000

Itemized deductions:

ItemAmount
Charitable contributions (CTK)$3,105.00
State and local taxes (FL — no state income tax; limited to property taxes)Unknown
Mortgage interestUnknown
Total itemized (known)$3,105.00+

Conclusion: Standard deduction of $30,000 almost certainly exceeds itemized deductions. Use standard deduction.

Step 4: QBI Deduction (Section 199A)

QBI base for S-Corp:

QBI deduction from S-Corp: 20% × $111,021 = $22,204 (estimated)

QBI from Section 199A dividends:

Total QBI deduction: $22,204 + $12 = ~$22,216 (estimated)

Note: At 2025 MFJ income levels, the W-2 wage limitation does not phase in until taxable income exceeds ~$383,900 for MFJ filers, so the 20% of QBI is not expected to be wage-limited at this income level. Confirm with preparer.

Step 5: Taxable Income

ItemAmount
AGI$174,780.75
Less: Standard deduction-$30,000.00
Less: QBI deduction (estimated)-$22,216.00
Taxable income$122,564.75

Step 6: Federal Income Tax Calculation (2025 MFJ Brackets)

BracketRateTaxable Income in BracketTax
$0 – $23,85010%$23,850.00$2,385.00
$23,851 – $96,95012%$73,100.00$8,772.00
$96,951 – $122,564.7522%$25,614.75$5,635.25
Total ordinary income tax$16,792.25

Qualified dividends and long-term capital gains tax:

Total income tax before credits: $16,792.25 + $430.80 = $17,223.05

Step 7: Credits

CreditAmountNotes
Child Tax Credit (Sophia, born 2023)$2,000.00One dependent under 17; full credit at this income level
Foreign tax credit$184.96Total foreign taxes paid across all accounts (Form 1116)
Child and Dependent Care Credit~$600.00Estimated if Small Blessings qualifies; 20% × $3,000
Total credits~$2,784.96

Total income tax after credits: $17,223.05 - $2,784.96 = $14,438.09 (estimated)

Step 8: Payments vs. Tax Owed

PaymentAmount
W-2 federal withholding (Ben)$4,946.38
Estimated tax Q1 (April 2025)$3,900.00
Estimated tax Q2 (June 2025)$3,900.00
Estimated tax Q3UNKNOWN
Estimated tax Q4 (December 2025)$5,000.00
Chase backup withholding$0.19
Total confirmed payments$17,746.57

If no Q3 payment was made:

If a Q3 payment of ~$3,900 was made:


Key Sensitivities

The estimate is highly sensitive to the actual K-1 ordinary income. Here is a range:

K-1 Ordinary IncomeAGITaxable IncomeTaxEst. Refund (no Q3)
$110,000$162,760$110,544~$15,700~$4,200
$126,021 (estimate)$174,781$122,565~$17,223~$524
$140,000$186,760$134,544~$19,800~$2,053 owed

Critical action: Obtain the actual K-1 from Collective HUB before finalizing. The difference between a $110K and $140K K-1 income is a ~$4,100 swing in tax liability.


Self-Employment Tax Note

Ben’s S-Corp salary of $57,500 is the basis for payroll taxes (already withheld via the W-2: $3,565 SS + $833.75 Medicare = $4,398.75 employee side). The S-Corp pays the matching employer side. S-Corp distributions from the K-1 are not subject to self-employment tax — this is the primary S-Corp tax advantage.

Ben does not pay self-employment tax on K-1 ordinary income, only on his W-2 wages (already handled by payroll). No Schedule SE is required.