AnalystBuilt home Etsy shop

Bundles

Small Business Finance Complete

Inventory & COGS, pricing, invoices, bookkeeping and a cash flow forecast: five spreadsheets for one product business

Small Business Finance Complete: Inventory & COGS, pricing, invoices, books and cash flow
Inventory & COGS, pricing, invoices, books and cash flow
  • Small Business Finance Complete: Inventory & COGS, pricing, invoices, books and cash flow
  • Stock to cash, five tools: Count it, price it, bill it, book it, plan it
  • Know what's on your shelves: Stock value, days of stock, what to reorder, COGS % and dead stock
  • What to reorder, and how many: Suggested quantities that count open orders and your case size
  • Price from what you really paid: Materials, your time, overhead, fees and shipping, all covered
  • Know who owes you: Balance by age, today's follow-ups, top clients and invoice status
  • Books that tell you what to fix: Profit, year to date, what needs attention and your tax set-aside
  • Your cash, 12 months ahead: Cash now, year-end cash, the lowest point and early warnings

from $39 on Etsy

Price on Etsy may vary (sales, your currency).

View on Etsy
  • Google Sheets + Excel versions included
  • Instant digital download, nothing is shipped
  • Sample data and a Start Here tab
  • One-time purchase, no subscription

Works in Google Sheets (free Google account) and Microsoft Excel 2016 or newer.

Everything a product business needs to run its numbers, in five spreadsheets: what you have in stock and what it really cost, the price to charge, who still owes you, your books with a tax set-aside, and your cash for the next 12 months.

This is the complete set. It has the four templates of the Small Business Finance Starter plus the Inventory & COGS Tracker, for shops, makers and resellers who buy or make stock and sell it.

What's included

  • Inventory & COGS Tracker

    Stock on hand for up to 200 products, landed cost with shipping and duties shared across each order, a reorder list with suggested quantities, dead stock and overstock flags, and cost of goods sold month by month with a year-end inventory check. 10 tabs.

  • Pricing Calculator

    Your materials, time, overhead and selling fees turned into a recommended price per product, with break-even, wholesale vs retail and what you earn per hour. 8 tabs.

  • Invoice & Receivables Tracker

    Invoices, partial payments and clients in one log; a printable invoice, an AR aging report, reminder emails and a list of who to chase today. 8 tabs.

  • Small Business Bookkeeping

    Income and expenses by category with receipt checks, a monthly profit & loss, a quarterly tax set-aside and a one-page year summary. 8 tabs.

  • Cash Flow Forecast & P&L

    A 12-month forecast that turns into actuals as the year goes, with the lowest cash point, early warnings, margins and best / base / worst cases. 8 tabs.

Why you'll like it

  • Stock to cash in one routine: count it → price it → bill it → book it → plan it
  • The Inventory tracker shows the landed cost of every unit, so you price from what you really paid, not the supplier list price
  • The same cream-cell / gray-cell rule in every file: learn it once
  • Every file shows what needs your attention first, and comes with sample data you can clear in minutes
  • Any currency. Made by a data analyst: every number is a formula you can trace. No subscription, no app

How you get it

  1. Download on Etsy

    Buy the set on Etsy, then download START-HERE.pdf and the Excel .zip from your Purchases.

    How to download

  2. Make a copy

    Click each MAKE A COPY button in the PDF, one per spreadsheet: your copies are saved to your Google Drive. Prefer Excel? Open the .xlsx files.

    How to make your copy

  3. Start

    Follow the Start Here tab. Type in the cream cells; the gray cells do the math for you.

    Clearing the sample data

You receive:

  • START-HERE.pdf — Google Sheets links + quick guide
  • small-business-finance-complete-excel.zip — Excel versions, one folder per template

Good to know

  • Five separate files that each work on their own; nothing is linked between them. Once a month you copy a few totals across (for example, Bookkeeping's monthly category totals into Cash Flow Forecast), and START-HERE.pdf shows which.
  • Already own the four-file Small Business Finance Starter? Get the Inventory & COGS Tracker on its own instead.
  • Selling fees in the Pricing Calculator are sample numbers: type your own.
  • Amounts exclude any sales tax or VAT you collect.
  • Best on a computer; the Google Sheets phone app is fine for checking numbers.
  • For use in one business. Please do not resell or share the files.

Record-keeping and planning tools, not accounting, tax or financial advice.

Designed by me with the help of AI tools.

View Small Business Finance Complete on Etsy

Templates in this set

More in Bundles