How to Track Business Expenses with a Free Spreadsheet in Nigeria
You cannot grow a business you cannot measure. This guide shows Nigerian small businesses how to track every naira of spending with a free Google Sheets spreadsheet.
Ask a small business owner in Lagos how much they spent last month and you will often get a shrug. They know money came in, they know money went out, but they cannot say exactly how much went to stock, how much went to transport, how much went to data, or how much went to personal spending that quietly slipped into the business account. This is not carelessness. It is what happens when a busy trader in Balogun Market, a food vendor in Yaba, a salon owner in Lekki, a fashion designer in Abuja or a phone accessories seller in Port Harcourt tries to run a business from memory and a pocket full of receipts.
Tracking expenses changes that picture completely. When you record every naira you spend, you can see which costs are eating your profit, which products are actually making money, and whether you can afford to hire help, rent a bigger shop, or run an advert. You can also answer the questions that matter at the end of the year, such as how much tax you may owe, whether your prices are still right, and where you can cut costs without hurting quality. You do not need expensive accounting software to get these answers. A free spreadsheet, used consistently, will do the job for most small businesses in Nigeria.
This guide shows you how to build that spreadsheet from scratch, how to use it every day without it becoming a burden, and how to turn the numbers into decisions that grow your business. You only need a phone, a free Google account, and about thirty minutes to set it up.
Why Tracking Expenses Matters for a Nigerian Small Business
Many Nigerian small businesses fail not because they have no customers, but because they do not know their true costs. A trader buys stock for ₦200,000, sells it for ₦280,000, and believes she made ₦80,000 profit. She has forgotten the ₦15,000 she paid for transport from the market, the ₦10,000 for packaging, the ₦8,000 for MTN data and airtime used to attend to customers on WhatsApp, the ₦12,000 for fuel for the generator when NEPA took light, and the ₦20,000 she took from the till for food and school fees during the month. Her real profit was closer to ₦15,000, not ₦80,000. Without a record, she keeps pricing the same way and wonders why the business never seems to grow.
A spreadsheet shows the cost of doing business in Nigeria as it really is: generator fuel, extra deliveries because of Lagos traffic, bank transfer charges, POS charges, market levies, and the cost of data so customers can reach you. When these costs are visible, you can raise a stale price, stop selling a product that loses money, or negotiate a better rate with a supplier.
Step 1: Choose Your Free Spreadsheet Tool
You have two excellent free options, and both work well on a Nigerian phone with modest data.
- Google Sheets. This is the best choice for most small businesses. It is free with a Gmail account, it saves automatically to the cloud, and you can open it on your phone, your laptop, or a cybercafe computer. If your phone is lost or damaged, your records are still safe online. You can also share the sheet with your accountant or business partner without sending files back and forth. The Google Sheets app works on Android and iPhone, and you can enter figures even when your network is slow.
- Microsoft Excel Online or the Excel mobile app. If you already use Microsoft products, the free online version of Excel works in a browser and the mobile app is free for basic use. It is very similar to Google Sheets for simple expense tracking. Choose the tool you are most comfortable with, because the best spreadsheet is the one you will actually open every day.
Start free, build the habit first, and upgrade later when your transaction volume makes it necessary. Create the file now and name it clearly, for example "My Business Expenses 2026".
Step 2: Set Up Your Spreadsheet Columns
Open a new spreadsheet and create your first sheet, called "Expenses". Put these headings in the first row, one per column: Date, Description, Category, Payment Method, Amount, Receipt, and Notes. Each column has a clear job. Date tells you when the money left. Description tells you what you bought, in plain words, such as "50 yards Ankara fabric from Balogun" or "Diesel for generator, 20 litres". Category groups similar spending together so you can total it later. Payment Method records whether you paid cash, by bank transfer, with a card, or through a mobile money app. Amount is the naira figure. Receipt is a simple Yes or No, so you know whether you have proof of the purchase. Notes holds anything extra, such as the supplier name or the customer the expense relates to.
Keep the headings short. Seven columns are enough. Use the first row for headings only, make it bold, and freeze it so it stays visible when you scroll. Type the number only in the Amount column, without the naira sign, so your totals calculate correctly.
Step 3: Create Expense Categories That Match Your Business
Categories are the heart of your spreadsheet. Without them, you have a long list of purchases but no way to see patterns. With them, you can answer questions such as "How much did I spend on transport last month?" in seconds. Start with ten to twelve categories that match your real spending. Here is a sensible starting list for many Nigerian small businesses, which you can adjust to fit yours.
- Stock and materials. Raw materials, goods for resale, fabrics, ingredients, phone accessories, or anything you sell on to customers.
- Transport and delivery. Bus fares, fuel for your car or bike, dispatch rider fees, courier charges, and parking.
- Generator fuel and power. Petrol, diesel, inverter charging, and any money paid for electricity, including estimated bills and prepaid meter top-ups.
- Rent and shop costs. Shop rent, service charge, market levies, and security fees.
- Data, airtime and communication. MTN, Glo, Airtel or 9mobile data bundles, airtime, and internet subscriptions used for the business.
- Salaries and wages. Pay for staff, casual workers, and any apprentice allowance.
- Marketing and advertising. Flyers, social media adverts, WhatsApp Business costs, photography, and branding.
- Packaging. Bags, boxes, labels, wrapping, and delivery packaging.
- Bank and payment charges. Transfer fees, POS charges, and account maintenance fees.
- Repairs and maintenance. Fixing a sewing machine, a fridge, a phone, a generator, or shop fittings.
- Food and refreshments. Food bought for staff or customers during business hours, not your personal meals.
- Miscellaneous. Small items that do not fit anywhere else. Keep this category small. If it grows large, you need a new category.
Write the category list on a second sheet called "Categories" and use exactly the same spelling every time. "Transport" and "transport" look like different categories to a spreadsheet. If you are unsure where an expense belongs, ask what the money was mainly for.
Step 4: Record Expenses Every Single Day
A spreadsheet only works if the information inside it is complete. The habit matters more than the tool. Set a fixed time each day to record expenses, ideally in the evening after you close, or during a quiet moment in the afternoon. It takes five to ten minutes if you do it daily. It takes hours, and a lot of guessing, if you leave it for a month.
Follow this daily routine. First, gather every receipt, bank alert, and transfer confirmation from the day, including SMS alerts for small transfers and POS payments. Second, add one row per expense, starting with the date and amount. Third, write a clear description: "Tomatoes and peppers, Mile 12 market" is helpful a month later, while "Market" is not. Fourth, choose the category and payment method. Fifth, mark whether you have a receipt. Do not skip an entry because you have no receipt; an entry without one is far better than no entry at all.
If you spend money while you are out, write it in your phone notes app or send yourself a WhatsApp message with the amount and what it was for, then transfer it to the sheet in the evening.
Step 5: Separate Business Money from Personal Money
This is the single most important rule in this guide. If your business money and your personal money share the same account and the same pocket, you will never know whether your business is profitable. You will take ₦5,000 for lunch, ₦10,000 for a family need, and ₦3,000 for airtime for your personal line, and all of it will look like business spending. At the end of the month, the business looks like it lost money, when in fact the owner took the profit as personal spending without recording it.
Open a separate bank account for the business if you can, even if it is a simple savings or current account in the business name. All business income goes into that account, and all business expenses come out of it. Pay yourself a fixed salary or allowance from the business account to your personal account, for example ₦50,000 or ₦80,000 a month, depending on what the business can afford. Record that payment in the spreadsheet under a category called "Owner Salary" or "Owner Drawings". This way, your personal spending is one clear line in the sheet, not a hundred hidden withdrawals.
If you cannot open a separate account yet, keep business cash in a separate wallet or cash box and never mix it with personal cash. When you take money for a personal need, record it immediately as owner drawings. When you put your own money into the business, record that too.
Step 6: Track Cash Expenses Properly
Cash is still king for many small businesses in Nigeria. Market traders, food vendors, hairdressers, and artisans take a large share of their payments in cash and pay many of their suppliers in cash too. Cash is also the easiest money to lose track of, because there is no bank alert to remind you. If you ignore cash, your spreadsheet will understate your true costs and overstate your profit.
Start each day by counting the cash in your till and writing the figure in your notebook. During the day, put every cash expense receipt into an envelope. At the end of the day, count the cash again, add up the receipts, and enter each expense into the spreadsheet. If cash is short, check for a forgotten expense before assuming money is missing.
For cash received from customers, keep a separate record on a sheet called "Income" with columns for Date, Customer, Description, Payment Method, and Amount. At the end of each week, deposit excess cash into your business bank account rather than keeping large amounts in the shop.
Step 7: Use Simple Formulas to Get Monthly Totals
You do not need to be a spreadsheet expert to get useful totals. Two simple formulas do most of the work. The first is SUM, which adds up a column of numbers. At the bottom of your Amount column, type =SUM(E2:E100) if your amounts are in column E, adjusting the range to match your sheet. The total updates automatically every time you add an expense. The second is SUMIF, which adds up only the expenses in one category. For example, =SUMIF(C2:C100,"Transport",E2:E100) adds up all transport spending if your categories are in column C and your amounts are in column E. You can copy this formula for each category and build a small summary table on a sheet called "Monthly Summary".
Create that summary sheet at the start of every month. List each category in one column and the total spent in that category in the next, using SUMIF formulas. Add rows for total expenses, total income, and profit, which is income minus expenses. This one page becomes your monthly business report.
If formulas feel intimidating, start with SUM only and add SUMIF after a week or two. Do the monthly summary on the same day every month, for example the first day of the new month, so it becomes a habit.
Step 8: Review Your Spending and Make Decisions
Recording expenses is not the goal. Using the numbers to make better decisions is the goal. At the end of every month, sit down with your Monthly Summary for thirty minutes and ask five questions. First, which category grew the most compared with last month, and why? Second, which expenses could you reduce without hurting quality, for example by buying stock in bulk or sharing a delivery van? Third, are your prices still right, or have rising fuel and packaging costs quietly shrunk your margin? Fourth, is any category suspiciously high? Fifth, what will you change next month? Write down one or two actions.
Keep paper receipts in a monthly envelope labelled with the month and year, and digital receipts in a folder on your phone or Google Drive. A tidy set of spreadsheets and receipts helps if a tax authority asks for records, or if you need to prove an expense or show a partner how the business is performing.
Common Mistakes to Avoid
The first mistake is starting big and quitting early. A business owner creates a complicated spreadsheet with twenty sheets, enters expenses for three days, then abandons it because it takes too long. Start simple, with one Expenses sheet, one Income sheet, and one Monthly Summary sheet. You can add complexity later.
The second mistake is recording only large expenses. The ₦500 for pure water, the ₦1,000 for airtime, and the ₦2,000 for a bike ride seem too small to record, but small expenses add up fast. Fifty small expenses of ₦1,000 each is ₦50,000 a month. If you ignore them, your profit figure is wrong by ₦50,000.
The third mistake is mixing personal and business spending, as discussed above. If you cannot separate the money completely, at least separate the records completely. Every personal withdrawal must appear as owner drawings, not hidden inside a business category.
The fourth mistake is never reviewing the numbers. A spreadsheet that is filled in but never read is just a diary. The value comes from the monthly review, when you compare categories, spot waste, and adjust prices. Put a reminder in your phone for the first day of every month, and treat that review like an appointment with yourself.
The fifth mistake is keeping everything in your head and using the spreadsheet only when you remember. Tie the habit to something you already do every day, such as closing the shop, counting the till, or charging your phone in the evening. A habit linked to a daily routine lasts far longer than one that depends on willpower alone.
A Simple Weekly Routine That Works
On Monday morning, check that last week's entries are complete. Each working day, record expenses in the evening, which takes five to ten minutes. On Saturday, count your cash, deposit excess cash into the bank, and file the week's receipts. On the first day of the new month, build your Monthly Summary, review the numbers, and write down two actions for the new month. If a partner or staff member handles money, agree who records what, and make sure the person who spends the money records it the same day.
Final Checklist
Before you start, make sure you have chosen Google Sheets or Excel Online, created a spreadsheet named for your business and the year, set up your Expenses sheet with Date, Description, Category, Payment Method, Amount, Receipt, and Notes, listed your categories on a separate sheet, created an Income sheet with the same discipline, set a daily time to record expenses, separated business cash from personal cash, learned the SUM and SUMIF formulas for monthly totals, and put a monthly review in your calendar. If you can tick most of these boxes, you are ready. Start today, even if you start with yesterday's expenses from memory and bank alerts. A spreadsheet started today is worth far more than a perfect system planned for next month. Within three months, you will know exactly where your money goes, and that knowledge is the foundation of every good business decision you will make next.
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.