How to Keep Track of Customer Orders Without an App

If you sell made-to-order goods (cakes, custom prints, candles, woodwork, anything a person asks for and you then make), the problem is rarely the making. It is that the order arrived somewhere you will not look again. This post gives you a record that survives a busy Saturday market, and the checklist to run it.

Why do orders get lost between DMs, texts, and markets?

Because each channel is its own inbox, and none of them is built to answer "what is due Friday?"

A typical week for a small maker: someone messages on Instagram asking for two dozen cookies, a regular texts a change to her birthday order, a customer at the market says "put me down for one of those," and a Facebook comment turns into a real order three replies deep. That is four places. The order is not lost the day it is taken. It is lost the day you scroll past it, or the day the details change in one thread and not in your head.

Three failure patterns show up again and again:

• The order that lives only in a chat. Chats get buried by newer chats. Nobody searches for "Saturday" three days later.
• The verbal order at a market. You were standing, hands full, and meant to write it down later.
• The changed order. The customer edits a date or quantity in a new message, and your original note is now wrong.

All three have the same fix. The chat is where the order is discussed. The record is where the order lives. Once you treat those as different things, the rest of this post is just deciding what goes in the record.

One boundary: this post is about knowing what you owe people and what they owe you. Whether a deposit counts as income now or later, and how to report it, is a question for a bookkeeper or the IRS, not a log. The IRS says to keep supporting documents that show the amounts and sources of your gross receipts, and an order record that notes each deposit and final payment is a good place for that trail to start.

What six fields does an order record need?

Six. More than that and you stop filling them in on a busy day; fewer and you end up hunting through a chat to find the missing piece.

Field	What goes in it	Why it earns its place
Who	Name and one way to reach them (phone or handle)	You can confirm pickup without digging through messages
What	The item, quantity, and any custom detail (flavor, size, color, spelling of a name)	The thing you will get wrong if it is only in your memory
Due date	The day it is needed, plus a time if pickup is timed	The field everything else sorts by
Deposit	Amount taken so far and how (cash, Venmo, card)	Proves the customer is committed and what you already hold
Balance	What is still owed at pickup	Stops you handing over an order and forgetting to collect
Status	One of four words, covered next	Tells you at a glance what still needs your hands

A few habits make the record work:

• Write it before you reply. The record is part of taking the order, not paperwork afterward. If you cannot fill the six fields, you have not finished the conversation, and the missing field is your next question to the customer.
• One line per order. Whether that is a row in a spreadsheet, a line in a notebook, or one card on a screen, do not split an order across places.
• Edits go in the record first. When a customer changes the date, change the due date, then confirm in the chat. That keeps the record the source of truth.

If an order has several items, keep them in the "what" field of one order rather than creating a row per item. The record is a list of promises to people, not an inventory.

Which statuses does an order move through?

Four, and only four: taken, making, ready, collected.

Status	Meaning	What you do next
Taken	Details and deposit are recorded; nothing is made yet	Schedule the work against the due date
Making	You have started: materials bought, dough mixed, print running	Finish it before the due date
Ready	Made, packed, and waiting	Message the customer that it is ready, with pickup time
Collected	Handed over and the balance is paid	Nothing. The order is closed

The reason to cap it at four is that every extra status is a decision you have to remember to make. "Waiting on customer reply," "needs supplies," and "almost done" all feel useful, and all collapse into the four above. If you are waiting on a customer, the order is still taken and the missing detail goes in the "what" field. If you need supplies, add them to your task list and leave the order taken.

The word that matters most is collected, and it should mean two things at once: the item left your hands and the balance came in. An order that is handed over unpaid is not collected. Keeping that rule one line long ("collected means handed over and paid") is what closes the loop on money.

Reading the statuses as a filter gives you a quick picture. Everything not yet collected is open work or open money. Everything ready is a message you owe someone. Everything taken with a due date this week is your production list.

How do you track deposits and balances due?

Two columns, one subtraction, and one rule.

The deposit column records what you have already received. The balance column is the total price minus that deposit. When the customer pays at pickup, the balance becomes zero and the order can move to collected.

The rule: never move an order to ready without writing the balance next to it. That way the message you send ("your order is ready, balance is due at pickup") already contains the number, and you do not have to work it out while the customer waits.

A short example of how an order might read, using made-up numbers purely for illustration:

Who	What	Due	Deposit	Balance	Status
Dana, text	Two dozen cookies, lemon, boxed	Fri, 4 pm	20 paid by Venmo	30	Making
Marcus, market	One custom cutting board, name engraved	Sat	40 cash	40	Taken
Priya, Instagram	Six candles, mixed scents	Wed	0	54	Ready

Read that table in ten seconds and you know that Priya has not paid anything yet and her order is waiting, that Dana's order needs finishing by Friday afternoon, and that Marcus's board is not started. That is the whole value of the record.

Two cautions. First, a deposit protects you from a customer who disappears, but only if you told them up front what happens to it. Say it in the confirming message so there is no argument later. Second, if you take a lot of deposits, keep them visible in your money records as well, not only in the order log, so your totals match what is in the till and the account. The same record-first habit is covered for sales in how to track sales without software, and learning to invoice without accounting software covers how to write a payment request when a customer wants one.

How do you see tomorrow's pickups at a glance?

Run a five-minute check every evening. It is the single habit that turns the record from a list into a safety net.

The evening check:

1. Sort or scan by due date. Find every order due tomorrow and the day after.
2. Check each one's status. Anything due tomorrow that is still taken is the one that wakes you up at 3 a.m. Start it now or call the customer.
3. Check the balance. For each pickup tomorrow, note what the customer owes so it is in your head when they arrive.
4. Message the ready orders. Send the pickup reminder tonight, not tomorrow morning.
5. Look for stale taken orders. Any order older than a week with no progress deserves a decision: schedule it or release the date.

That is it. Five minutes, because there are only a handful of open orders on any given evening and the record is already sorted the way you need.

The check also gives you something a pile of chats never will: a view of whether you are over-booked. If Thursday has eleven orders and your usual output is six, you can see that on Monday and either move a few dates or stop saying yes, instead of discovering it Wednesday night.

If you want to see how this fits into a bigger weekly rhythm, the one-page weekly review shows how to close out the week's orders, unpaid balances, and next week's load in one sitting.

Can I use a spreadsheet, and what should it look like?

Yes. For many small makers a spreadsheet is exactly enough. Put the six fields in the first row as column headings, add one row per order, and freeze that top row so the headings stay visible. Sort by due date and filter out collected orders to see only open work.

Where a spreadsheet gets awkward is on your phone at a market, with a customer in front of you, typing into tiny cells. If you take most orders on the go, a notebook that you copy into the sheet each evening can work, as long as the evening copy-over is built into the five-minute check. The point is that an order is written down once, somewhere durable, before the conversation ends. The SBA's guide to managing your finances makes the same case for keeping a consistent system of records, and the IRS recordkeeping overview is a useful reference for what a small business is expected to keep and why.

When does a small maker need order software?

Later than most software pages suggest, and the signs are specific:

• You are handling more orders than you can scan in the evening check. If the open list no longer fits in your head or on a screen, sorting and filtering become real work.
• Several people take orders. A shared record needs everyone writing to the same place. A single notebook does not scale to two people.
• You need customers to see their own order status. A record kept for your own use is not a customer portal.
• You sell inventory-backed items. Once stock levels drive what you can promise, you need tracking beyond the order itself. Our guide on tracking inventory without software covers where that starts.

If none of those describe you, the problem is not a missing app. It is the missing habit. Software on top of a half-kept record just gives you a more expensive half-kept record.

How do you run this in SMBDashboard?

If you would rather not build the sheet yourself, SMBDashboard already has the pieces. Open the task list and add each order as a task: the customer in the title, the due date as the task's date, and the item and any custom detail in the notes. Your open tasks, sorted by date, are your evening check. Log the deposit in the money module as an open income entry so the balance still due is visible alongside your other numbers. The small business task manager page walks through the task view, and your data stays in your browser unless you turn on Pro sync.

The free version is enough to run a made-to-order side business: unlimited tasks and 25 customers. Pro removes the caps.

Frequently asked questions

What is the easiest way to track custom orders?

One line per order with six fields (who, what, due date, deposit, balance, status), kept in a single place and written before you reply to the customer. A notebook, a spreadsheet, or a task list all work. The format matters less than writing every order down once, in the same place, every time.

How do I track orders that come in through Instagram and Facebook messages?

Treat the message thread as the conversation and the record as the order. As soon as the customer confirms what they want and when, copy the six fields into your record, then reply to confirm. When the customer changes anything later, update the record first. That way one place always holds the current version of every order.

How do I keep track of deposits on orders?

Add a deposit column and a balance column to each order. Record the deposit amount and how it was paid when you take the order, and calculate the balance as the price minus the deposit. Write the balance next to the order before you mark it ready, and tell the customer in your confirming message what happens to the deposit.

Can I use a spreadsheet to track orders?

Yes. Use the six fields as column headings, add one row per order, freeze the top row, and sort by due date. Filter out collected orders to see only open work. A spreadsheet is a good fit until you have more orders than you can review in a few minutes, several people entering orders, or customers who need to see their own status.