đ Introducing Performance Dashboards
In our third product release, we introduced Dashboards.
Dashboards are fully interactive displays that show you all the financial metrics you care about in a single view. You can use dashboards to visualize your organizationâs customer, product, and financial health data in one place. Letâs take a look at what you need to know to make the most of this tool.
Getting started
To get to the Dashboard, navigate to Analytics powered by Syft. You will see a selector that says âVisualisationsâ at the top of your screen. Click on the drop-down arrow next to that and select âDashboardsâ.
As is the case with other features, when you load your dashboard for the first time, youâll see demo data. This gives you a taste of the feature while your own data loads. As soon as your data has loaded, it will replace the demo data and you can begin tweaking your dashboard.
Default view
The default view of the dashboard is the Performance overview. This is the dashboard format that you are able to access on every plan. If you are on the Comprehensive/Established plan, you will also have a number template options for your dashboard, which you can find out more about below.
Depending on the card you are looking at, you will have a range of comparatives options, such as current vs prior, current vs prior last year, and total prior year.
Dashboard templates
There are a number of different templates available. These include the following:
Performance overview: a view of how well your organization is performing financially, including metrics related to cash, profit, money owed to you and money you owe.
Cash position: a view of your cash flow and balances over time. This focuses on money coming in and out of your organization, showing how much cash you have and how it changes over time.
Sales tracker: a comprehensive view of your customer and product data that allows you to identify active and new customers, growth in product sales and opportunities for enhancing sales or customer experience.
Balance Sheet: a snapshot of your organizationâs assets, liabilities and shareholdersâ equity that helps you to assess overall financial health and stability.
Operational health: a view of how well your organization is performing in terms of its operational efficiency and financial health, considering profitability, top customers and accounts, major expenses and potential cash flow issues or risks within accounts receivable.
Products: key insights into the performance and status of the organizationâs product offerings, helping you to track and analyze various product-related metrics to help stakeholders understand how products are performing.
To add a dashboard from a template, click on "Manage dashboards" and then "Add dashboard from template."
General settings
Within the general settings for the dashboard, you have the following options:
Change the number of columns (choose between 2,3, or 4)
Choose to include/exclude the currency symbol
Include or exclude the graph key (this is on by default)
Choose the currency and date format
đNote:
These choices will apply to all your dashboards.
Create a dashboard
To create a new dashboard, click on âManage dashboardsâ and choose a new template as your base. Please note that âdashboardâ refers to the whole page, composed of numerous cards, whereas âcardâ refers to an individual graph within the dashboard.
To add a new card to your dashboard, click âAdd cardâ and select the category of data you would like to choose. Once youâve selected the category, you can then select specific metrics or the financial type, depending on what you have selected. You can choose between the following categories:
Profitability
Cash
Customers
Products
P&L and Balance Sheet, including summarised statements and account graphs
KPIs
Image
đĄPro tip:
You can add up to three images in a carousel, as PNGs, JPEGs, or GIFs.
The dashboard will automatically scroll to the new card youâve added so you can see it right away.
Edit cards within your dashboard
đNote:
Editing the cards within your dashboard is different from editing the dashboard as a whole. The cards are the individual graphs or images youâve added to the dashboard. For more information about editing the whole dashboard, read the later sections of this article.
To edit a card, open the More options (the vertical ...) menu. This will open a floating strip with settings for the card thatâs active. You can change the following:
The card size - standard, medium horizontal (2 x width of standard), medium vertical (2x length/height of standard), large (4x the size of standard). If you change the size, the dashboard will rearrange the cards to fit the dashboard to the adjusted card size.
Graph type - bar graph, line graph, donut graph, large number, table, stacked horizontal & stacked bar (in future)
Comparison periods
Periods to show (24, 12, 6, and 3)
Color themes for the graphs in your card - the maximum number of colours per card is five and you can apply to all cards or just the one that youâre in. By default, this will be applied to all.
You can also duplicate or delete cards.
In certain instances, you may also be able to set which specific accounts to show.
Interact with your cards
When viewing your dashboard, you can hover over a metric to see the trends of which that bar or point is comprised.
Manage your dashboard
You may want to edit aspects of your dashboard. Letâs consider what you can amend. To get started, navigate to âManage dashboard.â From there, you can:
Edit your existing dashboard (rename it by clicking on the name box and typing in a new name, or delete it by clicking on the trash icon)
Add a new dashboard from a template (depending on your plan)
Add a new blank dashboard (depending on your plan)
Drag and drop to reorder dashboards
đNote:
The dashboard at the start of the list is your default dashboard.
đ¨NB:
All of these settings can be found in the top white block. The settings in this block apply to all your dashboards. Meanwhile, the settings in the floating block relate to specific dashboards.
Important to note
Shared dashboards are view only pages. You cannot edit them in the shared mode. If you would like to edit anything in your dashboard, youâll need to return to the dashboard in Analytics powered by Syft. However, you can access AI insights within the shared dashboard.
On each page, you can see the last sync and the option to refresh now. By default, your dashboard refreshes every 15 mins. You can toggle on âShow demo dataâ if youâd prefer to showcase dummy data.
Share dashboard
Use a live link to share your dashboards with clients, stakeholders, investors, or members of your team. You can share these as view-only dashboards, which can be set to refresh daily, weekly or monthly.
You also have the ability to delete dashboards so that they will no longer be accessible. To delete a dashboard, simply disable sharing. To generate a new link, re-enable sharing.
đNote:
Dashboard shares are automatically disabled after 90 days.
⨠Introducing KPIs, Cash, and Organization Logos
In our second product release, we introduced KPIs and Cash graphs, along with the ability to add a logo.
Welcome to our second release update. From new graphs and insights to improve your decision-making to a simple but effective way to add branding to your reports, there's a lot to explore.
Let's get started.
đAdd an organization logo
First up - a little taste of branding. You now have the ability to brand your visualizations and reports on Analytics powered by Syft by uploading a logo or selecting an icon. This adds an element of professionalism to the appearance of your visualizations, making them ready to be shared with external parties.
How to add a logo
To add a logo, click on the icon next to your entityâs name. This will open a dialogue box with the option to upload. If you click on âUpload your logo,â you can then choose a logo from your computer files.
đNote:
For best results, select a logo with an aspect ratio of 1:1.
Alternatively, if you donât have a logo, you can search for an appropriate icon in the search bar below and use that to represent your entity.
â¨Introducing KPIs & Cash Graphs
As the old axiom goes, a picture is worth a thousand words. That's why we believe in the power of visualizing your data - helping you to understand what's going on in your business, from key metrics to cash in- and outflows with the power of graphs.
In addition to the new logo options, the team is happy to introduce a beautiful way for you to gain deeper insights into key performance indicators (KPIs) and cash data on Xero through KPI and Cash Graphs.
Let's take a look at what this entails.
đ° Visualize your Cash
The Cash tool is handy for getting a visual sense of your cash flow and balance. Sometimes, when you see your cash in a graph, you pick up on trends you might otherwise miss.
This is a powerful cash management tool that enables you to see what is happening to your cash and the key reasons for the inflows and outflows so that you can drive the inflows and reduce the outflows in the future.
Visualization options
You can visualize your cash in five different ways:
Cash in vs Cash out
Cash in
Cash out
Cash balance
Net cash flow
Frequencies
Want to narrow your focus to a particular month, quarter, or more specific date range? We've got you covered.
You can choose between several frequencies to view your cash flow and cash balance. These include basic frequencies:
Daily
Monthly
Quarterly
Annual (12 months)
Annual (financial year)
And more advanced frequencies:
Monthly (month to date)
Monthly (financial year to date)
Monthly (day-to-day)
Year to date (calendar year)
Year to date (financial year)
You can also select the date and year you would like to view.
Graph options
In the Graph options menu, you can choose:
Which bank accounts to show, be that all or only certain accounts
How many periods to display - either 3, 6, 12, or 24
If you click on the tear drop, you can choose between various color schemes so that your graphs match your organization's branding.
đ Magnify
Magnify refers to the hover states available in these graphs and it's one of our favorite features. This is because, like a magnifying glass, it is able to enlarge vital details that you may have missed just by looking at the line or bars of your chart.
How does this work? Well, simply put, if you hover over a line or bar in your graph, you will be able to see the following:
Trend: the trend of the relevant accounts compared to the prior period
Top transactions: the top transactions making up the number
Contacts: the top contacts impacting this number
đNote:
The trend displayed will differ depending on which graph you are viewing.
Export
Want to share your cash information with interested parties? No problem. You can export these graphs to email, Excel, PDF, Slack, WhatsApp, or Microsoft Teams to share them with clients, investors, or other stakeholders.
đ Visualize KPIs
Key performance indicators or KPIs are quantifiable measurements of performance over time for a specific outcome. They help you determine targets to aim for, set milestones to assess your organization's progress, and provide insights to various members of your team into how they could improve performance or make better decisions.
Graph types
With Analytics powered by Syft, KPIs can be visualized in either a line graph or a grouped bar chart. Simply click on the relevant icon to change the graph type. Here are a few reasons why you might choose each option:
Line graph: gives you the ability to track trends, making it easy to detect patterns and identify periods of growth or decline. The continuous line also means that it's easy to uncover even small fluctuations in the data, which you might otherwise miss.
Grouped bar graph: is effective in comparing the values of different metrics side by side (for example, debtors days alongside creditors days). These graphs are intuitive and easy for most people to understand, even if you aren't used to working with graphs.
KPI data
The KPIs you can choose to view in these graphs include:
Performance (amount):
Total Income
Gross Profit
Total Expenses
Net Income
Net Assets
Cash Balance
Return (percentage):
Gross Profit Margin
Net Income Margin
Return on Assets
Return on Equity
Efficiency (days):
Debtors Days
Creditors Days
Inventory Days
Leverage (ratio):
Quick Ratio
Debt to Equity
Current Ratio
Frequencies
Just as with Cash graphs, you can customize your view further by selecting the specific viewing frequencies that make sense to your business and where you would like to focus your attention. You can choose between several frequencies to view your KPIs.
Graph options
In the Graph options menu, you can choose:
Which KPIs to display: select from KPIs that are stated as numeric values, percentages, ratios, or days
The number of periods displayed: 24, 12, 6, or 3
And, as with the cash graphs, you can choose between various color schemes so that your graphs have the look and feel of your organization.
đ Magnify
Once again, this tool includes the beloved Magnify feature. On hover, you are able to identify:
The trend of the KPIs compared to the prior period.
For instance, perhaps your debtors days have gone up by 6.5 days compared to the debtors days last month. If this is the case, then you may want to investigate why that happened and look for ways to bring that number down going forward.
The equation which makes up each KPI.
For instance, debtors days is calculated as (Average Accounts Receivable/Trading Income) *Number of Days.
đNote:
KPIs will either be displayed as numbers (including values, days, and ratios) or percentages. As such, the trend will either reflect as a number or percentage increase/decrease.
Export
You can export these graphs to email, Excel, PDF, Slack, WhatsApp, or Microsoft Teams to share them with clients, investors, or other stakeholders. As easy as that.
â¨Introducing Graphs
Our very first release of features on Analytics powered by Syft, dedicated to helping you visualize your financial data in no time.
Financial information is most useful when it is easy to understand and is structured in a way that aids decision making. Xero Analytics powered by Syft helps you by automatically transforming your financial data into customizable graphs and tables that can be analysed or downloaded with ease!
Letâs take a look at how it works.
The Basics
In Analytics Powered by Syft, you have the following options across the top of your screen:
Profitability
Profit & Loss accounts
Balance Sheet accounts
Once you are in each of these sections, you have a number of options to choose from in terms of what you want to see and how youâd like it to be presented.
đ Note:
The accounts you see are the accounts you have on your P&L and BS.
You will see a key for the graph on the right-hand side to help you identify what you are looking at.
Frequency options
You can choose the frequency you would like to see, choosing between basic frequencies and more advanced options. The basic options are:
Daily
Monthly
Quarterly
Annual (12 months)
Annual (financial year)
The more advanced frequencies are:
Monthly (month to date)
Monthly (financial year to date)
Monthly (day-to-day)
Year to date (calendar year)
Year to date (financial year)
You can also choose which month and year to show by clicking on the drop-down arrows.
đ Note:
The date you select is the end date.
To choose how many months you would like to look at, use the period selector.
Graph options
In graph options, you can choose:
Which data to display within the graph youâve selected. For instance, within Income vs expenses, you can choose between Income and expenses, Income, Expenses and Profit and Loss.
The number of periods (24, 12, 6 or 3)
đ Note:
Graph options differ according to which graph you are working with.
Filtering
You can filter your graphs according to specific tracking categories, such as Location or Revenue. You can then apply these filters to any category (any category that meets the criteria) or an exact category (a category or categories that meet the specific criteria).
Whatâs the difference between any category and exact categories?
Any category is equivalent to an OR equation. This means that at least one of the categories must be true. For example, anything that exists in the location youâve selected OR in the account youâve selected will appear.
Exact category works like an AND equation. This means that both of your chosen categories must be true simultaneously. So, this would need to be a transaction in the specific location AND account, for instance.
Example:
If we take the example of Jâs Cupcake Company, Jay may want to see transactions that occurred in her Zootopia branch as well as transactions within her Cake Sales division. She would select any category to see any transactions within Zootopia or Cake Sales. However, if she wanted to narrow her focus to see only Cake Sales that occurred within Zooptopia, she would select the exact category.
Color themes
You can apply a colour theme of your choosing to the graph, deciding between the following options:
Xero blue
Confetti
Misty mountain
Zanzibar spice
Ocean waves
Summer day
Unicorn birthday
Dawn
Magnify đ
You can hover over the graph line to identify trends, top transactions and top contacts, giving you a comprehensive view of what constitutes key figures.
Export options
All graphs can be exported to PDF, Excel, Slack, WhatsApp or Microsoft Teams by clicking on the Export button and selecting the relevant option. Sharing to Slack, WhatsApp or Teams makes it easier to send graphs directly to team members, clients or stakeholders.
Settings
Under Settings at the top right of the screen, you can choose from the following options in terms of display:
Accounting basis
Decimals
Data labels
Graph key
Data points
Currency symbol
You can also change your reporting currency.
đ Note:
When you change these settings, your changes will persist across all graphs.
Last refresh date
At the bottom of the screen, you can see the last time this data synced to your underlying accounts. You can also click on the revolving arrows to refresh it now.
đ Note:
If you see any mismatches in your data, this may be because it has not refreshed recently.
Show demo data
If you would like to look at dummy data as opposed to your actual data, you can toggle on the âShow demo dataâ option to get a sense of what the graphs look like with demo data. This is helpful for giving clients or staff a taste of the data without inputting sensitive information.
Give feedback
At the bottom right of the screen, youâll see you have the option to provide us with feedback on Analytics powered by Syft. Please let us know what you think so we can continue to improve this feature.
Now, letâs get into the nitty gritty details of the different visualizations.
Profitability
When looking at the Profitability section, you can choose between the following metrics to focus on:
Income vs expenses
Sales
Cost of Sales
Other Income
Expenses
Profit & Loss Accounts
Under Profit & Loss accounts, you can choose between a wide range of graph types, namely:
Line graph
Grouped bar graph
Stacked bar graph
Horizontal bar graph
Normalised horizontal stacked bar graph
Donut graph
As with the other graphs, you can change the dates to view and toggle between different graph options.
Account display options
With the line graph, grouped bar graph and stacked bar graph, you can select the accounts to display as well as the number of periods to view them for.
Within the horizontal bar graph, the normalised horizontal stacked bar graph and the donut graph, you can see:
Top accounts
Specific account
For certain graphs, you can also select the comparison period to view.
Using the âSpecify accountsâ button, you can choose which exact accounts to show on the graph. You can tick the box next to each individual account that you would like to see.
As with other graphs, you can filter according to tracking categories, change your graph colours, or export.
Balance Sheet Accounts
Balance Sheet accounts work very similarly to Profit & Loss accounts with the same graph types available, and the ability to choose which accounts to display. For example, you may want to include total accounts such as Total Liabilities, or perhaps some non-current asset accounts such as Motor Vehicles to focus on those specific details.
You can also choose the number of periods to display (i.e., 24, 12, 6 or 3).