An inventory and sales report template is a reusable way to track what stock you have, what came in, what sold, and how sales performed during a chosen period. Use the blank table below as a starting point, then adapt its columns to your products and recordkeeping process.
What an Inventory and Sales Report Shows
The report brings stock movement and sales activity together. A stock count on its own tells you what is on hand, but not why the quantity changed. A sales summary shows what customers bought, but may not reveal whether remaining stock is low or whether a stock count needs investigation. Combining the two gives a more useful view of each product over a week, month, or other defined period.
Small retailers, makers, online sellers, and storeroom managers can use a report like this to spot fast-moving items, identify products that have not sold, prepare replenishment requests, and investigate differences between recorded and counted stock. It can also give a team a consistent record to review. It is an operational tool, not a substitute for a physical count or for the accounting records required by an organization.
How the Quantities and Sales Figures Fit Together
For each product, the basic stock movement calculation is: beginning quantity + stock received − units sold + customer returns added back to stock + other adjustments = ending quantity. Adjustments can include documented damage, samples, transfers, or a correction after a count. Keep the reason for a material adjustment in the notes rather than making the number appear without explanation.
Sales dollars follow a separate calculation. Gross sales are the value of sales before deductions; net sales are gross sales less discounts and the value of returns or allowances, using the definitions your business applies consistently. A return may affect both sales and inventory, but not always in the same way: a returned item could be damaged or not yet inspected, so it might not go straight back into sellable stock.
Do not confuse sales revenue with the value of inventory on hand. A report may show both, but they answer different questions. Ending quantity multiplied by a recorded unit cost can provide an operational estimate of stock value; formal financial reporting may require a prescribed method and additional controls. If you need figures for tax filings or formal financial statements, ask a qualified professional how your rules apply.
Inventory and Sales Report Template
Blank template: enter one row per product for the same reporting period. Use a consistent unit of measure and currency, and explain unusual adjustments in the notes.
| Product ID | Product name | Beginning quantity | Received | Units sold | Returns to stock | Adjustments (+/−) | Ending quantity | Unit cost | Ending stock value | Gross sales | Discounts and returns | Net sales | Reorder point | Notes |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Sample — fictional figures: For a fictional product called Blue Mug (ID DEMO-01), beginning quantity is 20, received is 10, units sold is 8, returns to stock is 1, and adjustments are −1. Ending quantity is 22. If the recorded unit cost is $4, ending stock value is $88. At a fictional selling price of $12, gross sales are $96; with $12 in returns and no discounts, net sales are $84. The example illustrates separate stock and sales calculations; it is not a benchmark for any business.
How to Complete the Report
Prepare the report in a consistent order so another person can follow the figures. If more than one person handles stock, agree on the definitions before the first reporting period and keep the same approach unless you document a change.
- Set the period. Record its start and end dates, the date the report was prepared, and who prepared it. State the currency and whether quantities mean individual items, cases, kilograms, or another unit.
- List products clearly. Use a stable product ID or SKU where available, alongside a plain-language name. IDs help distinguish similar variants such as different sizes or colors.
- Enter opening stock and movements. Carry forward the prior period’s ending quantity as the next period’s beginning quantity. Add receipts from delivery records and sales from the same agreed source for every product.
- Record returns and adjustments separately. Distinguish returned units from damaged stock, transfers, count corrections, and other changes. Keep a note or reference to the underlying record if one exists.
- Calculate and review. Apply the stock movement formula, compare it with a physical count when appropriate, and calculate sales deductions consistently. Investigate unexpected differences instead of silently changing a figure.
- Save the report with its supporting records. A report is easier to verify when its date range, source records, and any corrections are identifiable.
Choose the Reporting Period and Level of Detail
The right reporting frequency depends on how quickly stock moves and how often decisions are made. A high-turnover product may need more frequent review than a slow-moving item. A weekly report can make short-term changes visible; a monthly report can support broader comparisons. Whatever interval you choose, use clear cut-off times so that a delivery or sale is not counted in two periods or omitted between them.
Choose a level of detail that answers real questions without making the report hard to maintain. A single-product row is useful when variants have different prices or stock levels. A category summary can help with a high-level review, but it should not replace product-level records when individual items need replenishment or investigation. If locations matter, add a location column or make separate reports for each site, and avoid mixing location totals without showing how they were combined.
Useful Measures to Add
The basic template can be extended when a team needs more than quantities and sales. Choose measures that have a clear definition and a practical use; extra columns that are never reviewed add work without improving decisions.
- Sales quantity and net sales: Show unit movement as well as money so that price changes do not obscure how many items moved.
- Gross margin: Some businesses compare sales with product cost, but the calculation depends on consistent cost and sales definitions. Treat it as a separately defined measure rather than labeling sales revenue as profit.
- Stock cover or days on hand: These estimates relate available quantity to a rate of use or sales. They can help with planning, but past demand may not predict future demand, and seasonal changes can make a simple average misleading.
- Reorder point: A threshold can flag a product for review. It should reflect replenishment time, expected demand, and the organization’s own process rather than being copied indiscriminately across every item.
- Count variance: If you conduct a physical count, show the difference between counted and expected quantities and record the follow-up action.
Common Reporting Problems
Many report errors come from inconsistent definitions rather than complicated arithmetic. For example, one period may record a customer return as a negative sale while another records it as a separate return, or a delivery may be entered on the order date instead of the date stock actually arrived. Write down the chosen treatment and apply it consistently.
Other common problems include duplicate product names, mixed units, missing dates, and formulas copied incorrectly in a spreadsheet. A case of 12 items should not be added to a quantity of individual items without conversion. Likewise, a product variant should not be combined with another variant if their stock or sales need to be managed separately. Check totals against the underlying sales and receiving records, and protect formula cells if several people edit the file.
Negative stock is a signal to investigate, not automatically proof of theft or a bad count. Possible explanations include delayed receiving entries, sales recorded against the wrong product, timing differences, or a genuine counting error. Review the transactions around the date the discrepancy began, document any correction, and preserve the original information where your process requires an audit trail.
Finally, do not treat an inventory value as a cash figure or assume that a large sales total means an item is profitable. Costs, discounts, returns, damaged stock, and other expenses may affect the wider picture. The report is most reliable when its scope is clear and readers know which measures it does—and does not—include.
Paper, Spreadsheet, or Inventory System?
A printable sheet works for a small assortment or a one-time count, especially when someone needs to walk through a stockroom and record quantities by hand. It is simple to share, but totals and comparisons usually require manual work, and handwriting can be hard to interpret. A spreadsheet makes formulas, sorting, and period-to-period comparisons easier, though it depends on careful data entry and version control.
A dedicated inventory system may suit a larger range of products, multiple locations, or frequent transactions because it can organize item records and movement history. It also requires setup and reliable procedures; using software does not automatically make source data accurate. The practical choice is the least complicated format that your team can keep current, check, and understand.
Frequently Asked Questions
What should an inventory and sales report include?
At minimum, include the reporting period, product identifier and name, beginning quantity, stock received, units sold, returns, adjustments, ending quantity, and a note field. Add sales amounts, costs, reorder points, or location details if they serve a specific review task.
How do I calculate ending inventory quantity?
Add beginning quantity and stock received, subtract units sold, then add returns placed back into stock and other positive or negative adjustments. Compare the result with a physical count when one is performed, and record how any difference was handled.
Can one report track both inventory and sales?
Yes. Keep stock quantities and sales amounts in distinct columns because they measure different things. Use a consistent period and product identifier so the two kinds of activity can be compared without treating revenue as stock value.
How often should I prepare an inventory and sales report?
Use a frequency that matches how quickly stock changes and how often decisions are needed. Some teams review selected products more often and prepare a full summary less frequently. Set clear period cutoffs and apply them the same way each time.
What is the difference between gross sales and net sales?
Gross sales generally describe sales before deductions, while net sales subtract discounts and returns or allowances according to the reporting definitions being used. State those definitions on the report or in its instructions, especially if different people will prepare it.
Can I use this template for several locations?
Yes. Add a location field or make separate copies for each site, then label any combined totals clearly. Keep product IDs and units consistent across locations so that totals can be reconciled and transfers are not mistaken for new purchases or sales.