Google Sheets
Small Business Bookkeeping & Profit Dashboard, Google Sheets Template, Automated P&L, Income Expense Tracker
π· Run your business by the numbers β without doing the maths. This automated Google Sheets bookkeeping template turns every sale and expense into a live profit dashboard: log a few details, pick from dropdowns, and watch your income, costs, profit and margin update themselves.
No more shoebox receipts, year-end panic or "am I actually making money?" β the dashboard answers it at a glance.
π WHAT'S INSIDE (6 tabs)
β’ Dashboard β 6 live KPI cards (income, expenses, net profit, margin, sales tax, deductible costs), 2 business-health gauges & 4 auto-updating charts
β’ Income β log every sale with channel dropdowns (Etsy, Shopify, wholesale & more)
β’ Expenses β categorised costs with tax-deductible tracking
β’ Settings β make the dropdown lists your own
β’ Start Here β quick setup guide so you're running in minutes
βοΈ HOW IT WORKS
1. Open your link and click "Make a copy" β the template saves to your Google Drive
2. Add your income and expenses as they happen (each entry takes seconds)
3. Watch the dashboard recalculate your profit, margin and tax β live
4. Check your best channels and biggest costs in the charts
5. Come tax time, your numbers are already organised
π PERFECT FOR
β’ Etsy & Shopify sellers, makers and crafters
β’ Freelancers and side hustlers
β’ Small business owners who hate bookkeeping
β’ Anyone who wants to see profit clearly, without accounting software
π» FORMAT & ACCESS
β’ Made for Google Sheets β works on phone, tablet & desktop
β’ Nothing to install, no software fees β just a free Google account
β’ Delivered as a private "Make a Copy" link β one click and it's yours
β’ Your copy is 100% private and fully editable, forever
β’ All formulas built in β type your numbers, everything updates itself
β‘ INSTANT ACCESS β Your template link is available immediately after purchase. No physical item will be shipped.
π Please note: This is a digital product. Due to the instant-access nature of digital files, all sales are final and no refunds are offered. If anything looks off, message me and I'll happily help.
Helpful guides
- Bookkeeping for Etsy Sellers: A Simple System That WorksSelling is the fun part β the numbers are where shops quietly leak money. Here's a simple bookkeeping system for Etsy and handmade sellers: what to track, how often, and how to know your real profit.
- Google Sheets for Small Business: Run the Whole Thing FreeBefore you subscribe to accounting software, a CRM, an order system and an invoice tool, look at what Google Sheets does free. Here's the full small-business setup, sheet by sheet.
- CRM in Google Sheets: Manage Clients Without Monthly FeesMost small businesses don't need CRM software β they need a tidy pipeline and reliable follow-ups. Here's how a Google Sheets CRM does the job without the monthly fee.
More in Google Sheets
Quick viewGoogle Sheets Mega Bundle β The Complete Collection, All 25 Dashboards: Budget, Wedding, Business, ADHD, Renovation & More (Β£338 Value)
Google Sheets
Β£49.99
Quick viewLife OS β The Master Dashboard, Google Sheets Life Planner Spreadsheet: Todayβs Top 3, Goals, Habits, Money & Weekly Review in One Live Dashboard
Google Sheets
Β£19.99
Quick viewHomeschool OS β Google Sheets Homeschool Planner Spreadsheet: Attendance Tracker, Lesson Planner, Progress & Curriculum Budget, Up to 4 Children
Google Sheets
Β£14.99
Quick viewCollege Student OS β Google Sheets Student Planner Spreadsheet: Assignment Tracker, Weighted Grade Calculator & Student Budget, Semester Dashboard
Google Sheets
Β£12.99
Quick viewNew Baby Budget β Google Sheets First-Year Planner Spreadsheet: Baby Checklist with Costs, Maternity Leave Cash Flow & First-Year Expense Tracker
Google Sheets
Β£12.99
Reviews
No reviews yet, bought this? Be the first to leave one below. Every review helps another shopper decide.
Write a review
Β£14.99