Freelance Income Tracker Spreadsheet 2027, Self Employed Income, 1099 Tracker, Side Hustle, Google Sheets Excel

Seller's description

Freelance income tracker spreadsheet for Google Sheets and Excel: track self employed income by client, your real hourly rate, 1099 forms and quarterly tax — and pay yourself a steady salary from irregular income. Instant digital download from Fyscale.

✦ FREELANCE INCOME TRACKER PRO — EDITION 2027.1 (BUILT FOR 2027–2029)
Know your real hourly rate, what you owe the IRS — and how much you can safely pay yourself.

Log each payment and your hours. Your real $/hour per client and per project, monthly income vs goal, self-employment tax, four quarterly payments, 1099 checks and a steady monthly salary all calculate themselves. 17 sheets, 14,000+ formulas, zero formulas for you to write.

──────────────────────────────────────────
NEW IN EDITION 2027.1
──────────────────────────────────────────
★ Pay Yourself a Salary — the irregular-income budget: pick the salary you want, and a buffer account absorbs good and slow months. Each month shows what's available, the salary paid, the buffer and a status — plus a suggested steady salary based on your real numbers.
★ Rates & Rules + Tax Brackets by year — IRS & SSA figures for 2026–2030 with Official / Estimate status, picked automatically from your tax year. Includes the 2027 Social Security wage base ($192,300).
★ 1040-ES due dates by year — rolled forward for weekends and holidays.
★ Light + Dark editions — same formulas, pick the look you like.

──────────────────────────────────────────
WHAT'S INSIDE — 17 SHEETS
──────────────────────────────────────────
📊 Dashboard — 12 live KPIs: income, net profit, real $/hour, hours worked, billable share, goal reached, estimated tax, set aside so far, next tax payment and amount, money still owed to you, top client. Month by month, income vs goal chart, who pays you best, tax payments and project alerts.
💵 Income — 600 payments: platform/processing fees, net received and the amount to set aside for tax on every payment.
⏱ Time Log — 1,200 entries, billable or not; client and value fill in from your hourly rate.
📁 Projects — 200 projects: quote vs hours actually worked, real $/hour, still owed and alerts (Past due · Over hours · Unpaid balance · Below your rate).
👥 Clients — 100 clients: paid this year, hours, real $/hour, share of income and which tax form to expect (1099-NEC, 1099-K or none).
🧾 Expenses — 400 business costs with the deductible % by category.
📅 Monthly Summary — income, fees, expenses, net profit, hours, real $/hour, goal and set-aside every month, with a chart.
🏛 Tax Estimate — self-employment tax (with the wage base), federal income tax by bracket, QBI deduction, state estimate, the 4 quarterly payments with due dates and status, plus a safe-harbor amount.
💼 Pay Yourself — a steady salary from irregular income, with a buffer account and chart.
📑 1099 Check — type the amount on each 1099-NEC / 1099-K you receive; differences are flagged before you file.
💲 Rate Calculator — the minimum hourly rate you need from your take-home goal, costs, taxes and billable hours — and instant project quotes.
⚙️ Setup + Rates & Rules + Tax Brackets + Version & Updates + Start Here + How to Use.

──────────────────────────────────────────
WHAT YOU GET (4 DOWNLOADS)
──────────────────────────────────────────
✓ Fyscale-Freelance-Income-Tracker-Pro-2027.xlsx — Light edition, Excel 2016+ and Google Sheets
✓ Fyscale-Freelance-Income-Tracker-Pro-2027-Dark.xlsx — Dark edition, same formulas
✓ 14-page Quick-Start Guide (PDF) with a screenshot for every step + what's new in 2027.1
✓ Video tutorial (MP4)
✓ Example data included so you see every report working — clear it in one step
✓ Instant download

──────────────────────────────────────────
PERFECT FOR
──────────────────────────────────────────
• Freelance designers, writers, developers, photographers, VAs and consultants
• Upwork and Fiverr sellers (fees and 1099-K handled)
• Anyone with variable income who wants a steady paycheck
• Anyone with a side hustle paying their own quarterly taxes

──────────────────────────────────────────
HOW TO USE
──────────────────────────────────────────
1. Setup: filing status, state tax rate and your income goal.
2. Clients and Projects: your rate, quotes and estimated hours.
3. Income: log each payment — move the set-aside to savings.
4. Time Log: log your hours every day.
5. Pay Yourself: set one steady salary; each quarter pay the amount on Tax Estimate.

──────────────────────────────────────────
BUILT TO LAST — 2027 · 2028 · 2029
──────────────────────────────────────────
✓ Tax figures and brackets are kept by year in Rates & Rules and Tax Brackets — change the tax year in Setup and everything follows, due dates included.
✓ Free yearly updates through the 2029 edition with the new brackets, wage base and 1040-ES dates already filled in. The IRS had not published its 2027 inflation figures when this edition was made — those rows are marked Estimate and the official figures arrive free.
✓ Works in Excel 2016+ and Google Sheets — no add-ons, no macros, no subscription to expire. Your data stays in your own file.

──────────────────────────────────────────
WHY FYSCALE
──────────────────────────────────────────
✦ Full commercial license — use for your own business AND your clients' businesses
✦ Free yearly updates through the 2029 edition
✦ Direct support from the maker — message us, we reply within 24 hours
✦ 30-day money-back guarantee — no risk
✦ Built for US freelancers: IRS brackets, SE tax, Form 1040-ES dates, US Letter printing

LICENSE
Allowed: use the file for your own business, clients, or customers. Modify the contents as you wish.
Not allowed: resell or redistribute the raw files or blank templates.

30-DAY GUARANTEE
If after 30 days you feel this file doesn't help, send us a message on Etsy and we'll refund your money. No hassle, no long questions.

DISCLAIMER
This template gives planning estimates only. It is not tax, legal, financial or accounting advice and is not affiliated with the IRS. Tax figures are editable — confirm final amounts with a qualified tax professional.

HOW THIS WAS MADE
Designed and tested by Fyscale. AI tools assisted with drafting and formula checks; every file was reviewed and recalculated before release.

FAQ — FREQUENTLY ASKED QUESTIONS
Q: What is "real $/hour"?
A: Everything a client paid you divided by every hour you logged for them — including emails, calls and revisions.

Q: How does "Pay Yourself" work with irregular income?
A: Every payment goes into a buffer account; you pay yourself the same salary each month. The sheet shows whether the buffer can keep up and suggests a safe salary.

Q: Does it handle married filing jointly?
A: Yes. Choose your filing status in Setup and add your spouse's income for a household estimate.

Q: Do I need spreadsheet experience?
A: No. If you can type a date and an amount, you can use this file. The guide and video walk you through every step.

Q: Is this a physical product?
A: No, this is a digital download. You'll get the files instantly after purchase.

Q: Can I use this on my phone?
A: Yes. Google Sheets works on phones — handy for logging hours on the go.

──────────────────────────────────────────
PAIRS PERFECTLY WITH
Self-Employed Tax Organizer — Edition 2027.1 with Deduction Finder and an offline Tax Estimator.
See all Fyscale tools: etsy.com/shop/Fyscale

Fyscale — premium finance tools for US freelancers and small business owners.