Small Business Profit Pack — Free Spreadsheets for Profit & Loss, Cash Flow & Pricing

The problem

Revenue without clarity is just busy work — you're making money but you don't know if you're keeping any of it

💵

Most small business owners confuse revenue with profit — and it costs them everything

A business that does $12,000 a month in revenue sounds healthy until you subtract COGS, rent, payroll, software subscriptions, card processing fees, and the random $400 repair that always shows up in month nine. The gap between gross revenue and net profit is where most small businesses silently bleed out — not from one big mistake, but from dozens of small costs that never get tracked together. The Monthly Profit & Loss Tracker forces that accounting into one view, every month, whether you want to see it or not.

⚠

Cash flow surprises kill profitable businesses — and most owners don't see them coming until it's too late

A business can be profitable on paper and still bounce payroll. Profit is an accounting concept; cash is what pays your suppliers and keeps the lights on. Seasonal dips, large vendor invoices due in the same week as payroll, slow-paying clients, and unexpected tax bills are all predictable with a rolling cash flow forecast — but most business owners don't build one until after the first time they almost ran out of money. The 12-week Cash Flow Forecast in this pack builds that visibility before the crisis, not during it.

📈

Pricing guesswork leaves money on the table — or loses jobs to competitors you're actually undercutting yourself

Most small business owners set prices by gut feel, competitor comparison, or "what feels right" — and all three approaches share the same flaw: none of them start with what the work actually costs. Cost-plus pricing is the floor. Value-based pricing is the ceiling. The gap between them is your negotiating room. Without a pricing model that calculates both, you're either leaving margin behind every time a client says yes too fast, or you're losing jobs to a competitor who's just doing the math you're not. The Pricing Calculator in this pack builds the model that tells you exactly what to charge — and why.

What's inside

Six templates that put your actual business numbers in one place — so you can run the business instead of being run by it

Each template is a CSV file that opens in Google Sheets, Excel, Numbers, or any spreadsheet app. Pre-built formulas, realistic benchmarks, and clear column labels included.

01

Monthly Profit & Loss Tracker

Revenue by category, cost of goods sold (COGS), gross profit, gross margin percentage, operating expenses line-by-line (rent, payroll, software, marketing, payment processing, miscellaneous), total operating expenses, operating income, net income, and net margin. Twelve monthly columns with a YTD total and a rolling 3-month average for every row. The gross margin row is color-coded against a target you set — green when you're above it, red when you're below. The most common small business revelation when they first fill this out: their effective gross margin is 15–20 points lower than they assumed. This spreadsheet shows you that gap by month, not by year-end surprise.

Pairs with Profit Margin Calculator & Markup Calculator

02

Break-Even Analysis

Fixed costs (rent, insurance, salaries, subscriptions — costs that don't change with volume), variable cost per unit (materials, labor, shipping, payment processing — costs that scale with every sale), selling price per unit, contribution margin per unit (price minus variable cost), break-even units (fixed costs ÷ contribution margin), break-even revenue, and margin of safety (how far current revenue is above break-even, in dollars and percentage). Includes a multi-scenario table: adjust price, variable cost, or fixed cost independently and see how break-even shifts. The margin-of-safety column is the number most business owners have never calculated — it tells you exactly how much revenue you can lose before you go cash-negative.

Pairs with Break-Even Calculator & Profit Margin Calculator

03

12-Week Cash Flow Forecast

Rolling 12-week cash flow model: weekly cash inflows (sales collected, client payments, loan proceeds), weekly cash outflows (payroll, vendor payments, rent, utilities, loan repayments, tax estimates), net weekly cash flow, running cash balance, burn rate (average weekly outflow), and runway in weeks (current balance ÷ burn rate). Color-coded balance column flags weeks where the running total dips below your minimum cash reserve threshold. The burn rate and runway rows are the ones that change behavior: most business owners who see "6 weeks of runway" start collecting receivables differently the next morning. This forecast forces a forward-looking view instead of only reading the bank statement after the fact.

Pairs with Business Cash Flow Calculator & Break-Even Calculator

04

Pricing Calculator

Cost-plus pricing (direct cost + overhead allocation + target margin = floor price), value-based pricing (client value delivered × capture rate = ceiling price), competitive benchmark column (competitor price range, your position in market), target margin back-calculation (enter desired net margin, get required price), and a price sensitivity table showing margin outcome at 5%, 10%, and 15% price adjustments. The overhead allocation column is where most freelancers and small service businesses get pricing wrong — they calculate labor cost but forget to bake in software, insurance, accounting, and the unbillable hours spent on admin. This template adds the overhead back in before you set the number, not after you realize you underpriced.

Pairs with Markup Calculator, ROAS Calculator & CAC/LTV Calculator

05

Startup Cost Estimator

One-time startup costs (equipment, licenses, deposits, initial inventory, website build, legal/accounting setup, branding), recurring monthly costs (rent, payroll, software, insurance, utilities, marketing budget), total startup capital required (one-time + 3–6 months of recurring), personal living expenses during ramp-up period, total funding need, funding sources breakdown (savings, loan, investor, other), funding gap (need minus secured), months to break-even estimate, and a capital runway table showing how long your startup capital lasts at various revenue levels. The funding gap column is the honest number most business plans avoid — this template requires you to calculate it directly, and the months-to-break-even row tells you how long you need to survive before it closes.

Pairs with Break-Even Calculator & Business Cash Flow Calculator

06

Vendor Comparison Worksheet

Multi-vendor quote tracker: vendor name, unit price, minimum order quantity, effective price at your typical order volume, lead time (days), payment terms (net 30, prepay, etc.), quality rating (1–5 based on samples or history), reliability rating (1–5 based on on-time delivery history), risk notes (single-source risk, import tariff exposure, capacity limits), total cost of ownership per unit (unit price + shipping + payment terms cost of capital + quality reject rate × rework cost), and a recommendation score that weights price, quality, lead time, and risk according to priorities you set. The TCO column is what changes vendor decisions: the cheapest unit price vendor frequently has the highest total cost once shipping, lead time financing cost, and defect rate are accounted for. This worksheet makes that math explicit before you commit to a supplier relationship.

Pairs with Profit Margin Calculator & Markup Calculator

How to use it

Start with the P&L, build the forecast, then price like you actually know your numbers

1

Fill in last month's P&L first — the numbers will tell you where to look next

Pull your last 3 months of bank statements and your last invoice batch. Fill in the Monthly P&L Tracker starting with the most recent month. The gross margin row will tell you whether your pricing is fundamentally sound. The operating expense total will tell you whether your cost structure is the problem. The net margin will tell you whether the business is actually profitable at current volume. Most business owners find a different problem than the one they thought they had — and identifying the right problem is worth more than any single fix.

2

Build the 12-week cash flow forecast before the next big outflow hits

Take your P&L operating expenses and map them into the weekly cash outflow rows — some costs hit monthly (rent, payroll), some are quarterly (insurance, estimated taxes), some are irregular (inventory reorders, equipment repairs). Build out the inflow side using your average weekly collections from the P&L revenue row. The first forecast is rough; it gets sharper every week you update it. The burn rate and runway outputs will tell you whether you're running the business or whether the business is running you — and how much margin you have to course-correct before a cash crunch becomes a crisis.

3

Run the Break-Even and Pricing Calculator together to set prices you can actually defend

Your break-even analysis tells you the minimum revenue the business needs to survive. Your pricing calculator tells you whether your current prices generate enough contribution margin to hit that number at realistic volume. If you need 150 units/month to break even but your market supports 80 units at your current price, the answer is either raise the price or cut fixed costs — not work harder. Most pricing decisions made with only one of these tools are missing half the picture. Running them together closes that gap and gives you a number you can defend to yourself, to clients, and to a bank if you ever need a loan.

Small Business Profit Pack

Download all 6 templates — free, no email required

CSV files that work in Google Sheets, Excel, Numbers, or LibreOffice. Open, fill in your numbers, and finally know whether your business is actually profitable — not just busy.

💵 Monthly Profit & Loss Tracker CSV — revenue, COGS, gross margin, operating expenses, net margin ⚖ Break-Even Analysis CSV — fixed costs, contribution margin, break-even units, margin of safety 📈 12-Week Cash Flow Forecast CSV — weekly inflows, outflows, running balance, burn rate, runway 🏷 Pricing Calculator CSV — cost-plus, value-based, target margin back-calculation, price sensitivity 🚀 Startup Cost Estimator CSV — one-time costs, monthly burn, funding need, months to break-even 📋 Vendor Comparison Worksheet CSV — multi-vendor TCO, quality/reliability scores, recommendation score

Got the templates? Now get a second set of eyes.

Book a free 15-minute small business numbers audit using your actual P&L or cash flow

Fill in the Monthly P&L Tracker or Cash Flow Forecast with your real numbers, then bring it to a 15-minute call. We'll run through the margins with you, flag the cost lines worth cutting first, check whether your pricing covers your actual overhead, and tell you what the numbers say about the health of the business — no pitch, just the math.

Name Email What kind of business are you running? What's the problem you want to solve?

✓ No cost, no obligation ✓ Bring your actual numbers ✓ We run the math, you keep the worksheets

Stay sharp

New business templates, pricing benchmarks, and cash flow tools — monthly

We ship new calculators, spreadsheets, and business guides every month. Join the list and get them before anyone else. No spam, unsubscribe anytime.

Use these with the pack

Business calculators that pair with these templates

Run your numbers live in the calculator, then log the results in the spreadsheets.

View all business & marketing calculators

From the team at CareerKit Digital

A more profitable business starts with higher personal income

CareerKit Digital builds job-search and career-acceleration tools — resume templates, interview prep kits, LinkedIn profile optimizers, and income negotiation guides — so you can increase what you earn and bring more capital to your business, whether you're funding a side hustle from a day job or negotiating a higher rate before you go full-time on your own.

Browse CareerKit Digital on Etsy