The Shopfolio Blog

85+ free guides on taxes, bookkeeping, rental analysis, and real estate investing. Spreadsheet-backed, no fluff.

Freelancer

1099 Contractor vs. W-2 Employee: When to Hire Which (2026)

At 5–6 hours per week, a W-2 employee becomes cheaper than a $60/hr contractor. Here is the full cost comparison, the IRS behavioral control test, and the misclassification liability most owners miss.

Freelancer

5 Freelance Client Red Flags (and the Dollar Math Behind Each)

Most freelancers learn to spot bad clients after getting burned. The second lesson is cheaper. Five warning signs — with the exact numbers they cost you.

Freelancer

Best 1099 Freelancer Tax Tracker Spreadsheet for 2026

Track 1099 freelancer income, estimate quarterly taxes, and reconcile at year end. Compare free vs paid spreadsheet options and see which one saves you the most time.

Freelancer

Best Freelancer Tax Tracker Spreadsheet 2026 (Reviewed + Ranked)

Comparing the top 1099 freelancer tax tracker spreadsheets in 2026: Shopfolio Lite ($9 one-time), QuickBooks Solopreneur ($20/mo), FreshBooks ($17/mo), and free templates. SE tax, quarterly estimates,

Freelancer

Do Freelancers Need Business Insurance? (The 4 Policies Worth Knowing)

Professional liability (E&O) costs $400–$1,500 per year and is fully deductible. A client dispute without it typically costs $10,000–$40,000 in attorney fees alone. Here's which policies freelancers a

Freelancer

Do You Need an LLC as a Freelancer? The Tax Math (2026)

Most freelancers form an LLC for the wrong reason. Here's exactly what an LLC changes (and doesn't) for your taxes — and the income level where an S-Corp election actually saves money.

Freelancer

Freelancer Quarterly Tax Calendar 2026: All 4 Deadlines

The IRS quarterly estimated tax schedule for 2026 — all 4 deadlines, the income windows for each, how to calculate what you owe, and what happens if you miss one.

Freelancer

Freelancer Tax Deductions: The 12 Categories That Reduce Your Tax Bill

Every dollar of freelancer business deductions saves 26 to 36 cents in combined SE tax and income tax, depending on your bracket. Full $80K worked example with $5,727 in tax savings across all 12 dedu

Freelancer

Health Insurance for Freelancers: What to Buy and How to Deduct It (2026)

Most freelancers default to COBRA when they go independent — and overpay by $1,800 a year. Here's exactly how to pick the right plan, calculate your subsidy, and take the self-employed health insuranc

Freelancer

Home Office Tax Deduction for Freelancers: Simplified vs. Regular Method (2026)

The simplified method takes 5 minutes and saves $346. The regular method takes 30 minutes and saves $1,383. Here's exactly how to calculate the home office deduction — and which method wins for your s

Freelancer

How to Calculate Your Freelance Rate (The 3-Step Formula)

Most freelancers undercharge because they start with the market, not their own numbers. The 3-step formula: target gross income + business costs ÷ billable hours. Full worked example: $64K take-home o

Freelancer

How to Price a Freelance Project (Fixed-Fee Formula + Worked Example)

Charging hourly punishes efficiency. The fixed-fee formula: estimated hours × your hourly floor × scope buffer. Full worked example: 32-hour website project quoted at $3,400 with a 20% buffer baked in

Freelancer

How to Write a Freelance Invoice (and What to Do When Clients Don’t Pay)

The 9 fields every freelance invoice must include, when to send it, how to structure late fees, and the four-step escalation ladder when a client doesn’t pay.

Freelancer

IRS Underpayment Penalty for Freelancers: How to Avoid It (2026)

Miss a quarterly estimated tax payment and the penalty starts accruing that day — even if you pay everything by April 15. Here's the math, the two safe harbor methods, and what to do if you've already

Freelancer

Mileage Deduction for Freelancers: Standard Rate vs. Actual Expense (2026)

The 2026 IRS mileage rate is 72.5 cents per mile — but the actual expense method can save far more if you drive a newer or expensive car. Here's how to choose, the math for both, and the lock-in rule

Freelancer

SEP-IRA vs Solo 401(k) for Freelancers: Which Retirement Account Wins? (2026)

At $80K freelance income, a Solo 401(k) lets you contribute $33,670 — saving $7,407 in taxes. A SEP-IRA lets you contribute $14,870. Here's the math behind which account wins at your income level.

Freelancer

Schedule C Spreadsheet: Track Business Expenses for Tax Time

How to set up a Schedule C expense tracker that makes tax filing painless. 19 IRS categories explained, quarterly tax estimation, and the spreadsheet that does it automatically.

Freelancer

Self-Employment Tax: What It Is, How to Calculate It, and How to Reduce It

Self-employment tax is 15.3% on 92.35% of net SE income. Here is the exact formula, a full worked example for a $75K freelancer, and the strategies that legally reduce it.

Freelancer

Vehicle Tax Deduction for Self-Employed: Section 179, Bonus Depreciation & the Weight Test (2026)

A $47,000 truck deducted entirely in year one. A $45,000 sedan capped at $20,300. The 6,000-pound GVWR weight test determines which rule you fall under — and whether you can use Section 179 or standar

Freelancer

What Your Freelance Contract Must Include (and the 3 Clauses That Save You)

Most freelance contracts are missing the three clauses that prevent the most expensive disputes. Here’s what every freelance agreement needs — with the dollar math on what happens without them.

Freelancer

Your First 1099: The Complete Tax Checklist for New Freelancers

Got your first 1099? Here is exactly what to do: the two taxes you now owe, how much to set aside, when quarterly payments are due, and the 12 deductions that reduce your bill. Educational content — n

Small Business

Best Small Business Bookkeeping Spreadsheet 2026 (Reviewed + Ranked)

Comparing the top small business bookkeeping spreadsheets in 2026: Shopfolio Pro ($29 one-time), QuickBooks Simple Start ($35/mo), Wave (free), and popular Etsy templates. Schedule C alignment, cash f

Small Business

How to Build a 6-Month Cash Flow Projection for Your Small Business

A cash flow projection shows when money actually lands in your account — not when you invoice. Here is how to build one in five rows, with a full worked example and the three gaps most business owners

Small Business

How to Calculate Your Business Break-Even Point (Formula + Examples)

Break-even analysis answers one question: how much revenue do you need to stop losing money? Here are the two formulas every small business owner needs, with service and product business examples.

Small Business

How to Improve Small Business Cash Flow: 13 Strategies, Ranked by Impact

Cash flow problems kill profitable businesses. Here are 13 ways to fix yours — from invoice timing changes (this week) to structural moves that eliminate the problem permanently.

Small Business

How to Manage Small Business Finances: The Complete Guide

The 7 financial systems every small business needs — from tracking your first expense to benchmarking your profit margins. Full $180K worked example with verified math.

Small Business

How to Pay Yourself as a Small Business Owner (Salary vs. Draw vs. Distribution)

Sole proprietors take an owner’s draw. S-corp owners must take a salary. The method determines what you owe in taxes — and the difference can be thousands of dollars per year.

Small Business

How to Price Your Product or Service: 3 Methods With Real Math

Cost-plus gives you the floor. Value-based gives you the ceiling. Competitive pricing tells you where you'll actually land. Here's how to use all three — with worked examples.

Small Business

How to Read a Profit and Loss Statement (and What It Won't Tell You)

A P&L statement shows revenue minus expenses. But it hides cash flow timing, customer concentration risk, and the difference between accrual profit and money in your account. Here is what to do with b

Small Business

LLC vs. Sole Proprietor vs. S-Corp: Which Business Structure Saves the Most in Taxes?

Compare LLC, sole proprietor, and S-Corp taxes with real numbers. SE tax savings at $50K, $80K, and $120K profit — and the income threshold where an S-Corp election actually pays off.

Small Business

Should Your LLC Elect S-Corp Status? The Break-Even Tax Math (2026)

An S-Corp election saves $3,434/year at $80K profit — but only if the math clears the overhead. Here’s the full SE tax comparison, reasonable compensation trap, and the income level where it actually

Small Business

Small Business Bookkeeping Template: Replace QuickBooks for $9

A small business bookkeeping spreadsheet template that tracks income, expenses, and P&L with IRS Schedule C categories. Replace QuickBooks for a one-time $9 purchase.

Small Business

Small Business Payroll Taxes: What You Owe Beyond the Salary (2026)

A $50,000 salary triggers $4,110 in employer payroll taxes — FICA, FUTA, and SUTA — before workers’ comp or benefits. Here’s the full stack, the filing schedule, and the one penalty that pierces your

Small Business

Small Business Tax Deadlines 2026: The Complete Calendar for Sole Proprietors

Every 2026 tax deadline for sole proprietors, LLCs, and small businesses — quarterly estimated taxes, 1099-NEC, Schedule C, payroll. With penalty math and a 5-step system to never miss one.

Small Business

What Is a Good Profit Margin for a Small Business? (2026 Industry Benchmarks)

A 10% net profit margin is thriving in restaurants. It’s underperforming in consulting. Industry context determines what good means — here are the benchmarks and three levers to improve yours.

Small Business

When to Hire Your First Employee: The Full Cost Calculation (2026)

A $50,000 salary costs $66,057 in year one. Here is the full cost stack — payroll taxes, benefits, overhead — and the three signals that tell you the math works.

Landlord

1031 Exchange Rules: How Landlords Defer Capital Gains and Depreciation Recapture

How the 1031 exchange works for rental property — the 45-day and 180-day rules, qualified intermediary requirement, basis carryover, and the full tax math on a $300K property with $85K of accumulated

Landlord

Airbnb vs. Long-Term Rental: Which Strategy Makes More Money?

Full cost comparison — Airbnb vs. long-term rental on the same $300K property. Two occupancy scenarios, property management fee impact, break-even occupancy, and the 3 questions every investor must an

Landlord

Best Rental Property Tracker Spreadsheet 2026 (Reviewed + Ranked)

Comparing the top rental property tracker spreadsheets in 2026: Shopfolio Pro ($29 one-time), Stessa, Landlord Studio, and popular Etsy templates. Schedule E auto-fill, budget vs actual, and the one-t

Landlord

Cap Rate Calculator: Formula, How to Use It, and What It Doesn't Tell You

Capitalization rate formula, a worked example with real expense numbers, good cap rate benchmarks by market type, and how to use cap rate to value a property before you make an offer.

Landlord

DSCR Calculator for Rental Properties: How Lenders Score Your Deal

How to calculate DSCR (Debt Service Coverage Ratio) for a rental property — the formula lenders use, qualification thresholds, how rent projections affect your numbers, and how to back-solve your max

Landlord

Do I Need an LLC for a Rental Property? (The Honest Math)

The case for an LLC rests on three claims: liability protection, privacy, and tax savings. Two of those three are mostly wrong. Here is the actual math.

Landlord

Gross Rent Multiplier (GRM): The 30-Second Deal Screen and Why You Can't Stop There

GRM formula, a worked example on a $300K SFR, market benchmarks by property class, and why GRM alone will lead you into bad deals — with the four-filter cascade that actually works.

Landlord

How to Analyze a Rental Property Deal in 10 Minutes

Learn the 5 metrics that separate profitable rental deals from money pits: NOI, Cap Rate, DSCR, Cash-on-Cash, and IRR. Step-by-step with real numbers.

Landlord

How to Build Long-Term Wealth With Rental Properties: The Complete 2026 Guide

How rental properties actually build wealth: the 5 levers (cash flow, amortization, appreciation, tax benefits, inflation hedge) with a full $200K worked example. Then the 6-step investor roadmap.

Landlord

How to Buy Your First Rental Property: A Step-by-Step Guide (2026)

The number-first approach to buying your first rental property — target criteria, financing limits, the 5-minute deal screen, and how to calculate the maximum price you should offer.

Landlord

How to Calculate Rental Property Cash Flow (The Number Every Landlord Gets Wrong)

The formula for rental property cash flow — the full top-down model from gross rent to net cash in pocket, and the $10,821 mistake most landlords make on paper.

Landlord

How to Evict a Tenant: The Legal Process Step by Step (2026)

The eviction process: 5 steps, state timelines from 30 days (Texas) to 12 months (California), 4 mistakes that get cases dismissed, and the full cost stack at $1,800/month rent.

Landlord

How to Finance a Rental Property: 5 Loan Options Compared (2026)

Conventional, DSCR, hard money, portfolio, seller financing — each loan type has different rate, qualification, and cash flow trade-offs. Here is how to choose, with real numbers.

Landlord

How to Screen a Tenant: The Landlord’s Checklist (2026)

A bad tenant costs $5,000–$10,000 in eviction, lost rent, and turnover. Here is the step-by-step tenant screening checklist that protects landlords — without Fair Housing violations.

Landlord

Landlord Insurance: What It Covers, What It Doesn't, and How to Factor It Into Your Deal

What landlord insurance actually covers on a rental property — DP3 vs. DP1, ACV vs. replacement cost, liability gaps, and how to model the premium correctly in your NOI analysis.

Landlord

Move-Out Inspection Checklist for Landlords (What to Document Before Returning the Deposit)

A room-by-room move-out inspection checklist for landlords: what to document, how to photograph, and the four documentation mistakes that lose deposit disputes in court.

Landlord

Property Manager Cost vs. Self-Managing: The Full Math (2026)

Most landlords quote property management at 10%. The real all-in cost is 14–17% of gross rent. Here is the break-even analysis that tells you which path makes financial sense.

Landlord

Rental Property Depreciation Recapture: What You'll Owe When You Sell

The full tax calculation when you sell a rental property — depreciation recapture at 25%, long-term capital gains, and NIIT. Full worked example: $300K property held 10 years, $375K sale, $32K–$39K in

Landlord

Rental Property Depreciation: The Tax Shelter Most Landlords Underuse

How the 27.5-year depreciation deduction works, a year-by-year tax savings table on a real example, the land allocation trap, cost segregation basics, and what recapture costs at sale.

Landlord

Rental Property Due Diligence Checklist: What to Inspect Before You Buy

A complete rental property due diligence checklist covering physical inspection, financial verification, legal title review, and neighborhood analysis — with the math that turns DD findings into price

Landlord

Rental Property Expense Tracker: What to Track and Why

Every expense category landlords should track for rental properties. How to organize income, expenses, and repairs for tax time and cash flow analysis.

Landlord

Schedule E Rental Income: What Every Landlord Must Track (and Why Depreciation Changes Everything)

Schedule E is where rental income and losses are reported on Form 1040. Here is the full expense list, a line-by-line worked example, and the depreciation math that most landlords miss.

Landlord

What Can a Landlord Deduct From a Security Deposit? (State-by-State Guide)

Security deposit deductions: what landlords can and cannot charge, normal wear and tear vs. damage, state return deadlines (14–30 days), and the prorated deduction formula with a worked example.

Landlord

What to Include in a Rental Lease Agreement (5 Clauses That Protect Landlords)

Most lease templates are missing 5 clauses that cost landlords thousands. Here is what every rental lease must include — and the exact language that protects you.

Real Estate

BRRRR Calculator Spreadsheet: Model Your Next Flip-to-Rental

How to use a BRRRR calculator spreadsheet to model Buy-Rehab-Rent-Refinance-Repeat deals. MAO, rehab budget, cash-out refi math, and the cash-left-in-deal metric.

Real Estate

Best BRRRR Calculator Spreadsheet 2026 (Reviewed + Ranked)

Comparing the top BRRRR calculator spreadsheets in 2026: Shopfolio Pro ($29), DealCheck Plus ($10/mo), BiggerPockets free, and the most popular Etsy template. Which one actually models the full cycle?

Real Estate

Best Real Estate Deal Analyzer Spreadsheet 2026 (Reviewed + Ranked)

Comparing the top real estate deal analyzer spreadsheets in 2026: Shopfolio Pro ($29), AssetAFC ($38), DealCheck ($10/mo), and the BiggerPockets free calculator. One-time vs. subscription, depth of an

Real Estate

Cash on Cash Return Calculator: Formula, Benchmarks, and What It Misses

How to calculate cash on cash return for rental property — the formula, what qualifies as a good CoC in today's market, and why you need DSCR alongside it before making an offer.

Real Estate

How the BRRRR Method Works: Step-by-Step with Real Numbers

The complete BRRRR investing cycle explained with real numbers: MAO, rehab, rent, cash-out refi, and the Repeat math. Full $200K worked example with 2026 rate reality check.

Real Estate

Real Estate Deal Analyzer Calculator: How to Underwrite a Rental Property

How to use a real estate deal analyzer spreadsheet to underwrite rental properties. Calculate NOI, DSCR, Cap Rate, IRR, and get a GO/NO-GO verdict in 10 minutes.

Real Estate

The BRRRR Strategy: How to Calculate Your Returns

Learn how to calculate BRRRR returns step by step. MAO via the 70% rule, rehab budgeting, cash-out refi math, and the cash-left-in-deal metric that matters most.

Real Estate

What Is a Good Cap Rate? (2026 Market Benchmarks)

What counts as a good cap rate depends on market tier, property class, and the interest rate environment — not a single number. Here are the institutional benchmarks and how to apply them to a specifi

Guide

How to Calculate Q2 Estimated Taxes (Due June 15, 2026)

Q2 estimated taxes are due June 15 and cover only April–May income. Here is the exact calculation: SE tax formula, safe harbor method, and a worked example for a $60K freelancer.

Guide

Net Operating Income (NOI) Calculator: Formula, Full Example, and What It Misses

NOI formula for rental property, a line-by-line expense build on a real example, the most common ways investors inflate NOI, and how NOI feeds cap rate, DSCR, and cash on cash return.

Freelancer

Best Google Sheets Budget Template for Freelancers (2026)

The 5 things your freelance budget spreadsheet needs: income tracking by client, quarterly tax set-asides, Schedule C expense categories, profit margin alerts, and cash runway projections.

Landlord

How to Track Rental Property Income & Expenses in a Spreadsheet

Set up a rental property expense tracker that maps to IRS Schedule E. Track rent collected, repairs, insurance, depreciation, and net cash flow per property per month.

Real Estate

BRRRR Calculator Spreadsheet for Real Estate Investing

How to use a BRRRR calculator spreadsheet to model the full cycle: MAO, rehab budget, holding costs, refi proceeds, cash left in deal, and post-refi cash flow with sensitivity analysis.

Freelancer

Freelancer Tax Tracker: How to Calculate Quarterly Estimated Taxes

Calculate quarterly estimated taxes using Form 1040-ES. SE tax formula, safe harbor rules, underpayment penalties, the 2026 deadline calendar, and how to track it all in a spreadsheet.

Small Business

Small Business Bookkeeping Spreadsheet vs QuickBooks

When a spreadsheet beats QuickBooks for small business bookkeeping, and when it doesn't. Transaction volume thresholds, feature comparison, cost analysis, and the migration trigger.

Real Estate

Real Estate Deal Analyzer Template: How to Use One

Walk through a real 4-unit deal with cap rate, DSCR, cash-on-cash return, NOI, and debt yield. See where the same property passes at $340K and fails at $420K.

Small Business

How to Track Etsy Shop Profit Per Listing

Calculate true profit per Etsy listing after all fees: listing fee, transaction fee, payment processing, Offsite Ads, shipping labels. Most sellers overestimate margins by 15-25%.

Small Business

Best Spreadsheet Templates for Small Business (2026)

The 7 spreadsheet templates every small business needs: P&L tracker, cash flow projection, tax prep organizer, invoice tracker, break-even calculator, budget template, and industry benchmarks.