Inventory Sales List for an Ecommerce Website & ebay Calculator

Need to track your completed sales and current inventory for an Ecommerce website like ebay? Follow along as we build the only Inventory Sales List for an Ecommerce website you will ever need.

Bonus - Also included, how to create an ebay calculator.

**I am not a financial advisor or a CPA. Do not use this video as financial advise.**

RESOURCES
- Get the Inventory Sales List for an Ecommerce Website & ebay Calculator on my Etsy shop: https://www.etsy.com/listing/1631590851/inventory-sales-list-for-an-ecommerce?ref=listings_manager_grid

TIMESTAMPS
0:00 Introduction
0:10 Dashboard Overview
0:51 Building Percentage Fees for Ecommerce websites like ebay
2:55 Adding Sales Tax
3:29 Inventory Sales List
5:13 Drop-Down List
5:54 Sales tax function using a SUM Function
6:59 Why you need to lock your cells sing F4
7:49 Populating a Function only if data is available using an IF Function
9:10 Market Fee - What is an INDEX Function and how to make one
10:43 Market Fee - What is a MATCH Function and how to make one
11:52 Market Fee - Using an INDEX MATCH Function
12:52 Market Fee - Combining the INDEX MATCH Function with the SUM Function
13:45 Market Fee - Wrap up
15:31 IFERROR Function
16:21 Net Profit - Using SUM Function and IFERROR Function
17:32 Cleaning up Inventory Sales List
18:40 ebay (Ecommerce) Calculator
21:03 ebay (Ecommerce) Calculator - Pie Chart
22:07 ebay (Ecommerce) Calculator - Dynamic Chart Title
23:11 ebay (Ecommerce) Calculator - Wrap up
25:09 Verifying Functions
26:48 Adding additional Yearly tabs
27:41 Annual Summary tab
30:29 Wrap up

CONNECT WITH ME
- Etsy: Link will be added soon.
- X (Twitter): Link will be added soon.
- TikTok: Link will be added soon.
- Instagram: Link will be added soon.
- LinkedIn: Link will be added soon.

SUBSCRIBE ON YOUTUBE
https://www.youtube.com/@philipsmithmedia

SUPPORT THE CHANNEL
-Amazon affiliate link: https://amzn.to/3RxGHPz (Purchasing an item through this link will help support my channel by giving me a small commission on an item you buy - the price you pay for the item is not affected and is the same)