Business Control Hub | Freelancer Finance & Cashflow Dashboard Excel

Description
📊 BUSINESS CONTROL HUB + BONUS CASHFLOW TRACKER


Organize your business finances in one clean and structured Excel system.
This free professional toolkit is designed for freelancers, self-employed professionals, consultants, creators and small businesses that want a clearer overview of income, expenses, profit, forecasts, recurring costs, clients and marketing performance.


IDEAL FOR
👩‍💻 Freelancers
💼 Consultants
🎨 Creators
🛍️ Online Sellers
📚 Coaches
🏢 Small Businesses
🚀 Solo Entrepreneurs
📊 Self-Employed Professionals


📈 BUSINESS FINANCE DASHBOARD


The Main Business Control Hub includes a visual dashboard with key financial indicators such as:
💰 Total Income
💸 Total Expenses
🧾 Tax Collected
📈 Net Profit
📣 Marketing Average ROI


Four dynamic charts provide additional visibility into:
📊 Income by Category
📊 Expenses by Category
📈 Income vs Expenses by Month
📣 Revenue by Marketing Channel


💰 INCOME & EXPENSE TRACKING
Record income by:
• Month
• Category
• Description
• Client
• Amount


The workbook automatically calculates the built-in 10% tax column and summary metrics.


The Expenses tracker helps organize:
• Business costs
• Expense categories
• Amounts
• Recurring vs one-off expenses


🔮 FORECAST PLANNING
Plan projected income and expenses across 12 months.


The workbook automatically calculates monthly Net Projection and summary figures for:
✅ Projected Income
✅ Projected Expenses
✅ Projected Net


🔁 RECURRING COSTS
Maintain fixed and recurring business expenses such as:
• Software
• Hosting
• Rent
• Insurance
• Phone
• Email
• Bookkeeping


Annual cost figures are calculated automatically from monthly amounts.


📣 MARKETING ROI TRACKER
Track marketing activity by channel with:
✅ Planned Budget
✅ Actual Spend
✅ Leads / Customers
✅ Revenue
✅ Automatic ROI


This provides a simple way to compare marketing investment with generated revenue.


👥 CLIENT DIRECTORY
Maintain a lightweight client database containing:
• Client name
• Contact information
• Lifetime Value
• VIP status


Summary metrics help provide a quick overview of overall client value.


🎁 BONUS CASHFLOW TRACKER
A separate simplified cashflow workbook is also included.


Enter:
💵 Starting Balance
🎯 Target Monthly Net
💰 Monthly Income
💸 Monthly Expenses


The workbook automatically calculates:
✅ Net Cashflow
✅ Margin
✅ Running Balance
✅ Monthly Status
✅ Quick Insights


Its separate dashboard displays:
💰 Total Inflow
💸 Total Outflow
📈 Net Cashflow
💵 Ending Balance


Plus 2 visual charts for monthly performance and running cash position.


📘 PDF HOW-TO GUIDE
The included 5-page English guide explains:
🚀 Initial setup
✏️ Editable vs formula areas
📊 Main workbook workflow
🎁 Bonus Cashflow Tracker
📈 Dashboard usage
☁️ Google Sheets considerations
🛠️ Troubleshooting
⚖️ License and usage notes


✨ SIMPLE & EDITABLE
✅ Formula-based Excel workbooks
✅ Demo data included
✅ Dropdown support
✅ Automatic summaries
✅ 4 Main Dashboard Charts
✅ 2 Cashflow Dashboard Charts
✅ No macros
✅ No VBA
✅ No external data connections


Microsoft Excel is recommended for the most consistent experience.
The XLSX files can also be imported into Google Sheets. Some formatting, fonts or chart styling may display differently after conversion.


💎 ONE SIMPLE BUSINESS FINANCE WORKFLOW
Income → Expenses → Forecast → Fixed Costs → Marketing → Clients → Dashboard → Cashflow
Use the included sample data to understand the workflow, then replace it with your own business information.


⚖️ FINANCIAL DISCLAIMER
This product is an editable organizational and financial-tracking template intended for general business use.
It does not constitute tax, accounting, bookkeeping, legal, investment or financial advice.


All entries, formulas, tax assumptions, calculations and outputs should be reviewed and validated by the user before being used for financial or business decisions.


The workbook does not replace professional accounting or bookkeeping systems.