Small Business Bookkeeping Planner Spreadsheet for Google Sheets and Excel

PRICING CALCULATOR AND BOOKKEEPING SPREADSHEET FOR GOOGLE SHEETS AND EXCEL

A bookkeeping and pricing calculator spreadsheet for makers and small sellers who sell on Etsy, their own site, at markets or wholesale. It works out what each product truly costs, the price that pays your time, and what the business kept after every fee.
Covers sales, expenses, invoices, mileage, and the Schedule C and estimated tax lines for a US small business.

📊 WHAT IT DOES

✓ Pricing: builds a price from materials, packaging, your minutes and the channel's fee, and shows the price for your margin.
✓ Product profit: shows what each product brought in, what it cost, and what an hour spent making it paid, over the last twelve months.
✓ Channels: shows where sales came from and how much of every dollar reached you after each channel's fee.
✓ Invoices: tracks what is waiting to be paid, what is late, and how many days it takes a client to pay.
✓ Hourly rate: divides profit by the hours on Time, month by month, next to the rate you price at.
✓ Break even: shows how many pieces a month cover your fixed costs, and how many also pay you.
✓ Profit & loss: twelve months of what came in, what channels and costs took, and what was left.
✓ Schedule C: lays out this year's numbers the way the tax form asks for them.
✓ Estimated tax: works out what each quarterly payment should be and what is still due.

📂 WHAT'S INSIDE: 30 TABS AND 76 CHARTS

✓ Start with these: Home, Start here, Setup, Products
✓ Every week: Sales, Expenses, Invoices, Time, Mileage
✓ Price and profit: Pricing, Product profit, Channels, Hourly rate, Break even, Fixed costs
✓ The books: This month, Quarter, Profit & loss, Cash flow, Accounts, Owner pay
✓ Tax: Schedule C, Estimated tax, Sales tax
✓ Routine and help: Goals, Check-in, Catch-up, Notes, Read me, Free gift

📝 HOW IT WORKS

1. Open the PDF and click the link to make your own copy in Google Sheets. Or open the Excel file.
2. On Start here, fill in the shaded cells. Add your hourly rate, how much to set aside for tax, your mileage rate and the margin you price for.
3. Add your products on Products, log each sale on Sales and each receipt on Expenses as you go.
4. Everything else fills in by itself. Home shows what sold this month, profit this year, what an hour really paid and what invoices are waiting.

📥 WHAT YOU GET

✓ Google Sheets version (the link is in the PDF)
✓ Excel version (.xlsx) for desktop Excel on Windows or Mac
✓ Two color themes, Dark and Serene, each with a filled example and a blank copy
✓ A PDF with the links and the first steps
✓ A video guide for this planner (the link is in the PDF)

💻 GOOD TO KNOW

✓ Works with a free Google account. No add-ons, no subscription, no bank connection.
✓ Type only in the shaded cells. Formulas are protected, so you can't break them by accident.
✓ Best on a computer. The Google Sheets app works for quick entries on your phone.
✓ Amounts show in dollars. The formulas work the same in any currency.
✓ The Excel version may look slightly different from the photos (fonts, colors, charts). The photos show Google Sheets.
✓ English only. Not made for Apple Numbers.
✓ Free updates for life.

This is a digital download. Nothing will be shipped. Because it is a digital file, it can't be returned, but if anything is unclear, message me and I will help you set it up.
This planner is a tool for your own records, not financial advice.