Business Growth for SMEs14 min read2026-11-15

How to Keep Simple Business Records With a Notebook or Google Sheets in Nigeria

A practical guide to keeping simple business records in Nigeria with just a notebook or a free Google Sheet, so you always know what you earned, what you spent, and whether your business is really making money.

J

Igono Joel

Published 2026-11-15

How to Keep Simple Business Records With a Notebook or Google Sheets in Nigeria — featured image for Joetech blog article about tech skills and AI

Many Nigerian small business owners work hard every day and still do not know whether their business is making money. They sell all day, the cash comes in, the cash goes out, and at the end of the month they cannot say how much they earned or where the money went. The problem is not that they are bad at business. The problem is that they keep no records. Without records, you are guessing. With records, you know.

Keeping business records does not require an accountant, expensive software, or a degree in finance. A notebook and a pen are enough to start. A free Google Sheet on your phone is even better, because it adds up the numbers for you and it cannot be lost in the rain. This guide shows you exactly what to record, how to set it up in a notebook or in Google Sheets, and how to use your records to make better decisions every week.

Why Records Matter More Than Sales

Sales feel like success. A busy day with many customers feels like a good day. But sales are not profit. A food vendor who sells ₦50,000 of food in a day may have spent ₦45,000 on ingredients, gas, packaging, and transport, leaving only ₦5,000. A fashion seller who sells ten dresses at ₦15,000 each may have bought them for ₦13,000 each, leaving very little after delivery and packaging. Without records, both sellers think they are doing well, until the money runs out and they cannot restock.

Records show you the truth about your business. They show which products make money and which ones only look busy. They show whether your prices are too low. They show how much you spend on small things, like transport and airtime, that quietly eat your profit. They show whether your business is growing month by month, or just going round in circles.

Records also protect you. When a customer says she paid and you are not sure, your record settles it. When a supplier says you owe him money, your record shows what you already paid. When a staff member handles cash, your record shows what should be in the drawer. When you apply for a loan or a grant, the bank or the organisation will ask for your records. A business with records looks serious and trustworthy. A business without them looks like a gamble.

What to Record Every Day

You only need to record four things every day: money in, money out, what you sold, and what you owe or are owed. Everything else is optional. Start with these four, and do them every single day without fail.

Money in is every naira that enters your business: cash sales, bank transfers, payments through Paystack or Flutterwave, and money from Opay or Palmpay. Write down the date, the amount, and what it was for. "12 Nov, ₦18,500, sale of 1 dress, transfer" is a complete record. Do not write "money received" without saying what it was for, because in two weeks you will not remember.

Money out is every naira that leaves your business: stock purchases, transport, packaging, airtime, data, food for yourself during work hours if you pay for it from the business, and any money you take home. Yes, money you take home is money out. Many business owners take cash from the till for personal use and never record it, then wonder why the business has no money. Write it down: "12 Nov, ₦5,000, took home for children's school fees." That honesty is what makes your records useful.

What you sold is the list of products or services: how many, at what price, and to whom if you know. "3 bottles of cream at ₦8,000 each" is enough. This record shows you which products sell fastest and which ones sit on the shelf. It also helps you know when to restock, because you can see exactly how many you have sold since your last purchase.

What you owe and are owed is the credit record. If a customer buys on credit, write her name, the amount, and the date she promised to pay. If a supplier gives you goods on credit, write his name, the amount, and the date you promised to pay. Credit is where many small businesses lose money silently, because they forget who owes them. A written credit record, checked every week, recovers money that would otherwise be lost.

Setting Up a Notebook System

A notebook is the simplest way to start, and it works even when there is no network, no light, and no phone battery. Buy a hardcover notebook, not loose paper, because loose paper gets lost. Keep it at your shop or in your bag, and write in it every day.

Divide the notebook into sections. The first section is the daily cash record. Rule a page into columns: date, description, money in, money out, and balance. At the end of each day, write every transaction in order, and calculate the balance. Start each day with the balance from yesterday. This running balance tells you at any moment how much cash your business should have. Count the cash in your drawer or your account at the end of the day and compare it with the balance in the book. If they do not match, find the difference that same day, while you still remember.

The second section is the sales record. Each day, write what you sold: the product, the quantity, the price, and the total. If you sell many small items, group them: "25 meat pies at ₦500 = ₦12,500". This section shows you your best sellers at a glance.

The third section is the credit record. Make two lists: "People who owe me" and "People I owe". For each entry, write the name, the amount, the date, and the promised payment date. Check this section every Saturday, and follow up with anyone whose payment is overdue. A short message, "Good morning, this is a friendly reminder about the ₦15,000 balance from last week", recovers more money than silence ever will.

The fourth section is the stock record. Write down what you buy, when you buy it, how many, and at what price. "10 Nov, 20 bags of rice, ₦45,000 each from Alhaji Musa, Ikeja market." When you sell, you can see what you have left. This stops you from buying stock you already have, and from running out of your best seller without noticing.

Write neatly and use one line per transaction. Do not write in pencil, because pencil can be changed. Use a pen. If you make a mistake, cross it out with one line and write the correction beside it, so the history is still clear. Keep the notebook safe, and never tear out pages. A notebook with missing pages cannot be trusted, not even by you.

Setting Up a Google Sheet

A Google Sheet does the same job as a notebook, but it adds up the numbers for you, it is searchable, and it is saved online, so you cannot lose it if your phone is stolen or your notebook gets wet. Google Sheets is free, and it works on any phone with the Google Sheets app. If you have a Gmail account, you already have it.

Create a new spreadsheet and name it with your business name and the year, for example "Ada's Cakes Records 2026". Create four tabs at the bottom: Daily Cash, Sales, Credit, and Stock. Tabs keep your records organised in one file, instead of scattered across many files.

In the Daily Cash tab, create columns: Date, Description, Money In, Money Out, and Balance. In the Balance column, use a simple formula that adds the money in and subtracts the money out from the previous balance. You only need to type the formula once, in the first row, and then copy it down. Each time you enter a transaction, the balance updates itself. This is the biggest advantage of a sheet over a notebook: no more manual addition, and no more arithmetic mistakes.

In the Sales tab, create columns: Date, Product, Quantity, Price Each, and Total. Use a formula in the Total column that multiplies quantity by price. At the bottom, use a SUM formula to add up the whole column, so you can see your total sales for the week or the month at a glance. This total is the number you compare with your money-in record to check that everything matches.

In the Credit tab, create columns: Date, Name, What For, Amount Owed, Date Promised, and Status. Update the Status column when a customer pays: change it from "Unpaid" to "Paid" and write the date. Use the filter tool to show only unpaid entries, so you can see at a glance who still owes you.

In the Stock tab, create columns: Date Bought, Product, Quantity Bought, Cost Each, Total Cost, and Quantity Left. Update Quantity Left each time you sell. When it reaches zero, you know it is time to restock. This tab also shows you the true cost of each product, which is what you need to set a profitable price.

Separating Business Money From Personal Money

The most important rule in business records is also the simplest: your business money is not your money until you pay yourself. Many Nigerian small businesses fail not because they do not sell, but because the owner spends the business money as if it were a personal wallet. School fees, food, fuel, and gifts all come out of the till, and then there is nothing left to buy stock.

Open a separate bank account for your business. It does not need to be a corporate account at first; a second personal savings account, used only for business, is a good start. All business money goes into that account, and all business spending comes out of it. Your personal spending comes from your personal account. If you use Opay or Palmpay for business, open a separate wallet for the business too.

Pay yourself a salary, even if it is small. Decide on a fixed amount each week or each month, such as ₦20,000 a week, and transfer it from the business account to your personal account on a fixed day. That transfer is your salary, and it is the only money you spend on personal things. Everything else stays in the business. This one habit will change your business more than any other, because it stops the slow leak that kills small businesses.

Reading Your Records Every Week

Records are useless if you never read them. Set aside thirty minutes every Sunday evening, or Monday morning, to review the week. This weekly review is where records turn into decisions.

First, add up the week. How much money came in? How much went out? What is left? This is your weekly profit, before you pay yourself. If the number is negative, find out why immediately: did you buy too much stock, did you spend too much on transport, or did you take too much money home? A negative week is a warning, not a disaster, if you catch it early.

Second, look at your best and worst products. Which products sold the most? Which made the most profit? Which ones did not sell at all? Stop ordering products that do not sell, and order more of the ones that do. A product that sits on your shelf for three months is money that is not working. Sell it at a discount, or stop stocking it.

Third, check your credit list. Who owes you, and for how long? Call or message anyone who is more than a week overdue. Be polite but firm. Credit that is not followed up becomes a gift, and you cannot afford to give gifts to every customer.

Fourth, compare this week with last week. Are sales going up or down? Are expenses rising? A simple comparison, week by week, shows you trends that a single day never will. If sales are falling for three weeks in a row, something needs to change: your prices, your products, or your marketing. Your records will have warned you before the problem became a crisis.

Records for Tax and the CAC

Keeping records is not only good for your business; it is also what the law expects. The Corporate Affairs Commission requires registered businesses to keep proper records, and the tax authorities can ask to see them. A business with clean records can answer those questions calmly. A business without them cannot.

For tax, your records show your income and your expenses, which is what determines how much tax you owe. In Nigeria, small businesses may qualify for simplified tax treatment, but you still need records to prove your income. Keep your records for at least five years. Keep your receipts too: every receipt for stock, rent, transport, and equipment is evidence of your expenses. Take a photo of each receipt with your phone and save it in a folder in Google Drive, so the paper copy is not your only copy.

If your business grows, your records will make it easy to work with an accountant. An accountant charges less and works faster when your records are organised, because she does not have to rebuild your history from memory. Many accountants in Lagos offer a monthly bookkeeping service for a small fee, and they can take over your records when your business is big enough to need it. Until then, your notebook or your Google Sheet is enough, as long as you keep it up to date.

Frequently Asked Questions

How much time does record keeping take each day?

About ten minutes, if you do it every day. Write down each transaction as it happens, or at the end of the day before you close. The mistake is to wait until the end of the week, because by then you have forgotten half the transactions. Ten minutes a day is far easier than five hours on a Sunday trying to remember the whole week.

What if I cannot use Google Sheets?

A notebook is perfectly fine. Many successful Nigerian businesses run on notebooks for years. The important thing is not the tool, it is the habit. Use the tool you are comfortable with, and use it every day. If you can use a phone, Google Sheets is worth learning, because it adds up the numbers for you and keeps a backup online.

Should I record small expenses like ₦200 for transport?

Yes, record everything. Small expenses add up faster than you think. ₦200 for transport, ₦500 for airtime, and ₦1,000 for packaging, repeated every day, can add up to more than ₦50,000 in a month. If you do not record them, you will never know where that money went. Record every naira, no matter how small.

What if my staff handles cash?

Give your staff a clear rule: every sale must be written down immediately, with the amount and what was sold, and the cash must go into the drawer or the business account the same day. Count the cash at the end of each day and compare it with the record. If there is a difference, ask about it the same day. Good records protect honest staff too, because they prove the money is correct.

When should I hire an accountant?

When your records take more than an hour a day to maintain, when you start paying tax, or when you need a loan and the bank asks for financial statements. Until then, a notebook or a Google Sheet, kept daily and reviewed weekly, is enough for most small businesses. Start with the simple system, and grow into professional help when your business is ready.

What to Do Next

  1. Today, buy a hardcover notebook or create a Google Sheet named with your business name and the year, with tabs for Daily Cash, Sales, Credit, and Stock. Write down today's transactions before you sleep tonight.
  2. This week, open a separate bank account or wallet for your business, decide on a fixed weekly salary for yourself, and record every transfer between your business money and your personal money.
  3. Every Sunday evening, spend thirty minutes reviewing the week: add up money in and money out, find your best and worst products, follow up on overdue credit, and compare the week with the one before it. Keep the habit for one month, and you will never run your business blind again.

Get weekly tech insights

Join our newsletter for practical guides on web dev, AI tools, and digital marketing — sent every Monday.

No spam. Unsubscribe anytime.