Every small business owner reaches a point where they realise their finances are all over the place. Money is coming in, money is going out, and somewhere in between, the picture gets blurry.
A good bookkeeping template fixes that. It gives your finances structure, so you always know exactly where things stand.
This post gives you a free small business bookkeeping template you can start using today. No download needed. No sign-up wall. Just a practical, ready-to-use structure you can copy into a spreadsheet, a notebook, or a bookkeeping app like Monesize.
Bookmark this page. You will want to come back to it.
What a Good Small Business Bookkeeping Template Should Cover
Before we get into the actual template, let us talk about what it needs to include. A lot of business owners make the mistake of only tracking income and expenses, and then wondering why they still feel financially confused.
A complete small business bookkeeping template covers five core areas:
- Income tracking
- Expense tracking
- Inventory management
- Profit and loss summary
- Monthly review checklist
Each of these pieces works together. Skip one and you get an incomplete picture. Use all five consistently and you will always know the true financial state of your business.
Section 1: Income Tracker
Use this template to record every naira your business earns. Update it every time money comes in.
| Date | Description | Payment Method | Category | Amount (₦) |
|---|---|---|---|---|
| e.g. 01/03/2026 | Sale of 3 ankara fabrics | Bank transfer | Product sales | 15,000 |
| Total Income |
How to use this section:
Record every sale the same day it happens. In the description column, write a short note about what was sold or what the payment was for. The payment method column helps you track whether money came in through cash, transfer, POS, or any other channel. The category column lets you separate different income streams, for example product sales, service fees, delivery charges, or wholesale orders.
At the end of each month, add up your total income column. That figure is your gross revenue for the month.
Section 2: Expense Tracker
This is where most businesses leak money without realising it. Track every expense here, including the ones that feel too small to bother with.
| Date | Description | Vendor/Supplier | Payment Method | Category | Amount (₦) |
|---|---|---|---|---|---|
| e.g. 02/03/2026 | Restock of body creams | Ade Cosmetics | Cash | Stock purchase | 40,000 |
| Total Expenses |
Suggested expense categories for Nigerian small businesses:
- Stock purchase / restocking
- Rent and utilities
- Logistics and delivery
- Marketing and advertising
- Airtime and data
- Salaries and wages
- Equipment and supplies
- Bank charges and transfer fees
- Miscellaneous
How to use this section:
Log every expense as soon as you make it. Do not rely on memory. The vendor column is useful when you need to review what you have spent with a specific supplier. Categories help you spot which areas of your business cost the most, which often surprises people.
At the end of the month, total your expenses column. That figure is your total cost of running the business for that period.
Section 3: Inventory Tracker
If you sell physical products, inventory is money sitting on your shelf. You need to know exactly what you have, what it cost you, and how fast it moves.
| Product Name | Opening Stock (Units) | Units Purchased | Units Sold | Closing Stock (Units) | Unit Cost (₦) | Total Stock Value (₦) |
|---|---|---|---|---|---|---|
| e.g. Body cream 200ml | 20 | 30 | 35 | 15 | 2,500 | 37,500 |
| Total Value |
How to use this section:
Update your inventory tracker every time you restock or make a sale. The closing stock column tells you what you have left at the end of each week or month. The total stock value column (closing stock multiplied by unit cost) tells you how much money is tied up in unsold goods.
If a product keeps showing a high closing stock number, it is a slow mover. If a product sells out quickly, you want to make sure you always have enough of it.
Section 4: Monthly Profit and Loss Summary
This is the most important part of your small business bookkeeping template. It pulls everything together and shows you whether your business actually made money.
| Amount (₦) | |
|---|---|
| Total Income (from Section 1) | |
| Total Expenses (from Section 2) | |
| Net Profit / Loss | |
| Profit Margin (%) | Net Profit divided by Total Income, multiplied by 100 |
How to read this summary:
If your net profit is a positive number, your business made money. If it is negative, your expenses exceeded your income and your business ran at a loss for that month.
Your profit margin percentage tells you how efficiently your business converts revenue into profit. For example, if you made 200,000 naira in revenue and your net profit was 60,000 naira, your profit margin is 30 percent. That means for every 100 naira you earn, you keep 30 naira after expenses.
Tracking this monthly helps you spot trends. If your profit margin drops two months in a row, something changed and your books will help you find out what.
Section 5: Monthly Review Checklist
Most business owners record transactions but never sit down to actually review them. This checklist makes sure you close out every month properly.
End of Month Bookkeeping Checklist:
- All income transactions recorded and categorised
- All expenses recorded and categorised, including small cash payments
- Inventory updated with new purchases and sales
- Bank statement checked and reconciled with records
- Monthly profit and loss summary completed
- Profit margin calculated and noted
- Slowest and fastest selling products identified
- Biggest expense categories reviewed
- Any unusual or unexpected transactions investigated
- Notes written on anything that needs attention next month
How to run your monthly review:
Pick a fixed date every month, the last Friday of the month works well for many business owners. Block out one hour. Go through the checklist above. Write a short note (even two or three sentences) summarising how the month went financially. Then carry any outstanding issues into your plan for the following month.
This review is where your bookkeeping stops being a chore and starts being a tool. The data you collected all month finally tells you something useful.
Bonus: Weekly Cash Flow Snapshot
Beyond the monthly view, a quick weekly snapshot helps you stay on top of cash flow in real time. Cash flow is simply whether you have enough money coming in to cover what is going out.
| Week | Opening Balance (₦) | Total Income (₦) | Total Expenses (₦) | Closing Balance (₦) |
|---|---|---|---|---|
| Week 1 | ||||
| Week 2 | ||||
| Week 3 | ||||
| Week 4 | ||||
| Monthly Total |
Your closing balance each week becomes your opening balance the following week. If you notice your closing balance trending downward week after week, your expenses are growing faster than your income. That is a signal to act, not to panic, but to act.
ALSO READ: Small Business Bookkeeping in Nigeria: The Ultimate 2026 Starter Guide
How to Transfer This Template to a Spreadsheet
If you want to use this in Google Sheets or Excel, here is how to set it up quickly:
Create a new spreadsheet and add five tabs at the bottom, one for each section above. Label them Income, Expenses, Inventory, Profit and Loss, and Monthly Review. Copy the column headers from each section into the corresponding tab. Add a new row for each transaction as it happens.
For the Profit and Loss tab, use a simple formula that pulls the totals from your Income and Expenses tabs automatically. In Google Sheets, this looks like pulling the sum from your income sheet and subtracting the sum from your expenses sheet. Your net profit updates itself every time you add a new transaction.
Or Skip the Spreadsheet Entirely with Monesize
Building and maintaining a spreadsheet takes time. Formulas break. Files get corrupted. Phones get lost. And none of it gives you real-time reports without extra work.
Monesize gives you everything in this template built directly into an app, designed specifically for Nigerian small business owners. You log your income and expenses, Monesize handles the tracking, the categorisation, and the reports automatically.
You get:
- A live income and expense tracker
- Inventory and sales management
- Automatic profit and loss calculation
- Monthly financial summaries without lifting a finger
- Everything accessible from your phone, anytime
You do not have to build the system yourself. Monesize is the system.
🚀 Start free on Monesize today and bring this entire template to life without a single spreadsheet.
Final Thoughts
A small business bookkeeping template is only as useful as the consistency you bring to it. The structure is here. The categories are here. The monthly review checklist is here.
Your job now is to pick it up and use it, every week, every month, without skipping.
Business owners who stay close to their numbers build businesses that last. And you now have everything you need to be one of them.