01-projects / financials / tax-prep / 2024

document summary

Sun Apr 05 2026 20:00:00 GMT-0400 (Eastern Daylight Time) ·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)

TermProceedsCost BasisWash Sale DisallowedNet 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)

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

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

Income

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

Federal Tax Withheld (W-2)

SourceAmount
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

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

Capital Gains / Losses

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

Estimated Tax Payments

QuarterDate PaidAmount
Q1 2024April 10, 2024$4,230.00
Q2 2024June 10, 2024$4,230.00
Q3 2024Not documented — verify
Q4 2024January 3, 2025$4,230.00
Total documented$12,690.00

Itemized Deductions (Schedule A)

CategoryAmountSource
Mortgage interest (Box 1, Form 1098)$16,990.68Mr. Cooper
Property taxes paid (from escrow)$9,544.21Hillsborough County via escrow
Charitable contributions — Christ the King$2,785.00Church 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 ItemAmount
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.