Inventory Worksheet and Sales Worksheet all in one
This worksheet doesn’t apply state tax on services.
Inventory and Sales Worksheet includes tabs or sheet to track inventory and sales for the following type of business activities:
Private label
Resell (resale)
Print on Demand
Digital Products
Handmade
If you want to design a spreadsheet to track your inventory, you could.
The main goals are to track:
Inventory at the beginning of the year
Inventory of purchases during the year
Revenue and Cost of goods sold during the year
Inventory at year end.
However, when you have more than one business activities including private label, resale, Print on Demand, digital products, and handmade that incudes tracking raw materials, out of inventory, and finished products, and you want to track them all in one workbook, things become more complicated.
If you have less products to inventory, you might find our simpler inventory-sales spreadsheet the best suited for your business model to start with.
State Sales Tax Return and Form 1125-A Cost of Goods Sold
Some states have sales tax exemptions on services.
Some state applies sales tax on physical products and some services.
If you sell digital downloads and physical products on your own website where you are required to collect your state sales tax for purchases incurred within your state, you could use this worksheet to record, sales tax on physical products but exempt tax on services.
This worksheet can be helpful to fill your State Sales Tax Return and Form 1125-A Cost of Goods Sold if you keep your record up to date.
Free Inventory and Sales Worksheet F23D1
Download it here.