Consigned Stock Control Excel Spreadsheet Template

Registration of Products, Resellers, and Suppliers:

Register your products, the resellers that work with you, and the suppliers where you carry out your purchases.

Consignment Control:

Area to register the products that were delivered to resellers, as well as their return and sale. This will automatically update the consigned stock control tab.

Purchasing Control:

Area for the registration and control of the purchases of products made month by month.

Consigned Stock Control:

Demonstration with the information of all your registered products, the quantity in stock for each of them, stock status, and other details.

Service Order ready for printing:

Order two-way service (one for you and one for the reseller) ready for printing. Ideal tool to keep a record of products delivered to your suppliers.

Resellers Commission Report:

Automatically view a list of all your resellers and their commission amounts month by month.

Report of Products Consigned with Resellers:

See a list of all your products that have been delivered to resellers but have not yet been sold or returned.

Reseller Inquiry:

Choose a reseller and see all the details of the transactions, sales, and receipts that he performed.

Cash flow:

Based on sales and purchases made, automatically see a cash flow statement with your income, expenses, and profit/loss per month.

Monthly Purchasing and Sales Report:

Track monthly and individually the number of products sold and purchased.

Reseller Dashboard:

Analyze the key indicators and charts of your resellers in a control panel organized on a single screen.

Products Dashboard:

See the total quantity of products registered, the quantity in stock and its approximate value, as well as a chart of monthly evolution of purchases of new products.

Financial Dashboard:

Financial indicator panels with a monthly cash flow chart and indicators of revenues, expenses, profit/loss, and profitability for the year.


Consigned Stock Control Excel Spreadsheet Template

average rating 5.0 out of 5
Based on 1 review
  • 5 Stars
    1 Review
  • 4 Stars
    0 Reviews
  • 3 Stars
    0 Reviews
  • 2 Stars
    0 Reviews
  • 1 Star
    0 Reviews
100% of reviewers would recommend this product to a friend
1 Review
Reviewed by Paulo, from Brazil
Verified Buyer
I recommend this product
Rated 5 out of 5
Review posted

Excelente o material tanto na apresentação quanto no conteúdo.

O produto atende as expectativas e o atendimento é excelente.

Was this helpful?
Download Free Trial Version

Product Specs:

  • License to 3 Computers
  • 100% Editable File
  • Immediate Access
  • Works on MAC and PC
  • All Excel Versions
  • Premium Support
  • Over 30.000 satisfied customers