Index

Overview:

The OmniData™: Cashflow Magnifier Analytics – Power BI Model, is designed to give your organization a 360 degree view of all factors that affect your cash.  Key metrics for any organization, like payables, payables efficiency, Receivables, collection efficiency, cashflow metrics into the future, inventory days, inventory turn and monthly usage from transactional inventory data are included. All are presented in a set of easy to use and easy to understand dashboard that can easily be enhanced to meet specific needs.

vertsep
Cashflow Magnifier main screen

Scope of help:

This help is is designed to provide you with dashboard usability. For a much deeper dive into help on the data model, crafting your own dashboards from the data model, or access to the data model, please contact OmniData™.

Navigation:

Accounts Payable Overview

This report is designed to provide you with a simple overview of accounts payable.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AP Balance Overdue v Target
    • AP Days Overdue v Target
    • AP Balance v Target
    • Open AP Documents v Target
  • Report Components:
    • AP Balance by:
      • Aging
      • Vendor Group
      • Vendor Payment Terms
    • AP Balance & AP Balance Overdue by Company with Aging Buckets
    • AP Balance by Company, Container, and Invoice Detail
vertsep
Screen Shot 2020-12-30 at 1.14.30 PM

Accounts Payable - Payments Efficiency

This report is designed to provide you with an in-depth look into payment efficiency with respect to Accounts Payable.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AP Balance Overdue v Target
    • AP Days Overdue v Target
    • AP Balance v Target
    • Open AP Documents v Target
  • Report Components:
    • AP Payments Effectiveness Measures
    • AP Payment  Effectiveness Ratio v Target
    • Average of Days to AP Settlement vs Target by Year Month
    • Total AP Voucher, Count Paid in Time Count and Payment Effectiveness Ratio by Year Month
    • AP Effectiveness Details by Company
vertsep
Screen Shot 2020-12-30 at 1.14.49 PM

Accounts Receivable Overview

This report is designed to provide you with a simple overview of accounts receivable.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AR Balance Overdue v Target
    • AR Days Overdue v Target
    • AR Balance v Target
    • Open AR Documents v Target
  • Report Components:
    • AR Balance by Aging, Vendor Group, and Vendor Payment Terms:
    • Customer AR Balance and AR Balance Overdue by Company and Aging Buckets
    • Customer AR Balance by Country and Payment Terms
vertsep
Screen Shot 2020-12-30 at 1.15.11 PM

Accounts Receivable - Collection Efficiency

This report is designed to provide you with an in-depth look into collection efficiency with respect to Accounts Receivables.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AR Balance Overdue v Target
    • AR Days Overdue v Target
    • AR Balance v Target
    • Open AR Documents v Target
  • Report Components:
    • AR Collection Effectiveness Measures
    • AR Collection Effectiveness Ratio v Target
    • Average of Days to AR Settlement vs Target by Year Month
    • Total AR Invoice Count, Collected in Time Count and Collection Effectiveness Ratio by Year Month
    • AR Collection Effectiveness Details by Company
vertsep
Screen Shot 2020-12-30 at 1.15.27 PM

Cashflow Overview

This report is designed to provide you with a simple overview of Cashflow.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AP Balance Overdue v Target
    • Open AP Documents v Target
    • AR Balance Overdue v Target
    • Open AR Documents v Target 
  • Report Components:
    • Accrued Cashflow by Year
    • AP Balance & AR Balance by Month
    • Cashflow by Company and Aging
    • AP & AR Balance by Company
vertsep
Screen Shot 2020-12-30 at 1.15.44 PM

Cash-In and Cash-Out with Document Details

This report is designed to demonstrate the relationship between AP vs AR.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AP Balance Overdue v Target
    • Open AP Documents v Target
    • AR Balance Overdue v Target
    • Open AR Documents v Target 
  • Report Components:
    • AR Balance
    • AP Balance
    • Customers (Cash-In)
    • Vendors (Cash-Out)
vertsep
Screen Shot 2020-12-30 at 1.16.02 PM

Cash Projections with Bank Details

This report is designed to give you a projection of your cash in the future.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • AP Balance v Target
    • Open AP Documents v Target
    • AR Balance v Target
    • Open AR Documents v Target 
  • Report Components:
    • Current Bank Balance Slider
    • Projected Cash Balance after Overdue AP & AR Settlements AP & AR Balance by Company
    • Projected Cash Balance after Overdue AP & AR Settlements AP & AR Balance by Company including next 10 days of upcoming AP & AR Payments
vertsep
Screen Shot 2020-12-30 at 1.16.16 PM

Inventory Overview

This report is designed to provide you with a simple overview of Inventory.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • Inventory Turn and KPI Value
    • Days in Inventory and KPI Value
    • Months on Hand and KPI Value
    • Average Inventory Value and KPI Value 
  • Report Components:
    • Average Inventory Value by Year and Quarter
    • Inventory Closing Value Analysis
vertsep
Screen Shot 2020-12-30 at 1.16.29 PM

Inventory Quantity Overview

This report is designed to provide you with a simple overview of Inventory Quantity.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • Inventory Turn and KPI Value
    • Days in Inventory and KPI Value
    • Months on Hand and KPI Value
    • Average Inventory Value and KPI Value 
  • Report Components:
    • Closing Quantity and Average Inventory Value by Year and Quarter
    • Closing Quantity by Item Group Name
vertsep
Screen Shot 2020-12-30 at 1.16.43 PM

Procurement Planning

This report is designed to provide you with a simple overview of Procurement Planning.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • Inventory Turn and KPI Value
    • Days in Inventory and KPI Value
    • Months on Hand and KPI Value
    • Average Inventory Value and KPI Value 
  • Report Components:
    • Days un Inventory, Closing Quantity, and Closing Quantity by Item Group Name and ABC Item
    • Closing Quantity by Item Group Name and Item Name
vertsep
Screen Shot 2020-12-30 at 1.16.58 PM

ABC Analysis

This report is designed to provide you with ABC Analysis.

  • Filters:
    • Calendar Year, Quarter, & Month
    • Company ID + Name
  • KPIs:
    • Inventory Turn and KPI Value
    • Days in Inventory and KPI Value
    • Months on Hand and KPI Value
    • Average Inventory Value and KPI Value 
  • Report Components:
    • Outbound Quantity by ABC, Item Group, and Item
    • Outbound Quantity and % Total by ItemID + Name
vertsep
Screen Shot 2020-12-30 at 1.17.14 PM