Templates / Small Business Bookkeeping + Inventory
Small Business Bookkeeping Spreadsheet with Inventory & Balance Sheet
Simple bookkeeping for a small shop: money in and out, stock on hand, sales tax, a monthly P&L, and a balance sheet that checks itself.
$14
Buy on Ko-fi, $14Instant download: you get one .xlsx file. For Google Sheets, upload it to Google Drive and open it with Google Sheets. Digital item, so nothing is shipped. For use in your own business; please don't resell or share the file.
What's inside
- Business Dashboard: net revenue, gross profit and margin, operating expenses, net income, cash, inventory value, items to reorder, sales tax owed, plus charts
- Transactions: sales, refunds, expenses, stock purchases, equipment, owner contributions and draws, loans and sales tax payments, with a check column that flags missing categories or types
- Inventory + Stock Log: up to 200 products; units purchased, sold or adjusted; on-hand quantity, reorder alerts, value on hand and cost of goods sold
- Monthly P&L: revenue by category, refunds, cost of goods sold, gross profit, expenses by category and net income for every month
- Sales Tax: collected, refunded and remitted by month, with a running balance owed
- Balance Sheet: cash, inventory, equipment, loans, sales tax owed and equity, with a check that should read $0.00, plus an inventory check
- Editable income and expense categories
Good to know
- Works in Microsoft Excel, Google Sheets and LibreOffice. No macros.
- Cash-basis bookkeeping; equipment is shown at cost (no depreciation).
- Yellow cells are for typing; grey cells calculate.
This is a record-keeping tool, not tax or accounting advice.
Previews
Questions
How many products can the inventory track?
Up to 200 products, with reorder alerts and cost of goods sold.
Does it track sales tax?
Yes: collected, refunded and remitted by month, with a running balance owed.
Is it cash or accrual?
Cash basis. Equipment is shown at cost, with no depreciation.
Does it replace an accountant?
No. It's a record-keeping tool, not tax or accounting advice.