KPI Dashboard – Tracking Invoices/Data Points/Salesmen/Products
Two input cards drive the database creation of this KPI dashboard. You will be able to track the total sales/outstanding/paid amounts across all invoices over any time-frame and charted daily for any 365 days of time. This 365 day tracking also goes for product sales and 10 other organization measures that you may want to track on a daily basis.
A query function is also added to look at any individual invoice to see what is owed/paid.
There is also a range of 30/60/90/120 day tracking based on a current date the user inputs. This is built around all the various things you may want to track on an invoices, including addons, items on, discounts, total amount.
|Summary||Ultimate KPI dashboard in Excel that has a lot of dynamic functions and tracking features for various items that you may have on a given invoice.|
|Screenshots / Pictures||
|Use Cases||CFO, dashboard, invoice analysis, kpi, Sales Tracking|
You must log in and be a buyer of this download to submit a review.