
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.
Description
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 Best Practice includes
1 Inventory and COGS Excel Spreadsheet
Reviews
4.5 / 5 (50 votes)- 80%
- 6%
- 6%
- 4%
- 4%
- Rate this Downloadable Tool
Write a review
Tori Ramsey(last updated: 04/12/2019 01:20)
abbas abasov(last updated: 02/12/2019 14:52)
Rahul Banerji(last updated: 20/11/2019 20:15)
Michelle Murphy(last updated: 20/11/2019 19:36)
Oscar Serrano(last updated: 11/11/2019 02:59)
CPA Richard Karichia Mbaabu(last updated: 25/10/2019 07:50)
Ali issa(last updated: 20/10/2019 14:45)
Diane Mitchell(last updated: 15/10/2019 18:18)
Chris Crenshaw(last updated: 15/10/2019 18:04)
Momodou .D. Faal(last updated: 10/10/2019 11:50)
Darrin Dyches(last updated: 02/10/2019 20:15)
Dee Smith(last updated: 01/10/2019 00:48)
greeneco(last updated: 21/09/2019 03:56)
mwangi kaigi(last updated: 13/09/2019 18:07)
Tibor Rusiňák(last updated: 12/09/2019 21:26)
Rony Medina(last updated: 11/09/2019 15:22)
Afnan Abu Zanuna(last updated: 06/09/2019 18:17)
zakaria chaklader(last updated: 02/09/2019 08:27)
its so helpful. thanksits so helpful. thanksJohnny Poonan(last updated: 30/08/2019 07:53)
Prince Chakax(last updated: 09/08/2019 12:05)
Ibrahim Farouk(last updated: 05/08/2019 19:10)
fine jesulewami(last updated: 26/07/2019 18:39)
Ricardo Mantovani Assis(last updated: 26/07/2019 11:51)
Excellent modelExcellent modelمحمد جمال749(last updated: 23/07/2019 13:44)
Agung Widodo(last updated: 23/07/2019 02:27)
PapaGood(last updated: 31/05/2019 23:47)
Jared Addo(last updated: 22/05/2019 14:32)
Eslam Elshrkawy(last updated: 11/05/2019 20:25)
Brett Effman(last updated: 01/05/2019 02:00)
Dan Rosen(last updated: 04/04/2019 14:11)
People using this Best Practice also downloaded
Retail Inventory and Sales Workbook
Inventory and Sales Excel Template Workbook for Retail.salesexcelspreadsheettrackingretail2,101Discussadd_shopping_cartfreeby Vend
OKR, PPP and KPI manager Excel Model for small startup teams
This guide and spreadsheet is to help teams of up to 20 members manage their KPIs, OKRs, & PPPs.performancekpiexcelspreadsheetppp1,867Discussadd_shopping_cartfreeby Alexander Jarvis
Inventory Food Cost Calculator
This can be used to track all of your numbers at the end of the month and confirm those of the accounting function.accountingcalculatorexcelspreadsheetnumbers430Discussadd_shopping_cartCost of Goods Manufactured Excel Model Template
Excel model for scheduling the cost of good manufactured for your businesscogscost of goods soldinventorycost of goods manufacturedcogm4,412Discussadd_shopping_cartfreeby CFI
Cryptocurrency Portfolio Tracker
Cryptocurrency Portfolio Tracker in Excel that updates prices and produces a pie chart.excelspreadsheettrackingbitcoinfintech432Discussadd_shopping_cartfreeby Prks21
Used Car Dealership - 5 Year Pro-Forma Excel Financial Model
A bottom up financial model to forecast the revenue, expenses, and cash flows of a used car dealership startup business.cogsp&lcash flowfinancial modelpro forma1,127Discussadd_shopping_cart$45.00by Jason Varner
Property Plant And Equipment (PPE) Schedule - Excel Model Template
This is a PP&E schedule template to help your business keep up with balances and depreciation costs.businessmodeltemplateexcelspreadsheet144Discussadd_shopping_cartfreeby Wall Street Oasis
How to Make Your Financial Model Look Professional
This tool provides Before and After examples to show you how you can make your models look professional.modelinginvestorsfundraisingfinancial modelingexcel452Discussadd_shopping_cartfreeby Alexander Jarvis
Powerful and Customizable Debt Module Excel Model
Powerful, highly customization and free debt calculations module.debtinterestexcelspreadsheetprincipal753Discussadd_shopping_cart$19.00by Alex Martyanov
Hotel Investment Appraisal Excel Model Template
Download this read-to-use Hotel Investment Appraisal to help assess the viability of an investment into a hotel.investmentfinanceexcelspreadsheethotel692Discussadd_shopping_cart$49.00by Mahender K. Punhani
Related categories
Any questions on Inventory And COGS Excel Spreadsheet?
The user community and author are here to help. Go ahead!