Enhanced Insights: Cash Flow Index

Specific to fully implemented SmartOrder users, the Cash Flow tab within Enhanced Insights provides beneficial purchase information

Update! As of August 15, 2024 Insights (including CFI) can be accessed via the new Insights tab indicated by a pie chart. Users will still have access to Custom Insights.

Note: To get the most out of Cash Flow Index, it is vital that users operate SmartBar efficiently and follow the best practices. A correct draft line-up, accurately updated inventory, and general SmartBar maintenance will help ensure the data reflects correctly. 

To access, navigate to Enhanced Insights by clicking on the graph icon on the left, then click on the cash flow tab.

The Cash Flow information can be seen by category and consists of:

• Liquor
• Draft
• Package
• Wine
• Fees
• Keg Deposits
• Keg Returns
• Package Deposits

 In this example, the chart indicates for every dollar spent, it can expected to get $2.35 back.

By scrolling down, users can see All Product Performance consisting of all categories.

Draft products displays avgkegs and packages avgbottles.

Users are given the cash flow (profit) by subtracting revenue by the purchased amount.

Users are given the index for a product or category by dividing revenue by the purchased amount.

should a user forget how these key items are calculated, a table rubric has been built into the Cash Flow Index tab.

Underneath the All Products Performance chart, it showcases Distributor Performance, focusing on specific distributors and the purchasing data associated with them.

Below the Distributor Performance table is the Products with less than 70% gross profit margin or GPM.

This gives a good call out to products that users may want to reconsider having. Having data-driven conversations with your distributor will help get concerns across while maintaining the relationship. 

Draft Slow Movers shows products with an average keg amount less than .7 kegs per 30 days. Given the data, replacement for these products may be considered, and further purchases may want to be postponed.

Sharing this data with your team can be beneficial!

With Enhanced Insights Cash Flow’s purchasing information, users can make data-driven decisions to boost their business, sharpen their inventory, and have a greater ROI!