01-projects/financials/tax-prep/2024

document summary

2026-04-06·tax-prep·status: in-progress

2024 Tax Document Summary

Filing status: Married Filing Jointly | Dependents: 1 (Sophia M. Wilson, born 2023-02-16) | State: Florida (no state income tax)


1. W-2 — Benjamin A. Wilson (Ray Data LLC)


2. W-2 — Michelle M. Wilson (Perez Eye Center)


3. Form 1095-B — Health Coverage


4. Form 1098 — Mortgage Interest (Mr. Cooper / Nationstar)

Form 1098 Boxes:

Escrow Summary (from annual statement):


5. Form 1099-NEC — Mammoth Growth / Ray Data Co

Boxes:


6. Form 1099 Composite — Charles Schwab

Form 1099-DIV

Form 1099-INT

Form 1099-B (Summary of Proceeds, Gains & Losses)

All amounts $0.00 — no sales transactions in this account.


7. Form 1099 — Wells Fargo Investment (Wealthfront Brokerage, Account 8W108343)

Form 1099-DIV

Form 1099-INT

Form 1099-B (Summary of Proceeds, Gains & Losses)

Term Proceeds Cost Basis Wash Sale Disallowed Net Gain/(Loss)
Short-term (covered, Box A) $17,479.97 $17,732.86 $2.18 ($250.71)
Long-term (covered, Box D) $1,848.80 $1,847.90 $0.00 $0.90
Grand Total $19,328.77 $19,580.76 $2.18 ($249.81)

Notable holdings sold (short-term losses):


8. Form 1099 — Wells Fargo Savings (Wealthfront Brokerage, Account 8W539966)

Form 1099-INT

Monthly detail: Jan $77.60 | Feb $65.16 | Mar $38.49 | Apr $41.64 | May $58.39 | Jun $55.68 Jul $50.35 | Aug $48.30 | Sep $44.53 | Oct $39.00 | Nov $36.19 | Dec $46.25

Form 1099-DIV / 1099-B


9. Charitable Contributions — Christ the King Catholic Church

Contribution totals:


10. Schedule K-1 (Form 1120-S) — Ray Data LLC

Part III — Income, Deductions, Credits:

Items affecting shareholder basis:

Other information:

Notes: The $81,049 ordinary income flows to Schedule E, Page 2. The $89,778 in cash distributions is non-taxable return of basis (not additional income). Ben's W-2 salary of $55,000 from Ray Data LLC is separate.


11. Estimated Tax Payment — Q1 2024


12. Estimated Tax Payment — Q2 2024


13. Estimated Tax Payment — Q4 2024


14. Escrow Details — 2024 (escrow-details-2024.jpg)

Item Annual Amount Provider
County Tax (Hillsborough, Parcel A1206680000) $9,544.21
Hazard Insurance $7,744.00 Slide Insurance Company (SIC3055601)
Flood Insurance $1,979.00 Wright National Flood (09115230923401)

Tax Return Inputs — 2024 Federal (MFJ, 1 dependent)

Income

Category Amount Source
Ben W-2 wages (Box 1) $55,000.00 Ray Data LLC W-2
Michelle W-2 wages (Box 1) $118,750.06 Perez Eye Center W-2
Total W-2 wages $173,750.06
S-Corp K-1 ordinary income $81,049.00 Ray Data LLC Schedule K-1
1099-NEC (Ray Data LLC entity level) $189,870.00 Mammoth Growth — flows through S-Corp, already reflected in K-1

Federal Tax Withheld (W-2)

Source Amount
Ben W-2 federal withheld $4,615.92
Michelle W-2 federal withheld $18,038.54
Total W-2 federal withheld $22,654.46

Investment Income

Category Amount Source
Interest — Schwab (1099-INT) $0.12 Schwab acct 5373-5670
Interest — Wealthfront savings (1099-INT) $601.58 Wealthfront acct 8W539966
Total interest income $601.70
Ordinary dividends — Schwab (1099-DIV Box 1a) $11.52 Schwab acct 5373-5670
Qualified dividends — Schwab (1099-DIV Box 1b) $11.52 Schwab acct 5373-5670
Ordinary dividends — Wealthfront invest. (1099-DIV Box 1a) $2,638.40 Wealthfront acct 8W108343
Qualified dividends — Wealthfront invest. (1099-DIV Box 1b) $1,877.13 Wealthfront acct 8W108343
Total ordinary dividends $2,649.92
Total qualified dividends $1,888.65
Foreign tax paid (potential credit) $125.09 Wealthfront acct 8W108343
Exempt-interest dividends (tax-free) $418.78 Wealthfront acct 8W108343
Section 199A dividends $45.55 Wealthfront acct 8W108343

Capital Gains / Losses

Category Net Gain/(Loss) Source
Short-term net (Wealthfront 8W108343) ($250.71) Covered lots
Long-term net (Wealthfront 8W108343) $0.90 Covered lots
Schwab acct 5373-5670 $0.00 No sales
Wealthfront acct 8W539966 $0.00 No sales
Total net capital gain/(loss) ($249.81)

Estimated Tax Payments

Quarter Date Paid Amount
Q1 2024 April 10, 2024 $4,230.00
Q2 2024 June 10, 2024 $4,230.00
Q3 2024 Not documented — verify
Q4 2024 January 3, 2025 $4,230.00
Total documented $12,690.00

Itemized Deductions (Schedule A)

Category Amount Source
Mortgage interest (Box 1, Form 1098) $16,990.68 Mr. Cooper
Property taxes paid (from escrow) $9,544.21 Hillsborough County via escrow
Charitable contributions — Christ the King $2,785.00 Church statement
Total itemized deductions $29,319.89

Standard deduction (MFJ 2024): $29,200

Itemizing vs. standard deduction: The itemized total of $29,319.89 exceeds the $29,200 MFJ standard deduction by approximately $120. This is extremely close — the marginal benefit of itemizing is negligible (~$120 additional deduction). However, this does NOT account for any other potential Schedule A deductions (state/local taxes are capped at $10,000 SALT; Florida has no state income tax, so SALT is limited to the $9,544.21 property tax — already included above). Given the SALT cap includes property taxes and the total is barely above the standard deduction, the practical recommendation is to verify whether any other itemizable expenses exist (unreimbursed medical expenses >7.5% AGI, additional charitable giving to other organizations, etc.). If not, the difference is immaterial and either approach yields nearly identical results. Most tax software will automatically select the higher deduction.

Summary Income Picture

Line Item Amount
W-2 wages (combined) $173,750.06
S-Corp K-1 ordinary income $81,049.00
Interest income $601.70
Ordinary dividends (net of exempt) $2,231.14
Net capital loss ($249.81)
Approximate gross income ~$257,382
Less: estimated tax payments ($12,690.00)
Less: W-2 withholding ($22,654.46)

Note on Q3 payment: Only Q1, Q2, and Q4 estimated tax payment documents are present. Confirm whether a Q3 payment (~September 2024 deadline) was made. Total documented estimated payments are $12,690. If Q3 was also $4,230, total would be $16,920.

Note on self-employment / QBI: The K-1 ordinary income of $81,049 may qualify for the 20% Section 199A Qualified Business Income deduction, subject to W-2 wage limits and taxable income thresholds. At approximately $257K gross income MFJ, they are within the phase-in range for the QBI deduction limitation — this requires careful calculation by the tax preparer.

Note on Additional Medicare Tax: Combined wages + K-1 income exceeds the $250,000 MFJ threshold for the 0.9% Additional Medicare Tax. Tax preparer should confirm this is calculated on Form 8959.