OmniDocExcel Spreadsheet for Tracking Sales Step by Step
Learn how to build an Excel spreadsheet for sales with date, product, quantity and total columns, then check your totals using OmniDoc's UniCell.
If you sell products from a shop, a market stall or your own website, sales recorded in notebooks or chat messages become hard to add up at the end of the month. A sales spreadsheet fixes that by giving each sale its own row, with the date, product, quantity and amount side by side. This guide shows you how to set one up as an Excel spreadsheet for sales, using UniCell in the OmniDoc desktop client.
You will build a sales log with fixed columns, a total for each sale calculated from quantity and unit price, and a totals row for the whole period. The steps assume you have not built one before. They focus on recording sales, not on advanced formulas or general templates.
How do you create an Excel spreadsheet for sales? The short answer
Set up one row per sale with fixed columns, calculate each total from quantity and unit price, and check the totals against your payment records.
| Your situation | What to do | Why |
|---|---|---|
| You sell a few products at fixed prices | Use one row per sale with a product column and a unit price column | Totals stay consistent and filters work well |
| You sell several items in one order | Record one row per item and repeat the order ID | You can total each order without losing item detail |
| You want monthly totals | Keep the full date in its own column | Filtering by month becomes reliable |
| You sell in person and online | Add a channel column | You can see which channel brings in which amounts |
| You take refunds or pay fees | Enter refunds as negative rows and add a fee column if needed | Net figures are clearer than gross totals alone |
Before you start
- Gather your source records. Pull together receipts, order confirmations or card payment reports for the period you want to start with. Working from memory leaves gaps that are hard to find later.
- Write a product list with exact names and prices. If the same item appears as "Blue mug" and "blue mug 350ml," filters will split its sales into two groups.
- Choose one date format. Use the same format in every row so sorting and monthly filters treat each date as a real date.
- Decide which columns you need before you enter data. Adding a column later means filling it in for every earlier row, so settle the layout first.
- Install the desktop client. UniCell is part of the OmniDoc desktop client for Windows, macOS and Linux. You can get it at download.omnidoc.top.
Building your sales log in UniCell, step by step
- Create a new spreadsheet in UniCell. Open the OmniDoc desktop client and start a blank UniCell spreadsheet so you control the layout from the first row.
- Type the column headers in row 1. Use Date, Order ID, Product, Channel, Quantity, Unit price, Total and Notes. Headers in the first row let you sort and filter every row that follows.
- Enter your first sale in row 2. Record one sale per row, with the date, what sold, the quantity and the price per item.
- Add a formula in the Total column. If Quantity is in column E and Unit price is in column F, type =E2*F2 in cell G2. The total updates when you correct either number.
- Copy the formula down the Total column. Fill it down to the last sale so every row calculates its own total without retyping the formula.
- Add a totals row below your data. Leave a blank row, then sum the Total column, for example =SUM(G2:G100). Make the range cover every row you expect to add, or extend it as the log grows.
- Save the file and keep a copy. Save the spreadsheet in the desktop client once you finish entering a set of sales. If you need to open the file in another spreadsheet program, confirm which formats the client saves before you share it.
Check the result
Once the log has a few weeks of sales, check the figures before you use them for decisions.
| Check | How to see it | If it's wrong |
|---|---|---|
| Totals match the source | Compare several Total cells with receipts or payment reports | Re-enter the quantity or unit price in that row |
| Formulas cover every row | Scroll to the last sale and confirm its Total is filled in | Copy the formula down the column again |
| Totals row includes all sales | Compare the sum with the rows you entered | Extend the SUM range to the last row |
| Dates sort correctly | Sort by Date and check the order | Re-enter any dates stored as text in a different format |
| Product names are consistent | Sort by Product and scan for near-duplicate names | Pick one spelling and correct the other rows |
❓ FAQ
1. Can I track sales from several shops in one spreadsheet?
Yes. Add a Channel column that names each shop, then filter by it to see one shop's totals. The totals row still covers all shops together.
2. Should I record cost as well as selling price?
Add a Unit cost column if you want to see profit on each sale. Multiply cost by quantity in a new column, then subtract that from the Total column to get the margin.
3. Do I need a template before I start?
No. The columns in this guide are enough for a basic sales log. Add more columns only when a real question needs them.
4. How do I record a refund?
Enter the refund as its own row with a negative quantity, so the Total formula returns a negative amount. Put the original order ID in Notes so you can match the two rows later.
5. Can I bring sales figures from a PDF report into my log?
If the report is a PDF, use the PDF editor in the OmniDoc desktop client to export it to Excel. Then copy the rows into your log and run the checks in the table above, because the copied figures need the same review as manual entries.
📝 Summary
A sales spreadsheet works when every sale has its own row, every total comes from a formula, and the sums match your source records. Build the log in UniCell, save it after you enter each set of sales, and review it at the end of each month. That gives you an Excel spreadsheet for sales you can rely on.
