Lifehampers Global Consults

  1. Home
  2. Blog
  3. Business Templates & Guides
Business Templates & Guides

Record Keeping for Small Businesses in Nigeria: Sales, Stock and Profit in One Excel Sheet

LGLifehampers TeamBusiness and digital consultants, IbadanUpdated 3 min read
Record Keeping for Small Businesses in Nigeria: Sales, Stock and Profit in One Excel Sheet

Record Keeping for Small Businesses in Nigeria: Sales, Stock and Profit in One Excel Sheet

Small Business Bookkeeping & Inventory Workbook (Excel) template pack cover

Ask most traders how much they sold last month and they can tell you. Ask how much profit they made and many cannot. Without records, stock disappears, credit customers forget, and the business looks busy while money leaks out. This guide shows the simple record-keeping system that fixes it, in about five minutes a day.

Quick answer: keep five records: sales, purchases (restock), expenses, stock and debtors. Profit is sales minus the cost of the goods sold, minus running expenses. An Excel workbook that links these records gives you stock balance, reorder alerts and monthly profit automatically.

Start today with the Bookkeeping & Inventory Workbook

One Excel file for up to 200 products: sales with profit per sale, restock, expenses, debtors, stock balance with reorder alerts, and a monthly profit report for the whole year. Plus a plain-English bookkeeping guide.

Get the template pack for ₦4,500   See what is inside (usually ₦7,500)

The five records every small business needs

RecordWhat to write downWhy it matters
SalesDate, product, quantity, price, how they paidReal daily takings and best-selling items
Purchases (restock)Supplier, product, quantity, unit cost, paid or owedCost of goods and what you owe suppliers
ExpensesRent, salaries, fuel, transport, data, chargesFind where money leaks
StockOpening stock, bought, sold, balanceAvoid running out and spot missing goods
DebtorsCustomer, amount owed, paid, due dateCollect credit before it is forgotten

How to work out your real profit

Gross profit = sales minus what those goods cost you. Net profit = gross profit minus running expenses. Example from the workbook’s sample month: sales ₦672,400, cost of goods ₦603,000, gross profit ₦69,400, expenses ₦57,500, net profit ₦11,900. Busy shop, thin profit: exactly the kind of thing records reveal. Check your pricing with the free profit margin calculator.

A 5-minute daily routine

  1. Record each sale as it happens, or from your receipt book at closing.
  2. Record any goods bought and any expense paid today.
  3. Check the reorder list for items running low.
  4. Once a week, count a few products and compare with the stock balance.
  5. At month end, read the profit report and chase overdue debtors.

Common record-keeping mistakes

  • Mixing personal and business money. Record personal withdrawals as owner drawings.
  • Not recording damaged or expired goods, so stock looks higher than it is.
  • Giving new credit to customers who have not paid old balances.
  • Only tracking sales, not the cost of goods, so profit is overstated.

Excel workbook or inventory software?

A well-built Excel workbook is enough for most shops with one location and up to a few hundred products. If you have several branches, barcode scanning or many staff selling, consider inventory management software. For customer invoices, use the free invoice generator.

Know your profit every month

Type only into the yellow cells: products, sales, restock and expenses. The workbook does the stock balance, profit per sale, debtors and monthly report for you. Works in Excel and Google Sheets, on laptop or phone.

Get the template pack for ₦4,500   See what is inside (usually ₦7,500)

Frequently Asked Questions

What records should a small business keep in Nigeria?

At minimum: sales, purchases, expenses, stock and debtors, plus bank statements and receipts. These records also support loan applications and tax filing.

Can I keep business records on my phone?

Yes. An Excel or Google Sheets workbook works on Android and iPhone for daily entries; read the reports on a laptop when you can.

How do I calculate profit for my shop?

Sales minus the cost of the goods you sold gives gross profit. Subtract running expenses such as rent, salaries and fuel to get net profit.

Do small businesses need records for tax?

Yes. Even if your business qualifies as a small company with low or no tax under the Nigeria Tax Act 2025, you need records to prove your turnover.

Is there a ready Excel bookkeeping and inventory template for Nigeria?

Yes. The Lifehampers Small Business Bookkeeping & Inventory Workbook tracks sales, stock, expenses, debtors and monthly profit, with instant download.

General information, not accounting or tax advice.

Share this guide

Leave a Comment

Your email address will not be published. Required fields are marked *

Talk to an expert

Need help with Business Templates & Guides?

Book a free consultation and get clear, practical next steps for your business.

Scroll to Top