Xero 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:
- Visualise Sales Dynamically with Cool Charts
- Know your Customer Card List
- Sales by Customer, and Location
- Sales by Tracking Categories, e.g. Salesperson or Region
- Sales - who has stopped buying
- 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
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
Focus on Customer Location
- Group your Customers by their Address e.g. State, City or Postcode
- Analyse your Customers at a summary level by their Address e.g. State, City or Postcode
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
- Hide Columns (+/- Columns) to see just the columns you need
- To understand Average Cost & COGS data in XERO Click Here
- 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
- While filtered for one Salesperson (Tracking Category)
- To show more detail - Analyse by Invoice Detail (or Analyse by Item)
- Group by Customer
- Save the Report and Schedule it to email off weekly or monthly
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
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
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