Freelancer Finance Planner & Client CRM | Excel Business Dashboard

Description
💼 FREELANCER FINANCE PLANNER + CLIENT CRM


Organize freelance finances, client projects and future sales opportunities in one practical Excel toolkit.
This free professional system is designed for freelancers, consultants, coaches, creatives and small service businesses that want clearer visibility over projects, invoices, payments, expenses, tax reserves, leads and clients.


📊 MAIN FREELANCER FINANCE TRACKER
The Main Tracker contains 7 worksheets:
🏠 Start
📊 Dashboard
📁 Projects
🧾 Invoices
💳 Payments
💸 Expenses
⚙️ Dashboard_Data
The workbook separates manual inputs, dropdown fields and automatic formula areas to keep the workflow easy to understand.


IDEAL FOR
💼 Freelancers
📚 Coaches
📊 Consultants
🎨 Designers & Creatives
💻 Independent Professionals
🚀 Solopreneurs
🏢 Small Service Businesses
🌐 Online Service Providers


📁 PROJECT TRACKING
Manage client work with:
• Project ID
• Client Name
• Project Name
• Project Type
• Status
• Start & Due Dates
• Project Amount
• Notes


The tracker automatically calculates:
✅ Invoice Count
✅ Amount Invoiced
✅ Amount Paid
✅ Paid %
✅ Outstanding Balance


This creates a clear connection between projects, billing and received payments.


🧾 INVOICE MANAGEMENT
Track invoices from draft through payment.
Maintain:
• Invoice Number
• Invoice Date
• Project
• Description
• Subtotal
• Tax Rate
• Due Date
• Status


Automatic calculations provide:
✅ Client Name
✅ Tax Amount
✅ Invoice Total
✅ Amount Paid
✅ Paid %
✅ Outstanding Balance
✅ Overdue Status


💳 PAYMENTS & INCOME
Record incoming payments with:
💵 Gross Amount
💳 Fees
📅 Payment Date
🏦 Payment Method


The workbook automatically calculates:
✅ Net Income
✅ Linked Project
✅ Linked Client
✅ Suggested Tax Reserve


The Tax Reserve is an internal planning estimate based on the tax rate configured in the workbook.


💸 EXPENSE TRACKING
Maintain business costs by:
• Category
• Vendor
• Description
• Payment Method
• Amount
• Tax-Deductible Status
• Optional Project Link


Project names are automatically linked when a valid Project ID is selected.


📊 FREELANCER BUSINESS DASHBOARD
The Main Dashboard provides 6 KPI cards:
💰 Gross Revenue
💵 Net Income
💸 Expenses
📈 Net Profit
🧮 Tax Reserve
🧾 Open Invoices


Four dynamic charts provide additional visibility into:
📊 Monthly Gross Revenue vs Expenses
📈 Monthly Profit & Tax Reserve
👥 Net Income by Client
💸 Expenses by Category


No manual input is required on the Dashboard.


🎁 BONUS: LEAD PIPELINE + CLIENT CRM
The separate bonus workbook helps manage future business before it becomes paid project activity.
It contains 5 worksheets:
🏠 Start
📊 Dashboard
🚀 Leads
👥 Clients
⚙️ Data
🚀 LEAD PIPELINE


Track:
✅ Lead Source
✅ Service Type
✅ Sales Status
✅ Estimated Deal Size
✅ Probability
✅ Weighted Value
✅ Next Action
✅ Due Date
✅ Priority


Weighted Value is calculated automatically from:
Estimated Deal Size × Probability


This provides a simple way to prioritize opportunities and understand expected pipeline value.


👥 CLIENT CRM
Maintain a lightweight client database with:
• Client Name
• Industry / Type
• Main Contact
• Email
• Country / Timezone
• First Project Date
• Client Status
• Notes


Total Closed Revenue is automatically calculated from won opportunities for matching clients.


📈 BONUS PIPELINE DASHBOARD
The bonus dashboard summarizes:
💰 Total Pipeline
📊 Expected Value
🚀 Active Leads
🏆 Won Value
✅ Won Leads
📈 Win Rate


Four visual charts provide additional pipeline and client-status analysis.


📘 9-PAGE HOW-TO GUIDE
The included English guide explains:
🚀 Quick Setup
🎨 Input & Formula Color Logic
📁 Project Tracking
🧾 Invoice Management
💳 Payments
💸 Expenses
📊 Main Dashboard
🚀 Lead Pipeline
👥 Client CRM
🔄 How Both Files Work Together
☁️ Google Sheets Import
🛠️ Best Practices
⚖️ Usage & Legal Notes
💎 ONE SIMPLE FREELANCER WORKFLOW


The toolkit connects:
Lead → Client → Project → Invoice → Payment → Expense → Dashboard
Use the bonus pipeline before a deal is won, then move confirmed work into the Main Tracker for financial management.


✨ SIMPLE & EDITABLE
✅ Formula-based Excel workbooks
✅ Dropdown fields
✅ Data bars
✅ Automatic calculations
✅ Realistic sample data
✅ Modern navigation
✅ No macros
✅ No VBA
✅ No external data connections


Microsoft Excel is recommended for the most consistent design and chart experience.
The XLSX files can also be imported into Google Sheets. Some colors, fonts, charts, navigation or layout details may vary after conversion.