How to Track Daily Sales for a Small Business

To track daily sales, write every sale down when it happens (what was sold, how many, for how much, how it was paid), then add up the day at closing and check the total against your cash, card and credit records. The method matters less than doing it for every sale, every day.

Many small shops end up recording only the sales they remember at closing time. This guide covers what to record, a closing routine that takes about five minutes, and how to catch the errors that make the total wrong.

What to write down for each sale

Five things cover the daily routine: the date, the item and quantity, the price (after any discount), how the customer paid, and, for credit sales, the customer's name and phone number. You can skip the name for cash sales to walk-in customers. For anything on credit, the name and phone number are the minimum, because you cannot collect a debt you did not write down.

The full field list, with a record-keeping method comparison and how long to keep records, is in the best way to keep sales records.

If you want to test the habit before choosing a tool, the free daily sales tracker records entries in your browser and exports a CSV for Excel or Google Sheets. It keeps entries on that device only and does not sync, so use it to try the idea. If you are weighing a spreadsheet against an app, see Excel vs a sales tracking app.

Step-by-step: a daily routine

Step 1: Record the sale at the counter

Write it down before the customer leaves. "I'll note it later" is how $40 disappears from the record. If that is not practical, keep a pile of receipt copies and enter them at the first quiet moment, not at closing.

Step 2: Split the day by payment type

Track four buckets separately:

• Cash
• Card
• Bank or mobile-money transfer
• Sold on credit (not paid yet)

This split is what makes a sales record useful. Total sales is not the money in your hand. Credit sales count as sales today but arrive later.

Step 3: Close the day in five minutes

At closing, do these in order:

1. Add up total sales for the day.
2. Add up each payment bucket. The four buckets must add up to the total.
3. Count the cash drawer.
4. Compare it with the expected cash (formula below), including cash collected on old debts.
5. Write one line about anything odd: a refund, an item out of stock, a dispute.

Step 4: Check the cash

Expected cash = opening cash + cash sales + cash collected on old debts − cash refunds − cash paid out

Money you put into the drawer or take out for yourself belongs in the formula too; write it down as its own line.

Worked example with made-up figures:

A $5 gap on $640 of cash sales is small and might be change-giving. A $50 gap, or a gap that repeats, means you should look at refunds, change-giving, money paid in or out that was not written down, or unrecorded sales. Write the difference down daily. After two weeks the pattern is visible.

The day's sales for the example:

The $1,125 is sales, not cash. The drawer should hold $690, which includes the $100 you started with and the $30 an old debtor paid, and the $180 on credit is a debt someone owes you. If you only look at the $1,125 you will think you have more cash than you do.

Step 5: Look at the week, not just the day

One day tells you little. On the same weekday each week, compare totals. If Saturday was $1,125 last week and $780 this week, ask what changed: weather, a competitor, a stockout, a price change. Over a few weeks you will know your normal range and which days need more staff or more stock.

Which numbers to look at each day

You do not need a dashboard. Four numbers cover most decisions:

1. Total sales for the day, compared with the same weekday last week
2. Payment split: how much is cash, how much is credit
3. Top sellers: the two or three products that brought most of the sales
4. Items that ran out: every stockout can be a lost sale you never see

If you also record what each item cost you, you can add a fifth: gross profit (sales minus the cost of what you sold). See how to calculate profit for a small business.

Common mistakes

• Recording at closing from memory. Small sales are forgotten, and the total comes out low.
• Mixing cash with sales. Cash in the drawer is not sales; some of it is float, supplier payments or the owner's money.
• Not recording credit. Customers who owe you disappear from the record and nobody chases them.
• Not recording discounts and returns. The total looks high and the cash comes up short.
• Not recording what you ran out of. You stay unaware of what the shop could have sold.
• Keeping two records. A notebook for sales and a spreadsheet for stock means one is always out of date. Record once and let reports come from that.

How to track daily sales automatically

If you sell all day, typing the same sale into a notebook, then a spreadsheet, then a stock sheet is the slow part. A sales app records each sale once and builds the totals from it.

In Daily Sales Record you open the Sales section, tap Add Sale, choose the products and, if you want, a customer, add a discount, tax, shipping or payment details, and save.

Saving the sale updates your stock, and your reports are generated from those sales. The Archive lets you look up any past day by date, and reports can be viewed as charts and exported to PDF (Excel export is part of Pro). The sales tracking app guide shows what each part does.

Customers who pay later are easier to follow in the same place: the Customers section shows outstanding dues per customer, with an account statement you can export.

If you want to see what a finished daily report looks like, we have a sample daily sales report you can copy as a CSV. For the bigger picture of how to keep records for tax and bank purposes, read the best way to keep sales records for a small business.

Daily closing checklist

Save or screenshot this.

• All sales for the day recorded (receipt copies entered)
• Sales split into cash, card, transfer and credit
• The split adds up to total sales
• Cash drawer counted and compared with expected cash (including old debts collected)
• Refunds, discounts and payouts written down
• Items that ran out noted for reorder
• One-line note on anything unusual

Final takeaway

Track sales at the moment of the sale, split them by how they were paid, and check the total against your cash every night. That takes about five minutes and tells you whether the day matches the money. Once that habit is stable, add stock and cost so you can see profit.

Next steps: once the habit is stable, add what each item cost so you can see profit (see how to calculate profit), and keep a stock record alongside your sales.

This article is general information, not accounting or tax advice.