Inventory and Sales Tracking In Excel For Amazon and Ebay | Chris Benjamin | Skillshare

Inventory and Sales Tracking In Excel For Amazon and Ebay

Chris Benjamin, Instructor, MBA and CFO

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
17 Videos (1h 50m)
    • 038ITIE Section 01a Course Introduction

    • 038ITIE Section 01b Instructor Introduction

    • 038ITIE Section 01c Introduction To Excel

    • 038ITIE Section 02a Introduction To Layout

    • 038ITIE Section 02b Labels Part 1

    • 038ITIE Section 02c Labels Part 2

    • 038ITIE Section 02d Labels Part 3

    • 038ITIE Section 02e Labels Part 4

    • 038ITIE Section 03a Data Entry Part 1

    • 038ITIE Section 03b Data Entry Part 2

    • 038ITIE Section 03c Data Review Part 1

    • 038ITIE Section 03c Data Review Part 2

    • 038ITIE Section 03d Data Review Part 3

    • 038ITIE Section 04a Summary Tab P&L

    • 038ITIE Section 04b Summary Tab Profit by Website

    • 038ITIE Section 04c Review of Summary Tab and Addl Ideas

    • 038ITIE Section 05a Course Conclusion


About This Class

Template Included! Build an inventory and sales tracking spreadsheet for your Amazon, Ebay, Etsy or other business

** New Course for 2018! **

As a seller on Amazon, Etsy, Ebay or any other platform, you can certainly appreciate the difficulty in keeping track of everything.  What inventory do you have on hand, what is listed online for sale, what has sold and needs to ship, what is shipped, what are you waiting payment for, and much more.  Having run my own online business before, i can appreciate how complex it can be the busier you are.  

At the end of the course, you will have an powerful tool and the knowledge to really take control of your business.  If you decide to not build your own, I provide the template we build in the course as well for you to download!

In this course you will learn how to take control of your inventory tracking issues and also knowing how much you are truly making.  We will build an entire inventory, cost and sales tracking spreadsheet from scratch.  Starting with a blank workbook, by the end of the course you will have a fully functioning inventory tracking spreadsheet and much more:

What We Do In The Course:  

  • Learn best practices for tracking your Amazon, Ebay, Etsy or other store results
  • Learn basic Microsoft Excel functions and formatting that we will then use in the course
  • Start with a blank workbook and structure a framework for our tracking spreadsheet
  • Determine what fields we need to include to successfully track our inventory, sales and costs
  • Create methods and tools to quickly sort and organize data for quick results and answers to questions such as
    • What items do we have listed currently
    • What do we need to ship
    • What has sold but hasn't been paid
    • How much did we spend this month/quarter/year on inventory
    • How much in sales did we do this month/quarter/year
  • And Much More!

After taking this course, you will feel empowered to successfully run your Ebay, Amazon, Etsy or other business much more successfully!

At any point if you have a question, please feel free to ask through the course forum, I'd be happy to answer any and all questions.  

Chris Benjamin, MBA & CFO is a seasoned professional with over 20 years experience in accounting, finance, and online sales on platforms such as Amazon, Etsy, Ebay and others  Having spent the first 10 years of my career in corporate settings with both large and small companies, I learned a lot about the accounting process, managing accounting departments, financial reporting, external reporting to board of directors and the Securities and Exchange Commission, and working with external auditors.  

The following 10+ years I decided to go into CFO Consulting, working with growing companies and bringing CFO level experience to companies.  I help implement proper best business practices in accounting and finance, consult on implementation of accounting systems, implementing accounting procedures, while also still fulfilling the CFO roll for many of my clients which includes financial reporting, auditing, working with investors, financial analysis and much more.  

Thank you for signing up for this course. I look forward to being your instructor for this course and many more!

Chris Benjamin, Instructor, CFO & MBA





  • --
  • Beginner
  • Intermediate
  • Advanced
  • All Levels
  • Beg/Int
  • Int/Adv


Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Chris Benjamin

Instructor, MBA and CFO

Report class