Yes. An epoxy resin sales inventory spreadsheet can track products, incoming stock, sales, reorder points, and batch details in one Excel workbook. Start with separate Products, Receipts, and Sales sheets, then calculate stock on hand as opening quantity plus received quantity minus sold quantity.
What the spreadsheet should track
Epoxy inventory has a few needs that a basic list of product names and quantities will miss. Resin and hardener may be sold as a matched kit, sold separately, or received in different package sizes. Pigments, fillers, molds, and protective supplies may also be part of the same catalog, but they are not interchangeable with resin stock. Give each sellable product a unique SKU and record the unit of measure consistently, such as kit, bottle, kilogram, or pair.
A useful workbook separates product information from stock movements. The Products sheet holds one row per SKU and its current summary. Receipts records each delivery, while Sales records each item sold. This makes it easier to trace where a balance came from than repeatedly overwriting a quantity in a single stock cell.
- Products: SKU, product name, product type, unit, opening quantity, reorder point, planning unit cost, and calculated stock totals.
- Receipts: date received, SKU, supplier, batch or lot number, expiry or recommended-use date if supplied, quantity, and unit cost.
- Sales: sale date, order number, SKU, quantity, selling price per unit, line total, and lot number when you need lot-level traceability.
Choose whether quantities represent individual containers or complete kits before entering data. If one sale is a two-part kit, the spreadsheet should treat that kit as one SKU only if the stock is actually managed and sold as a kit. If resin and hardener are tracked separately, record them as separate SKUs and ensure a kit sale reduces the correct quantities for both components.
Set up the core stock calculations
In Excel for Microsoft 365 on Windows, create the three sheets and enter the column headings on row 1. On Products, use columns A through L for SKU, Product, Type, Unit, Opening Qty, Reorder Point, Planning Unit Cost, Received, Sold, On Hand, Status, and Planning Stock Value. On Receipts, use columns A through G for Date, SKU, Supplier, Lot, Use-By Date, Qty, and Unit Cost. On Sales, use columns A through G for Date, Order No., SKU, Qty, Price Each, Line Total, and Lot.
With Products SKU in A2, Opening Qty in E2, and Reorder Point in F2, enter the following in Products!H2 to total receipts for that SKU from Receipts rows 2 through 1000. For example, if SKU ER-KIT-01 has received 12 units, the result is 12.
=SUMIF(Receipts!$B$2:$B$1000,A2,Receipts!$F$2:$F$1000)
With Products SKU in A2 and Sales SKU in C2:C1000, enter this in Products!I2 to total units sold. If two sales rows contain 3 and 2 units of ER-KIT-01, the result is 5.
=SUMIF(Sales!$C$2:$C$1000,A2,Sales!$D$2:$D$1000)
With opening quantity in E2, received quantity in H2, and sold quantity in I2 on Products, enter this in J2 for the current calculated balance. If opening stock is 8, receipts are 12, and sales are 5, the result is 15 units.
=E2+H2-I2
With On Hand in J2 and Reorder Point in F2 on Products, enter this in K2 to flag stock at or below the threshold. If 15 units are on hand and the reorder point is 6, the result is In stock; at 6 or fewer, it returns Reorder.
=IF(J2<=F2,"Reorder","In stock")
With On Hand in J2 and Planning Unit Cost in G2 on Products, enter this in L2 for an estimated planning value. At 15 units and a planning cost of $18 per unit, the result is $270.
=J2*G2
With quantity in Sales!D2 and price per unit in Sales!E2, enter this in Sales!F2 to calculate the line total. A sale of 3 units at $24 each returns $72.
=D2*E2
Copy each formula down the relevant column. The example ranges stop at row 1000; extend them if the workbook grows. For a more maintainable setup, select each data range and choose Insert > Table, then use table formulas that fill down automatically. Keep SKU spelling consistent across sheets: an extra space or a slightly different code can make a SUMIF total incorrect.
Record batches, shelf life, and product details
Epoxy products are often supplied with manufacturer, batch, storage, and shelf-life information. Capture the lot number on each receipt rather than keeping only the latest lot on the Products sheet. If an issue arises with a particular batch, a receipt log can help identify which stock arrived together and which orders used it, provided sales are also recorded by lot.
Do not assume every product has the same expiry rule, or that a date printed on a label means the product becomes unusable on that exact day. Follow the supplier’s product documentation for storage conditions and dating. If a supplier does not provide a relevant date, leave the field blank rather than inventing one. A spreadsheet date is a tracking aid, not a substitute for the product label or technical data sheet.
For careful lot control, make one row per product lot on a separate Lots sheet, with SKU, lot number, receipt date, quantity received, remaining quantity, and supplier date information. Record the lot used on each sale or production issue. A simple SKU-level balance can show that 20 units remain while concealing that 18 are from an older lot and 2 are from a newer one. Businesses that require strict first-in, first-out handling should maintain lot-level balances instead of relying only on total SKU stock.
Make the sheet easier to use
Convert each input range into an Excel table with Insert > Table, and confirm that the table has headers. Tables make filtering and sorting easier and generally extend formatting and formulas as new rows are added. Use clear sheet names and freeze the top row with View > Freeze Panes > Freeze Top Row so column headings remain visible while scrolling.
- Use Data > Data Validation to provide a dropdown of approved SKUs in the Sales and Receipts sheets. This reduces typing differences.
- Format dates as dates, quantities as numbers, and selling prices and costs as currency. Keep quantity units explicit in the Unit column.
- Use Home > Conditional Formatting > Highlight Cells Rules to color low stock or overdue dates. A visual alert should supplement, not replace, checking the underlying values.
- Protect formula columns from accidental edits if several people enter transactions, while keeping entry columns editable.
- Keep a dated backup. If the workbook is stored in OneDrive or SharePoint, version history may help recover earlier copies, but a separate backup policy is still useful.
Microsoft 365 for Windows includes XLOOKUP, FILTER, and other newer functions, but the basic SUMIF and IF formulas above avoid requiring them. The ribbon labels and formulas are broadly similar in Excel for Mac, though some dialog layouts and keyboard shortcuts differ. Excel for the web has many of the same features, but some desktop controls are presented differently.
What the numbers mean—and do not mean
The On Hand result is only as reliable as the records entered. It is a calculated book balance, not a physical count. Record receipts when stock is accepted, sales when inventory leaves, and any returns, damaged goods, samples, spills, or internal-use quantities as adjustments. If those events are omitted, the spreadsheet can show stock that is not actually available.
Planning Stock Value is quantity multiplied by the entered planning cost. It can help with purchasing estimates, but it is not automatically an accounting inventory valuation. Costs can vary by supplier, freight, discounts, and purchase date; accounting treatment may also depend on the business and applicable rules. Do not present this simple estimate as a tax figure or formal financial statement value. For bookkeeping or tax reporting, check the appropriate records and consult a qualified professional.
Likewise, a reorder point is a prompt to review purchasing, not an automatic purchase recommendation. Set it using actual sales pace, supplier lead time, minimum order quantities, storage limits, and the risk of product aging. A popular resin with a long delivery lead time may need a different threshold from a slow-moving pigment that is easy to replace.
Common spreadsheet problems
A frequent error is mixing units. If receipts are entered in kilograms but sales are entered in bottles, subtracting the two quantities produces a meaningless balance. Either track separate SKUs and units or define a reliable conversion process and record it consistently. Do not convert a kit into component quantities silently; make the kit contents and stock reduction explicit.
Another common problem is deleting or editing old transaction rows to “fix” a balance. That removes the audit trail and may change totals unexpectedly. Correct a transaction with a clearly documented adjustment or reversal row instead, and keep the original information where practical. Also check for duplicate sales imports, negative quantities, misspelled SKUs, and dates entered as text.
If the spreadsheet reports more stock than a shelf count, compare the latest physical count with the calculated balance and investigate the difference. Common causes include unrecorded samples, damage, order cancellations, returned goods, or sales entered twice. Set a regular count schedule appropriate to the business and document adjustments rather than changing the opening balance without explanation.
When to move beyond a spreadsheet
A workbook is often a reasonable starting point for a small catalog and a modest number of transactions, especially when one person controls data entry. It becomes harder to manage when several staff edit at once, orders arrive through multiple sales channels, stock is held in several locations, or lot traceability and permissions are essential. At that point, inventory software or an integrated point-of-sale system may reduce duplicate entry and provide better user controls.
Before switching, list the requirements that are genuinely important: multiple warehouses, kit-component deductions, barcode scanning, purchase orders, lot tracking, sales integrations, and exports for bookkeeping. Compare those needs with the spreadsheet’s actual limitations, not just the size of the product list. Keep an export or backup of the workbook during any transition and reconcile starting quantities before relying on the new system.
Frequently Asked Questions
Can I use one spreadsheet for resin, hardener, and complete kits?
Yes, if each item has its own SKU and unit, and the stock rules are clear. If a kit consumes separate resin and hardener inventory, record that deduction for both components or use a system that supports bill-of-materials logic; merely recording the kit sale will otherwise overstate component stock.
How do I calculate epoxy resin stock on hand?
For each SKU, add the opening quantity and recorded receipts, then subtract recorded sales and other stock reductions. Reconcile the result with physical counts because a formula cannot account for unentered damage, samples, or stock movements.
Should I track batch numbers in the inventory spreadsheet?
Track them when supplier or business requirements make traceability useful. Record the lot on receipt and, if you need to trace sales, record which lot was supplied for each order. A product-level total alone does not identify the source lot of remaining stock.
Can this workbook tell me the official value of my inventory?
Not by multiplying quantity by a single planning cost. That calculation is a helpful estimate, but actual inventory valuation may require a defined cost method and complete purchase-cost records. Check with a qualified accounting professional for reporting requirements.
What should I do if the spreadsheet balance does not match a stock count?
Check for missing or duplicated receipts and sales, unit mismatches, returns, samples, damage, and data-entry errors. Record a dated, explained adjustment after investigating, then review the entry process so the same discrepancy is less likely to recur.
Safe handling and recordkeeping
An inventory sheet should not replace safe-work procedures. Keep current supplier safety data sheets accessible, follow product-label directions for storage and handling, and make sure employees know the applicable workplace procedures and protective equipment requirements. Do not store sensitive customer or payment information in a general inventory workbook. Limit access to business records, keep backups, and separate operational inventory data from confidential order details whenever possible.
Related
- How to Embed a Video in Canva PowerPoint
- Home Budget Spreadsheet: Build a Clear Monthly Plan
- Excel Online CSV Import: Steps, Settings, and Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- PowerPoint Text Transitions: Add and Control AnimationsTo make text appear, move, or fade in PowerPoint, select its text box and choose an effect from…
- Excel 365 Password Protection: How to Do It SafelyTo password-protect an entire Excel 365 workbook on Windows, open it and choose File > Info > Protect…
- How to Indent in an Excel Cell for Clearer LayoutsTo indent text in an Excel cell, select the cell or range, then choose Home > Increase Indent…
- Create Rules in Outlook Mobile: App and Browser GuideTo create a rule for Outlook mail, first check whether your Outlook mobile app offers a Create rule…
- Excel Reverse Worksheet Order: How to Do ItTo reverse worksheet tab order in Excel for Microsoft 365 on Windows, drag the sheet tabs into the…
- How to Undo a Sort in Google SheetsTo undo a sort in Google Sheets, press Ctrl+Z on Windows or Chromebook, or Command+Z on Mac, immediately…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.