Description
Get the full bundle: Small Business Finance Spreadsheet Bundle ($14.99, 5 workbooks: cash flow, P&L, budget, freelancer finance, Etsy seller profit).
Log each sale and each cost once, and get a monthly P&L, an annual statement, a quarterly view, budget vs actual and a dashboard. Works in Microsoft Excel and Google Sheets.
Watch the setup guide & full tour
What’s inside (9 connected tabs)
- Start Here: 6 setup steps, colour key, tab guide
- Dashboard: revenue, gross profit and margin, operating costs, net profit and margin, best month, tax set-aside, this vs last month, budget watch, 2 charts
- Setup: business name, currency, year, tax set-aside %, 30 categories in 3 groups
- Transactions: 2,000 rows, category dropdown, month and quarter filled in from the date
- Monthly P&L: 12 months by category, gross and net profit, both margins
- Annual Statement: classic P&L with % of revenue on every line and key ratios
- Quarterly: Q1 to Q4 side by side with net margin and a chart
- Budget vs Actual: yearly budget scaled to date, variance, on track / watch / over budget
- Expense Breakdown: costs ranked biggest first with a pie chart
Why it helps
- Monthly, quarterly and annual P&L from one list of transactions
- Gross and net margin worked out for you
- Budget vs actual with clear status
- Tax set-aside reminder on the dashboard
- Formulas only: no macros, no add-ons, no subscription
- Sample data so you can see how it works
Included
- Profit-and-Loss-Statement.xlsx
- Setup Guide PDF
- Setup + full tour video
An organising tool, not tax or accounting advice.
Want your own store like this one? createdigitaltools.com runs on Hostinger WordPress hosting. Start your own shop with Hostinger, or try the no-code Hostinger Website Builder.
Affiliate links: I may earn a commission at no extra cost to you.
