{"product_id":"freelancer-business-tracker-plr","title":"Freelancer Business Tracker PLR (auto calculating)","description":"\u003ch1\u003eFreelancer Business Tracker - Know Your Numbers, Price With Confidence, Keep More Money\u003c\/h1\u003e\n\u003cp\u003e\u003cstrong\u003eYou 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.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eYou'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.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eEleven 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.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eIncludes 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003e\"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.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eWhether 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.\u003c\/p\u003e\n\u003cp\u003e \u003c\/p\u003e\n\u003chr\u003e\n\u003ch2\u003e💼 What's Inside The Freelancer Business Tracker\u003c\/h2\u003e\n\u003ch3\u003eSheet 1: Dashboard (Your Financial Command Center)\u003c\/h3\u003e\n\u003ch4\u003e8 Auto-Calculated Key Metrics (Updating in Real-Time):\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eMetric\u003c\/th\u003e\n\u003cth\u003eWhat It Shows\u003c\/th\u003e\n\u003cth\u003eWhy It Matters\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eTotal Income\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eSum of all paid invoices from Income Log\u003c\/td\u003e\n\u003ctd\u003eHow much you've actually been PAID (not just invoiced) - this is your real income\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eTotal Expenses\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eSum of all business costs from Expense Log\u003c\/td\u003e\n\u003ctd\u003eWhat your freelance business actually costs to run\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eNet Profit\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Total Income minus Total Expenses\u003c\/td\u003e\n\u003ctd\u003eThe money you ACTUALLY made. Many freelancers confuse revenue with profit.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eProfit Margin %\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e (Net Profit ÷ Total Income) × 100\u003c\/td\u003e\n\u003ctd\u003eHealthy freelance business = 40-60% profit margin. Below 30% = expenses too high or rates too low.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eTax Owed (Estimate)\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eAuto-pulls from Tax Calculator sheet\u003c\/td\u003e\n\u003ctd\u003eHow much to set aside for tax. Removes surprise £5,000 tax bill panic.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eOutstanding Invoices\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eTotal of all unpaid invoices from Invoice Log\u003c\/td\u003e\n\u003ctd\u003eMoney you're owed but haven't received yet. High number = cash flow problem.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eEffective Hourly Rate\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Total Income ÷ All Hours Worked (billable + unbillable)\u003c\/td\u003e\n\u003ctd\u003eYour TRUE hourly rate after accounting for unbillable time. Often shockingly lower than your stated rate.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003e\u003cstrong\u003eTop Client (By Revenue)\u003c\/strong\u003e\u003c\/td\u003e\n\u003ctd\u003eAuto-identifies highest-paying client from Client Log\u003c\/td\u003e\n\u003ctd\u003eWho's actually making you the most money? Prioritize relationships that pay.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eVisual Progress Bars Toward Goals:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eMonthly Income Goal:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSet your monthly target (e.g., £4,000)\u003c\/li\u003e\n\u003cli\u003eDashboard shows current month income\u003c\/li\u003e\n\u003cli\u003eProgress bar fills as you approach goal\u003c\/li\u003e\n\u003cli\u003ePercentage achieved auto-calculates\u003c\/li\u003e\n\u003cli\u003eVisual indicator: 🟢 On track \/ 🟡 Behind \/ 🔴 Significantly behind\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eAnnual Income Goal:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eSet your yearly target (e.g., £50,000)\u003c\/li\u003e\n\u003cli\u003eDashboard tracks cumulative income year-to-date\u003c\/li\u003e\n\u003cli\u003eProgress bar and percentage\u003c\/li\u003e\n\u003cli\u003eShows if you're on pace to hit annual target\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eWhy This Dashboard Matters:\u003c\/strong\u003e 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?\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 2: Before You Start (The 5 Problems + Minimum Rate Calculator)\u003c\/h3\u003e\n\u003ch4\u003eThe 5 Problems Every Freelancer Faces (Honest Explanations):\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003ePROBLEM 1: INCONSISTENT INCOME (Feast or Famine)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Reality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePROBLEM 2: UNDERCHARGING (Not Knowing Your Worth)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Reality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePROBLEM 3: TAX ANXIETY (No Idea What You Owe)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Reality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePROBLEM 4: TIME LEAKAGE (Unbillable Hours Killing Profit)\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Reality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePROBLEM 5: NOT KNOWING WHICH CLIENTS TO DROP\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eThe Reality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003chr\u003e\n\u003ch4\u003eMinimum Rate Calculator (Know Your Floor):\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eHow It Works:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eSTEP 1 - INPUT YOUR NUMBERS:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Personal Expenses (£):\u003c\/strong\u003e Rent, bills, food, transport, insurance, everything you need to live. Example: £2,500\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eMonthly Business Expenses (£):\u003c\/strong\u003e Software, equipment, training, travel, accountant, etc. Example: £500\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDesired Monthly Billable Hours:\u003c\/strong\u003e How many hours you REALISTICALLY can bill per month (not total work hours). Example: 80 hours (20 hours\/week × 4 weeks)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfit Buffer (%):\u003c\/strong\u003e Additional percentage for savings, tax, growth, emergencies. Recommended: 30-50%. Example: 40%\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eSTEP 2 - CALCULATOR AUTO-CALCULATES YOUR MINIMUM HOURLY RATE:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eExample Calculation:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTotal monthly expenses: £2,500 + £500 = £3,000\u003c\/li\u003e\n\u003cli\u003eWith 40% profit buffer: £3,000 × 1.4 = £4,200 needed per month\u003c\/li\u003e\n\u003cli\u003eBillable hours available: 80 hours\/month\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eMINIMUM HOURLY RATE: £4,200 ÷ 80 = £52.50\/hour\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eWhat This Means:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eReality Check Built In:\u003c\/strong\u003e If calculator shows you need £75\/hour but you're currently charging £25\/hour, you have three options:\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eRaise your rates (dramatically)\u003c\/li\u003e\n\u003cli\u003eReduce your expenses (cut costs)\u003c\/li\u003e\n\u003cli\u003eAccept you're not earning enough and need to pivot\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eThis calculator doesn't sugarcoat. It shows mathematical reality.\u003c\/strong\u003e\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 3: Income \u0026amp; Invoice Log (500 Rows - Every Payment Tracked)\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003e500 rows. Track every invoice for years without running out of space.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eWhat to Log for Each Invoice:\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eColumn\u003c\/th\u003e\n\u003cth\u003eWhat to Record\u003c\/th\u003e\n\u003cth\u003eWhy It Matters\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eDate Invoice Sent\u003c\/td\u003e\n\u003ctd\u003eWhen you invoiced client\u003c\/td\u003e\n\u003ctd\u003eTrack payment timeline - are they paying in 7 days or 60?\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient Name\u003c\/td\u003e\n\u003ctd\u003eWho you invoiced\u003c\/td\u003e\n\u003ctd\u003eLinks to Client Log for profitability analysis\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eProject\/Service Description\u003c\/td\u003e\n\u003ctd\u003eWhat the invoice was for\u003c\/td\u003e\n\u003ctd\u003eIdentify most profitable service types\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eAmount (Before Tax)\u003c\/td\u003e\n\u003ctd\u003eBase amount\u003c\/td\u003e\n\u003ctd\u003eYour actual income before tax added\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eVAT \/ Sales Tax\u003c\/td\u003e\n\u003ctd\u003eTax amount if applicable (UK VAT 20%, US varies by state)\u003c\/td\u003e\n\u003ctd\u003eTrack tax collected separately\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Amount Billed\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Amount + Tax\u003c\/td\u003e\n\u003ctd\u003eWhat client actually pays\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePayment Status\u003c\/td\u003e\n\u003ctd\u003eDropdown: \u003cstrong\u003eUnpaid \/ Paid \/ Partially Paid \/ Overdue\u003c\/strong\u003e\n\u003c\/td\u003e\n\u003ctd\u003eTrack outstanding money owed\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eDate Payment Received\u003c\/td\u003e\n\u003ctd\u003eWhen money hit your account\u003c\/td\u003e\n\u003ctd\u003eCalculate average payment time per client\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eInvoice Reference Number\u003c\/td\u003e\n\u003ctd\u003eYour invoice #\u003c\/td\u003e\n\u003ctd\u003eMatch payments to specific invoices\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePayment Method\u003c\/td\u003e\n\u003ctd\u003eBank transfer, PayPal, Stripe, cash, etc.\u003c\/td\u003e\n\u003ctd\u003eTrack which methods clients prefer, fees\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eNotes\u003c\/td\u003e\n\u003ctd\u003eAny relevant details\u003c\/td\u003e\n\u003ctd\u003eContext for late payments, disputes, etc.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eAuto-Calculated Insights:\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Income:\u003c\/strong\u003e Sum of all PAID invoices (feeds Dashboard)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Outstanding:\u003c\/strong\u003e Sum of all Unpaid + Partially Paid invoices\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Overdue:\u003c\/strong\u003e Unpaid invoices where invoice date \u0026gt;30 days ago\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAverage Invoice Value:\u003c\/strong\u003e Mean of all invoices\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAverage Days to Payment:\u003c\/strong\u003e Mean time between invoice sent and payment received\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eWhy 500 Rows Matters:\u003c\/h4\u003e\n\u003cp\u003eIf 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?\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 4: Expense Log (500 Rows - Every Business Cost Tracked)\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eTax-deductible expenses reduce your taxable profit = lower tax bill. But you must RECORD them.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eCommon Allowable Expense Categories (Listed at Top for Reference):\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eExpense Category\u003c\/th\u003e\n\u003cth\u003eExamples\u003c\/th\u003e\n\u003cth\u003eTax Deductible?\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eOffice Supplies\u003c\/td\u003e\n\u003ctd\u003ePens, paper, printer ink, stationery\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eSoftware \u0026amp; Subscriptions\u003c\/td\u003e\n\u003ctd\u003eAdobe, Canva, hosting, project management tools, CRM\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eHardware \u0026amp; Equipment\u003c\/td\u003e\n\u003ctd\u003eLaptop, monitor, keyboard, camera, tablet (over £X may need to depreciate)\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTravel (Business)\u003c\/td\u003e\n\u003ctd\u003eMileage, train, flights for client meetings or work events\u003c\/td\u003e\n\u003ctd\u003e✅ Yes (keep mileage log for HMRC\/IRS)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eMeals (Business)\u003c\/td\u003e\n\u003ctd\u003eClient lunches, working meals while traveling for business\u003c\/td\u003e\n\u003ctd\u003e✅ Partially (rules vary - consult accountant)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTraining \u0026amp; Courses\u003c\/td\u003e\n\u003ctd\u003eSkills courses, conferences, books, webinars related to your work\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eMarketing \u0026amp; Advertising\u003c\/td\u003e\n\u003ctd\u003eWebsite, business cards, ads, sponsorships\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eProfessional Fees\u003c\/td\u003e\n\u003ctd\u003eAccountant, solicitor, business coach, insurance\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eRent (Office\/Coworking)\u003c\/td\u003e\n\u003ctd\u003eDedicated office space or coworking membership\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eHome Office (Use of Home)\u003c\/td\u003e\n\u003ctd\u003ePercentage of rent\/mortgage, utilities, internet if working from home\u003c\/td\u003e\n\u003ctd\u003e✅ Yes (simplified or detailed method - track carefully)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eUtilities (Business)\u003c\/td\u003e\n\u003ctd\u003eInternet, phone contract, electricity (business portion if home office)\u003c\/td\u003e\n\u003ctd\u003e✅ Partially (business use percentage)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eBank Fees\u003c\/td\u003e\n\u003ctd\u003eBusiness bank charges, PayPal fees, Stripe fees\u003c\/td\u003e\n\u003ctd\u003e✅ Yes\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eExpense Log Columns:\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eDate\u003c\/td\u003e\n\u003ctd\u003eWhen expense incurred\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eExpense Category\u003c\/td\u003e\n\u003ctd\u003eDropdown from categories above\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eDescription\u003c\/td\u003e\n\u003ctd\u003eWhat you bought\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eAmount (£)\u003c\/td\u003e\n\u003ctd\u003eCost\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTax Deductible\u003c\/td\u003e\n\u003ctd\u003eY\/N checkbox (most are Yes, but personal expenses mixed in must be No)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eReceipt Reference\u003c\/td\u003e\n\u003ctd\u003eWhere receipt is stored (e.g., \"Dropbox \u0026gt; Receipts \u0026gt; Jan2025\" or receipt number)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003ePayment Method\u003c\/td\u003e\n\u003ctd\u003eBusiness card, personal card, cash, direct debit\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eNotes\u003c\/td\u003e\n\u003ctd\u003eContext if needed\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eAuto-Calculated Insights:\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Expenses:\u003c\/strong\u003e Sum of all expenses (feeds Dashboard)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Tax-Deductible Expenses:\u003c\/strong\u003e Sum of expenses where Tax Deductible = Yes (feeds Tax Calculator)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpenses by Category:\u003c\/strong\u003e Breakdown showing where money goes\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eExpenses as % of Income:\u003c\/strong\u003e Are expenses eating too much profit?\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eWhy Expense Tracking Matters:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eTax Savings Example:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIncome: £40,000\u003c\/li\u003e\n\u003cli\u003eExpenses (tracked): £8,000\u003c\/li\u003e\n\u003cli\u003eTaxable Profit: £32,000\u003c\/li\u003e\n\u003cli\u003eTax at 20%: £6,400\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003evs\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIncome: £40,000\u003c\/li\u003e\n\u003cli\u003eExpenses (not tracked, only remember £3,000): £3,000\u003c\/li\u003e\n\u003cli\u003eTaxable Profit: £37,000\u003c\/li\u003e\n\u003cli\u003eTax at 20%: £7,400\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eDifference: £1,000 extra tax paid because you didn't track £5,000 of legitimate expenses.\u003c\/strong\u003e\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 5: Client Log (50 Clients - Who's Actually Profitable?)\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eThe revelation: Your highest-paying client might be your LEAST profitable per hour worked.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eWhat to Track for Each Client:\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eField\u003c\/th\u003e\n\u003cth\u003eWhat It Shows\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient Name\u003c\/td\u003e\n\u003ctd\u003eWho they are\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eIndustry\/Sector\u003c\/td\u003e\n\u003ctd\u003eWhat they do (helps identify profitable niches)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eContact Email\/Phone\u003c\/td\u003e\n\u003ctd\u003eHow to reach them\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eStart Date (First Project)\u003c\/td\u003e\n\u003ctd\u003eWhen relationship began\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Revenue from Client\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-sums\u003c\/strong\u003e all invoices for this client from Invoice Log\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Hours Worked\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-sums\u003c\/strong\u003e all hours for this client from Time Tracker\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eRevenue Per Hour\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAUTO-CALCULATES:\u003c\/strong\u003e Total Revenue ÷ Total Hours. THIS IS THE GAME-CHANGER.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eYour Personal Rating (1-5 Stars)\u003c\/td\u003e\n\u003ctd\u003eHow much you enjoy working with them (work satisfaction, communication quality, payment reliability)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eReferral Status\u003c\/td\u003e\n\u003ctd\u003eDropdown: Cold outreach \/ Referral \/ Repeat client \/ Platform (Upwork, Fiverr) \/ Other\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eNotes on Client\u003c\/td\u003e\n\u003ctd\u003eAnything relevant (difficult revisions, scope creep, amazing to work with, etc.)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eAuto-Ranking System:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eClients Ranked by Revenue Per Hour (High to Low):\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eThe tracker automatically sorts clients showing:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTop 5 Most Profitable Clients\u003c\/strong\u003e - Highest revenue per hour\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBottom 5 Least Profitable Clients\u003c\/strong\u003e - Lowest revenue per hour (time drains)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eWhy Revenue Per Hour Changes Everything:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eExample Scenario:\u003c\/strong\u003e\u003c\/p\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eClient\u003c\/th\u003e\n\u003cth\u003eTotal Revenue\u003c\/th\u003e\n\u003cth\u003eTotal Hours\u003c\/th\u003e\n\u003cth\u003eRevenue\/Hour\u003c\/th\u003e\n\u003cth\u003eReality\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient A\u003c\/td\u003e\n\u003ctd\u003e£5,000\u003c\/td\u003e\n\u003ctd\u003e120 hours\u003c\/td\u003e\n\u003ctd\u003e£41.67\/hour\u003c\/td\u003e\n\u003ctd\u003eLooks like best client (highest revenue) but actually LOW profit per hour due to endless revisions\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient B\u003c\/td\u003e\n\u003ctd\u003e£1,800\u003c\/td\u003e\n\u003ctd\u003e15 hours\u003c\/td\u003e\n\u003ctd\u003e£120\/hour\u003c\/td\u003e\n\u003ctd\u003eLooks like small client but actually MOST profitable - fast, easy, pays well\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient C\u003c\/td\u003e\n\u003ctd\u003e£3,200\u003c\/td\u003e\n\u003ctd\u003e45 hours\u003c\/td\u003e\n\u003ctd\u003e£71.11\/hour\u003c\/td\u003e\n\u003ctd\u003eGood middle ground - decent pay, reasonable hours\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp\u003e\u003cstrong\u003eStrategic Decisions Based on Data:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eClient A:\u003c\/strong\u003e Raise rates or drop them. Their projects eat time for low return.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eClient B:\u003c\/strong\u003e Prioritize them. Offer retainer. Ask for referrals to similar clients.\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eClient C:\u003c\/strong\u003e Good client to keep, reasonable profitability.\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eWithout 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.\u003c\/strong\u003e\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 6: Time Tracker (365 Days - Where Your Hours Actually Go)\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003e365 rows with dynamic start date auto-populating all dates.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eDaily Time Tracking Columns:\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eDate\u003c\/td\u003e\n\u003ctd\u003eAuto-populates from Dashboard start date\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eDay of Week\u003c\/td\u003e\n\u003ctd\u003eAuto-calculates (Monday, Tuesday, etc.)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eClient Name\u003c\/td\u003e\n\u003ctd\u003eWho you worked for (or \"Admin\", \"Marketing\", \"Learning\", etc. for unbillable)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eProject\/Task Description\u003c\/td\u003e\n\u003ctd\u003eWhat you worked on\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eStart Time\u003c\/td\u003e\n\u003ctd\u003eWhen you started (e.g., 9:00 AM)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eEnd Time\u003c\/td\u003e\n\u003ctd\u003eWhen you finished (e.g., 11:30 AM)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Hours\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e End Time minus Start Time (e.g., 2.5 hours)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eBillable\u003c\/td\u003e\n\u003ctd\u003eY\/N checkbox - Can you bill client for this time?\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eHourly Rate (This Session)\u003c\/td\u003e\n\u003ctd\u003eRate for this project\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eRevenue (This Session)\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Total Hours × Hourly Rate (if Billable = Yes)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eNotes\u003c\/td\u003e\n\u003ctd\u003eContext, interruptions, etc.\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003ch4\u003eAuto-Calculated Insights:\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Billable Hours:\u003c\/strong\u003e Sum of all hours where Billable = Yes\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Unbillable Hours:\u003c\/strong\u003e Sum of all hours where Billable = No\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBillable Percentage:\u003c\/strong\u003e (Billable Hours ÷ All Hours) × 100\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTotal Revenue from Tracked Time:\u003c\/strong\u003e Sum of all revenue sessions\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eEffective Hourly Rate:\u003c\/strong\u003e Total Revenue ÷ All Hours Worked (billable + unbillable)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eThe Effective Hourly Rate Reality Check:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eExample:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eYou charge £50\/hour for client work\u003c\/li\u003e\n\u003cli\u003eThis week: 20 billable hours at £50\/hour = £1,000 revenue\u003c\/li\u003e\n\u003cli\u003eAlso this week: 10 unbillable hours (emails, proposals, admin, invoicing)\u003c\/li\u003e\n\u003cli\u003eTotal hours worked: 30 hours\u003c\/li\u003e\n\u003cli\u003e\u003cstrong\u003eEffective hourly rate: £1,000 ÷ 30 hours = £33.33\/hour\u003c\/strong\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eReality:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eSolutions once you see this:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eRaise rates to £75\/hour so effective rate becomes £50\/hour\u003c\/li\u003e\n\u003cli\u003eReduce unbillable time (systemize admin, qualify leads better)\u003c\/li\u003e\n\u003cli\u003eBill for previously unbillable time (admin fees, rush fees)\u003c\/li\u003e\n\u003cli\u003eAccept reality and adjust lifestyle budget accordingly\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 7: Tax Calculator (Know What You Owe + How Much to Save)\u003c\/h3\u003e\n\u003ch4\u003eSECTION 1: Annual Tax Estimate (Auto-Calculated)\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003ePulls data automatically from Income and Expense Logs:\u003c\/strong\u003e\u003c\/p\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Income\u003c\/td\u003e\n\u003ctd\u003eAuto-pulls from Invoice Log (paid invoices only)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTotal Tax-Deductible Expenses\u003c\/td\u003e\n\u003ctd\u003eAuto-pulls from Expense Log (where Tax Deductible = Yes)\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eTaxable Profit\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Income minus Expenses\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eYour Tax Rate (%)\u003c\/td\u003e\n\u003ctd\u003eEnter your rate: UK 20% (basic), 40% (higher), 45% (additional) OR US federal 22%, 24%, 32% + state\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eEstimated Tax Owed\u003c\/td\u003e\n\u003ctd\u003e\n\u003cstrong\u003eAuto-calculates:\u003c\/strong\u003e Taxable Profit × Tax Rate %\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp\u003e\u003cstrong\u003eUK Self-Assessment Breakdown:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTaxable profit up to £12,570 = 0% (personal allowance)\u003c\/li\u003e\n\u003cli\u003e£12,571 - £50,270 = 20%\u003c\/li\u003e\n\u003cli\u003e£50,271 - £125,140 = 40%\u003c\/li\u003e\n\u003cli\u003eAbove £125,140 = 45%\u003c\/li\u003e\n\u003cli\u003ePlus National Insurance: Class 2 + Class 4 (tracker can estimate if you enter rates)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eUS Quarterly Estimated Tax Reminder:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIf you expect to owe $1,000+ in tax, IRS requires quarterly payments\u003c\/li\u003e\n\u003cli\u003eDeadlines: April 15, June 15, September 15, January 15\u003c\/li\u003e\n\u003cli\u003eTracker shows quarterly breakdown: Annual Tax ÷ 4\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eSECTION 2: Per-Payment Calculator (The Life-Saver)\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eEvery time you receive payment, use this calculator:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eINPUT:\u003c\/strong\u003e Payment amount received (e.g., £2,000)\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eCALCULATOR SHOWS:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eSet aside for tax (based on your tax rate %):\u003c\/strong\u003e £2,000 × 30% = £600 (example for 30% combined tax rate)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSafe to keep\/spend:\u003c\/strong\u003e £2,000 - £600 = £1,400\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHow to Use This:\u003c\/strong\u003e\u003c\/p\u003e\n\u003col\u003e\n\u003cli\u003eGet paid £2,000\u003c\/li\u003e\n\u003cli\u003eOpen Per-Payment Calculator\u003c\/li\u003e\n\u003cli\u003eEnter £2,000\u003c\/li\u003e\n\u003cli\u003eSee: Save £600 for tax, Keep £1,400\u003c\/li\u003e\n\u003cli\u003eImmediately transfer £600 to separate savings account labeled \"TAX\"\u003c\/li\u003e\n\u003cli\u003eSpend the £1,400 guilt-free\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eThis prevents:\u003c\/strong\u003e Spending all £2,000, then January tax deadline hits and you owe £5,000 you don't have.\u003c\/p\u003e\n\u003ch4\u003eTax Savings Tracking:\u003c\/h4\u003e\n\u003cp\u003eOptional section to log each transfer to tax savings account:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eDate\u003c\/li\u003e\n\u003cli\u003ePayment received amount\u003c\/li\u003e\n\u003cli\u003eAmount transferred to tax savings\u003c\/li\u003e\n\u003cli\u003eRunning total in tax savings account\u003c\/li\u003e\n\u003cli\u003eEstimated tax owed (from Section 1)\u003c\/li\u003e\n\u003cli\u003eShortfall or surplus (are you on track?)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 8: Monthly Review (12-Month Side-by-Side Comparison)\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eAuto-generated dashboard showing key metrics across all 12 months.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eWhat Auto-Populates for Each Month:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eINCOME SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTotal income per month\u003c\/li\u003e\n\u003cli\u003eNumber of invoices sent\u003c\/li\u003e\n\u003cli\u003eAverage invoice value\u003c\/li\u003e\n\u003cli\u003eOutstanding invoices at month-end\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eEXPENSES SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTotal expenses per month\u003c\/li\u003e\n\u003cli\u003eExpenses as % of income\u003c\/li\u003e\n\u003cli\u003eLargest expense category\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003ePROFIT SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eNet profit per month\u003c\/li\u003e\n\u003cli\u003eProfit margin %\u003c\/li\u003e\n\u003cli\u003eCumulative profit year-to-date\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eCLIENTS SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eActive clients count\u003c\/li\u003e\n\u003cli\u003eNew clients added\u003c\/li\u003e\n\u003cli\u003eClients lost\u003c\/li\u003e\n\u003cli\u003eTop client by revenue\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eHOURS SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eTotal hours worked\u003c\/li\u003e\n\u003cli\u003eBillable hours\u003c\/li\u003e\n\u003cli\u003eUnbillable hours\u003c\/li\u003e\n\u003cli\u003eEffective hourly rate\u003c\/li\u003e\n\u003cli\u003eBillable percentage\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003cp\u003e\u003cstrong\u003eGOALS SECTION:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eIncome goal vs actual\u003c\/li\u003e\n\u003cli\u003ePercentage achieved\u003c\/li\u003e\n\u003cli\u003eOn track or behind indicator\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eVisual Indicators:\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eBest Month:\u003c\/strong\u003e Highest profit month auto-highlighted\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWorst Month:\u003c\/strong\u003e Lowest profit month auto-highlighted\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTrends:\u003c\/strong\u003e Income increasing, stable, or decreasing over year\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 9: Annual Overview (Full Year Summary + Next Year Planning)\u003c\/h3\u003e\n\u003ch4\u003eSECTION 1: This Year Summary (Auto-Calculated)\u003c\/h4\u003e\n\u003cul\u003e\n\u003cli\u003eTotal annual income\u003c\/li\u003e\n\u003cli\u003eTotal annual expenses\u003c\/li\u003e\n\u003cli\u003eNet annual profit\u003c\/li\u003e\n\u003cli\u003eProfit margin % for year\u003c\/li\u003e\n\u003cli\u003eTotal tax owed estimate\u003c\/li\u003e\n\u003cli\u003eTotal invoices sent\u003c\/li\u003e\n\u003cli\u003eTotal hours worked (billable + unbillable)\u003c\/li\u003e\n\u003cli\u003eEffective annual hourly rate\u003c\/li\u003e\n\u003cli\u003eTop 3 clients by revenue\u003c\/li\u003e\n\u003cli\u003eMost profitable service or project type\u003c\/li\u003e\n\u003cli\u003eBest month (highest profit)\u003c\/li\u003e\n\u003cli\u003eWorst month (lowest profit)\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eSECTION 2: Next Year Goal-Setting\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eSet targets for next financial year:\u003c\/strong\u003e\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eIncome Goal:\u003c\/strong\u003e Target annual revenue (e.g., 20% increase over this year)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProfit Margin Goal:\u003c\/strong\u003e Target profit percentage (e.g., increase from 40% to 50%)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eClient Goal:\u003c\/strong\u003e Number of clients to acquire or retain\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eRate Increase Percentage:\u003c\/strong\u003e How much to raise rates (e.g., 15% across board)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHours Goal:\u003c\/strong\u003e Billable hours target (e.g., reduce total hours but maintain income)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eSkills to Learn:\u003c\/strong\u003e What training or development needed\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eServices to Add:\u003c\/strong\u003e New offerings to increase income\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eServices to Drop:\u003c\/strong\u003e Low-margin work to eliminate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eClients to Drop:\u003c\/strong\u003e Time-drain clients to fire\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch4\u003eSECTION 3: Year-on-Year Comparison (If Tracking Multiple Years)\u003c\/h4\u003e\n\u003ctable\u003e\n\u003ctbody\u003e\n\u003ctr\u003e\n\u003cth\u003eMetric\u003c\/th\u003e\n\u003cth\u003eYear 1\u003c\/th\u003e\n\u003cth\u003eYear 2\u003c\/th\u003e\n\u003cth\u003eChange\u003c\/th\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eIncome\u003c\/td\u003e\n\u003ctd\u003e£38,000\u003c\/td\u003e\n\u003ctd\u003e£52,000\u003c\/td\u003e\n\u003ctd\u003e+37% 🟢\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eProfit\u003c\/td\u003e\n\u003ctd\u003e£15,200\u003c\/td\u003e\n\u003ctd\u003e£26,000\u003c\/td\u003e\n\u003ctd\u003e+71% 🟢\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003ctr\u003e\n\u003ctd\u003eEffective Rate\u003c\/td\u003e\n\u003ctd\u003e£22\/hour\u003c\/td\u003e\n\u003ctd\u003e£34\/hour\u003c\/td\u003e\n\u003ctd\u003e+55% 🟢\u003c\/td\u003e\n\u003c\/tr\u003e\n\u003c\/tbody\u003e\n\u003c\/table\u003e\n\u003cp\u003e\u003cstrong\u003eThis shows growth objectively. Not feelings, not guesses - numbers.\u003c\/strong\u003e\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 10: Q\u0026amp;A Problem Solver (10 Real Freelancer Questions)\u003c\/h3\u003e\n\u003ch4\u003eThe Questions with Honest, Practical Answers:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eQ1: How do I know what to charge?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eA:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ2: How much tax will I owe?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eA:\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ3: What do I do about non-paying clients?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ4: How do I know which clients to drop?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ5: Why is my hourly rate so low despite charging decent rates?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ6: How do I estimate project time accurately?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ7: Should I do fixed price or hourly?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ8: How do I grow beyond referrals and word-of-mouth?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ9: When should I increase my rates?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQ10: How do I handle scope creep (clients asking for more)?\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cem\u003eAll 10 questions answered with evidence-based, practical guidance - not motivational fluff.\u003c\/em\u003e\u003c\/p\u003e\n\u003chr\u003e\n\u003ch3\u003eSheet 11: How To Use (Daily Routine + Setup Instructions)\u003c\/h3\u003e\n\u003ch4\u003eDaily 5-Minute Routine:\u003c\/h4\u003e\n\u003col\u003e\n\u003cli\u003e\n\u003cstrong\u003eLog time worked today:\u003c\/strong\u003e Fill in Time Tracker for each work session\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLog any invoices sent:\u003c\/strong\u003e Add to Invoice Log immediately after sending\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eLog any expenses incurred:\u003c\/strong\u003e Add to Expense Log same day (don't wait)\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eUpdate payment status:\u003c\/strong\u003e Mark invoices as Paid when money received\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eCheck Dashboard:\u003c\/strong\u003e Quick glance at key metrics\u003c\/li\u003e\n\u003c\/ol\u003e\n\u003cp\u003e\u003cstrong\u003eConsistency = accurate data. 5 minutes daily prevents hour-long catch-up sessions monthly.\u003c\/strong\u003e\u003c\/p\u003e\n\u003ch4\u003eFinancial Year Start Date Instructions:\u003c\/h4\u003e\n\u003cp\u003e\u003cstrong\u003eUK:\u003c\/strong\u003e Tax year runs 6 April to 5 April. Set start date to 6 April [current year].\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eUS:\u003c\/strong\u003e Tax year runs 1 January to 31 December. Set start date to 1 January [current year].\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eStarting mid-year?\u003c\/strong\u003e That's fine - set start date to whenever you begin tracking. Just note in Annual Overview that it's partial year.\u003c\/p\u003e\n\u003ch4\u003eDisclaimer\u003c\/h4\u003e\n\u003cp\u003e\u003cem\u003e\"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.\"\u003c\/em\u003e\u003c\/p\u003e\n\u003ch4\u003eFull PLR Rebrand Instructions\u003c\/h4\u003e\n\u003chr\u003e\n\u003ch2\u003e🎯 Who This Tracker Is For\u003c\/h2\u003e\n\u003ch3\u003ePersonal Use (By Freelance Discipline):\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Designers\u003c\/strong\u003e - Graphic, web, UX\/UI, branding\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Writers\u003c\/strong\u003e - Copywriters, content writers, journalists, editors\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Developers\u003c\/strong\u003e - Web dev, app dev, software engineers\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Consultants\u003c\/strong\u003e - Business, marketing, strategy consultants\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Coaches\u003c\/strong\u003e - Business, life, health, career coaches\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Photographers\u003c\/strong\u003e - Event, portrait, commercial photography\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eVirtual Assistants\u003c\/strong\u003e - Admin, social media, customer service VAs\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eSocial Media Managers\u003c\/strong\u003e - Freelance SMM, community managers\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Marketers\u003c\/strong\u003e - Email marketing, ads, SEO, content marketing\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance Video Editors\u003c\/strong\u003e - YouTube editors, commercial video production\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eAny self-employed professional\u003c\/strong\u003e - Anyone invoicing clients needs this\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003eProfessional Use (PLR\/MRR):\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e✓ \u003cstrong\u003eBusiness coaches\u003c\/strong\u003e - Give to freelance clients for financial organization\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eAccountants\u003c\/strong\u003e - Provide to self-employed clients for record-keeping\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eBookkeepers\u003c\/strong\u003e - Help clients organize before bookkeeping sessions\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eBusiness consultants\u003c\/strong\u003e - Tool for freelance\/solopreneur clients\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFinancial advisors\u003c\/strong\u003e - Help self-employed clients track income\/expenses\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eCo-working spaces\u003c\/strong\u003e - Offer as member resource\u003c\/li\u003e\n\u003cli\u003e✓ \u003cstrong\u003eFreelance platforms\u003c\/strong\u003e - Provide as value-add to freelancers on platform\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch2\u003e💰 Includes Full PLR and MRR Rights\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e✅ Use for your own freelance business\u003c\/li\u003e\n\u003cli\u003e✅ Rebrand with your business name\u003c\/li\u003e\n\u003cli\u003e✅ Sell as your own product\u003c\/li\u003e\n\u003cli\u003e✅ Give to clients and students\u003c\/li\u003e\n\u003cli\u003e✅ Include in coaching programs\u003c\/li\u003e\n\u003cli\u003e✅ Bundle with business courses\u003c\/li\u003e\n\u003cli\u003e✅ Customize for specific industries\u003c\/li\u003e\n\u003cli\u003e✅ Offer MRR rights to buyers\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch2\u003e📦 What You Get Immediately\u003c\/h2\u003e\n\u003cul\u003e\n\u003cli\u003e✅ \u003cstrong\u003e11-Sheet Google Sheets System\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eDashboard with 8 Auto-Calculated Metrics\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eVisual Progress Bars (Monthly \u0026amp; Annual Goals)\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eMinimum Rate Calculator\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003e500-Row Invoice Log\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003e500-Row Expense Log\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003e50-Client Tracker with Revenue Per Hour\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003e365-Day Time Tracker with Dynamic Dates\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eTax Calculator with Per-Payment Breakdown\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eMonthly Review (12-Month Comparison)\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eAnnual Overview with Goal-Setting\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eQ\u0026amp;A Problem Solver (10 Questions)\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003cli\u003e✅ \u003cstrong\u003eFull PLR and MRR Rights\u003c\/strong\u003e\n\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003chr\u003e\n\u003ch2\u003e❓ FAQ\u003c\/h2\u003e\n\u003ch3\u003eDo I need accounting software instead?\u003c\/h3\u003e\n\u003cp\u003eThis 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.\u003c\/p\u003e\n\u003ch3\u003eWill this work for my accountant?\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eYes.\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003ch3\u003eWhat if I use QuickBooks or Xero already?\u003c\/h3\u003e\n\u003cp\u003eYou 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.\u003c\/p\u003e\n\u003ch3\u003eDoes this work for US and UK tax?\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eYes.\u003c\/strong\u003e 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.\u003c\/p\u003e\n\u003ch3\u003eCan I track multiple currencies?\u003c\/h3\u003e\n\u003cp\u003eThe tracker uses one currency throughout (you choose £, $, €, etc). If you invoice in multiple currencies, convert to your base currency when logging.\u003c\/p\u003e\n\u003ch3\u003eWhat's the difference between this and a budget planner?\u003c\/h3\u003e\n\u003cp\u003eBudget planners are for personal finance. This is for BUSINESS finance - invoices, expenses, client profitability, tax estimates specific to freelancing\/self-employment.\u003c\/p\u003e\n\u003ch3\u003eCan business coaches rebrand for clients?\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003eYes!\u003c\/strong\u003e Full PLR\/MRR rights. Perfect tool for freelance\/solopreneur clients who need financial organization.\u003c\/p\u003e\n\u003ch3\u003eHow long does it take to set up?\u003c\/h3\u003e\n\u003cp\u003eInitial 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.\u003c\/p\u003e\n\u003chr\u003e\n\u003ch2\u003e💼 Stop Guessing. Start Knowing. Track Your Freelance Business Like a Business.\u003c\/h2\u003e\n\u003cp\u003e\u003cstrong\u003eFreelancer 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\u0026amp;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.\u003cbr\u003e\u003cbr\u003e\u003c\/strong\u003e\u003cem\u003eEleven-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\u0026amp;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.\u003c\/em\u003e\u003cstrong\u003e\u003cbr\u003e\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003ePerfect for:\u003c\/strong\u003e 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\u003c\/p\u003e\n\u003cp\u003eKnow your numbers. Price with confidence. Keep more money. Start tracking today.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eQuestions?\u003c\/strong\u003e \u003ca href=\"https:\/\/digitalbizplr.com\/pages\/contact\" target=\"_blank\"\u003eContact us here\u003c\/a\u003e\u003c\/p\u003e","brand":"Digital Biz PLR","offers":[{"title":"Default Title","offer_id":57636468654412,"sku":null,"price":12.25,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0846\/2748\/9100\/files\/DIGITALBIZPLR-PLRDigitalProducts_DigitalPLR_DigitalPLRProducts_1920x1080px_-2026-05-26T133748.190.png?v=1779805283","url":"https:\/\/digitalbizplr.com\/products\/freelancer-business-tracker-plr","provider":"Digital Biz PLR","version":"1.0","type":"link"}