Ghana SME Workbook | Kunateh Impact

FREE TOOL · GHANA SME

Ghana SME Business Operating Workbook

A 7-tab Excel + Google Sheets workbook that gives a non-technical Ghana-based small business owner a real, working view of their daily sales, weekly trends, monthly P&L, cash flow, inventory, and a dashboard. Built for businesses like Twinnies Gallery — cash-heavy, WhatsApp-driven, no formal bookkeeping until now.

Pre-populated with sample data. Currency: ¸. Dates: DD/MM/YYYY.

EXCEL Download (.xlsx)

ghana-sme-workbook.xlsx · generated by scripts/build-sme-workbook.js
Open in Excel or LibreOffice. Mobile-friendly in Google Sheets mobile app.

⬇ Download Excel (.xlsx)

SHEETS Open in Google Sheets

Same 7 tabs, same formulas, same sample data. The live version — click File → Make a Copy to get your own editable workbook saved to your Drive.

Open Google Sheets ↗

What's Inside (7 tabs)

DAILY SALES LOG

Date + Product name + Category + Qty sold + Unit Price (auto from INVENTORY) + Total + Payment Method + Notes. Bottom TOTAL / AVG row.

WEEKLY SUMMARY

Auto-rollup from Daily. Per-week revenue by category, WoW % change, top category, Cash vs MoMo split + Top 5 products by revenue.

MONTHLY P&L

Revenue, COGS, Gross Profit & Margin, Operating Expenses, Net Profit & Net Margin, MoM comparison.

CASH FLOW TRACKER

Daily opening, cash in/out, auto closing balance. Closing turns RED when below Min Buffer.

INVENTORY

SKU, pricing, margin, opening / received / sold / closing stock, reorder qty suggestion, stock value.

DASHBOARD

5 KPI tiles, Top 20 Products, Top 5 best sellers, Inventory Health, three CHART DATA blocks for Insert → Chart in Sheets/Excel.

SETUP & INSTRUCTIONS

Plain-English guide for the owner. How to log a sale, how to add products, how to read the dashboard.

How To Use

Excel users

Click Download Excel (.xlsx) above and open the file in Excel or LibreOffice. Start logging sales on the DAILY SALES LOG tab. Inventory on the INVENTORY tab. Everything else auto-calculates.

Google Sheets users

Click Open Google Sheets → once the sheet loads, choose File → Make a Copy to get your own editable version saved to your Google Drive.

How to clear the sample data

On the DAILY SALES LOG and INVENTORY tabs, filter the Row Tag column to show rows tagged SAMPLE, select those rows, right-click, and delete. Repeat on every tab that has sample rows. Your rolls-up (Weekly, Monthly, Dashboard) reset to zero automatically.

Kunateh Impact — Tools