Small Business Dashboard for Excel, Income, Expense and Profit Tracker for Freelancers
Item highlights
Seller's description
Know what you earned, what you spent and who still owes you, in one dashboard.
Log money in and money out once. The monthly P&L, KPI dashboard, top clients and invoice status build themselves.
WHAT IT DOES
- Setup once: currency symbol, fiscal-year start (any month), tax set-aside %, opening cash, payment terms, your own categories
- Monthly P&L: income, cost of sales, gross profit and margin, operating expenses, net profit, tax set-aside
- KPI dashboard (year to date): revenue, gross margin, net profit and margin, cash and cash runway, this month vs last month, unpaid and overdue invoices, charts, expense mix
- Invoice log: due date from your payment terms; status turns Paid, Due soon or Overdue by itself
- Rows dated outside your fiscal year are flagged and left out, so totals stay right
- Freelancer extras: top 5 clients by revenue, monthly income goal vs this month, Income ledger by client and project
WHAT'S INSIDE
- Small-Business-Dashboard-Freelancer.xlsx: filled example (a fictional design freelancer, 10 months of data)
- Blank copy
- 3-page PDF guide
Tabs: Instructions, Setup, Income (500 rows), Expenses (500), Invoices (200), P&L, Dashboard
WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice.
No macros, no add-ins. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them. Best edited on a computer; phone apps can view.
GOOD TO KNOW
- Instant digital download: a .zip with the filled example, a blank copy and a PDF guide. Nothing is shipped.
- Licence: for your own use and use inside your own business. Please do not resell or share the files.
- A problem opening the file? Message us and we'll help.
- Bookkeeping aid only, not financial, accounting or tax advice. The tax set-aside is a savings % you choose; ask a qualified accountant or your tax office what you owe. No VAT/sales-tax returns.
HOW THIS WAS MADE
We designed these workbooks and wrote the formulas, guide text and the scripts that build the files with the help of AI tools. Scripts recalculated each file in LibreOffice and compared it with a separate Python calculation across 10 test cases, including edge cases. The listing photos are real screenshots of the files (no AI-generated images).
If something goes wrong with an order, we've got your back for all eligible purchases. View program terms
NowPrice:$2.39
Original Price: $3.19
25% off
Sale ends on November 16
You can only make an offer when buying a single item
Delivery
Instant download
Your files will be available to download once payment is confirmed. Here's how.
Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.
Seller's description
Specifications
Know what you earned, what you spent and who still owes you, in one dashboard.
Log money in and money out once. The monthly P&L, KPI dashboard, top clients and invoice status build themselves.
WHAT IT DOES
- Setup once: currency symbol, fiscal-year start (any month), tax set-aside %, opening cash, payment terms, your own categories
- Monthly P&L: income, cost of sales, gross profit and margin, operating expenses, net profit, tax set-aside
- KPI dashboard (year to date): revenue, gross margin, net profit and margin, cash and cash runway, this month vs last month, unpaid and overdue invoices, charts, expense mix
- Invoice log: due date from your payment terms; status turns Paid, Due soon or Overdue by itself
- Rows dated outside your fiscal year are flagged and left out, so totals stay right
- Freelancer extras: top 5 clients by revenue, monthly income goal vs this month, Income ledger by client and project
WHAT'S INSIDE
- Small-Business-Dashboard-Freelancer.xlsx: filled example (a fictional design freelancer, 10 months of data)
- Blank copy
- 3-page PDF guide
Tabs: Instructions, Setup, Income (500 rows), Expenses (500), Invoices (200), P&L, Dashboard
WORKS WITH
A script opened this file in Microsoft Excel for Mac 16.114.3 and ran a full recalculation. Every cell matched the values stored in the file, with no error cells. That test did not type new data. Excel for Windows, older Excel versions and Google Sheets have not been tried. The formula tests ran in LibreOffice.
No macros, no add-ins. Formula cells are protected without a password, so you can't break them by accident, and you can still unlock them. Best edited on a computer; phone apps can view.
GOOD TO KNOW
- Instant digital download: a .zip with the filled example, a blank copy and a PDF guide. Nothing is shipped.
- Licence: for your own use and use inside your own business. Please do not resell or share the files.
- A problem opening the file? Message us and we'll help.
- Bookkeeping aid only, not financial, accounting or tax advice. The tax set-aside is a savings % you choose; ask a qualified accountant or your tax office what you owe. No VAT/sales-tax returns.
HOW THIS WAS MADE
We designed these workbooks and wrote the formulas, guide text and the scripts that build the files with the help of AI tools. Scripts recalculated each file in LibreOffice and compared it with a separate Python calculation across 10 test cases, including edge cases. The listing photos are real screenshots of the files (no AI-generated images).
-
Designed by
-
Item typeDigital download
-
Digital file type(s)1 ZIP
If something goes wrong with an order, we've got your back on all eligible purchases. View program terms
Meet your seller
More from this shop
-
Digital download
Service Business Dashboard for Excel, Job Profit Tracker, Invoice Log for Contractors
Sale Price $2.39
Original Price $3.19
-
Digital download
Project Management Template for Excel, Automatic Gantt Chart, RAID Log, Dashboard
Sale Price $2.84
Original Price $3.79
-
Digital download
Seller Profit Tracker Spreadsheet for Excel, Fees, Shipping, Profit per Product
Sale Price $2.39
Original Price $3.19
-
Digital download
Project Management Bundle for Excel, Gantt Planner Plus Small Business Dashboard
Sale Price $3.82
Original Price $5.09
-
Digital download
Construction Schedule Template for Excel, Gantt With Trades, Hold Points and Permits
Sale Price $2.84
Original Price $3.79
-
Digital download
Spreadsheet Bundle for Excel, Project Gantt, Business Dashboard, Debt Payoff and Budget
Sale Price $4.87
Original Price $6.49
-
Digital download
Business Sales Budget Template for Excel & Google Sheets | Revenue Planning Targets Sales Dashboard
Sale Price $1.33
Original Price $2.67
-
Digital download
Small Business Dashboard Bundle | Excel Revenue Expense Profit Tracker | KPI Analytics Template | Google Sheets
$4.99
-
Digital download
Excel Budget Template Small Business Budget Spreadsheet Financial Tracker Business Expense Management System Cash Flow Profit Loss Dashboard
$4.00
-
Digital download
Annual Sales & Expense Report Template for Excel Google Sheets | Business Revenue, Cost Profit Dashboard
Sale Price $2.00
Original Price $4.00
-
Digital download
Simple Sales Tracker | Business Performance-Revenue-Profit & Customer Analytics | Excel Template
Sale Price $1.88
Original Price $3.13
-
Digital download
Complete Sales Tracker Excel & Google Sheets | KPI Dashboard and Sales Pipeline Tool, CRM, Forecast, Budget Tracker, Funnel, Revenue Tracker
Sale Price $2.16
Original Price $3.33
-
Digital download
Small Business Bookkeeping Spreadsheet Google Sheets, Income and Expense Tracker, Simple Bookkeeping Template
Sale Price $2.40
Original Price $3.00
-
Digital download
Small Business Financial Forecast Template | Excel Five Year Planner
$3.95
-
Digital download
Sales Dashboard, Small Business Tracker, Google sheets, Income expense tracking order payment Template
$9.25
-
Digital download
Google Sheets Invoice Tracker | Small Business Income Dashboard (Digital Download)
Sale Price $3.00
Original Price $4.00
-
Digital download
Small Business Bookkeeping Spreadsheet | Financial Template (Digital)
$1.41
-
Digital download
Small Business Profit & Cash Flow Dashboard | Excel + Google Sheets
$2.99
Shoppers with similar taste loved these
-
Digital download
Social Media Manager Starter Kit, Canva Template Business Bundle, Client Onboarding Pack, Branding, Pricing Services, Strategy Proposal
Sale Price $20.19
Original Price $40.38
-
Digital download
Small Business Tracker Spreadsheet Google Sheet Excel Inventory Tracker Bookkeeping Template Client Order Tracker Employee Timesheet Payroll
Sale Price $12.60
Original Price $25.19
-
Digital download
New Client Welcome Packet Template for Canva, 30 Page Editable Business Onboarding Guide, Modern Customizable Marketing Book Service Pricing
Sale Price $4.33
Original Price $8.65
-
Digital download
Freelancer Business Planner Google Sheets Excel CRM Client Tracker Invoice Bookkeeping Task Manager Expense Budget Dashboard Template
Sale Price $15.10
Original Price $30.21
-
Digital download
Profit and Loss Easy Bookkeeping Template & Business Spreadsheet with Income and Expense Tracker | Tax Planner and Client Tracker
Sale Price $14.52
Original Price $29.04
-
Digital download
Small Business Bundle Bookkeeping Inventory Tracker Order Tracker Product Handmade Pricing Calculator Smart Bill Calendar Google Sheet Excel
Sale Price $14.82
Original Price $29.64
-
Digital download
Photographer's Business Planner: Client Workflow & Budget Tracker (PDF Download)
Sale Price $11.18
Original Price $22.35
-
Digital download
All-in-One Digital Planner 2027 2028 2029, Hyperlink Digital Planner, Daily Weekly Monthly Journal, Goodnotes Planner, Apple Google Calendar
Sale Price $0.83
Original Price $2.96
-
Digital download
Small business bookkeeping Google Sheets Dark Mode Income Expense Tracker Freelancer Tax Planner Profit Loss Spreadsheet 1099 Mileage Log
Sale Price $6.99
Original Price $13.98
-
Digital download
Digital Business Planner,Business Notebook, Small Business Planner, Goodnotes Planner, Notability Planner
Sale Price $1.49
Original Price $2.99
-
Digital download
COMPLETE Etsy Shop Printable Planner
$3.00
-
Digital download
Printable Business Planner Bundle: Branding, Website, Blog (A5, A4, Letter Size) (PDF Digital)
$26.70