Inventory and COGS Excel Spreadsheet
Originally published: 02/02/2018 14:31
Publication number: ELQ-32615-1
View all versions & Certificate
certified

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

Second Half Dreams offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.5 / 5 (66 votes)

please wait...