Unleash financial insights from Xero data

Unleash Financial Insights with Xero Data

Tired of time-consuming tasks and manual data entry? Your time and money are better spent on efforts to grow your business. With Xero online accounting software, you can get beautiful views of where your cash is going and put time-consuming tasks on automatic. Xero is built for small businesses for managing financial data with invoicing, bank reconciliation, inventory, sales, expenses, bookkeeping, and more.

Why use Xero?

Xero allows you to manage all your finances in the cloud. You can log into software and check the health of your organization anywhere, anytime, on your Mac, PC, tablet, or phone to get awesome views of your cash flow. Xero accounting software takes its information directly from your online banking accounts so you never make a mistake typing in the numbers—it’s much more accurate. It also allows you to get paid faster through online invoices for your customers and be updated when they’re opened.

Bold BI allows you to extract financial patterns from Xero analytics data so you can keep an eye on your finances and stay on top of your company’s interests.

In this blog post, we are going to explore how to integrate Xero data with Bold BI. We’ll track key accounting metrics through a dashboard that gives you a clear view and understanding of your business’s financial health.

Connecting Xero data with Bold BI

You can connect to Xero data with Bold BI in the following ways:

  1. Connect with direct Xero data connector.
  2. Connect with Xero data connector through CData Cloud Hub.

Let’s see how to create a Xero data source using Bold BI with a direct Xero data connection.

1. Connecting with direct Xero data connector using Bold BI

To create the direct Xero data source connectivity from the dashboard designer, follow the steps explained on this page. Also, use the steps in this documentation to authenticate with Xero web service.

After successful authentication, the NEW DATA SOURCE configuration panel opens, as shown in the following image.

Xero Data Connection Panel
Xero Data Connection Panel
  1. Specify a unique name for the Xero data source and provide a description (optional).
  2. Choose your Organization from the drop-down list.
  3. Select Resources from the drop-down list. The corresponding URL will be displayed in the URL text box. If you want to connect with other endpoints, you can enable the Custom Urlcheck box and provide the URL in the text box manually.
  4. Enter xero-tenant-id in the header panel by selecting ADD above the header, if you selected the Custom Url check box.
  5. Leave the default value GET for the REST API under Method.
  6. Set a time interval for Refresh Settings so that the dashboard can refresh itself with the latest data updates.
  7. Set the data format to be JSONsince all the REST API endpoints return results in JSON format.
  8. Xero will be set automatically in the Authentication Type section since OAuth is used for authenticating with a Xero account.
Xero Data Connection with Required Details
Xero Data Connection with Required Details
  1. Select Preview & Connect to connect with the configurations set. Drag and drop the table and save the Xero data source.

Now let’s see how to create a Xero data source using the CData Cloud Hub connector in Bold BI.

2. Connecting with Xero data connector through CData Cloud Hub connector using Bold BI

To connect with the Xero data connector through the CData Cloud Hub, you will need to create a OAuth2.0 app first. Each app is assigned a unique client ID and client secret that will be used in the OAuth flow.

Set OAuth 2.0 redirect URI to https://oauth.cdata.com/oauth/ in your app. You can then log in and connect your app in the CData Cloud Hub.

Creating Xero OAuth App
Creating Xero OAuth App

Now let’s see how to connect Xero data through the CData Cloud Hub connector. This will allow you to create a virtual database for all supported connectors and make it available as a standard SQL interface. Refer to this blog post for more details about CData Cloud Hub connector integration with Bold BI.

Creating a virtual database for the Xero data source in CData Cloud Hub

In your CData Cloud Hub, select the Xero data source.

Selecting Xero in CData Cloud Hub
Selecting Xero in CData Cloud Hub

In the Settings tab, choose the schema you want to visualize in your dashboard.

Creating Virtual Database for Xero Data
Creating Virtual Database for Xero Data

In the Advanced tab, set the OAuth Client ID and OAuth Client Secret properties to successfully launch the OAuth flow. Verify that OAUTH2 is selected for the Xero App Authentication property, as shown in the following.

Setting Up for Xero Database
Setting Up for Xero Database

Once you have set the properties in the Advanced tab, navigate to the Settings tab and click Reset Database to prompt the OAuth flow.

Creating a Virtual Database for Xero Data
Creating a Virtual Database for Xero Data

This will prompt you to log in to your Xero account through the browser. When you do so, the necessary OAuth credentials will be generated and applied to the created database.

After you have followed these steps, you should receive a ‘Success!’ message in Cloud Hub. Once you receive this, click Save Changes to save the generated OAuth credentials to the created database to maintain connectivity.

Save Database in CData Cloud Hub
Save Database in CData Cloud Hub

The created database will be listed under databases like the following.

Showing Available Databases in CData Cloud Hub
Showing Available Databases in CData Cloud Hub

Once you’ve saved the Xero virtual database, you are ready to connect to Bold BI with the CData endpoint.

Creating Xero data source through CData using Bold BI dashboard

To create a Xero data source through CData, select CData from the data source list and fill in the required details.

Xero Data Connection with Required Details
Xero Data Connection with Required Details

Click Connect to connect with the configuration set. Drag and drop the table and save the CData Xero data source.

Data Source Editing Window
Data Source Editing Window

You can create a Xero data source in the two ways I’ve explained. The created data source will be added to the DATA SOURCES panel.

Data Source List Panel
Data Source List Panel

Once the data source is created, add the required widgets to your dashboard and connect data to them to visualize your metrics.

Creating a financial dashboard with Xero data

Let’s visualize key accounting metrics with Xero analytics data using a Bold BI dashboard through a CData connection.

Refer to the following Xero online accounting dashboard.

Xero Online Accounting Dashboard
Xero Online Accounting Dashboard

This Xero online accounting dashboard focus on tracking the financial data of company through following metrics:

  • Accounts Receivable
  • Accounts Payable
  • Receivable Overdue
  • Payable Overdue
  • Income over Month
  • Expense over Month
  • Overdue Amount
  • Invoices Overdue
  • Recent Payments
  • Accounts Payable and Receivable by Month
  • Net Profit Forecasting over Week

 

The Xero online accounting dashboard is useful to business owners, bookkeepers, and accountants for keeping track of what is happening in their business.

Conclusion

We hope this blog post provides needed information about Xero and guides you in connecting to Xero data in a Bold BI dashboard. If you have any questions, please use the comments section available below. You can also contact us by submitting your questions through the Bold BI website or, if you already have an account, you can log in to submit your support question.

Access live 30-minute demo with our experts

Leave a Reply

Share

Access live 30-minute demo with our experts

Related Blogs

Up arrow icon
Live Chat Icon For mobile
Hugo Morris

We are here. Let’s chat!

Live Chat Icon