Publication number: ELQ-32615-1
View all versions & Certificate
Inventory and COGS Excel Spreadsheet
Created for the purpose of tracking your Amazon Inventory purchases and Cost of Goods Sold.
This spreadsheet was originally built by Amazon seller, Second Half Dreams to keep track of inventory purchases and cogs, however it can be used for other selling purposes outside of Amazon and adapted for use.
Before you begin to use, you should keep the following things in mind:
-Basic Excel knowledge required.
-This spreadsheet has been mainly created for those who do not have the amount of sales or volume to subscribe to Inventory Lab or other Inventory tracking software. You will find that at a certain point you will outgrow this spreadsheet.
-This sheet will not track your income and expenses.
For the spreadsheet:
Monthly tabs are included. For each month you can add what
what you bought and what you sold. If you bought an item in February it should go in the February tab. If you sold something in February, it should also go in the February tab.
You'll find your purchases in your store receipts.
Two separate lists have been created for inventory bought and inventory sold. This is because a combined lists stops working out when you're in your second month of selling.
*Originally shared on SecondHalfDreams.com*
This business tool includes
1 Inventory and COGS Excel Spreadsheet
Second Half Dreams offers you this business tool for free!
download for free
Add to bookmarks
- Luis Manuel González Nieto(last updated: 29/01/2019 19:56)
- Rio Azul Ciência(last updated: 14/01/2019 22:07)
- Dominique Shavonne(last updated: 21/12/2018 23:13)
- Bimo Aryo Saputro(last updated: 04/12/2018 09:22)
- Hossam EL-Zarow(last updated: 01/11/2018 08:44)
- Randy Perkins(last updated: 22/10/2018 10:57)
- Daniel Osvald(last updated: 24/09/2018 08:09)
- Margery Llanes(last updated: 05/09/2018 06:22)
- Janel Turner(last updated: 05/09/2018 02:43)
- Mohamed Sururr(last updated: 15/08/2018 14:17)
- Charles Ekebire(last updated: 10/08/2018 20:58)
- Anil Kumar922(last updated: 31/07/2018 10:14)
- padam Gusain(last updated: 27/07/2018 07:28)
- Esther Fairrow(last updated: 16/07/2018 02:53)
- Piet Potgieter(last updated: 18/06/2018 05:31)
- Nicole Robertson(last updated: 13/05/2018 14:32)
People using this tool also downloaded
Retail Inventory and Sales WorkbookInventory and Sales Excel Template Workbook for Retail.salesexcelspreadsheettrackingretailformulaeworkbookinventoryautomated982 remove_red_eyefreeby Vend
OKR, PPP and KPI manager Excel Model for small startup teamsThis guide and spreadsheet is to help teams of up to 20 members manage their KPIs, OKRs, & PPPs.performancekpiexcelspreadsheetpppokrtrackingready to usetracker961 remove_red_eye
Inventory Food Cost CalculatorThis can be used to track all of your numbers at the end of the month and confirm those of the accounting function.accountingcalculatorexcelspreadsheetnumbersinventoryfiguresfood costtransfersmonth end226 remove_red_eye
Cost of Goods Manufactured Excel Model TemplateExcel model for scheduling the cost of good manufactured for your businesscogscost of goods soldinventorycost of goods manufacturedcogmproduct costingraw material1,075 remove_red_eyefreeby CFI
Cryptocurrency Portfolio TrackerCryptocurrency Portfolio Tracker in Excel that updates prices and produces a pie chart.excelspreadsheettrackingbitcoinfintechcryptocurrecyportfliokeeping track245 remove_red_eyefreeby Prks21
Hotel Investment Appraisal Excel Model TemplateDownload this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotelappraisal235 remove_red_eye$89.00by Mahender K. Punhani
Calculator to Determine the Capacitor kVARCalculator is Excel used to determine the capacitor kVAR needed to improve PF of a single load/entire power system.calculatorexcelspreadsheetelectrical engineeringcapacitor calculator323 remove_red_eyefreeby Square D
Discount Cash Flow Template in ExcelThis is a discounted cash flow (DCF) template with income statement, balance sheet, FCF calculation & FV calculation.valuationcash flowdcfinvestordiscounted cash flowexcelspreadsheetmodellingvaluation methods257 remove_red_eyefreeby Andrew Han
Excel Custom Format Cheat SheetTeaching you how to do excel custom format so that you're able to improve your spreadsheets with handy tips and tricks.excelspreadsheetcustom formattips and tricks86 remove_red_eye
Social Media Startup ValuationTool to help you calculate Social Media valuation when looking to calculate overall business valuation.toolvaluationfundraisingsocial mediaexitexcelspreadsheet153 remove_red_eye
Any questions on Inventory And COGS Excel Spreadsheet?
The user community and author are here to help. Go ahead!