BI4Cloud BI4Cloud BI4Cloud BI4Cloud
  • Features
  • Pricing
  • See It
  • Free Trial
  • Run BI
  • Blog
  • Help
BI4Cloud BI4Cloud
  • Features
  • Pricing
  • See It
  • Free Trial
  • Run BI
  • Blog
  • Help
Mar 07

Use Custom Lists to Group Items and Customers

  • March 7, 2016
  • Tips & Tricks

If you have hundreds of Customers or Items and are drowning in detail you will find it difficult to understand your margin mix or spot trends in your business.

It is easy to Categorise your Customers and Items into similar groupings within your accounting package then use BI4Cloud to find out early when issues arise.

Items
Our clients categorise their Items by Brand, Product Type (e.g. Parts v Finished Goods), Wine Variety (e.g. Chardonay v Shiraz) or Product Use (Diesel v Petrol).

Customers
I have seen clients categorise their Customers by Buying or Franchise Group, by Distribution channel (Direct v Wholesale v Online) or by Customer Type (Restaurants v Schools).

The key thing is to understand what are the key drivers of your business. If you have different margins for one Brand to another then being able to report on Sales and margins over time by each Brand will help you to better understand how each Brand contributes to your bottom line. Is one Brand constantly being discounted to move product, are marketing campaigns resulting in increased overall gross profit and not just increased sales?

Salespeople need this higher level sales data to identify gaps they can fill e.g. Customers or Customer Types only buying some not all of your Brands or Product Types.

Click Here to learn how to use Custom Lists in MYOB to categorise Customers and Items. Then use BI4Coud to report on them. Find out how easy it is to:

  • Group by – to Subtotal Items by Product Group
  • Analyze by – to see Brands as a Row dimension
  • Filter – to focus on just one Customer Buying Grouping
  • Pivot – to show Customer Type as Columns
  • Visualize – to bring the numbers to life in a chart
  • Compare – to track variances from prior periods

  • Facebook
  • Twitter
  • Reddit
  • Pinterest
  • Google+
  • LinkedIn
  • E-Mail

Comments are closed.

Recent Posts

  • Announcing New Beta Release of BI4Cloud WorkBooks
  • Upcoming Webinars and Masterclass Sessions
  • Understanding your Margins
  • Access reports from Remote Offices
  • Joint Ventures in Architecture and Construction

Recent Comments

    Archives

    • December 2022
    • March 2020
    • April 2018
    • September 2017
    • August 2017
    • March 2017
    • October 2016
    • September 2016
    • August 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016

    Categories

    • Announcements
    • Events
    • New Features
    • Newletters
    • Tips & Tricks
    • Uncategorized
    • User Stories

    Meta

    • Log in
    • Entries feed
    • Comments feed
    • WordPress.org

    CONTACT A HUMAN

    Drop us a line [email protected]
    Give us a call + 61 2 8011 1511
    BI4Cloud is a product of Interactive Reporting Pty Ltd.

    RECENT POSTS

    • Announcing New Beta Release of BI4Cloud WorkBooks
    • Upcoming Webinars and Masterclass Sessions
    • Understanding your Margins
    Australia
    Interactive Reporting Pty Ltd
    ABN 68 128 589 266
    © 2021 Interactive Reporting.