A small business owner often knows which customers bought something today, which supplier called yesterday and roughly how much is in the bank account. That knowledge feels sufficient until a supplier claims an invoice is unpaid, a customer disputes a balance, or the owner cannot explain why sales have grown but money remains scarce.
Good records solve practical problems before they become accounting problems. They show what came in, what went out, who owes money, what the business owns and whether the owner is withdrawing more cash than the business can safely afford.
A very small business can begin with a notebook, Microsoft Excel or Google Sheets. It does not necessarily need full accounting software on day one. However, simple bookkeeping is not a replacement for qualified accounting or tax advice when the business's complexity, reporting obligations or risks require professional support.
Understand what to record and why
Think of record-keeping as answering six questions: What did we sell? What did it cost? How much did we receive? What do we still owe? What do customers owe us? What stock or other assets remain?
These are separate questions because a sale is not always paid immediately, an expense is not always paid at once, and money in the bank is not always profit.
The Central Bank of Nigeria's financial literacy programme identifies record keeping, cash-flow management and budgeting as important financial skills. Nigerian tax rules also make proper records a compliance matter. Section 31 of the Nigeria Tax Administration Act, 2025, which commenced in January 2026, requires appropriate books or records of account and specifies a minimum retention period of six years after the relevant year of assessment. Businesses should check the official legislation and any applicable sector rules for their circumstances.
The practical lesson is straightforward: do not wait for an accountant or tax notice before recording transactions.
Step 1: Separate business money from household money
If sales payments, family contributions, personal spending and stock purchases all pass through one account without explanations, reliable reporting becomes difficult.
Use a distinct transaction trail for the business. Where appropriate, maintain a business bank account consistent with your registration status. If you use cash, a POS terminal, transfer payments or a digital wallet, record the source of each receipt.
When the owner brings personal money into the business, label it capital introduced or owner loan, depending on the actual arrangement. When the owner takes money out for personal use, label it owner's drawing for a sole proprietorship, or the appropriate payment category for a company. Do not automatically classify it as a cost of producing goods.
For example, buying fabric for resale is a business transaction. Using proceeds from fabric sales to pay a personal bill is a withdrawal. Both affect cash, but they mean different things.
Step 2: Maintain a daily cashbook
At the simplest level, a cashbook has one row for each cash movement. Record the date, description, category, payment channel, amount in, amount out and running balance.
DateDescriptionChannelMoney inMoney out 3 NovEight snack packs soldTransfer₦28,000— 3 NovIngredients purchasedCash—₦9,000 3 NovPackaging purchasedTransfer—₦3,000 3 NovDelivery paidTransfer—₦2,500 These amounts are illustrative. They produce ₦13,500 in net cash from the recorded transactions before other costs and adjustments. That figure is not necessarily final profit: opening stock, wages, rent, tax and other expenses may also be relevant.
Use one row per transaction rather than recording only the day's total. Save receipts, transfer confirmations and invoices so that each entry can be checked later. For an electronic transfer, confirm settlement in the account rather than relying on a customer's screenshot.
Step 3: Keep a sales register, including unpaid sales
The cashbook shows money movements. A sales register shows what you sold, even if a customer has not paid yet. Typical columns are invoice number, date, customer, item or service, quantity, price, amount, payment status and outstanding balance.
If a school orders printed materials worth ₦80,000 and pays ₦30,000 upfront, the register should show an ₦80,000 sale, ₦30,000 received and ₦50,000 outstanding under the agreed arrangement. The business's cashbook records only the amounts actually received when paid.
This distinction is essential when customers use instalments, deposits or credit. Without it, the owner may count the same payment twice or forget that a large invoice is overdue.
Assign each invoice a unique reference, such as INV-2026-001. Use the same reference on the receipt and in the customer's record. The format can be simple as long as it is consistent.
Step 4: Keep an expense register and evidence
Every business expense should have a date, category, explanation, amount, vendor and payment evidence where possible. Useful categories include inventory purchases, packaging, transport, power and fuel, rent, wages, communication, marketing, equipment maintenance and professional services.
Be careful with the accounting treatment of larger purchases. A laptop or industrial machine may be a long-term asset rather than an ordinary cost to expense fully in the same way as stationery. Loan principal, owner withdrawals and some advance payments also require different treatment. A bookkeeper can record the transaction immediately while seeking accounting advice about its correct classification.
Where receipts are unavailable, write a contemporaneous voucher with details of the payment and the person paid. A self-written voucher does not necessarily satisfy every tax or audit requirement, but a dated record is better than an unexplained withdrawal.
Step 5: Track stock separately from cash
A shop can receive ₦200,000 in cash and still be worse off if goods worth ₦230,000 have left the shelves. You need a stock record showing each product, opening quantity, purchases, sales, returns, damage and closing quantity.
For example, if you begin with 30 units of a product, buy 20 more, sell 35 and lose two through damage, the closing physical quantity should be 13. If your stock record says 17, investigate the four-unit difference rather than adjusting the figure without explanation.
Record cost prices and, where possible, the landed costs of stock. A product bought for ₦8,000 and transported at an attributable cost of ₦600 is not necessarily an ₦8,000 product in economic terms.
Count stock physically at a frequency suitable for the business. Perishable food and high-value electronics may require tighter controls than inexpensive stationery. Reconcile physical quantities with the stock register and document any discrepancy.
Step 6: Create customer and supplier balances
Keep an accounts receivable sheet for customers who owe money, and an accounts payable sheet for amounts owed to suppliers and service providers.
For each balance, record the invoice number, original amount, payments, due date, outstanding amount and status. Review unpaid items at least weekly. This prevents embarrassing situations in which the owner demands payment from a customer who has already paid or forgets a major supplier obligation.
If clients pay in instalments, allocate each payment to the correct invoice. If a supplier gives you 30 days to pay, record the payable immediately; do not wait until the cash leaves the bank before recognising the obligation in your operational register.
Step 7: Reconcile bank and cash records every week
Reconciliation means comparing the cashbook with bank statements, POS settlement reports, wallet records and cash counted physically. Every unexplained difference deserves attention.
Common problems include duplicate entries, transfers credited to the wrong invoice, bank charges omitted from the register, returned payments, failed transfers recorded as successful and expenses paid by an employee but not yet reimbursed.
A weekly routine is easier than investigating three months of confused transactions. Choose one day, download statements and tick off each movement against your records. Flag missing evidence and resolve it while details are still fresh.
Step 8: Produce a monthly performance summary
At month-end, prepare at least three simple reports.
Sales and costs: the value of sales, direct costs and operating expenses, so you can estimate how the business performed during the month. Cash summary: opening cash, cash received, cash paid and closing cash, so you know whether liquid funds increased or decreased. Debts and inventory: unpaid invoices, supplier obligations and stock balances, so you can see where money is tied up.
Suppose monthly sales are ₦900,000, directly attributable cost of goods sold is ₦540,000 and other operating expenses are ₦220,000. Your simplified operating profit is ₦140,000. The figure may require further accounting adjustments, and it does not say how much cash is available. If customers still owe ₦250,000, a large part of the recorded sales has not yet been collected.
A monthly review should lead to decisions: Which items generate a reliable margin? Which customers routinely pay late? Which expenses are increasing? Which stock remains unsold? What should we change next month?
A basic Google Sheets or Excel structure
Create one file with six tabs:
Dashboard: month, sales, expenses, cash balance, unpaid customer invoices and payables.
Sales: invoice number, customer, date, product, total and payment status.
Expenses: date, vendor, category, description, amount and evidence reference.
Cashbook: date, channel, inflow, outflow and running balance.
Stock: SKU, opening quantity, purchases, sales, adjustments and closing quantity.
Debts: customer or supplier, invoice, due date, payments and balance.
For a very small service business with no stock, the stock tab may not be needed. Keep the workbook proportionate to the business rather than creating a complicated system that nobody maintains.
Use protected formulas where appropriate, control access, back up your data and avoid keeping your only copy on a phone that could be lost or damaged. If multiple staff members use the file, define who can edit transactions and who reviews changes.
Nigerian evidence: digitisation should start with basic records
An October 2026 SMEDAN digital transformation blueprint, published with GIZ, draws on research involving more than 1,600 MSMEs and support organisations across nine states and the FCT. Its practical recommendations emphasise starting from real business problems and building simple digital discipline, beginning with record-keeping, rather than buying complicated tools for their own sake.
That is a useful guide for a small trader deciding between a notebook, a spreadsheet and an accounting subscription. First establish a dependable recording routine. Upgrade the tool when transaction volume, staff access or reporting needs justify the extra complexity.
How to avoid common beginner mistakes
Mistake: Recording only bank alerts. Alerts can omit cash transactions, charges, reversals and sales made on credit. Reconcile with actual statements and receipts.
Mistake: Recording the same sale twice. If you enter an invoice in the sales sheet and later receive payment, link the payment to that invoice rather than entering a new sale.
Mistake: Treating every withdrawal as an expense. Owner drawings and loan principal repayments should be identified correctly rather than distorting operating costs.
Mistake: Counting new stock purchases as the same thing as cost of goods sold. Inventory purchased and inventory sold during a period may differ. Keep the stock record and seek accounting support where needed.
Mistake: Keeping no supporting evidence. A spreadsheet number without a receipt, invoice, voucher or transaction record is difficult to verify.
Mistake: Backfilling records months later. Memory is unreliable, especially in a business handling many daily transactions. Record promptly and review regularly.
When should you hire an accountant or bookkeeper?
Simple records are a starting point, not permission to ignore professional obligations. Seek qualified assistance when you have employees and payroll obligations, multiple outlets, significant inventory, loans, complex tax questions, statutory financial reporting, investors or recurring unexplained differences.
Also seek professional advice before making decisions about business structure, tax treatment, asset depreciation or formal financial statements. A trained accountant can help build controls that prevent mistakes and fraud. Outsourcing the accounts does not eliminate the owner's responsibility to understand the reports.
Frequently asked questions
Can I use a notebook instead of accounting software?
Yes, for a very small operation, provided entries are complete, legible, consistently organised and securely stored. A spreadsheet makes calculations, searching and backups easier as the business grows.
Is a bank statement enough to keep business records?
No. It does not fully explain the business purpose of each transaction, unpaid invoices, stock, cash sales or expenses that have been incurred but not yet paid.
How often should I update my records?
Enter transactions daily, reconcile cash and banks weekly, and review performance monthly. High-volume businesses may need more frequent reconciliation.
How long should I keep my records in Nigeria?
Section 31 of the Nigeria Tax Administration Act, 2025 generally provides for retaining relevant books and records for at least six years after the year of assessment in which a transaction occurred. Other legal, contractual or sector requirements may require longer retention. Confirm the applicable rules for your business.
Do I still need an accountant if I know how to use Excel?
Excel can organise data, but it cannot determine every accounting treatment or legal obligation for you. Use it for daily records and obtain qualified help for financial statements, tax and more complex decisions.
Start with today's transactions
Business record-keeping does not need to begin with expensive software. Begin by recording each sale and expense today. Reconcile the bank account at the end of the week. Review what customers owe and what stock remains. At month-end, use the numbers to make better decisions.
A business owner who can explain where money came from, where it went and what remains is in a stronger position to control costs, deal with lenders, fulfil obligations and grow responsibly.
Further reading: Central Bank of Nigeria: Financial Literacy; Nigeria Revenue Service: Nigeria Tax Administration Act, 2025; Corporate Affairs Commission: Business Name Registration.












Reader conversation
0 approved comments