01-projects/financials/tax-prep/2025

document summary

2026-04-06·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

Box Description Amount
1 Wages, tips, other compensation $57,500.00
2 Federal income tax withheld $4,946.38
3 Social security wages $57,500.00
4 Social security tax withheld $3,565.00
5 Medicare wages and tips $57,500.00
6 Medicare tax withheld $833.75
12 (no entries)
14 Other (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

Box Description Amount
1 Nonemployee compensation $201,396.00
4 Federal 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 Line Description Amount
3 Total 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:

Box Description Amount
1a Total ordinary dividends $19.94
1b Qualified dividends $15.69
7 Foreign tax paid $0.12

1099-INT: All zeros (no interest income)

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

Term Form 8949 Type Proceeds Cost Basis Wash Sale Disallowed Net G/L
Short A (basis reported) $1,752.73 $1,861.74 $0.00 -$109.01
Long D (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:

Box Description Amount
1a Total ordinary dividends $10.25
1b Qualified 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:

Box Description Amount
1a Total ordinary dividends $4,071.54
1b Qualified dividends $2,220.86
3 Nondividend distributions $0.72
5 Section 199A dividends $48.96
7 Foreign tax paid $152.21
12 Exempt-interest dividends $4.12

1099-INT: All zeros

1099-B Summary:

Term Form 8949 Type Proceeds Cost Basis Wash Sale Disallowed Net G/L
Short A (basis reported) $19,559.64 $19,953.56 $0.00 -$393.92
Long D (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:

Box Description Amount
1 Interest 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:

Box Description Amount
1a Total ordinary dividends $729.39
1b Qualified dividends $516.68
5 Section 199A dividends $8.73
7 Foreign tax paid $32.63
12 Exempt-interest dividends $186.87

1099-INT: All zeros

1099-B Summary:

Term Form 8949 Type Proceeds Cost Basis Wash Sale Disallowed Net G/L
Short A (basis reported) $4,943.31 $5,057.52 $0.00 -$114.21
Long D (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)

Box Description Amount
1 Interest income $1.02
4 Federal 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:

Box Description Amount
1a Total ordinary dividends $12.59
1b Qualified 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:

Box Description Amount
1 Interest 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:

Date Description Amount
2/10/2025 Fall Tuition 2s TH — August $407.00
2/10/2025 Registration — New Student 25/26 SY $275.00
2/18/2025 Card Processing Fee $22.17
8/4/2025 Security Fee (annual) $300.00
8/11/2025 Card Processing Fee $9.75
8/14/2025 SB Tote Bag $20.00
8/27/2025 Fall Supply Fee $225.00
9/4/2025 Fall Tuition — September $407.00
9/4/2025 Card Processing Fee $21.19
9/19/2025 Fall Tuition — October $407.00
10/1/2025 Card Processing Fee $13.23
11/3/2025 Fall Tuition — November $407.00
11/3/2025 Card Processing Fee $13.23
12/1/2025 Fall Tuition — December $407.00
12/4/2025 Card Processing Fee $13.23
12/4/2025 Santa 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

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

Interest Income

Source Account Amount Type
Wealthfront Cash (Ben/Michelle joint) 8W539966 $1,932.96 Ordinary interest
Chase Savings (Michelle) 122705370 $1.02 Ordinary interest
Schwab joint 5373-5670 $0.13 Ordinary interest
Total interest $1,934.11

Dividend Income

Source Account Ordinary Qualified Sec 199A Tax-Exempt Foreign 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

Source Account Short-Term Long-Term Wash 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

Quarter Date Amount
Q1 April 14, 2025 $3,900.00
Q2 June 5, 2025 $3,900.00
Q3 NOT PROVIDED
Q4 December 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 Item Amount
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)

Deduction Amount Notes
SEHI deduction (self-employed health insurance) -$15,000.00 Estimated — 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:

Item Amount
Charitable contributions (CTK) $3,105.00
State and local taxes (FL — no state income tax; limited to property taxes) Unknown
Mortgage interest Unknown
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

Item Amount
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)

Bracket Rate Taxable Income in Bracket Tax
$0 – $23,850 10% $23,850.00 $2,385.00
$23,851 – $96,950 12% $73,100.00 $8,772.00
$96,951 – $122,564.75 22% $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

Credit Amount Notes
Child Tax Credit (Sophia, born 2023) $2,000.00 One dependent under 17; full credit at this income level
Foreign tax credit $184.96 Total foreign taxes paid across all accounts (Form 1116)
Child and Dependent Care Credit ~$600.00 Estimated 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

Payment Amount
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 Q3 UNKNOWN
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 Income AGI Taxable Income Tax Est. 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.