Skip to main content
Visualize

Create customizable graphs and tables on Syft with ease

Nikhita avatar
Written by Nikhita
Updated today

Who can use this feature

Roles: Owner, Admin, Staff, Client, Investor and optional on custom roles

Plans: Available on Standard, Plus, Advanced and Scale

Basics

Financial information is most useful when it is easy to understand and is structured in a way that aids decision making. Syft's "Visualize" tab does just that.

For many people, a long list of numbers isn’t nearly as easy to understand as a clear graph or table with different colors differentiating important details. "Visualize" automatically transforms your financial data into customizable graphs and tables that can be analyzed in Syft or added to report packs or live views at the touch of a button!

Add to Report

To add any "Visualize" page to a report template or entity specific report, click on the "+" icon at the top right of your screen.

Export

To export and download any "Visualize" page, click on the "Download" button at the top right of your screen and choose to export either to PDF, Word, Excel or add it to a Report from here. Click on "Options" to add the page to a report template and more, shown in the image below.

Graph Insights

AI-generated graph insights are found underneath each graph which gives you a summary and explanation of what the key figures are in the graph for the period selected. Graph insights can be toggled on or off under "Options" in some graphs within "Visualize".

In graph insights, the total of the selected account or category for the period, the average of that account or category for the period, the best-performing period in the data you're showing, and the worst-performing period will be noted.

Set Custom Date Ranges

If you would like to use the different scenario adjustments, you can go to the top of the screen and select custom date ranges within the global date selector.

Dashboard

Visualize your organization's customer, product, and financial health data in one place. Dashboards are fully interactive displays that show all the financial metrics you care about in a single view. You can create your own dashboard by building one from scratch.

Navigate to "Visualize" > "Dashboard" to land on your dashboard page. To add a new dashboard, click on the "+" icon, and to switch between different dashboards, click on the dashboard top tabs. You can change the period you want to view your dashboard at the top of the page.

Card options

To add a new card, click "Add card." You can then choose the following:

  • The entity whose data you would like to see

  • What data you would like to see (KPI Scorecard data, customers or products, Connections, financials, cash, transaction list, or image)

  • Specify which data to show (for e.g. if you choose KPI Scorecards, you can select which scorecard to reflect)

  • Choose a graph type (line graph, bar graph, or numeric value)

Then, click "Create."

Within each individual card, you will find a cog icon where you can configure:

  • The format: card size, card type, graph colors

  • Comparisons: compare to prior year

  • Duplications: duplicate the card

  • Chart in Excel: export the card to Excel for further customization

  • Go to Source: go to the underlying data

  • Removal: remove the card

💡 Pro tip

Once you've selected graph colors, you can toggle on "Update all graphs" so that all graphs in the dashboard use your selected colors.

You can also unlock AI insights using the AI button at the bottom of each card.

📓 Note

You are limited to 2 free AI queries per month unless you upgrade your AI requests.

Dashboard options

You can choose the number of periods you would like to show on your dashboard and the number of columns of cards to show by using the drop-down menus above the dashboard.

You can drag and drop cards to position them as you like. You can also loop animations so that your graphs continuously animate in by clicking on the looping toggle.

KPIs & Accounts

This is a great tool for viewing your Profit and Loss, Balance Sheet, KPIs, and Transactions and what makes them up to get a deeper understanding of trends and what is causing them. You can then use this understanding to make better business decisions going forward.

Navigate to "KPIs & Accounts" within "Visualize" to analyze your Profit & Loss, Balance Sheet, KPIs and Profitability in graphical format. You have the ability to view any account or total in these graphs with insights provided below the graph.

💡 Pro tip

Hover over any section of a graph, and the key values it represents will be highlighted and shown in a pop-up window. Click on any number or bar on the graph to drill down into transaction-level detail.

Accounts

Click on the "Profit & Loss" sub-tab to visualize your Profit & Loss account in whatever graph makes the most sense to you. Switch between the "Profit & Loss" and "Balance Sheet" top tabs to view each statement's visuals. There are many different ways to customize graphs in this section, including:

  • Graph type: change the graph type within the menu indicated by (1) in the image below.

  • Graph data: select which accounts you'd like to display on your graph, indicated by (2). Selecting specific accounts for a specific graph will save to that graph even if you click to view another graph. Select the number of periods you want your graph to display, indicated by (2). Specify the period type at the top of the page.

  • Divisions: filter your graph by division or tracking category, indicated by (3).

  • Compare: compare your accounts against a specific budget or forecast, as indicated by (4).

  • Color: change the color of your graph lines, as indicated by (5).

  • Options: select whether you would like to show insights, data labels, or a graph key on your graph, indicated by (6).

The different graph types available are as follows:

  • Line graph

  • Stacked bar graph

  • Horizontal bar graph

  • Normalized horizontal bar graph

  • Treemap graph

  • Partition icicle graph

  • Donut graph

💡 Pro tip

On the horizontal bar, normalized stacked horizontal bar, and donut charts, you can select accounts by category. Simply choose the categories you want to see, and the top accounts for those categories will be auto-selected. You can see the top 5, 10, 15, or 20 accounts.

As is the case in dashboards, you can customize the colors for each account or line within a graph by clicking the color drop-down. Toggling "Update to all graphs" will ensure that your color selection is consistent across all graphs.

📓 Note

If you have a report pack with multiple visualizations and you change Color 1 (for example) and add a new graph to that report pack, that new color will follow through to the other graphs in the report pack that use Color 1.

Default View

The default view is Net Profit or Loss Before Tax. However, you can change that to any category in the profit and loss statements and, within a category, to any accounts within that category.

The default period is the previous 12 months of data. However, you can change that to 12 quarters or 12 years by clicking the global date selector at the top of the screen. You can also change the number of months selected by clicking the period drop-down above any graph.

💡 Pro tip

Your Profit and loss statement helps you identify trends and seasonality in the data. It allows you to see if there are certain periods when the business is improving or declining, and it allows you to plan for those periods in the future.

KPI Scorecards in Visualize

The "KPI Scorecards" top tab within the "KPIs & Accounts" sub-tab, as shown in the image below, gives you a visualization of each of Syft’s key performance indicators or ratios for your business as well as custom KPIs that you've created you've created in KPI Scorecards in Analyze.

The standard view is the net margin. However, you can switch between any KPIs created in the KPI dashboard or any of Syft's standard KPIs.

The graph will show the trailing 12 months by default. However, you can switch this to either quarters or years. You can also switch between a line graph, grouped bar graph or bar graph to view KPI data.

You can view a KPI from any of your KPI Scorecards and zero in on specific KPIs within those scorecards. You can also choose the number of periods to show.

You can show data from:

  • Profitability

  • Liquidity

  • Solvency

  • Du Pont Analysis

  • KPI Scorecards

💡 Pro tip

The benefit of this graph is that it enables you to see how your accounting ratios change over time and to identify any trends or seasonality. You can also see if you are above or below your historic trailing average in any period. You may then be able to adjust your processes to improve these ratios.

You can also compare your KPIs against a budget or forecast by clicking "Compare," as shown in the image below. Additionally, you can choose the type of line pattern to assign to each variable within the color drop-down.

Transactions

The "Transactions" top tab within the "KPIs & Accounts" tab shows the total transactions processed in the entity over the prior 12 periods by default (which can be customized). To view transaction volume data, you can switch between a line graph, grouped bar graph, or bar graph.

This graph defaults to showing the total transactions for the prior 12 months; however, it can be customized by period and type of transaction.

Total transactions are the sum of all other types of transactions. Using the selector drop-down menu allows you to focus on a specific transaction. This graph's advantage is that it allows you to track trends and seasonality in the number of transactions processed in the entity.

🛠️ Use Case

If your invoices have dropped, it could indicate that your sales are decreasing. If your credit notes have increased, you could investigate why people return your products. Alternatively, you could consider why more manual journals were needed and if there were perhaps more errors.

This is a tool for examining things from a different perspective, which can enhance your ability to make decisions and notice issues.

Chart in Excel

Accounts and KPI graphs also have the option to "Chart in Excel." This allows full customization of a chart within Excel and visibility of the data it is plotting. Click on "Download" at the top right of any graph and then click "Chart in Excel."

After this, an Excel workbook will automatically download to your device. As you open the workbook, you will see the Accounts or KPIs graph and the data that fuels this graph plotted in a blank sheet, as shown in the image below.

💡 Pro tip

The data is editable, and the graph will reflect any changes you make.

Profitability

Get an overview of your income vs. expenses, sales, and profitability to identify trends and issues and better understand your business’s performance.

Navigate to "Visualize" > "Profitability" (as seen in the image below) to view your income vs. expenses, top sales accounts, cost of sales, other income accounts, top expenses accounts, and break-even graph. Let’s take a look at these reports in more detail.

Income vs. Expenses

In the "Income vs Expenses" top tab, you can visualize income vs expenses as represented in a graph for any period you choose.

As the Basics section mentions, all "Profitability" graphs can be customized by period, category, or account. The "Income vs Expenses" graph can also be filtered by division, and you can choose to display one of the following variables:

  • Income and Expenses

  • Income

  • Expenses

  • Profit & Loss

💡 Pro tip

You can identify seasonality and trends in the "Income vs Expenses" graph.

Sales

In the "Sales" top tab you can visualize sales in a graphical format for any period and get graph insights generated. The "Sales" graph shows, by default, the top 10 revenue or sales accounts for the period. What goes into your sales account is everything classified as revenue in your chart of accounts setup.

You can choose the view of this graph from the following:

  • vs. Prior (default): current vs. prior month, quarter, or year (depending on the period in the global date selector at the top of the page)

  • vs. Prior L.Y: current vs. last year's same period

  • vs. Budget: current vs. budget value (you can select the budget you would like to use and whether you would like to use the period budget or total budget)

Cost of Sales

Navigate to the " Cost of Sales " top tab to view the top cost of sales accounts in graphical format for any period and get graph insights. The graph views are the same as the "Sales" graph views mentioned above.

Other Income

Visualize top other income accounts in a graphical format for any period and get graph insights by navigating to the "Other Income" top tab. The "Other Income" graph shows, by default, the top 10 relevant accounts for the period. The graph views available are the same as for the "Sales" graph views mentioned above.

Expenses

Managing costs is critical to running a successful business. Syft's "Expenses" top tab allows you to see your largest expense areas. Click any value on the graph to drill down and isolate the cause of the expense so that you can understand and manage these expenses better going forward.

Visualize expenses in a graphical format for any period and get graph insights by navigating to the "Expenses" top tab. The "Expenses" graph shows, by default, the top 10 expense accounts for the period. The default view is "vs. Prior"; however, you can easily switch between the views mentioned for the "Sales" top tab.

💡 Pro tip

All of these graphs have full drill-down functionality. Clicking on any of the bars will open the transaction list for that account and for that period.

Break-Even

"Break-Even" is the point at which each additional unit of revenue results in an operating profit. It is calculated as fixed cost divided by contribution margin, calculated by taking revenue minus variable costs divided by revenue. To navigate to "Break-Even," navigate to Visualize > Profitability. Here, you will see Break-Even as one of the top tabs.

If you click any of the points to the right of the break-even point, then the following metrics and figures will be displayed in the graph legend:

  • Break-Even Point

  • Revenue

  • Operating Costs

  • Variable Costs

  • Fixed Costs

  • Operating Profit

  • Margin of Safety

💡 Pro tip

View specific values for these metrics at varying degrees above or below the Break-Even point by clicking on different points in the graph. This will allow you to see the different operating profits that could be achieved at different revenues.

Break-Even Equations

  • Operating Costs: the total operating costs for the business, which are composed of variable and fixed costs.

  • Operating Profit: revenue minus operating costs.

  • The margin of Safety: the distance between what the business generates in revenue versus its break-even point. So, the business could generate less revenue but still be above its break-even point and, therefore, generate operating profits.

👀 People also search for breakeven or break even.

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.

Under Cash in Visualize, you will find two sections: cash flow and cash balance. Cash flow is further divided into direct and indirect flows. Let’s look at these in more detail.

To get a visual sense of your organization's cash, navigate to "Visualize" > "Cash." Here, you can choose between the following graphs:

  • Flow: cash in vs. cash out

  • Direct: direct cash flow statement

  • Indirect: indirect cash flow statement

  • Cash balance: total bank balance as well as the balance of individual accounts

Flow

The cash flow graph shows the cash in and cash out in a business. Everything classified as cash and cash equivalents in your chart of accounts will pull through here.

You can choose the number of periods to show for each graph by clicking on figure 1 in the image below.

You can also choose which specific information to focus on. For instance, in the Flow graph, you can choose between:

  • Cash in vs. cash out

  • Just cash in

  • Just cash out

  • Net cash flow

You can also zero in on specific bank accounts if you would like to focus your attention on one or two in particular.

📓 Note

Cash paid is the same as cash out.

Syft excludes inter-account transfers so as not to inflate the numbers. We also look out for transactions that happened on the same day for the same amount of money.

Direct

In your cash flow direct graph you can view your cash flow statement. It turns your cash flow statement using the direct method into a waterfall, line or bar graph. To change the graph format, click on the icon above the graph.

If you decide to change to a line or bar graph, you can:

  • Choose between Totals, Accounts, Trading Activities, Cash Flow from Financing Activities, and Cash Flow from Trading Activities

  • Pick data to visualize: Trading activities, Accounts, Cash Flow from Investing Activities, Cash Flow from Operating Activities, Free Cash Flow, or Cash Flow from Financing Activities

  • Select the number of periods to show

Indirect

The cash flow indirect graph visualizes your cash flow statement indirect over a default of 12 months. You can use this graph to view your indirect cash flow statement using a waterfall graph or view elements of the statement with a bar or line graph.

Cash Balance

Navigate to "Cash" > "Cash Balance" to view your cash balance in a graphical format for any period. You can limit the accounts to the specific ones you want to focus on. The default view is for a 12-month period, but you can change this as well.

Within Cash Balance, you can select a specific bank account to focus on (as shown in Figure 1 below) and choose whether to show or hide individual balances (as shown in Figure 2 below).

💡 Pro tip

In the "Cash Flow`' and "Cash Balance" graphs, there is drill-down functionality on both of these graphs meaning that you can click on any point on the graph to see which transactions make up each account or click on any bar in the graph and drill-down into the details that make up that bar. This will open your transaction list from all your accounting software and system transactions.

Customers

Within the "Customers" tab you can visualize your top customers by sales, accounts receivable and debtors, debtors days outstanding, new customers, active customers and retention.

Sales

To analyze certain sales metrics, navigate to the "Metrics" top tab within "Sales," as shown in the image below.

Within the bar graph option, you can select one customer at a time to ensure a focused periodic view to identify trends with certain customers. You can multi-select customers to analyze and compare customer sales within the line graph option. The maximum number of customers you can select is 15 customers to ensure the graph is concise.

Analyze customer sales metrics within the "Metrics" top tab by selecting one of the following metrics in the drop-down:

  • Sales

  • Growth in sales

  • Percentage growth in sales

  • Average customer spend

  • Median customer spend

  • Number of purchases

  • Growth in purchases

  • Discounts given

  • Cost of sales

  • Gross profit

  • Outstanding

View top customers by sales in a graphical format for any period by navigating to the "Customer Sales" top tab.

📓 Note

This is based on customers you have invoiced in your accounting provider, minus any credit notes or returns for the customer. By default, it's a list of your 10 biggest customers. This is converted into your reporting currency.

Alongside this graph you'll see the proportion of total sales that a certain customer makes up. You can also choose the number of customer sales to view. For example, if you want to focus on your top 20 customers rather than just the top 10, you can do so.

🛠️ Use case

This function helps you identify which customers are generating the most and least sales. This information can inform your marketing and other business strategies, ensuring that you are looking after your customers and generating the most sales.

It can also prompt you to focus more on your lowest-sales customers and generate more sales from them.

Activity

Activity is divided into three top tabs: "Active Customers", "Customer Retention" and "New Customers". Navigate to the "Activity" tab within "Customers", as shown in the image below.

  • Active customer: a customer who has been invoiced during the period in question. In the active customers graph, you will see customers invoiced over the last 24 months.

  • Customer retention: month-on-month customer retention illustrates the proportion of customers invoiced in a given month that were also invoiced in the previous month.

  • New customers: the number of new customers who were invoiced per month.

The Active Customers graph shows unique customers invoiced during the period. This value will equal the count of "Number of Sales" within the Customer Sales table.

🛠️ Use case

It is useful to see the number of active customers you have, as active customers generate sales. If your active customers increase or decrease, you can investigate what changed in your business to ensure you make business decisions that increase active customers and, as a result, revenue.

These graphs help you get a sense of how many customers are repeat customers and how many customers you may be losing. This can be helpful when it comes to thinking about how you approach existing customers and how you might encourage them to buy from you or use your services again.

Receivables

Accounts Receivable

Navigate to the "Accounts Receivable" top tab within "Receivables" to visualize accounts receivable in a tabular format, as shown in the image below. You can drill down to see specific customers' outstanding invoices, as this report uses transaction-level data. Syft also takes into consideration multiple currencies and converts these for you.

💡 Pro tip

This can be a powerful tool in managing your debt collection to ensure that you focus your time on the right outstanding debt to ensure you recover it and that you are not selling new products to those clients who are not paying you.

Receivables and payables for Xero entities

You may wonder why Syft's aged receivables (AR) and aged payables (AP) reports differ to Xero's. Syft uses its own methodology to create these reports since:

  • Xero does not provide either of these reports via their integration so they need to be built from scratch

  • Xero does not share their methodology for how these reports are created. There are a variety of ways to classify unallocated payments, partial payments, prepayments, and FX movements to contacts and neither you nor Syft know how this is done in Xero

  • The methodologies used in Xero's old reports and new reports don't align either

In this section, we explain our methodology for calculating AR and AP reports, outline aging options available to you, and highlight a few common differences between Xero's old reports, Xero's new reports, and Syft.

Methodology

Generally speaking, Syft's methodology for creating an AR or AP report follows three steps:

  • Step 1: Accumulate invoices and payment information based on all journal entries

  • Step 2: Allocate assigned payments to invoices and contacts

  • Step 3: Allocate unassigned payments to invoices and contacts

Steps 1 and 2 are simple, and if it weren't for Step 3, all reports would align. The challenge with Step 3 is that it includes payments that can't be associated with journals, such as overpayments, pre-payments, partial payments, payments without assignment to contacts, and all of the aforementioned, with or without returns. This results in differences between Xero's old reports, Xero's new reports, and/or Syft.

For Step 3, Syft attempts to allocate unassigned payments using the date of the transaction. If we can't do this, Syft allocates the payment to the oldest time bucket. However, since there are several types of transactions in Step 3, this approach won't always align with how Xero approaches it.

Standard Receivables and Payables

The standard aged method is a calendar-based approach to receivables and payables. The aged buckets are Current month, last month, 2 months prior, 3 months prior, and 4 months or above.

Common differences

Below are a few differences you may notice between Xero's old reports, Xero's new reports, and/or Syft, along with steps to align them.

  • Contact names haven't changed:

If you change a contact name in Xero, it won't update in Syft. Xero doesn't allow us to fetch changes to contacts; it only allows us to fetch the entire list of contacts. Since we're updating transactions daily, re-fetching the entire contact list would slow down refreshes. However, Syft automatically fetches new contacts. If you'd like to fetch changes to historical contacts, contact a Customer Success Manager and we'll re-fetch all the data for your entity. This will take a few minutes and resolve the issue. We will make a change to avoid this in the future.

  • Unclassified as a contact in AR and Wages Payable as a contact in AP:

This occurs when you backdate payments and invoices in Xero. As a rule of thumb, posting an invoice in Xero several years ago may lead to reconciliation issues. Reach out to a Customer Success Manager and we'll re-fetch all the data for your entity. This will take a few minutes and will resolve the issue.

  • Time buckets:

Since Xero doesn't share their AR and AP methodology, we don't know how they allocate overpayments, pre-payments, partial payments, payments without assignment to contacts, and all of the aforementioned, with or without returns. A further complexity is the date to use, either the invoice date, the payment date, or the expected date. This results in differences between Xero's old reports, Xero's new reports, and/or Syft. Because of this, certain transactions aren't in the same time bucket, and, unfortunately, there is no way to align them.

Customer Debtors

Compare the total amounts due by your top debtors in a graphical format by navigating to the "Customer Debtors" top tab within "Receivables." You can change the number of debtors you want to focus on by clicking the drop-down arrow next to “Top 15”.

Debtors Day's Outstanding

Visualize debtor day's outstanding for the current month, the prior three months, and anything older by navigating to the "Debtors Day's Outstanding" top tab, as seen in the image below. This graph lets you quickly see the health of your debtor's balance and consider any need for expected credit losses or write-offs or more targeted action to try and recover these debts.

Suppliers

Within "Suppliers," you will see a visual representation of your top suppliers by purchases, accounts payable, creditors, and days outstanding.

Purchases

Visualize supplier purchases in a graphical format for any period by navigating to "Suppliers" > "Purchases." Choose whether to view a comparison between the current and prior periods or the current and prior last year's periods.

🛠️ Use case

This report is useful for helping you work out which suppliers are costing you the most money and how your purchases from them this month (or whatever period you have chosen to look at) compare to the prior month (or period). You can assess whether there are suppliers who might be more cost-effective or whether your spending has changed drastically in certain areas.

This view can help businesses identify dependency on key suppliers (when one supplier provides most of the items needed for your business) and help management implement backup plans in case that supplier stops operating or has supply issues.

Payables

The "Accounts Payables," "Creditors," and "Days Outstanding" top tabs within "Suppliers" > "Payables" work the same way as the "Receivables" top tabs within "Customers." The FX Exposures option is an additional functionality present in both the receivables and payables features.

The FX Exposures function allows you to analyze your accounts payables and accounts receivables exposure by currency to discern your risk in comparison to certain exchange rates. This will enable you to record any additional expenses or gains from currency movements for these accounts. Drill-down functionality also enables you to trace which invoices are contributing to the totals shown.

Products

Sales

Get a visual representation of the products you have sold with Syft's Products tool. navigate to the "Metrics" top tab within "Products" > "Sales", as shown in the image below.

Here, you will be able to select a metric that you would like to measure across products that you can multi-select from the drop-down for any period. To measure a metric with a more detailed view for a single product, click on the bar graph option. The metrics available are listed below:

  • Sales

  • Growth in sales

  • Percentage growth in sales

  • Cost of sales

  • Gross profit

  • Unique customers

  • Average products per purchase

  • Median products per purchase

  • Max products per purchase

  • Quantity sold

  • Growth in quantity sold

  • Percentage growth in quantity sold

  • Number of purchases

  • Average spend per purchase

Although you may have sold more of a certain product than others, it may not have been the most profitable. Checking the item’s GP contribution can be helpful in such cases.

Visualize top items by sales in a graphical format for any period.

You can amend the periods to view or the number of items to show, as well as date range options. You can also switch views between:

Inventory

The Inventory Management table gives you a high-level overview of all your physical items in your business, including the quantity on hand as of the reporting date, the average sales in the last three months of that item, and the most sales in the last three months of that item. Using the quantity of sales, the average number of sales, and the maximum sales in the month, Syft calculates when you are likely to run out of that item.

💡 Pro tip

The inventory list is ordered according to the shortest number of days until you run out of stock so that you can focus on items that need to be restocked most urgently.

Stripe entity

With Syft, you can make projections for upcoming churn in your business. Navigate to "Visualize" > "Subscriptions," where you will find three subscription tools as sub-tabs which are:

  • Recurring: visualize recurring revenue and recurring customers on a total basis.

  • Retention: visualize your company's retention rate, canceled subscriptions, and upcoming canceled subscriptions by revenue and customers on a total basis.

  • Unit Economics: visualize Average the revenue per user, calculated as total revenue divided by total number of users.

For example, in the "Upcoming Churn" top tab within the "Retention" sub-tab, you will find a graph that displays forecasted churn based on the current data Syft has for when churned customers will roll off the book.

Syft subscriptions terminology:

  • Churn: customers that have stopped using your product for a certain time frame and have a high chance of canceling their subscription

  • Expansions: active customers that have upgraded their subscriptions

  • Contractions: active customers that have downgraded their subscriptions

  • Existing: active customers with a consistent subscription

  • New: brand new customers that have just subscribed

  • Reactivations: customers who have activated their subscriptions again

Did this answer your question?