How to Use Google Sheets to Track Orders (A Free System for Small Businesses)
Stop losing orders in WhatsApp chats and notebooks. A simple Google Sheets system lets you track every order, payment and delivery for free — and it works from your phone.
If you sell on WhatsApp, Instagram or Facebook, you already know the problem: orders come in from everywhere, and keeping track of them is a daily struggle. A customer pays and you cannot remember which order it belongs to. Someone asks for a delivery update and you have to scroll through days of chat history to find their order. At the end of the month, you have no idea how much you actually sold, because the numbers are scattered across chats, notebooks and your memory. It is not a lack of effort — it is a lack of a system.
Google Sheets is the simplest system that actually works for a small business, and it costs nothing. It is a free spreadsheet that lives online, so you can open it on your phone or your computer, and your staff can use the same sheet at the same time. You do not need to buy software, hire a developer, or learn anything complicated. If you can type a name and a number into a table, you can run your whole order tracking on Google Sheets.
This guide shows you how to set up that system step by step: what columns to create, how to record an order in under a minute, how to track payments and deliveries, and how to use the sheet to answer the questions that matter — what sold, who still owes you, and what needs to go out today. It is written for Nigerian small businesses: the fashion vendor in Lekki, the food seller taking weekend orders, the phone accessories shop on Instagram, the small manufacturer supplying shops. Whatever you sell, the system is the same.
Why Google Sheets Works So Well for Order Tracking
The first reason is that it is free and it is already on your phone. Most Android phones come with Google Sheets installed, and on iPhone it is a free download. You only need a Google account, which is the same account you use for Gmail. There is no subscription, no trial that runs out, and no feature locked behind payment for the things a small business needs. That matters when every naira counts.
The second reason is that it works from anywhere. Because the sheet lives online, an order recorded on your phone at the market appears on your computer at home. If you have a staff member who takes orders, they can open the same sheet on their own phone and add orders too, and you will both see the same up-to-date information. No more asking "did you write it down?" or discovering at the end of the day that an order was recorded on a piece of paper that got lost.
The third reason is that it keeps your records safe. A notebook can be misplaced, a phone can be stolen, and a chat history can be deleted by accident. A Google Sheet is saved automatically every time you type, and it is stored in your Google account, not on one device. If your phone breaks, you sign in on another phone and everything is still there. That safety alone is worth switching for.
Finally, a spreadsheet can do the maths for you. Instead of adding up your daily sales with a calculator, you can set the sheet to add them automatically. Instead of guessing how many orders are still unpaid, you can filter the sheet and see them in seconds. You start with a simple table, and as your business grows, the same sheet grows with you — no new software to learn, no migration to another system.
Setting Up Your Order Tracker: The Columns You Need
Start by opening Google Sheets and creating a new blank spreadsheet. Give it a clear name, such as "Orders 2026" or "My Business Orders". Then set up one row of column headings across the top. These headings are the heart of your system, so choose them carefully. Here is a set that works for most small businesses selling physical products.
Your first column is the Order Number. Give every order a simple number — 001, 002, 003, and so on — or use the date plus a number, like 1311-01 for the first order on the 13th of November. The order number is how you and your customers refer to an order without confusion. When a customer asks about "my order", you ask for the order number, and you find it in seconds.
Next come the customer details: Customer Name, Phone Number, and Delivery Address. The phone number is the most important of the three, because it is how you reach the customer and how you identify them when they message you. Write phone numbers in a consistent format, and keep the delivery address in its own column, because you will need it when you hand the parcel to a rider.
Then the order itself: Date Ordered, Product or Item, Quantity, Unit Price, and Total Amount. The total can be calculated automatically — you can set the sheet to multiply quantity by unit price — but even typing it by hand is fine when you are starting out. Keeping product names consistent matters: write "Ankara gown – blue" the same way every time, so you can later search for all Ankara gown orders without missing any.
The last group of columns tracks money and delivery: Payment Status, Payment Method, Delivery Status, Delivery Date, and Notes. Payment Status should use simple, fixed words: Paid, Partial, or Unpaid. Delivery Status should also use fixed words: Pending, Packed, Shipped, Delivered, or Cancelled. Fixed words are important, because they let you filter the sheet later. If one person writes "done" and another writes "delivered" and another writes "sent", you cannot filter reliably. Agree on the words and stick to them.
Recording an Order in Under a Minute
The system only works if recording orders becomes a habit, and habits only form when the task is quick. So make a rule for yourself and your staff: no order is confirmed until it is in the sheet. Not "I will add it later" — later never comes, and the end of the day is when the mistakes happen. The moment a customer confirms an order, open the sheet, add a row, and fill it in.
On your phone, the fastest way is to keep the sheet open in the Google Sheets app and use it the same way you would a notebook. Type the order number, the customer name, the product, the amount, and the payment status. You can leave the delivery address and notes for a moment if the customer is still sending them, but the core of the order should be in the sheet before you move on to the next chat.
There is a small trick that makes this much faster: keep your most common products in a simple list, and copy the product name from the list instead of typing it fresh each time. Consistent product names make your later reports accurate. A second trick is to record the payment status honestly at the moment of recording — if the customer has not paid yet, write "Unpaid" rather than leaving the cell blank. A blank cell tells you nothing; "Unpaid" tells you exactly what to follow up on.
If you take orders through WhatsApp, consider a simple workflow: when a customer confirms, send them their order number in the chat. "Thank you! Your order number is 047. We will confirm your delivery once payment is received." That single message does three things: it reassures the customer, it gives them a reference to quote in later messages, and it commits you to having the order in the sheet, because you have just told the customer it exists.
Tracking Payments Without Losing Money
Unpaid and partly-paid orders are where small businesses quietly lose money. A customer says they will pay tomorrow, tomorrow becomes next week, and by then you have forgotten — or you remember, but you cannot find the amount or the product to remind them properly. Your order sheet fixes this, because it can show you every unpaid order at a glance.
Use the filter feature, which is built into Google Sheets. Tap the filter icon on the Payment Status column and choose to show only "Unpaid" and "Partial" orders. Now you have your follow-up list. Every morning, or every Monday if you prefer, go through that list and send a polite reminder to each customer. "Hello, this is a friendly reminder about your order 047, a balance of ₦5,000 is still outstanding. Please let us know when you would like to complete payment." Keep the tone friendly — most unpaid orders are forgetfulness, not bad faith.
The Payment Method column matters too. Record whether the customer paid by bank transfer, by POS, in cash, or through a payment link. At the end of the week, this tells you how your customers prefer to pay, and it helps you reconcile your bank account: the total of all "Paid by transfer" orders should roughly match the transfers that came in. If there is a big difference, something was missed, and the sheet helps you find it.
For partly-paid orders, add a second column for the amount paid and let the sheet calculate the balance. A customer who paid a deposit of ₦10,000 on a ₦25,000 order owes ₦15,000, and you should be able to see that number without doing mental arithmetic. When the balance comes in, update the amount paid and change the status to "Paid". The sheet becomes your memory, and your memory stops leaking money.
Tracking Deliveries and Keeping Customers Informed
Delivery is where customers judge you most harshly, because it is the part they experience. An order that is paid but not delivered on time creates more complaints than any other problem, and most delivery problems are not really delivery problems — they are information problems. The customer does not know where their order is, so they message you, and if you cannot answer quickly, they assume the worst.
Your Delivery Status column is the answer. Every order should move through the same stages: Pending when the order is confirmed, Packed when it is ready, Shipped when it is with the rider or courier, and Delivered when the customer confirms receipt. Update the status as the order moves. It takes five seconds, and it means that when a customer asks "where is my order?", you open the sheet and answer in one sentence instead of searching through chats and calling your rider.
Set the Delivery Date column to the date you promised the customer, not the date you hope to deliver. If you promised Friday, write Friday. Then, each morning, filter for orders with a delivery date of today and a status that is not yet "Delivered". That is your dispatch list for the day. Nothing gets forgotten, and nothing goes out late because nobody remembered it was due.
When you work with a dispatch rider or a logistics company, add the rider's name or the waybill number to the Notes column. If a parcel goes missing, you know exactly who had it and when. And when a customer confirms delivery, update the status the same day. A sheet full of orders marked "Shipped" that were actually delivered weeks ago is almost as useless as no sheet at all — it tells you nothing true about your business.
Using Your Sheet to Understand Your Business
Once you have a few weeks of orders in the sheet, it starts answering questions you could not answer before. This is where a simple tracker becomes a real business tool.
First, your total sales. At the bottom of the Total Amount column, you can add a sum that adds up all your orders automatically. Filter by "Paid" and the sum shows you what you actually received, not just what you sold. Filter by month, using the Date Ordered column, and you can see whether this month is better than last month. That is the beginning of real business knowledge, and it costs you nothing extra — the data is already there.
Second, your best products. Sort or filter by product name, and count how many times each product appears. You will quickly see which products your customers actually want and which ones sit unsold. That tells you what to restock and what to stop ordering. Many small businesses keep buying stock they do not need because they are guessing; your sheet replaces guessing with evidence.
Third, your unpaid money. Filter for "Unpaid" and "Partial" and look at the total. That number is money you have already earned but not yet collected. It is often surprisingly large, and seeing it written down is usually enough to start a follow-up routine that recovers a good part of it.
You do not need to build charts or dashboards to get this value. The filter and the sum are enough. Later, if you want, you can add a second tab in the same spreadsheet for a monthly summary, and copy your totals there each month so you can compare months side by side.
Common Mistakes and How to Avoid Them
The first mistake is having two systems. If some orders live in the sheet and others live only in a notebook or in your head, you have no system at all — you have two partial systems, and neither one can be trusted. Pick the sheet as the single source of truth, and record every order there, even the small ones, even the ones from your friend, even the cash orders. The small orders are the ones that get forgotten most easily.
Frequently Asked Questions
Do I need to pay for Google Sheets?
No. Google Sheets is free with a Google account, which is the same account you use for Gmail. The free version includes everything a small business needs for order tracking: unlimited rows, filters, formulas, and sharing. You only need an internet connection to open and save it.
Can I use Google Sheets on my phone?
Yes, and most small business owners use it mainly on their phone. Download the Google Sheets app, sign in with your Google account, and you can view and edit your order sheet anywhere. The app works well for adding rows and updating statuses, which is most of what order tracking needs.
What if I have staff who take orders? Can they use the same sheet?
Yes. Share the sheet with their Google account and give them editor access. They can add orders from their own phone, and you will both see the same live sheet. Agree on the fixed words for payment and delivery status first, so everyone records things the same way.
How do I stop customers' orders from getting mixed up?
Give every order a unique order number and use it in all your messages with the customer. When a customer asks about an order, ask for the number. Record the customer's phone number on every row, because that is the most reliable way to identify them when they message you from a different chat.
What happens if I lose my phone — do I lose my orders?
No. Your sheet is stored in your Google account online, not on your phone. Sign in to the same Google account on any other phone or computer and your sheet will be there, exactly as you left it. This is one of the biggest advantages over a paper notebook.
What to Do Next
Set up your order sheet today, in this order. First, open Google Sheets, create a new spreadsheet called "Orders 2026", and add the column headings from this guide: order number, customer name, phone number, delivery address, date ordered, product, quantity, unit price, total amount, payment status, payment method, delivery status, delivery date, and notes. Second, add your last five orders from memory or from your chats, so the sheet starts with real data. Third, make the rule that no order is confirmed until it is in the sheet, and send each new customer their order number. Fourth, set a daily five-minute habit — at the end of each day, update payment and delivery statuses and filter for unpaid orders to follow up.
If you would like help turning this simple system into something bigger — a proper website with online ordering, or a digital business card your customers can save — Joetech builds websites and digital tools for Nigerian small businesses. Tell us how you sell today, and we will help you build the system that fits it.
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.