How to Report Freelance Income in Google Sheets (2026)

The Ledger tab is the raw transaction log — every invoice paid, every payment received, with enough structure for SUMIFS to slice it any way downstream tabs need.

The Assumptions tab is the single source of truth for every rate and threshold in the model. Nothing is hardcoded anywhere else.

Wire every formula in subsequent tabs to these cells using absolute references like Assumptions!$B$4. When the IRS adjusts a threshold — and it will — you update one cell and every output refreshes.

This tab is your live Schedule C draft. Per IRS Instructions for Schedule C (2025), gross receipts go to Line 1, returns and allowances to Line 2, and cost of goods sold (rare for service freelancers) to Line 4. Part II — Lines 8 through 27 — is where most of the deduction work happens.

The cross-tab SUMIFS formula pulls from the Ledger by category and fiscal year:

=SUMIFS(
  Ledger!$D:$D,
  Ledger!$C:$C,  SchedC!$A5,
  Ledger!$A:$A,  ">=" & Assumptions!$B$3,
  Ledger!$A:$A,  "<=" & DATE(YEAR(Assumptions!$B$3), 12, 31)
)

Map each Part II line explicitly:

For home office, the simplified method caps at $1,500/year ($5/sq ft, 300 sq ft max). If your dedicated office space is larger, Form 8829 handles the actual-expense calculation.

SE tax is 15.3% of 92.35% of net profit — the 92.35% factor adjusts for the employer-side FICA that a W-2 employee would never see. For the 2025 tax year, the Social Security wage base is $176,100 per IRS Instructions for Schedule C (2025), so the 12.4% Social Security component phases out above that threshold. The 2.9% Medicare portion applies to all net profit with no cap.

=LET(
  net_profit,   SchedC!$B$30,
  se_base,      net_profit * Assumptions!$B$5,
  ss_tax,       MIN(se_base, Assumptions!$B$7) * 0.124,
  mc_tax,       se_base * 0.029,
  total_se,     ss_tax + mc_tax,
  total_se
)

On $187,500 gross with 28% expenses: net profit = $135,000, SE base = $124,672, SE tax ≈ $19,075. The deductible half (≈$9,538) flows to Form 1040 Schedule 1, Line 15, and reduces AGI before the federal income tax calculation runs — which is why SE tax and federal income tax have to be computed in sequence, not in parallel.

Per IRS Form 1040-ES (2025), quarterly estimated payments are due April 15, June 16, September 15, and January 15 of the following year. Missing them triggers an underpayment penalty running at 8% annualized on the shortfall — not a huge number, but avoidable.

The safe-harbor rule: pay the lesser of 100% of last year's total tax liability or 90% of this year's estimated liability. If prior-year AGI exceeded $150,000, the threshold rises to 110% of last year's tax, per IRS Publication 505.

=LET(
  prior_tax,    Assumptions!$B$11,
  est_current,  SchedC!$B$40,
  safe_harbor,  IF(
                  Assumptions!$B$12 > 150000,
                  prior_tax * Assumptions!$B$8,
                  prior_tax
                ),
  quarterly,    MIN(safe_harbor, est_current * 0.9) / 4,
  quarterly
)

Wire the output into a payment schedule on the Summary tab:

On the $187,500 gross / 28% expense example, quarterly payments run approximately $11,850 each.

Google Sheets doesn't have Excel's Data Table (Alt+D+T). But LET lets you build a full two-variable output grid inline — and the pattern applies to any scenario analysis, not just tax planning.

The general pattern:

=LET(
  row_vals, {r1; r2; r3; r4; r5},   // vertical axis — first input variable
  col_vals, {c1, c2, c3, c4},        // horizontal axis — second input variable
  ARRAYFORMULA(f(row_vals, col_vals))
)

Row and column vectors broadcast against each other via ARRAYFORMULA to produce an m×n output matrix. The function f(x, y) can be anything: