Inventory & Sales Management System — Google Sheets Template for Small Businesses (GH₵)

Stop guessing whether your business is actually making money.If you're running your shop from a notebook, your phone gallery and your memory, you already know the feeling: stock runs out without warning, customers owe you money you can't fully account for, and at the end of the month you honestly can't say what your profit was.This is a complete Inventory & Sales Management System built in Google Sheets. It does the maths for you. You type in a sale — the system pulls the price, works out the cost, the profit, the balance the customer still owes, and updates your stock automatically.What's inside — 10 connected sheetsDashboard — 12 live figures at a glance: sales today, sales this month, gross profit, net profit, total expenses, inventory value, outstanding payments, low stock and out of stock counts, plus 6 charts.Products — your full catalogue with cost price, selling price, profit per unit and profit margin calculated for you.Inventory — live stock levels with automatic Low Stock and Out of Stock warnings so you reorder before you run out.Sales — the engine. Pick a product from a dropdown and the price, cost, profit and balance due fill themselves in.Customers — who buys from you, how much they've spent, and exactly who still owes you.Expenses — rent, transport, data, packaging, advertising and more, all feeding into your net profit.Suppliers — contacts, what you buy from them, and what you still owe.Reports — best sellers, slow movers, sales by category, sales by payment method, monthly performance.Settings — change your currency, product categories, payment methods, expense categories and stock alert levels without touching a single formula.Quick Start — a plain-English page that gets you running in about 10 minutes.Why business owners like itFully automatic. Over 40 built-in formulas. No accounting knowledge needed.Formulas are locked. Only the yellow cells accept typing, so you can't accidentally break the system.Built for Ghana. GH₵ currency and Mobile Money, Cash, Bank Transfer, Card and Credit / Pay Later payment options, all editable if you sell elsewhere.Works on your phone. Google Sheets is free, and the system runs in the Google Sheets mobile app so you can record a sale from behind the counter.Yours forever. One payment, unlimited use, no monthly subscription.Perfect for boutiques and fashion sellers, beauty and cosmetics vendors, phone and electronics shops, provision stores, food and drinks businesses, online sellers and anyone selling on Instagram, TikTok or WhatsApp.What you getThe full template (.xlsx) ready to upload to Google SheetsA step-by-step setup guideInstructions for locking your formulas in Google SheetsHow to use itDownload the file.Upload it to your Google Drive.Open it and click File → Save as Google Sheets.Enter your products, then start recording sales.No software to install. No monthly fee. Just open it and go.