Freelancer Business Tracker PLR (auto calculating)

Freelancer Business Tracker - Know Your Numbers, Price With Confidence, Keep More Money You freelance full-time but your finances are chaos. Invoices in email drafts. Expenses on random receipts. No idea what you actually earned last month. Tax deadline approaching and you're guessing how much to pay. You think you're profitable but you're not sure. You're working harder than you ever did in employment, but somehow earning less per hour than minimum wage. You say yes to every client because you're scared to say no. You have no idea which clients are actually worth keeping and which are draining your time. This Freelancer Business Tracker ends the chaos. It gives you complete visibility into your freelance business finances: total income, expenses, net profit, profit margin, tax owed, outstanding invoices, effective hourly rate, and your most profitable clients - all auto-calculated on one dashboard. Eleven sheets. 500-row invoice log tracking every payment. 500-row expense log with tax-deductible flagging. 50-client tracker showing revenue per hour per client (reveals who's profitable and who's not). 365-day time tracker proving exactly how many hours you're actually working. Tax calculator that shows what you owe AND tells you exactly how much to set aside from each payment. Monthly review comparing income, expenses and profit across 12 months. Includes minimum rate calculator - enter your monthly expenses, desired billable hours, and profit buffer, and it calculates the LOWEST you should ever charge per hour. No more underpricing. No more working for £5/hour after expenses. Know your floor rate backed by actual numbers. "Before You Start" sheet addresses the 5 problems every freelancer faces: inconsistent income, undercharging, tax anxiety, time leakage (unbillable hours eating profit), and not knowing which clients to drop. Each problem explained with honest guidance - not motivational fluff, but practical reality. Whether you're a designer, writer, developer, consultant, coach, photographer, VA, social media manager, or any other freelancer - this tracker shows you the truth about your business finances. Are you actually profitable? Which clients pay best per hour worked? How much tax do you owe? What should you charge? The answers are all here, auto-calculated. 💼 What's Inside The Freelancer Business Tracker Sheet 1: Dashboard (Your Financial Command Center) 8 Auto-Calculated Key Metrics (Updating in Real-Time): Metric What It Shows Why It Matters Total Income Sum of all paid invoices from Income Log How much you've actually been PAID (not just invoiced) - this is your real income Total Expenses Sum of all business costs from Expense Log What your freelance business actually costs to run Net Profit Auto-calculates: Total Income minus Total Expenses The money you ACTUALLY made. Many freelancers confuse revenue with profit. Profit Margin % Auto-calculates: (Net Profit ÷ Total Income) × 100 Healthy freelance business = 40-60% profit margin. Below 30% = expenses too high or rates too low. Tax Owed (Estimate) Auto-pulls from Tax Calculator sheet How much to set aside for tax. Removes surprise £5,000 tax bill panic. Outstanding Invoices Total of all unpaid invoices from Invoice Log Money you're owed but haven't received yet. High number = cash flow problem. Effective Hourly Rate Auto-calculates: Total Income ÷ All Hours Worked (billable + unbillable) Your TRUE hourly rate after accounting for unbillable time. Often shockingly lower than your stated rate. Top Client (By Revenue) Auto-identifies highest-paying client from Client Log Who's actually making you the most money? Prioritize relationships that pay. Visual Progress Bars Toward Goals: Monthly Income Goal: Set your monthly target (e.g., £4,000) Dashboard shows current month income Progress bar fills as you approach goal Percentage achieved auto-calculates Visual indicator: 🟢 On track / 🟡 Behind / 🔴 Significantly behind Annual Income Goal: Set your yearly target (e.g., £50,000) Dashboard tracks cumulative income year-to-date Progress bar and percentage Shows if you're on pace to hit annual target Why This Dashboard Matters: One-glance financial health check. No scrolling through sheets, no manual calculations. Open tracker, see immediately: Am I profitable? Am I on track? What do I owe in tax? Who should I focus on? Sheet 2: Before You Start (The 5 Problems + Minimum Rate Calculator) The 5 Problems Every Freelancer Faces (Honest Explanations): PROBLEM 1: INCONSISTENT INCOME (Feast or Famine) The Reality: One month you make £6,000. Next month £800. You can't plan. You can't budget. You panic-accept bad clients during famine. This tracker doesn't fix inconsistency (that requires business systems), but it SHOWS you the pattern clearly. Once you see it, you can: Build 3-month buffer savings, Diversify income streams, Create retainer arrangements with best clients, Raise rates during feast months to compensate. PROBLEM 2: UNDERCHARGING (Not Knowing Your Worth) The Reality: You charge £30/hour thinking it's good money. Then you track ALL your hours (billable + unbillable: admin, emails, invoicing, scope creep, revisions, finding clients). Your EFFECTIVE hourly rate is £12. You're working below minimum wage. The Minimum Rate Calculator below prevents this - it shows you the FLOOR you must charge just to cover expenses and make basic profit. PROBLEM 3: TAX ANXIETY (No Idea What You Owe) The Reality: January comes. Tax deadline looms. You have £847 saved. You owe £4,200. Panic. This tracker's Tax Calculator shows running estimate based on actual income and expenses. Per-Payment Calculator tells you exactly how much to transfer to savings account every time you get paid. No surprises. No panic. PROBLEM 4: TIME LEAKAGE (Unbillable Hours Killing Profit) The Reality: You think you work 30 billable hours per week. Time Tracker shows reality: 18 billable, 15 unbillable (admin, emails, proposals that don't convert, learning, breaks). This is why your effective rate is so low. Tracking reveals the truth. Then you can: Bill for admin time where possible, Increase rates to cover unbillable overhead, Systemize repetitive tasks, Drop time-drain clients. PROBLEM 5: NOT KNOWING WHICH CLIENTS TO DROP The Reality: Some clients pay well but demand constant revisions (low revenue per hour). Some pay modestly but work is smooth (high revenue per hour). You keep the wrong ones because you judge by total payment, not profitability. Client Log shows revenue per hour per client. You discover: Your "best" client (£2K projects) = £18/hour after all the hours. Your "small" client (£500 projects) = £47/hour, fast, easy. Drop the wrong clients. Keep the right ones. Minimum Rate Calculator (Know Your Floor): How It Works: STEP 1 - INPUT YOUR NUMBERS: Monthly Personal Expenses (£): Rent, bills, food, transport, insurance, everything you need to live. Example: £2,500 Monthly Business Expenses (£): Software, equipment, training, travel, accountant, etc. Example: £500 Desired Monthly Billable Hours: How many hours you REALISTICALLY can bill per month (not total work hours). Example: 80 hours (20 hours/week × 4 weeks) Profit Buffer (%): Additional percentage for savings, tax, growth, emergencies. Recommended: 30-50%. Example: 40% STEP 2 - CALCULATOR AUTO-CALCULATES YOUR MINIMUM HOURLY RATE: Example Calculation: Total monthly expenses: £2,500 + £500 = £3,000 With 40% profit buffer: £3,000 × 1.4 = £4,200 needed per month Billable hours available: 80 hours/month MINIMUM HOURLY RATE: £4,200 ÷ 80 = £52.50/hour What This Means: You should NEVER charge less than £52.50/hour. That's your break-even + basic profit. Anything below that = you're subsidizing the client with your personal savings or working for free. Reality Check Built In: If calculator shows you need £75/hour but you're currently charging £25/hour, you have three options: Raise your rates (dramatically) Reduce your expenses (cut costs) Accept you're not earning enough and need to pivot This calculator doesn't sugarcoat. It shows mathematical reality. Sheet 3: Income & Invoice Log (500 Rows - Every Payment Tracked) 500 rows. Track every invoice for years without running out of space. What to Log for Each Invoice: Column What to Record Why It Matters Date Invoice Sent When you invoiced client Track payment timeline - are they paying in 7 days or 60? Client Name Who you invoiced Links to Client Log for profitability analysis Project/Service Description What the invoice was for Identify most profitable service types Amount (Before Tax) Base amount Your actual income before tax added VAT / Sales Tax Tax amount if applicable (UK VAT 20%, US varies by state) Track tax collected separately Total Amount Billed Auto-calculates: Amount + Tax What client actually pays Payment Status Dropdown: Unpaid / Paid / Partially Paid / Overdue Track outstanding money owed Date Payment Received When money hit your account Calculate average payment time per client Invoice Reference Number Your invoice # Match payments to specific invoices Payment Method Bank transfer, PayPal, Stripe, cash, etc. Track which methods clients prefer, fees Notes Any relevant details Context for late payments, disputes, etc. Auto-Calculated Insights: Total Income: Sum of all PAID invoices (feeds Dashboard) Total Outstanding: Sum of all Unpaid + Partially Paid invoices Total Overdue: Unpaid invoices where invoice date >30 days ago Average Invoice Value: Mean of all invoices Average Days to Payment: Mean time between invoice sent and payment received Why 500 Rows Matters: If you invoice 2-3 times per week, that's 100-150 invoices per year. 500 rows = 3-5 years of invoicing history in one place. See patterns over time: Are you growing? Which months are strongest? Are payment times improving? Sheet 4: Expense Log (500 Rows - Every Business Cost Tracked) Tax-deductible expenses reduce your taxable profit = lower tax bill. But you must RECORD them. Common Allowable Expense Categories (Listed at Top for Reference): Expense Category Examples Tax Deductible? Office Supplies Pens, paper, printer ink, stationery ✅ Yes Software & Subscriptions Adobe, Canva, hosting, project management tools, CRM ✅ Yes Hardware & Equipment Laptop, monitor, keyboard, camera, tablet (over £X may need to depreciate) ✅ Yes Travel (Business) Mileage, train, flights for client meetings or work events ✅ Yes (keep mileage log for HMRC/IRS) Meals (Business) Client lunches, working meals while traveling for business ✅ Partially (rules vary - consult accountant) Training & Courses Skills courses, conferences, books, webinars related to your work ✅ Yes Marketing & Advertising Website, business cards, ads, sponsorships ✅ Yes Professional Fees Accountant, solicitor, business coach, insurance ✅ Yes Rent (Office/Coworking) Dedicated office space or coworking membership ✅ Yes Home Office (Use of Home) Percentage of rent/mortgage, utilities, internet if working from home ✅ Yes (simplified or detailed method - track carefully) Utilities (Business) Internet, phone contract, electricity (business portion if home office) ✅ Partially (business use percentage) Bank Fees Business bank charges, PayPal fees, Stripe fees ✅ Yes Expense Log Columns: Date When expense incurred Expense Category Dropdown from categories above Description What you bought Amount (£) Cost Tax Deductible Y/N checkbox (most are Yes, but personal expenses mixed in must be No) Receipt Reference Where receipt is stored (e.g., "Dropbox > Receipts > Jan2025" or receipt number) Payment Method Business card, personal card, cash, direct debit Notes Context if needed Auto-Calculated Insights: Total Expenses: Sum of all expenses (feeds Dashboard) Total Tax-Deductible Expenses: Sum of expenses where Tax Deductible = Yes (feeds Tax Calculator) Expenses by Category: Breakdown showing where money goes Expenses as % of Income: Are expenses eating too much profit? Why Expense Tracking Matters: Tax Savings Example: Income: £40,000 Expenses (tracked): £8,000 Taxable Profit: £32,000 Tax at 20%: £6,400 vs Income: £40,000 Expenses (not tracked, only remember £3,000): £3,000 Taxable Profit: £37,000 Tax at 20%: £7,400 Difference: £1,000 extra tax paid because you didn't track £5,000 of legitimate expenses. Sheet 5: Client Log (50 Clients - Who's Actually Profitable?) The revelation: Your highest-paying client might be your LEAST profitable per hour worked. What to Track for Each Client: Field What It Shows Client Name Who they are Industry/Sector What they do (helps identify profitable niches) Contact Email/Phone How to reach them Start Date (First Project) When relationship began Total Revenue from Client Auto-sums all invoices for this client from Invoice Log Total Hours Worked Auto-sums all hours for this client from Time Tracker Revenue Per Hour AUTO-CALCULATES: Total Revenue ÷ Total Hours. THIS IS THE GAME-CHANGER. Your Personal Rating (1-5 Stars) How much you enjoy working with them (work satisfaction, communication quality, payment reliability) Referral Status Dropdown: Cold outreach / Referral / Repeat client / Platform (Upwork, Fiverr) / Other Notes on Client Anything relevant (difficult revisions, scope creep, amazing to work with, etc.) Auto-Ranking System: Clients Ranked by Revenue Per Hour (High to Low): The tracker automatically sorts clients showing: Top 5 Most Profitable Clients - Highest revenue per hour Bottom 5 Least Profitable Clients - Lowest revenue per hour (time drains) Why Revenue Per Hour Changes Everything: Example Scenario: Client Total Revenue Total Hours Revenue/Hour Reality Client A £5,000 120 hours £41.67/hour Looks like best client (highest revenue) but actually LOW profit per hour due to endless revisions Client B £1,800 15 hours £120/hour Looks like small client but actually MOST profitable - fast, easy, pays well Client C £3,200 45 hours £71.11/hour Good middle ground - decent pay, reasonable hours Strategic Decisions Based on Data: Client A: Raise rates or drop them. Their projects eat time for low return. Client B: Prioritize them. Offer retainer. Ask for referrals to similar clients. Client C: Good client to keep, reasonable profitability. Without tracking revenue per hour, you'd focus on Client A (biggest revenue) and neglect Client B (most profitable). This is why freelancers stay broke despite working 60-hour weeks. Sheet 6: Time Tracker (365 Days - Where Your Hours Actually Go) 365 rows with dynamic start date auto-populating all dates. Daily Time Tracking Columns: Date Auto-populates from Dashboard start date Day of Week Auto-calculates (Monday, Tuesday, etc.) Client Name Who you worked for (or "Admin", "Marketing", "Learning", etc. for unbillable) Project/Task Description What you worked on Start Time When you started (e.g., 9:00 AM) End Time When you finished (e.g., 11:30 AM) Total Hours Auto-calculates: End Time minus Start Time (e.g., 2.5 hours) Billable Y/N checkbox - Can you bill client for this time? Hourly Rate (This Session) Rate for this project Revenue (This Session) Auto-calculates: Total Hours × Hourly Rate (if Billable = Yes) Notes Context, interruptions, etc. Auto-Calculated Insights: Total Billable Hours: Sum of all hours where Billable = Yes Total Unbillable Hours: Sum of all hours where Billable = No Billable Percentage: (Billable Hours ÷ All Hours) × 100 Total Revenue from Tracked Time: Sum of all revenue sessions Effective Hourly Rate: Total Revenue ÷ All Hours Worked (billable + unbillable) The Effective Hourly Rate Reality Check: Example: You charge £50/hour for client work This week: 20 billable hours at £50/hour = £1,000 revenue Also this week: 10 unbillable hours (emails, proposals, admin, invoicing) Total hours worked: 30 hours Effective hourly rate: £1,000 ÷ 30 hours = £33.33/hour Reality: You're not earning £50/hour. You're earning £33/hour after unbillable time. This is why tracking ALL hours (not just billable) reveals truth. Solutions once you see this: Raise rates to £75/hour so effective rate becomes £50/hour Reduce unbillable time (systemize admin, qualify leads better) Bill for previously unbillable time (admin fees, rush fees) Accept reality and adjust lifestyle budget accordingly Sheet 7: Tax Calculator (Know What You Owe + How Much to Save) SECTION 1: Annual Tax Estimate (Auto-Calculated) Pulls data automatically from Income and Expense Logs: Total Income Auto-pulls from Invoice Log (paid invoices only) Total Tax-Deductible Expenses Auto-pulls from Expense Log (where Tax Deductible = Yes) Taxable Profit Auto-calculates: Income minus Expenses Your Tax Rate (%) Enter your rate: UK 20% (basic), 40% (higher), 45% (additional) OR US federal 22%, 24%, 32% + state Estimated Tax Owed Auto-calculates: Taxable Profit × Tax Rate % UK Self-Assessment Breakdown: Taxable profit up to £12,570 = 0% (personal allowance) £12,571 - £50,270 = 20% £50,271 - £125,140 = 40% Above £125,140 = 45% Plus National Insurance: Class 2 + Class 4 (tracker can estimate if you enter rates) US Quarterly Estimated Tax Reminder: If you expect to owe $1,000+ in tax, IRS requires quarterly payments Deadlines: April 15, June 15, September 15, January 15 Tracker shows quarterly breakdown: Annual Tax ÷ 4 SECTION 2: Per-Payment Calculator (The Life-Saver) Every time you receive payment, use this calculator: INPUT: Payment amount received (e.g., £2,000) CALCULATOR SHOWS: Set aside for tax (based on your tax rate %): £2,000 × 30% = £600 (example for 30% combined tax rate) Safe to keep/spend: £2,000 - £600 = £1,400 How to Use This: Get paid £2,000 Open Per-Payment Calculator Enter £2,000 See: Save £600 for tax, Keep £1,400 Immediately transfer £600 to separate savings account labeled "TAX" Spend the £1,400 guilt-free This prevents: Spending all £2,000, then January tax deadline hits and you owe £5,000 you don't have. Tax Savings Tracking: Optional section to log each transfer to tax savings account: Date Payment received amount Amount transferred to tax savings Running total in tax savings account Estimated tax owed (from Section 1) Shortfall or surplus (are you on track?) Sheet 8: Monthly Review (12-Month Side-by-Side Comparison) Auto-generated dashboard showing key metrics across all 12 months. What Auto-Populates for Each Month: INCOME SECTION: Total income per month Number of invoices sent Average invoice value Outstanding invoices at month-end EXPENSES SECTION: Total expenses per month Expenses as % of income Largest expense category PROFIT SECTION: Net profit per month Profit margin % Cumulative profit year-to-date CLIENTS SECTION: Active clients count New clients added Clients lost Top client by revenue HOURS SECTION: Total hours worked Billable hours Unbillable hours Effective hourly rate Billable percentage GOALS SECTION: Income goal vs actual Percentage achieved On track or behind indicator Visual Indicators: Best Month: Highest profit month auto-highlighted Worst Month: Lowest profit month auto-highlighted Trends: Income increasing, stable, or decreasing over year Sheet 9: Annual Overview (Full Year Summary + Next Year Planning) SECTION 1: This Year Summary (Auto-Calculated) Total annual income Total annual expenses Net annual profit Profit margin % for year Total tax owed estimate Total invoices sent Total hours worked (billable + unbillable) Effective annual hourly rate Top 3 clients by revenue Most profitable service or project type Best month (highest profit) Worst month (lowest profit) SECTION 2: Next Year Goal-Setting Set targets for next financial year: Income Goal: Target annual revenue (e.g., 20% increase over this year) Profit Margin Goal: Target profit percentage (e.g., increase from 40% to 50%) Client Goal: Number of clients to acquire or retain Rate Increase Percentage: How much to raise rates (e.g., 15% across board) Hours Goal: Billable hours target (e.g., reduce total hours but maintain income) Skills to Learn: What training or development needed Services to Add: New offerings to increase income Services to Drop: Low-margin work to eliminate Clients to Drop: Time-drain clients to fire SECTION 3: Year-on-Year Comparison (If Tracking Multiple Years) Metric Year 1 Year 2 Change Income £38,000 £52,000 +37% 🟢 Profit £15,200 £26,000 +71% 🟢 Effective Rate £22/hour £34/hour +55% 🟢 This shows growth objectively. Not feelings, not guesses - numbers. Sheet 10: Q&A Problem Solver (10 Real Freelancer Questions) The Questions with Honest, Practical Answers: Q1: How do I know what to charge? A: Use the Minimum Rate Calculator in Sheet 2 - it shows your FLOOR (break-even + basic profit). Then research market rates for your skill in your location (Google "[your skill] freelance rates UK/US", check freelance platforms, ask in communities). Charge somewhere between your minimum and market rate. If market rate is BELOW your minimum, you have problem: you need to either reduce expenses, increase value/specialize, or accept freelancing in that skill isn't financially viable. Don't charge based on "what feels fair" - charge based on math + market. Q2: How much tax will I owe? A: Use Tax Calculator in Sheet 7. It estimates based on YOUR actual income and expenses. General UK guide: if profit is £20K = expect £1,500-£2,500 in income tax + National Insurance. If profit is £40K = expect £7,000-£9,000. US guide: if profit is $50K single filer = expect roughly $10,000-$12,000 federal + state. These are estimates - consult accountant for exact calculation. Key: set aside 25-35% of every payment for tax. Better to oversave than undersave. Q3: What do I do about non-paying clients? Q4: How do I know which clients to drop? Q5: Why is my hourly rate so low despite charging decent rates? Q6: How do I estimate project time accurately? Q7: Should I do fixed price or hourly? Q8: How do I grow beyond referrals and word-of-mouth? Q9: When should I increase my rates? Q10: How do I handle scope creep (clients asking for more)? All 10 questions answered with evidence-based, practical guidance - not motivational fluff. Sheet 11: How To Use (Daily Routine + Setup Instructions) Daily 5-Minute Routine: Log time worked today: Fill in Time Tracker for each work session Log any invoices sent: Add to Invoice Log immediately after sending Log any expenses incurred: Add to Expense Log same day (don't wait) Update payment status: Mark invoices as Paid when money received Check Dashboard: Quick glance at key metrics Consistency = accurate data. 5 minutes daily prevents hour-long catch-up sessions monthly. Financial Year Start Date Instructions: UK: Tax year runs 6 April to 5 April. Set start date to 6 April [current year]. US: Tax year runs 1 January to 31 December. Set start date to 1 January [current year]. Starting mid-year? That's fine - set start date to whenever you begin tracking. Just note in Annual Overview that it's partial year. Disclaimer "This tracker is for record-keeping and financial organization purposes. It is not tax advice, accounting advice, or legal advice. Tax laws vary by jurisdiction and individual circumstances. This tracker provides estimates based on formulas, but actual tax owed may differ. Always consult a qualified accountant or tax advisor for advice specific to your situation. Allowable expenses vary by tax authority - verify what you can legally claim with your accountant." Full PLR Rebrand Instructions 🎯 Who This Tracker Is For Personal Use (By Freelance Discipline): ✓ Freelance Designers - Graphic, web, UX/UI, branding ✓ Freelance Writers - Copywriters, content writers, journalists, editors ✓ Freelance Developers - Web dev, app dev, software engineers ✓ Freelance Consultants - Business, marketing, strategy consultants ✓ Freelance Coaches - Business, life, health, career coaches ✓ Freelance Photographers - Event, portrait, commercial photography ✓ Virtual Assistants - Admin, social media, customer service VAs ✓ Social Media Managers - Freelance SMM, community managers ✓ Freelance Marketers - Email marketing, ads, SEO, content marketing ✓ Freelance Video Editors - YouTube editors, commercial video production ✓ Any self-employed professional - Anyone invoicing clients needs this Professional Use (PLR/MRR): ✓ Business coaches - Give to freelance clients for financial organization ✓ Accountants - Provide to self-employed clients for record-keeping ✓ Bookkeepers - Help clients organize before bookkeeping sessions ✓ Business consultants - Tool for freelance/solopreneur clients ✓ Financial advisors - Help self-employed clients track income/expenses ✓ Co-working spaces - Offer as member resource ✓ Freelance platforms - Provide as value-add to freelancers on platform 💰 Includes Full PLR and MRR Rights ✅ Use for your own freelance business ✅ Rebrand with your business name ✅ Sell as your own product ✅ Give to clients and students ✅ Include in coaching programs ✅ Bundle with business courses ✅ Customize for specific industries ✅ Offer MRR rights to buyers 📦 What You Get Immediately ✅ 11-Sheet Google Sheets System ✅ Dashboard with 8 Auto-Calculated Metrics ✅ Visual Progress Bars (Monthly & Annual Goals) ✅ Minimum Rate Calculator ✅ 500-Row Invoice Log ✅ 500-Row Expense Log ✅ 50-Client Tracker with Revenue Per Hour ✅ 365-Day Time Tracker with Dynamic Dates ✅ Tax Calculator with Per-Payment Breakdown ✅ Monthly Review (12-Month Comparison) ✅ Annual Overview with Goal-Setting ✅ Q&A Problem Solver (10 Questions) ✅ Full PLR and MRR Rights ❓ FAQ Do I need accounting software instead? This tracker is for freelancers who want simple, visual financial tracking without monthly software fees. If you're turning over £100K+ or have employees, proper accounting software makes sense. For solo freelancers earning under £100K, this provides everything you need. Will this work for my accountant? Yes. The organized logs (Income, Expenses, Time) give your accountant clean data for tax return preparation. This isn't replacement for accountant - it's the organized records they need from you. What if I use QuickBooks or Xero already? You can use both - this tracker gives you visual insights (Dashboard, Client Profitability, Time Tracking) that accounting software doesn't focus on. Or replace paid software with this free tracker. Does this work for US and UK tax? Yes. Tax Calculator accommodates both systems. Enter your tax rate percentage (UK 20-45%, US 22-32% federal + state) and it calculates accordingly. Instructions included for both tax years. Can I track multiple currencies? The tracker uses one currency throughout (you choose £, $, €, etc). If you invoice in multiple currencies, convert to your base currency when logging. What's the difference between this and a budget planner? Budget planners are for personal finance. This is for BUSINESS finance - invoices, expenses, client profitability, tax estimates specific to freelancing/self-employment. Can business coaches rebrand for clients? Yes! Full PLR/MRR rights. Perfect tool for freelance/solopreneur clients who need financial organization. How long does it take to set up? Initial setup: 10-15 minutes (enter start date, monthly expenses for Minimum Rate Calculator, personal goals). Daily use: 5 minutes logging activity. Worth it for financial clarity. 💼 Stop Guessing. Start Knowing. Track Your Freelance Business Like a Business. Freelancer Business Tracker. Eleven sheets. Complete income, expenses, tax and client profitability system. Includes: Dashboard (8 auto-calculated metrics total-income/total-expenses/net-profit/profit-margin-percentage/tax-owed-estimate/outstanding-invoices/effective-hourly-rate/top-client pulling from all sheets, visual progress bars monthly-annual-income-goals with percentage completion, quick-glance financial health), Before You Start (5 problems freelancers face honest explanations inconsistent-income/undercharging/tax-anxiety/time-leakage-unbillable-hours/not-knowing-which-clients-to-drop, minimum rate calculator enter-monthly-expenses-billable-hours-profit-buffer auto-calculates lowest-hourly-rate-preventing-underpricing), Income and Invoice Log (500 rows date-client-project-amount-tax-total-billed/payment-status Unpaid-Paid-Overdue/date-paid-invoice-reference/payment-method, auto-calculates total-income-outstanding-overdue-average-invoice-value, feeds Dashboard), Expense Log (500 rows date-category-description-amount/tax-deductible Y-N/receipt-reference, common allowable expense categories listed for reference, auto-calculates total-expenses-tax-deductible-expenses feeds Dashboard and Tax Calculator), Client Log (50 clients name-industry-contact-start-date/total-revenue auto-sums from invoices/total-hours auto-sums from time tracker/revenue-per-hour auto-calculates shows profitability, your-rating 1-5 stars/referral-status, auto-ranks best-and-worst-clients instantly), Time Tracker (365 days dynamic start date auto-populating, date-day-client-project/start-time-end-time-total-hours auto-calculates/billable Y-N/hourly-rate-revenue auto-calculates if billable, auto-calculates total-billable-unbillable-hours/billable-percentage/effective-hourly-rate reveals true earnings), Tax Calculator (auto-pulls income and expenses/calculates taxable-profit/estimates tax-owed based-on-your-rate UK-20-40-45-percent US-22-24-32-federal-plus-state, per-payment-calculator enter-any-payment shows-exactly-how-much-set-aside-for-tax-how-much-keep safe-to-spend, quarterly-payment-breakdown-UK-US), Monthly Review (12-month side-by-side Income-section-Expenses-section-Profit-section-Clients-section-Hours-section-Goals-section auto-pulling all metrics, visual-indicators best-worst-month-trends), Annual Overview (full-year summary total-income-expenses-profit-tax-invoices-hours-effective-rate-top-clients-most-profitable-service, next-year goal-setting income-profit-margin-clients-rate-increase-hours-skills-services-to-add-drop), Q&A Problem Solver (10 real questions how-to-price/how-much-tax/non-paying-clients/which-clients-drop/why-hourly-rate-low/estimate-time-accurately/fixed-vs-hourly/grow-beyond-referrals/when-increase-rates/handle-scope-creep with honest practical answers), How To Use (daily-5-minute-routine log-time-invoices-expenses-payments-check-Dashboard, financial-year-start-UK-6-April US-1-January setup, disclaimer not-tax-advice-consult-accountant, full-PLR-rebrand-instructions). All formulas auto-calculate. Professional business aesthetic. Mobile-friendly Google Sheets. Full PLR and MRR Rights. One-time fee. Instant access. Eleven-sheet Google Sheets system for freelancer business management. Includes: Dashboard (8 auto-calculated key metrics total-income/total-expenses/net-profit/profit-margin-percentage/tax-owed-estimate/outstanding-invoices-total/effective-hourly-rate/top-client-by-revenue pulling from all sheets automatically, visual progress bars toward monthly and annual income goals with percentage completion, quick-glance financial health indicators), Before You Start (5 problems freelancers face with honest explanations Problem-1-Inconsistent-income-feast-or-famine/Problem-2-Undercharging-not-knowing-worth/Problem-3-Tax-anxiety-no-idea-what-owed/Problem-4-Time-leakage-unbillable-hours-killing-profit/Problem-5-Not-knowing-which-clients-to-drop-keeping-bad-fits, minimum rate calculator enter-monthly-expenses-desired-billable-hours-profit-buffer auto-calculates lowest-hourly-rate-you-should-ever-charge, explanation-of-why-this-rate-matters preventing-working-below-minimum-wage), Income and Invoice Log (500 rows date-invoice-sent/client-name/project-description/amount-before-tax/VAT-or-sales-tax-if-applicable/total-amount-billed/payment-status dropdown Unpaid-Paid-Partially-paid-Overdue/date-payment-received/invoice-reference-number/payment-method/notes, auto-calculates total-income/total-outstanding/total-paid/average-invoice-value, feeds Dashboard outstanding-invoices automatically, overdue invoices auto-flag after 30-days), Expense Log (500 rows date/expense-category dropdown Office-supplies-Software-subscriptions-Hardware-equipment-Travel-Meals-training-courses-Marketing-advertising-Professional-fees-accountant-lawyer/Insurance/Rent-coworking-home-office/Utilities-internet-phone/Bank-fees/Other, description/amount/tax-deductible Y-N checkbox, receipt-reference, payment-method, notes, common allowable expense categories listed at top for reference what-you-can-claim, auto-calculates total-expenses/total-tax-deductible-expenses, feeds Dashboard and Tax Calculator), Client Log (50 clients client-name/industry-sector/contact-email-phone/start-date-first-project/total-revenue-from-client auto-sums from Income Log/total-hours-worked auto-sums from Time Tracker/revenue-per-hour auto-calculates total-revenue-divided-by-total-hours, your-personal-rating 1-5-stars for-work-satisfaction-communication-payment-reliability/referral-status dropdown Cold-outreach-Referral-Repeat-client-Platform-Upwork-Fiverr/notes-on-client, auto-ranks clients by revenue-per-hour showing best and worst instantly, identifies-high-value-vs-time-drain-clients), Time Tracker (365 rows with dynamic start date auto-populating all dates, date/day-of-week/client-name/project-task-description/start-time/end-time/total-hours auto-calculates end-minus-start, billable Y-N checkbox, hourly-rate-for-this-session, revenue-for-this-session auto-calculates hours-times-rate if-billable, notes, auto-calculates total-billable-hours/total-unbillable-hours/billable-percentage/total-revenue-from-tracked-time/effective-hourly-rate total-revenue-divided-by-all-hours-worked including-unbillable), Tax Calculator (auto-pulls total-income and total-expenses from other sheets, calculates taxable-profit income-minus-expenses, estimates-tax-owed based-on-your-tax-rate-percentage enter-your-rate-20-40-45-UK-or-22-24-32-US-federal, shows-quarterly-tax-payment-breakdown if-making-payments-on-account, includes per-payment-calculator enter-any-payment-amount shows-exactly-how-much-to-set-aside-for-tax percentage-based and-how-much-to-keep safe-to-spend, explanation-section covering-UK-self-assessment-deadlines/US-quarterly-estimated-tax/keeping-tax-savings-separate-account), Monthly Review (12-month side-by-side comparison auto-pulling from all sheets, Income-section total-income-per-month/number-of-invoices/average-invoice-value, Expenses-section total-expenses-per-month/percentage-of-income spent-on-expenses, Profit-section net-profit-per-month/profit-margin-percentage, Clients-section active-clients-count/new-clients-added/clients-lost, Hours-section total-hours-worked/billable-hours/unbillable-hours/effective-hourly-rate, Goals-section income-goal-vs-actual/percentage-achieved/on-track-or-behind, visual-indicators showing-best-month-worst-month-trends), Annual Overview (full-year summary total-annual-income/total-annual-expenses/net-annual-profit/total-tax-owed-estimate/total-invoices-sent/total-hours-worked/effective-annual-hourly-rate/top-3-clients-by-revenue/most-profitable-service-or-project-type, next-year goal-setting section income-goal/client-goal/rate-increase-percentage/skills-to-learn/services-to-add-or-drop, year-on-year comparison if-tracking-multiple-years), Q&A Problem Solver (10 real freelancer questions with honest practical answers How-do-I-know-what-to-charge/How-much-tax-will-I-owe/What-do-I-do-about-non-paying-clients/How-do-I-know-which-clients-to-drop/Why-is-my-hourly-rate-so-low-despite-charging-decent-rates answer-unbillable-hours/How-do-I-estimate-project-time-accurately/Should-I-do-fixed-price-or-hourly/How-do-I-grow-beyond-referrals-and-word-of-mouth/When-should-I-increase-my-rates/How-do-I-handle-scope-creep-clients-asking-for-more, evidence-based-answers-not-motivational-fluff), How To Use (daily-5-minute-routine log-time-worked-today/log-any-invoices-sent/log-any-expenses-incurred/update-payment-status-if-received/check-Dashboard-quick-view, financial-year-start-date-instructions UK-6-April-to-5-April/US-1-January-to-31-December setup-guidance, disclaimer this-tracker-for-record-keeping-not-tax-advice-consult-accountant, full-PLR-rebrand-instructions). All formulas auto-calculate. Professional business aesthetic. Mobile-friendly Google Sheets. Full PLR and MRR Rights. One-time fee. Instant access. Perfect for: Freelance designers, writers, developers, consultants, coaches, photographers, virtual assistants, social media managers, marketers, video editors, any self-employed professional, business coaches, accountants, bookkeepers, financial advisors Know your numbers. Price with confidence. Keep more money. Start tracking today. Questions? Contact us here