Inventory and Sales Spreadsheet Template

Inventory and Sales Spreadsheet Template facilitates retailers to control their sales and their product inventory at the same time. Easy to use, customizable and compatible with all Excel versions.

Features of Inventory and Sales Spreadsheet Template

Product Registration

Record all the products that your company sells, set the initial inventory and the amount spent on it.

‍

Customer and Supplier Registration and Analysis

Record all your customers and suppliers for whom you make sales and purchases, and know exactly which ones generate you the most incomes and expenses.

Purchasing and Sales Registration

Launch your purchases and sales (each one can have up to 10 types of products with different quantities), see the amount to be paid or received automatically and control discounts that you will give or that you have managed.

‍

Individual Product Analysis

Know exactly the information of a chosen product from your stock. Here you will be able to see receipts and expenses with this item, as well as your minimum stock, current stock, entries and exits.

Cash flow

According to the sales and purchases made month by month your cash flow will be automatically formed.

Purchasing and Sales Analysis

Track the amount of incomes and expenses generated by each of your products in stock each month.

‍

Inventory Analysis

Analyze the quantity of products in your inventory and know the need-to-purchase status with a product-wise notice.

Customer and Supplier Report

See automatically by month how much you paid for each supplier and how much you received from each registered customer.

Dashboards

The worksheet automatically compiles 3 dashboards with key information, metrics, and charts related to your company’s sales, inventory, and cash flow.