Understanding the Zayls Dashboard | Smarter Sales & Inventory Management | Zayls

by Fiona Pingkian
1 year ago
0 Views
Knowledge Base Getting Started with Zayls | Understanding the Zayls Dashboard

Understanding the Zayls Dashboard

Zayls Dashboard provides a high-level perspective of the purchasing, sales, and inventory cycle that is vital for the company stakeholders to give a well-informed business decision. The dashboard is composed of eleven parts. These parts will be elaborated below.

Manager's Dashboard

Users with Admin type will automatically have access to the dashboard.

Simple Dashboard (without Manager's dashboard permission)

For a regular user who wants to see the dashboard, go to Settings and click User Roles. Then, click Edit and select Dashboard under Reports.

Date Filter:

By default, the dashboard processes and displays the last 30 days of data in the system.

To change the date range of the dashboard:

1. Click the date range dropdown found at the top-right side of the window.

2. Click your desired date range:

  • Last 30 Days – will process all transaction data during the last 30 days
  • Today – will process all transaction data occurred during the day
  • Yesterday – will process all transaction data occurred yesterday
  • This Month – will process all transaction data starting from the first day of the month up to the last day of the month
  • Last Month – will process all transaction data occurred last month
  • This Year – will process all transaction data of the whole year starting from January 1 (current year) to December 31 (current year)
  • Custom – will process all transaction data within the date from and date to selected

Quick Overview Panel

This panel contains relevant information about the current status of the business. Each row in this panel contains the number of transactions, the name and status of the transaction, and the value of this transaction.

This is the only panel in the dashboard that is not affected by the date filter.

Purchases Panel

This panel contains the key performance metrics derived from the Purchasing Process. Listed below are the metrics and their definitions:

  • Gross Purchases – Purchases before tax and returns. This is the summation of all the bills processed by the system.
  • % change – This is the comparison between the gross purchases within this period and the last.
  • Purchases Trend – The purchases trend is a line graph that consists of when each portion of the Gross Purchases was incurred within the period.
  • Daily Average – the average purchases within a day
  • Purchase Returns – The value of purchase returns incurred within the period.
  • Taxes – the VAT amount incurred within each bill dated within the period.
  • Net Purchases – The final value of the purchases incurred within the period. This is obtained by subtracting the Purchase Returns and Taxes values to the Gross Purchases.

The VAT amount incurred in purchase returns has already been deducted in the Taxes metric

Sales Panel

This panel contains the key performance metrics derived from the Sales Process. Listed below are the metrics and their definitions:

  • Gross Sales – Sales before tax and returns. This is the summation of all the invoices processed by the system.
  • % change – This is the comparison between the gross purchases within this period and the last.
  • Sales Trend – The sales trend is a line graph that consists of when each portion of the Gross Sales was incurred within the period.
  • Daily Average – the average sales within a day
  • Sales Returns – The value of sales returns incurred within the period.
  • Taxes – the VAT amount incurred within each invoice dated within the period.
  • Net Sales – The final value of the purchases incurred within the period. This is obtained by subtracting the Sales Returns and Taxes values to the Gross Sales.

The VAT amount incurred in sales returns has already been deducted in the Taxes metric

Customer Orders vs Sales Panel

This panel consists of a line graph that compares the trends for customer orders and sales. This provides an insight on the business’ sales activities within the period.

  1. Customer Orders
    • Total Customer Orders – contains the value of the Sales Orders that are still pending and approved.
    • Customer Orders Trend – The customer orders trend is a line within the line graph that consists of when each portion of the total customer orders was incurred within the period.
  2. Sales
    • Total Sales – contains the value of the total sales within the period.
    • Sales Trend – the sales trend is a line within the line graph that consists of when each portion of the total sales was incurred within the period.

Units Sold Panel

This panel contains the metrics related to the inventories sold within the sales process. Listed below are the metrics and its definitions:

  • Gross Units Sold – Units Sold before returns. This is the summation of all the units sold derived from invoices within the system.
  • % change – This is the comparison between the gross units sold within this period and the last
  • Units Sold Trend – The units sold trend is a line graph that consists of when each portion of the Gross Units Sold was incurred within the period.
  • Daily Average – the average units sold within a day
  • Units Returned – The summation of all the units returned derived from sales returns within the system.
  • Net Units Sold – The final value of the units sold within the period. This is obtained by subtracting the Units Returned from the Gross Units Sold.
  • Most Sold Category – The category that has the most units sold within the period.
  • Most Sold Brand – The brand that has the most units sold within the period.

Top Sold Products Panel

This panel contains the top 5 products sold within the period. This ranking is based on each product’s net sales. Along with the product, it also includes the product’s category, its units sold, and its net sales.

Inventory Highlights Panel

This panel is a snapshot of the inventory at the end of the period. The panel showcases the Total Inventory Cost for all warehouses and a bar graph that represents the distribution of the inventory cost to each warehouse. Hovering over the bar-graph would also display the warehouse’ most valuable product, brand, and category in addition to its inventory cost.

Accounts Management Panel

This panel is an overview of the top 3 customers who has the highest collections within the period and the top 3 customers who has the highest unpaid invoices within the period. This panel provides an overview on which customers were the most valuable and the most liable within the period.

Slow Moving Inventory Panel

This panel showcases an overview of the products that has not been sold within the last 90 days. The items in the list are ranked in descending order based on which product has the highest inventory cost.

Recent Activities Panel

This panel provides an overview of the activities being done in the system. The panel showcases the activity done specifically, which transactions were affected, and which users are accountable for these changes.

Other Individual Metrics

Listed below are the definitions of each metric:

  • Most Active Sales Agent – showcases which sales agent has the highest amount of value based on the transactions of the accounts s/he was assigned to.
  • Average Order Cycle Time – showcases the average days it takes from a customer ordering to it being delivered
    • Formula: Total Average Order Cycle Time for each day within the period / No. of Days within the period
  • Most Used Discount – showcases which discounts is most used within the period
  • Average Profit per Sales Order – showcases the average profit margin a sales order has within the period
  • Perfect Order Performance – the perfect order performance is when your business was able to supply all the items within an order from your customers
    • Formula: Total Perfect Order Performance for each day within the period / No. of Days within the period
  • Average Days to Collect SO – The average days it takes from a customer being invoiced to the invoice payment being collected.