When you have an online business where you sell handmade products, you could keep track of inventory in excel spreadsheet.

The video illustrates how to create an inventory spreadsheet to track your handmade products.

how to manage inventory for a handmade business

How to manage your inventory?

Manage inventory by recording:

Inventory at the beginning of the year which is the same as the inventory at the end of the prior year.

Purchases of goods during the current year

Sales during the year

The cost of goods sold during the year

The inventory at the end of the year.

How to manage inventory in excel?

If you just started your business and would like to have a good control over the processes in your organization, if you don’t have an accounting software,

you could keep track of your inventory and sales in excel.

  1. Create a spreadsheet with a sheet to record all your goods purchased and goods sold
  2. Create a sheet inside the same workbook to each type your business activities in order to:
  3. track finished goods inventory,
  4. track reselling products
  5. track handmade products inventory
  6. track private label inventory, and more

Using “SUMIFS” formula, you could summarize data entries made in the inventory and sales spreadsheet into specific categories

Create a spreadsheet to summarize all the year activities into few major categories making it easy to file to file your State Sales Tax form and your business tax later:

Cost of Goods Sold Sheet includes:

Inventory at the beginning of the year

Purchases during the year

Inventory at the End of the Year

Cost of goods Sold during the year

Total Gross Receipts or Sales

Gross Profits

The video illustrates how to manage inventory in excel spreadsheet.

 

 

 

Free Download - Inventory-Sales Spreadsheet

You could find a free copy of Inventory-Sales Spreadsheet in the side bar under Free Downloads. No email is required to access it.

Manage Your Business Yourself

Previous articles in this category

 

Disclaimer:

“I am not an attorney to practice law. I am not allowed to draft legal documents, give advice on legal matters including immigration, or charge a fee for these activities.”

Affiliate Links Disclaimer:

Our articles contain affiliate links. When you click on one of our affiliate links and make a purchase, we will receive a commission. We thank you very much for your support!

 

Please Find About our Products and Links Below

Free Download

Would you please check the “Free Download” section on our website for budget spreadsheet, budget planner PDF, tax forms, motivational quotes, checklists, and more for you do download.  You don’t need to subscribe to access them.  We would like to have you in our community where we interact and encourage each other to reach our goals. We invite you to join our email list.

https://ninasoap.com/free-downloads/

Our Objectives

At Nina’s Soap, we thrive to live a quality life within our budget and increase our net worth. We share many aspects of our lifestyle including personal finance, investment, business management, cooking from scratch and growing some vegetables and fruit to save money and eat healthy.

For more, would you please visit us on our:

Blog: www.ninasoap.com

You Tube Channel:

https://www.youtube.com/c/LibermanConsultingLLC

 

Join Us for Free

You are invited to join us where you could ask questions, stay motivated and work toward reaching your financial goals

 

Join Now Button

 

How to Find Previous Articles

To make it easy to navigate our website, would you please check the side bar? Under “Post Archives”, are our “categories”. The links to our prior articles are saved under their appropriate categories. Would you please click on any category under “Post Archives” to read the titles of previous articles and click on the link of your interest to open the article.

 

Welcome to Our Financial Success Group!

To learn more tips on how to live below your income without sacrificing the quality of your life and start building wealth, would you please join our community for FREE by subscribing here: https://ninasoap.com/membership-join/

 

Our Online Stores

Welcome to Nina’s Soap our Natural Products Store

https://ninassoap.com

Our lye soaps are handmade with quality grade natural oils and butters, food grade sodium hydroxide, and herbs grown in our garden without pesticide or chemical fertilizer—- no additives, no fragrance, no dye.

Our towels, washcloths, and napkins are natural and eco-friendly alternatives of paper towels, paper napkins, and tissue papers for you to enjoy in the comfort of your home while saving money and the environment.

Welcome to Liber Label our Apparel Store

https://liberlabel.com

Customs design clothing, home décor, accessories, and stationery with motivational quotes to lift your mood every day.

Welcome to LiberOutlet.com our Resale Store

https://liberoutlet.com

New and used toys, small kitchen appliances, household products, office supplies, packaging supplies at a bargain price.

Affiliate Links:

Bluehost: We host our websites at Bluehost and like their service. They take the time over the phone to help solve website issues

https://www.bluehost.com/track/ninasoap/

 

Please Register for Free

Registration

 

Previous Articles by Category