₦7,500 ₦4,500
Excel (.xlsx) workbook and Word (.docx) guide, 2 files
- Instant download after payment
- Download link sent to your email
- Edit and reuse for your business
Look inside the pack
Real pages from the files you download. Tap an image to view it larger.
Do you know your profit for last month? Not sales, profit. This Excel workbook turns the notebook most traders keep into a simple system: record sales, restock and expenses as they happen, and the workbook tells you your stock balance, what to reorder, who owes you, and your real profit every month.
What you can see at a glance
- Stock left for every product, its value at cost, and a “Reorder” flag when it runs low
- Profit on every sale, using your cost price
- Monthly sales, gross profit, expenses and net profit for the year
- Customers with overdue credit balances
- Unpaid supplier invoices
Who it is for
Provision stores, supermarkets, boutiques, pharmacies, building materials shops, phone accessory sellers and online sellers on Instagram or WhatsApp. It works with up to 200 products and 300 entries per sheet, and you can extend it.
What is included
- Products and stock sheet with automatic stock balance, stock value and reorder alerts
- Sales record with automatic profit per sale
- Restock (purchases) record with supplier balances
- Expenses record with ready categories
- Debtors (credit customers) tracker with overdue flags
- Monthly profit report for the whole year and a business snapshot
- Plain-English bookkeeping guide for small businesses
How to use the Small Business Bookkeeping & Inventory Workbook (Excel)
- List your products with cost price, selling price and opening stock.
- Record every sale, restock and expense as it happens.
- Check the Products sheet for "Reorder" alerts and the Debtors sheet for overdue customers.
- Open the Report sheet at month end to see your sales, expenses and net profit.
Why not just use a free template?
Free templates usually track either stock or money, not both. This workbook links them, so every sale reduces stock and adds profit, every restock adds stock, and the monthly report pulls everything together without manual adding.
Questions
Do I need to know Excel?
No. You only type into yellow cells. Everything else calculates automatically, and the Start here sheet explains each step.
Can I use it on my phone?
Yes, it opens in Excel or Google Sheets on Android and iPhone. Daily entries are easy on a phone; reports read best on a laptop.
How many products can I track?
Up to 200 products and 300 entries per sheet out of the box. Copy the last row down to add more.
How do I get the files?
Right after payment you see download buttons on this page, and we email you a download link that works for 60 days.
Can I edit the templates?
Yes. They are normal Word and Excel files. Add your logo, business details and change anything you need.
Is this legal advice?
No. These are general templates for Nigerian businesses. For important or unusual matters, have a lawyer or accountant review your final documents. Book a consultation if you want us to help.
I paid but did not get my files.
Check your spam folder first, then message us on WhatsApp with your payment email.
General templates for information and convenience, not legal, tax or accounting advice.
Customers also buy
Nigeria Payroll & PAYE Calculator for 2027 (Excel)
Run your 2027 payroll on the new tax law: Excel payroll for up to 50 staff with PAYE bands, rent relief, pension, NHF, printable payslips and a monthly remittance summary.
₦4,500
View packPOS Agent Business Record Book (Excel + Printable)
Track every POS transaction, daily cash and wallet balance, shortages and monthly profit. Includes printable daily sheets, cash count and reversal forms.
₦3,000
View packBusiness Plan and Loan Proposal Pack
A guided business plan template, 3-year financial projections workbook, loan application letter and one-page pitch summary for Nigerian businesses.
₦5,000
View pack

