Yes, a free Excel sales tracking template in .xls format is available from Microsoft’s official template gallery (Office.com/templates) and many reputable third-party sites, and it typically includes columns for date, product, customer, quantity, unit price, and total. These templates are pre-built spreadsheets with formulas already set up, so you can start logging sales immediately and see totals, averages, and sometimes simple charts without building anything from scratch.
Why Use a Sales Tracking Template Instead of a Blank Spreadsheet
A blank Excel workbook gives you total freedom, but it also gives you a blank page and no structure. A sales tracking template saves time because the headers, formulas, and formatting are already in place. Instead of writing =SUM(D2:D100) yourself, the template does it for you. For a small business owner, freelancer, or sales rep, the difference is often an hour of setup versus five minutes of entering data.
Templates also reduce errors. When you build your own, it’s easy to forget a formula or misalign a column. A well-designed template includes data validation (like dropdown lists for product names) and conditional formatting (like highlighting sales below target in red), which you might not know how to set up. Even if you do know, the template saves you the effort.
What a Standard Sales Tracking Template Includes
Most free Excel sales templates follow a similar layout. The main sheet, usually called “Sales Log” or “Data,” has columns for:
- Date – the sale date, often formatted as a date (e.g., 03/15/2025).
- Product/Service – what was sold, sometimes with a dropdown list.
- Quantity – number of units sold.
- Unit Price – price per unit.
- Total – calculated as Quantity × Unit Price, using a formula like
=C2*D2. - Customer – who bought it (optional).
- Sales Rep – who made the sale (optional).
- Status – e.g., Paid, Pending, Delivered (optional).
A second sheet, often called “Summary” or “Dashboard,” uses formulas to pull totals from the log. For example, with data in rows 2 to 100, a summary cell might show total revenue with =SUM(E2:E100) or total units with =SUM(C2:C100). Many templates also include a simple bar chart that updates as you add rows.
Where to Download a Safe, Free .xls Template
The safest source is Microsoft’s own template gallery. In Excel, click File > New and type “sales tracking” in the search box. You’ll see options like “Sales Register,” “Sales Tracker,” or “Monthly Sales Report.” These are officially vetted and open directly in Excel. You can also visit Office.com/templates in a browser and download the .xlsx (modern) or .xls (legacy) file. The .xls format is older but still supported by Excel 365.
Third-party sites like Vertex42, Smartsheet, and Template.net also offer free templates. These are generally safe, but be cautious: avoid sites that force you to download a .zip or require an email address before showing the file. Always scan downloaded files with your antivirus software. If a site asks you to enable macros, be wary—most simple sales templates don’t need macros. Only enable macros if you trust the source and know what the macro does.
How to Use the Template: Step-by-Step
- Open the template in Excel (File > Open). If it’s .xls, Excel will open it in compatibility mode; that’s fine.
- Review the sheets – click the tabs at the bottom. Usually there’s a “Read Me” or “Instructions” sheet first. Read it.
- Enter your products or services – if there’s a dropdown list, go to the sheet that defines the list (often called “Lists” or “Settings”) and type your items. For example, if you sell coffee, list “Espresso,” “Latte,” “Cappuccino.”
- Start logging sales – in the Sales Log sheet, begin typing in row 2. For each sale, fill in the date, product, quantity, and price. The Total column should calculate automatically if the template has formulas.
- Check the summary – after a few entries, look at the Summary sheet. Totals should update. If they don’t, the template might have formulas that need to be dragged down, or you might be entering data in the wrong columns.
If the template doesn’t have a Total formula, you can add one yourself. In cell E2 (assuming Total is column E), type =C2*D2 and press Enter. Then click the cell, grab the fill handle (the small square at the bottom-right corner), and drag down to fill the formula for all rows.
Common Problems and How to Fix Them
The most frequent issue is that formulas don’t auto-fill for new rows. Many free templates only have formulas in the first few rows, so when you add row 101, the Total column is blank. To fix it, copy the formula from the row above. For example, if E100 has =C100*D100, click E101, type =C101*D101, or simply copy E100 and paste into E101.
Another problem is that the summary doesn’t include new rows. If the summary uses =SUM(E2:E100), it won’t count row 101. You have two options: update the range to =SUM(E2:E1000) to cover more rows, or convert your data range into an Excel Table. To do that, click anywhere in your data, press Ctrl+T (Mac: Cmd+T), and confirm. Then use structured references like =SUM(Table1[Total]) in the summary, which automatically expands as you add rows.
If dates appear as numbers (like 45678), the cell format is wrong. Select the date column, right-click, choose Format Cells, then pick a date format under the Number tab. On a Mac, the path is the same: right-click > Format Cells > Date.
Comparing Free Templates vs. Paid vs. DIY
Free templates are great for basic tracking, but they have limits. They rarely include advanced features like inventory integration, customer relationship management (CRM) fields, or multi-currency support. If you need those, you have two options: pay for a premium template (often $10–$50) or build your own.
Building your own is more work but gives you full control. You’d start with a blank workbook, create headers, and write formulas like =SUMIF for totals by product. For example, with products in A2:A100 and totals in E2:E100, you could use =SUMIF(A2:A100,"Latte",E2:E100) to get total latte sales. That’s a simple but powerful addition.
If you have Microsoft 365, you can also use modern functions like SUMIFS (for multiple criteria) or FILTER to create dynamic reports. For instance, to list all sales above $500, you could use =FILTER(A2:E100,E2:E100>500). These functions require Excel 2021 or Microsoft 365, so they won’t work in older .xls files.
Frequently Asked Questions
Can I use a .xls template in Google Sheets?
Yes. Upload the .xls file to Google Drive, then open it with Google Sheets. Most basic formulas and formatting convert fine, but some advanced features like macros or certain conditional formatting rules may not work. If you plan to use Google Sheets regularly, it’s better to search for a Google Sheets template instead, since the functions and menu paths differ.
How do I add a new product to the dropdown list?
Look for a sheet named “Lists” or “Settings.” The dropdown source is usually a range on that sheet. Add your product name to that list, and the dropdown in the Sales Log will update automatically. If you don’t see a Lists sheet, the dropdown might be hardcoded. In that case, select the cells with the dropdown, go to Data > Data Validation, and change the Source range to include your new item.
Why is my total column showing #VALUE! or #DIV/0!?
#VALUE! usually means the formula is trying to multiply text. Check that Quantity and Unit Price cells contain numbers, not text like “two.” #DIV/0! appears when a formula divides by zero, which is rare in a simple sales log but might occur if you have a percentage or average formula. To fix, check the formula and ensure the divisor isn’t blank or zero.
Can I track sales by month automatically?
Yes. Use the SUMPRODUCT function or a pivot table. For a simple monthly total, assuming dates in A2:A100 and totals in E2:E100, you can use =SUMPRODUCT((TEXT(A2:A100,"mmm")="Jan")*E2:E100) to get January’s total. A pivot table is even easier: select your data, go to Insert > PivotTable, drag Date to Rows, and Total to Values, then group the dates by month.
Is it safe to download a template from a random website?
Generally, no. Stick to Microsoft’s official gallery or well-known sites like Vertex42. If you must use a random site, scan the file with antivirus before opening. Also, never enable macros unless you’re certain the template is safe—macros can contain harmful code. For basic sales tracking, you don’t need macros at all.
What if I need to track more than just sales, like expenses?
Look for a “Sales and Expense Tracker” template, which includes both income and expense columns. Alternatively, you can add a column for “Type” (Sale or Expense) and use SUMIF to total each separately. For example, with Type in F2:F100 and Amount in E2:E100, use =SUMIF(F2:F100,"Sale",E2:E100) for sales and =SUMIF(F2:F100,"Expense",E2:E100) for expenses.
Related
- Excel Power Query Background Refresh Explained
- Excel Power Query: Get Data From Folder
- Excel: Count Cells with Specific Text
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Slicer Not Updating? Fixes for PivotTables and TablesIf an Excel slicer is not updating, first refresh the PivotTable or source data, then check that the…
- Invoice and Packing List Template in Excel: What to IncludeYes. An invoice and packing list template in Excel can be made as two clearly labeled worksheets in…
- Best Way to Record a PowerPoint PresentationFor most people, the best way to record a PowerPoint presentation is to use PowerPoint’s built-in recording tools,…
- Microsoft Word: How to Add FootnotesTo add a footnote in Microsoft Word, place the cursor where its reference number should appear, then choose…
- Google Sheets Unix Timestamp to Date Conversion GuideTo convert a Unix timestamp in Google Sheets, divide seconds by 86,400 or milliseconds by 86,400,000, then add…
- How to Set an Out of Office Reply in OutlookTo set an out-of-office reply in Outlook, open Automatic Replies, turn them on, write your message, and—if available—choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.