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 from 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 in to 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 insights 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 create a Xero data source with Bold BI through the CData Cloud Hub connector. You will need to create a OAuth2.0 app before connecting to Xero data. 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.
Now let’s see how to connect Xero data through the CData Cloud Hub. 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, click the Xero data source.
In the Settings tab, choose the schema you want to visualize in your dashboard.
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.
Once you have set the properties in the Advanced tab, navigate to the Settings tab and click Reset Database to prompt the OAuth flow.
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.
The created database will be listed under databases like the following.
Once you’ve saved the Xero virtual database, you are ready to connect to Bold BI with the MySQL endpoint.
Creating Xero data source through MySQL using Bold BI dashboard
To create a Xero data source through MySQL, select MySQL from the data source list and fill in the required details.
Click Connect to connect with the configuration set. Drag and drop the table and save the CData Xero data source.
The created data source will be added to the DATA SOURCES panel. Once the data source is created, add the required widgets to your dashboard and connect data to them to visualize the 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 MySQL connection.
Refer to the following 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.
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. Bold BI dashboards now come with a 15-day free trial with no credit card information required. We invite you to start a free trial and experience Bold BI for yourself.