A shop owner sells ₦80,000 worth of goods in one day and feels pleased with the result. But after buying replacement stock, paying for transport, covering electricity costs and settling other bills, very little money remains.
Where did the money go?
This is a common problem for small businesses. Sales can look impressive while the actual profit remains unclear. Without reliable records, a business owner may struggle to know which products perform well, which customers still owe money or whether the business can afford to expand.
The answer is not necessarily expensive accounting software or complicated spreadsheets. A small business can begin with a simple system that records money coming in, money going out, stock purchases and outstanding payments.
This guide explains how Nigerian entrepreneurs can build that system using a notebook, spreadsheet or basic accounting app.
Why Good Business Records Matter
Business records are more than a list of daily sales. They help you understand what is happening inside the business and make decisions based on evidence rather than guesswork.
A 2025 policy brief from the International Growth Centre examined digital record-keeping among small firms in Nigeria. It reported that adopting digital records helped participating businesses recall their profits more accurately. The brief also found that personalised support helped firms begin using digital record-keeping more effectively than basic information alone.
The practical lesson is simple: choosing a tool is only part of the job. You also need a routine for using it consistently.
Accurate records can help you:
Estimate whether the business is making a profit.
Identify products that sell well and products that remain unsold.
Track unpaid customer balances and outstanding supplier bills.
Plan purchases without tying up too much money in stock.
Understand how much cash is available for daily operations.
Prepare more organised information for an accountant or other professional when needed.
Records do not guarantee business success, but they make it easier to recognise problems before they grow.
1. Separate Business Money from Personal Money
One of the first improvements an entrepreneur can make is to separate business transactions from personal spending.
Suppose you sell clothes and receive ₦150,000 from customers. You use ₦90,000 to replace stock, spend ₦15,000 on transport and withdraw ₦20,000 for personal needs.
If you simply look at the money left in your account, you may not know how much is available for future stock purchases or whether the business performed well.
Instead, record each transaction under the appropriate category.
Where practical, use a dedicated business bank account or a separate payment account. If that is not possible immediately, maintain a clear record of business transactions and personal withdrawals.
Money taken from the business for personal use should be recorded as an owner's withdrawal or another appropriate category, not automatically treated as a business operating expense.
This distinction helps you understand the cost of running the business separately from the money you take out of it.
2. Record Every Sale, Not Just Cash Sales
Your records should capture sales regardless of how the customer pays.
A sale might be paid for through cash, bank transfer, a card payment, a payment link or another method. If you record only cash sales, your business figures will be incomplete.
Create a simple sales record with these columns:
| Date | Order or receipt number | Item or service | Amount | Payment method | Status |
|---|
| 30 Oct | ORD-001 | Office bag | ₦25,000 | Transfer | Paid |
| 30 Oct | ORD-002 | Phone accessory | ₦8,000 | Cash | Paid |
| 30 Oct | ORD-003 | Design service | ₦15,000 | Transfer | Awaiting payment |
These are illustrative examples, not actual transactions.
The payment status matters. A sale made on credit may count as revenue under an appropriate accounting method, but the money has not necessarily reached your account. Keep unpaid sales separate from money actually received.
At the end of each day, compare your records with the payments received. Investigate any differences rather than changing the figures simply to make them match.
3. Track Expenses, Including the Small Ones
Business owners often remember large purchases but overlook smaller expenses that accumulate over time.
Transport, packaging, delivery, data, repairs, transaction fees and other operating costs can reduce the money available to the business.
Record each expense when it happens. Include the date, amount, category, purpose and payment method. Keep receipts, invoices or other supporting evidence where available.
For example:
| Date | Expense | Category | Amount |
|---|
| 30 Oct | Delivery to customer | Delivery | ₦3,000 |
| 30 Oct | Mobile data | Communications | ₦2,500 |
| 30 Oct | Packaging materials | Supplies | ₦4,000 |
These amounts are examples only.
Do not record an expense twice simply because you entered it in a notebook and later added it to a spreadsheet. Choose one main record-keeping system and use receipts or other documents as supporting evidence.
For larger purchases, such as equipment, accounting treatment may differ from that of ordinary day-to-day expenses. If you are unsure how to classify a transaction, seek advice from a qualified accounting professional.
4. Understand the Difference Between Sales, Profit and Cash Flow
These three terms are related, but they do not mean the same thing.
Sales are the amounts earned from selling products or services.
Profit is what remains after the relevant costs and expenses have been accounted for.
Cash flow concerns the movement of money into and out of the business.
Consider this simplified example.
A business sells products for ₦200,000 during a period. The cost of the products sold is ₦120,000, and operating expenses are ₦35,000.
The simplified calculation is:
| Item | Amount |
|---|
| Sales revenue | ₦200,000 |
| Cost of goods sold | ₦120,000 |
| Gross profit | ₦80,000 |
| Operating expenses | ₦35,000 |
| Profit before other applicable costs and taxes | ₦45,000 |
In this illustration, gross profit is sales revenue minus the cost of goods sold. The simplified operating profit figure is then calculated after subtracting the stated operating expenses. Actual accounting results depend on the transactions and accounting method involved.
Now imagine that some customers have not paid yet, or that the business has already paid a supplier for stock it has not sold. The cash available may differ from the profit shown by the calculation.
That is why a business should track both its financial performance and its actual cash position.
Important: Money in the bank is not automatically profit, and a profitable business can still experience cash shortages.
5. Keep an Eye on Stock and Unsold Products
For retailers, stock represents money tied up in goods that have not yet been sold.
Without stock records, you may order products you already have, overlook popular items or discover too late that something has run out.
Maintain a basic stock sheet with these details:
Product name or stock code.
Quantity at the start of the period.
Quantity purchased.
Quantity sold.
Damaged, missing or returned units.
Quantity remaining.
For example, if you start with 20 phone chargers, purchase another 10 and sell 12, you would expect 18 to remain before accounting for any returns, damage or discrepancies.
Compare the expected quantity with the actual stock periodically. Investigate differences to find out whether they result from recording mistakes, damaged goods, unrecorded sales or another cause.
You do not need a sophisticated inventory system when you are just starting. A simple spreadsheet or notebook may be enough, provided you update it consistently.
Service businesses can adapt the same idea by tracking billable hours, unfinished jobs, customer deposits or materials used for each project.
6. Track Money Customers Owe You
Selling on credit can help attract customers, but it can also create cash-flow problems when payments are delayed.
Maintain a record of every outstanding customer balance. Include the customer or invoice reference, original amount, amount paid, balance remaining and agreed payment date.
For example:
| Invoice | Original amount | Paid | Outstanding |
|---|
| INV-101 | ₦40,000 | ₦25,000 | ₦15,000 |
| INV-102 | ₦18,000 | ₦0 | ₦18,000 |
These are illustrative figures.
Review unpaid invoices regularly and send polite reminders when payments are due. Keep the communication professional and record any agreed changes to the payment schedule.
You should also track money your business owes suppliers. Knowing both sides of the picture helps you avoid promising payments you cannot yet make.
7. Choose a Record-Keeping Tool That Fits Your Business
There is no single tool that every small business must use. The best starting point is one you can maintain reliably.
Option A: A notebook
A notebook can work for a very small operation with few daily transactions.
Use separate sections for sales, expenses, customer debts and stock. Write entries clearly, date them and keep supporting receipts organised.
The main weakness is that totals and reports require more manual work, and physical records can be lost or damaged. Review and back up the information where possible.
Option B: A spreadsheet
A spreadsheet can organise transactions into columns, calculate totals and help you filter records by date or category.
Google Sheets, for example, supports spreadsheets that can be edited and shared with appropriate access controls. It also provides templates that can help users get started.
A basic workbook could contain four tabs:
Sales: date, invoice number, customer reference, amount and payment status.
Expenses: date, category, amount, payment method and notes.
Stock: product, opening quantity, purchases, sales and closing quantity.
Summary: total sales, expenses, outstanding payments and other figures you review regularly.
Protect access to the spreadsheet, avoid sharing sensitive financial information publicly, and keep a backup. If internet access is unreliable, plan how you will record transactions when offline and update the main record later.
Option C: Accounting software
Accounting software may be useful when you need invoices, customer balances, expense tracking and financial reports in one place.
For example, Zoho Books offers accounting features such as invoicing, expense recording and financial reporting. Its available features, limits and prices depend on the current plan and applicable terms.
Before choosing any app, check whether its features suit your business, whether the costs are affordable, how you can export your records and how the service protects your data.
You do not have to pay for software simply because your competitors use it. Start with the simplest reliable system that meets your needs, then upgrade when manual work becomes difficult to manage.
8. Build a Daily and Weekly Record-Keeping Routine
A system only works if you use it. Instead of waiting until the end of the month to reconstruct what happened, schedule short sessions to maintain your records.
At the end of each business day:
Record sales and expenses.
Update payment statuses.
Save receipts and invoices.
Note any stock discrepancies.
Check that recorded payments match the available transaction evidence.
Once a week:
Review unpaid customer invoices.
Check important stock levels.
Compare your records with bank or payment-provider statements.
Look for unusual expenses or missing entries.
Back up your records.
At the end of each month:
Calculate sales and expenses using an appropriate accounting method.
Review profit and cash flow separately.
Identify products or services that perform well.
Check upcoming supplier payments and other commitments.
Discuss uncertain accounting or tax matters with a qualified professional.
These tasks do not have to take hours. For a small operation, a consistent routine can be more useful than a complicated system that nobody maintains.
9. Protect Your Financial Records
Digital records can be lost, accidentally deleted or accessed by people who should not see them. Protect them as carefully as you protect your business payment accounts.
Use strong, unique passwords and enable multi-factor authentication where available. Give staff access only to the records they need for their work.
Keep backups in a separate, secure location and check periodically that you can restore them. Do not rely on a single phone or computer to hold every copy of your financial information.
Avoid sending complete customer lists, bank details or other sensitive records to public AI tools without an appropriate, secure basis for doing so.
When using an accountant or bookkeeper, agree on how records will be shared, who can access them and how copies will be retained.
10. Keep Records Organised for Business and Tax Responsibilities
Accurate records can help you respond to questions about sales, expenses, purchases, payments and other business transactions.
The specific records you must maintain and the period for which you must keep them depend on your business structure and the rules that apply to you.
Do not assume that a spreadsheet alone satisfies every legal, accounting or tax requirement. Keep relevant supporting documents and seek current guidance from the appropriate Nigerian tax authority or a qualified tax professional when necessary.
Good record-keeping is useful even when your business is small, has made a loss or is not yet ready to hire an accountant. It gives you a clearer picture of your operations and makes it easier to prepare for future growth.
A Simple 7-Day Plan to Get Started
If your business currently relies on memory, scattered messages or loose paper, you do not need to digitise everything at once.
Day 1: Choose a notebook, spreadsheet or suitable accounting app.
Day 2: List your main sources of sales and your regular expenses.
Day 3: Begin recording every new sale, including its payment status.
Day 4: Record expenses and organise supporting receipts.
Day 5: List unpaid customer balances and outstanding supplier bills.
Day 6: Count important stock items or review the records for your services.
Day 7: Review the information, correct obvious mistakes and decide when you will update it each day.
The aim is not to create perfect records overnight. It is to establish a routine that becomes part of running your business.
Frequently Asked Questions
Can I manage business records on my phone?
Yes. You can use a spreadsheet app, a suitable accounting app or a notebook and later transfer the information to a digital record. Choose a method that you can use consistently and protect against data loss.
Do I need accounting software to know whether my business is profitable?
Not necessarily. A well-maintained spreadsheet can help you organise basic sales and expense information. As transactions become more complex, accounting software or professional advice may become more valuable.
How often should I record sales and expenses?
Ideally, record transactions daily or as soon as practical after they occur. Waiting too long makes it easier to forget small expenses, miss payments or enter inaccurate amounts.
Is money in my business account the same as profit?
No. The balance may include money owed to suppliers, customer deposits or funds needed to replace stock. Profit and cash flow are different measures and should be reviewed separately.
What if I have already lost track of some transactions?
Start with the records you can verify, such as receipts, invoices, bank statements and payment-provider histories. Clearly identify estimates and missing information rather than presenting guesses as confirmed figures. If the gaps affect important accounting or tax matters, consult a qualified professional.
Final Thoughts
A business does not need to be large before accurate record-keeping becomes important. Even a small shop, online seller, freelancer or service provider can benefit from knowing what comes in, what goes out, what remains unpaid and what stock is available.
Begin with a simple system. Record transactions consistently, keep supporting documents, protect your information and review the figures regularly.
As your business grows, you can add spreadsheets, accounting software or professional support where they provide real value.
The goal is not just to record money. It is to understand your business well enough to make better decisions.
What do you currently use to track your business money: a notebook, a spreadsheet or an accounting app? Share your experience in the comments.
Author Bio
Capitaltechie publishes accessible technology and business information to help readers understand digital tools, emerging technologies, entrepreneurship and practical business strategies. Our goal is to provide useful, independently researched content that supports informed decisions.
References
International Growth Centre (IGC), Enhancing Initial Adoption of Digital Records and Best Practices Among Small Firms: Evidence from Nigeria (2025).
Google Docs Editors Help, Get Sheets Productivity Tips and Use Templates.
Zoho Books, official product information and pricing for Nigeria.
Relevant Nigerian tax authorities and qualified accounting professionals for current record-keeping and tax obligations.
Social