Free Small Business Bookkeeping Planner

What this planner helps you track

• •Sales and payouts, one row per order, across every platform you sell on
• •Business expenses by category, so you can see where the money actually goes
• •Platform fees, listing fees, and payment processing fees month by month
• •Product costs and cost of goods sold per item
• •Marketing and ads spend, kept separate from product cost
• •Refunds, recorded once so they never distort your profit twice
• •Net profit and profit margin per month and for the year
• •A tax set-aside estimate based on one percentage you set yourself

What is included

Three files, all free and all ungated: the Excel workbook, a CSV pack for people who prefer plain files, and a blank printable monthly review page.

• •Start Here tab with plain-language instructions
• •Setup tab for your business name, year, goals, and editable category lists
• •Income Tracker with 500 pre-formatted rows
• •Expense Tracker with 500 pre-formatted rows
• •Platform Fees Tracker (detail tab, excluded from totals on purpose)
• •Product Costs & COGS tracker (detail tab)
• •Marketing & Ads Tracker (detail tab)
• •Tax Set-Aside Planner with one column for what you actually set aside
• •Monthly Summary with automatic totals
• •Dashboard with five simple charts
• •Yearly Summary with an at-a-glance block
• •Printable Monthly Review — one page, ready to print or save as a PDF
• •Ten sample rows showing what goes where, ready to delete

Who it is for

• •Etsy and handmade sellers seeing fees against real profit for the first time
• •eBay and vintage resellers juggling per-item costs
• •Shopify store owners separating ad spend from product cost
• •Amazon FBA sellers who want a simple view alongside their reports
• •KDP authors logging monthly royalty payouts
• •Print-on-demand sellers whose costs sit inside each order
• •Craft fair and market sellers combining cash and card takings
• •Freelancers and side hustlers who just want to know what to set aside

How to use it each week

• •Add each sale to the Income Tracker — one row per order or payout.
• •Add every business expense to the Expense Tracker — one row per purchase.
• •Record refunds once: either on the original order row, or as an expense row categorised Refunds. Never both.
• •Drop receipts into a folder named for the month.

How to use it each month

• •Check that everything for the month has been entered.
• •Compare your rows against your platform payouts and your bank or card statement.
• •Review the Dashboard and the Monthly Summary.
• •Fill in Amount Actually Set Aside on the Tax Set-Aside Planner.
• •Pick the month on the Printable Monthly Review, answer the three questions, then print or save it.

Related Guides

• Planning guideBusiness Planning

  How To Create A Small Business Budget: Complete Budgeting Guide (2026)

  Build a complete small business budget — revenue planning, expense forecasting, cash reserves, taxes, owner pay, growth and marketing budgets, with sample budgets for Etsy, eBay, KDP, Shopify, and FBA.

  Read guide →Profit Margin Calculator →
• Profit guideBusiness Planning

  Business Cash Flow Explained

  A plain-English cash flow guide for small sellers — cash vs profit, the three categories, why profitable businesses fail, and platform-specific payout timing.

  Read guide →Break-Even Calculator →
• Profit guideBusiness Planning

  How To Calculate Handmade Business Profit

  Work out what your handmade business actually keeps after materials, labor, packaging, shipping, fees, and taxes.

  Read guide →Handmade Pricing Calculator →

Related Calculators

• CalculatorBusiness Days CalculatorCount business days, workdays, and weekdays between two dates, excluding weekends.Open calculator →
• CalculatorBusiness Runway CalculatorHow many months your cash lasts at current burn.Open calculator →

Help Me Decide

• Decision GuideBusiness PlanningShould You Scale or Stay Small?Scaling sounds like the obvious goal, but staying small can be more profitable per hour. Use this framework to choose deliberately instead of by default.Read decision →

Troubleshooting

• TroubleshootingBusiness PlanningWhy Is My Profit Lower Than Expected?Revenue is up, but profit isn't. The gap is almost always one of five hidden leaks — fees, returns, shipping, COGS drift, or unpaid owner time. Find which one is eating you.Fix the issue →

Recommended Downloads

• ResourceWorkbookBusiness PlanningBusiness Money Checkup & Action WorkbookA printable workbook for a manual cash snapshot: review your reserves, plan receipts and bills for the next 30 days, follow a worked example, choose three actions and come back for a follow-up review.Open resource →
• ResourceWorkbookBusiness PlanningMonthly Business Review WorkbookA printable monthly business review workbook with a monthly dashboard, revenue and expense reviews, profit and marketing analysis, product performance, reflection on wins and lessons, goal progress, next-month action planning, a 12-month annual tracker and a quarterly review. Compare consistent records and use what you learn to choose your next priorities.Open resource →
• ResourcePlannerBusiness PlanningSmall Business Budget PlannerA printable, fill-in-by-hand workbook for monthly business budgeting: revenue planning and tracking, fixed and variable expenses, marketing and subscription costs, tax and savings reserve planning, projected business profit, monthly budget-versus-actual reviews, an annual summary and next steps. Reserve transfers are kept separate from profit as allocations, not extra expenses.Open resource →

Continue Learning

• CourseBusiness Math Basics for Online SellersA five-lesson starter course covering the only five numbers every online seller actually needs to track — revenue, margin, break-even, ROI, and cash flow.Open course →