dez-data/retail-bookkeeping-system

Excel-based inventory management and profit tracking system for small retail businesses and micro-enterprises in Africa # Retail Business Bookkeeping & Inventory System (Excel) A comprehensive Excel-based stock management and profit tracking system designed for small retail businesses, market vendors, and micro-enterprises in Africa. **View Live Demo (Google Sheets)** **Download Excel Template** --- ## The Problem This Solves Small businesses across Africa lose money daily because they don't track their numbers: **"I sold a lot today, but I don't know if I made profit"** **"I ran out of stock on my best-seller again"** **"I think I'm making money on phone cases, but I'm not sure"** **"I don't know what to reorder or how much"** **"Accounting software costs more than my monthly rent"** --- ## The Solution A **free, powerful Excel system** that tracks: Stock levels (real-time) Sales and revenue Purchase costs vs selling prices Profit per item and overall What to reorder and when **No expensive software. Just Excel.** --- ## Key Features & Screenshots ### 1. Stock Management & Inventory Tracking **What you see here:** - **Stock input section** (top): Record when you receive new inventory - **Current stock levels** (bottom): See what you have right now - **Automatic calculations**: System updates stock as you record sales **How it works:** ```excel Current Stock = Stock Received - Stock Sold Running Balance = Previous Stock + New Input - Sales ``` **Business impact:** - Never run out of best-sellers - See exactly what's in your store/warehouse - Know when to reorder before stockouts **Key columns:** - Date stock received - Product name - Quantity received - Purchase price (what YOU paid) - Current stock level (auto-calculated) --- ### 2. Sales Tracking & Revenue Recording **What you see here:** - Simple sales entry form - Every transaction recorded with date - Quantity sold per item - Selling price per transaction - Automatic revenue calculation **How it work …