BI4Cloud + Xero : Advanced Sales Analysis

logo-xero-60.pngXero sales data holds a wealth of valuable information about your business.

BI4Cloud Business Intelligence makes it easy to understand your Xero sales history, spot trends and then investigate the cause of any issues:  

  1. Visualise Sales Dynamically with Cool Charts
  2. Know your Customer Card List  
  3. Sales by Customer, and  Location
  4. Sales by Tracking Categories, e.g. Salesperson or Region
  5. Sales - who has stopped buying 
  6. Sales over time - by day, week, month, quarter and year 

1. Cool Charts - Dynamic Sales Analysis

Run Cool Charts to Instantly visualise your sales data over any date range

  • See your Top Customers and Items by Sales revenue
  • Click to filter by Tracking Category, Income Account or Customer 

Sales_-_cool_Charts.png

2. Welcome new Customers, Reward Loyalty

Run the Customer Card List report for a quick and simple tool to identify all:

  • New Customers last month/week to send a Customer satisfaction survey
  • Customers who have not been active for X days or years to offer a loyalty bonus
  • Customers who’s last Sales date was in a given date range (Stopped buying)
  • Customers by Distribution channel or Type to send a targeted campaign
  • Customers by State, Postcode or Country

3. Sales by Customer and Location

Focus on Sales by who you are selling to and where they are located.

  • Who are your Top Customers by Sales revenue?
  • Do you have different Sales expectations for different distribution channels or buying groups using Tracking Categories?
  • Can you justify opening a new branch or hiring a new salesrep for a given location?

Run the report Sales - Analyse Sales Monthly (Pivot)

  • Sort your Customers by Total Sales or by one month by Clicking on the Column header
  • Order by Last Sales Date to identify which customers have stopped buying
  • Choose Top 10 or Top 100 to focus on your best customers
  • Drill-down on a Customer to see what Items they have bought by Clicking on the Customer

Monthly_Sales_by_Customer.png

Focus on Customer Location

  • Group your Customers by their Address e.g. State, City or Postcode

Customers_gouped_by_State.png

  • Analyse your Customers at a summary level by their Address e.g. State, City or Postcode

Analyse_by_State.png

4. Sales by Tracking Categories - e.g. Salesperson 

 Focus on Sales by who is selling - Salesperson

  • Do you use a Tracking Category to allocate a Salesperson on each Sales Invoice?
  • Do you use a Tracking Category to allocate each Customer to a Default Salesperson?

To Create Sales by Salesperson (Tracking Category) Report - Run the BI4Cloud report Sales - Analyse Sales & Margins

  • Change Analyse by to Salesperson (or Tracking Category name) for the Salesperson on each Invoice or
  • Change Analyse by to Salesperson - Customer for the Default Salesperson on the Customer contact
  • Change the Sales Date Range to see a different Period e.g. This month or Last Month

Sales_by_Tracking_Code_-_Salesperson.png

  • Hide Columns (+/- Columns) to see just the columns you need
  • To understand Average Cost & COGS data in XERO Click Here

Hide_Columns.png

  • Filter by Salesperson (Tracking Category) for the Salesperson on each Invoice
  • Filter by Salesperson - Customer (Tracking Category) for the Default Salesperson on the Customer Contact card
  • Click Done

Filter_by_Salesperson_-_Tracking_Code.png

  • While filtered for one Salesperson (Tracking Category)
  • To show more detail - Analyse by Invoice Detail (or Analyse by Item)
  • Group by Customer

Inv_Detail_by_Customer.png

Pivot by Tracking Category

Run the report Sales - Analyse Sales Monthly (Pivot)

  • Analyse by Items to see Items as Rows instead of Customers
  • Pivot by Tracking Category e.g. Region or Salesperson to see where each Item was sold

Sales_by_Item_by_Region.png

 

5. Sales - Which Customers have Stopped Buying?

 Focus on Sales by who has stopped buying or is buying less. 

Run the  Report - Compare Sales by Customer

  • Sort by the Variance Column 
  • Sort by the Customer Last Sales Date
  • Click Compare to Change the Date Ranges used or add another date pair e.g. This Mth to date v MTD Last Month
  • Click on a Customer to Drill down to compare the Items they bought

Compare_Sales_by_Customer.png

6. Sales over Time - by Day, by Week by Month, by Quarter

 Focus on Sales over time to identify trends

  • Are your sales changing over time?
  • Do you have different sales based on seasonal fluctuations?

To Create a Pivot Report showing Sales by Item by Quarter Report 
- Run the Pivot report Sales - Analyse Sales Monthly (Pivot)

  • Change Analyse by to Item (or Salesperson) to see as Rows
  • Change the Then by to Sales by Quarter (or Year) to see as Columns
  • Change the Display from Total Sales to All (V) (Display all Dimensions as a Vertical Pivot to easily compare month to month or Quarter to Quarter across the page)
  • Hide some Dimensions to simplify the report use the +/- Columns option

Sales_by_Quarter.png

 

BI4Cloud.com

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?