QuickBooks Online
Azure SQL Server
Power BI
Power BI Quickbooks Online connector by Vidi is the most convenient connector on the market as it solves multiple problems:
Have you also spent dozens of hours trying to make the native Power BI QuickBooks Online connector work for your business? Have you also found it difficult to make your numbers in Power BI match to what you see in QuickBooks Online?
Our connector offers an easy solution to this problem because of its convenient data format! All the data is grouped into tables like P&L, Balance Sheet, Cash Flow, etc. No need to blend the data from dozens of different tables as it is already blended for you by us! You can also drill down to specific transactions that make up the values of your accounts.
If you have multiple QuickBooks Online accounts (perhaps you run an accounting practice or a group of companies), you will need some way to combine their data together. Our Power BI QuickBooks Online connector allows you to connect to multiple companies and combine their data in a single file!
Why reinvent the wheel and try to recreate the Quickbooks P&L, Balance Sheet and Cash Flow statements in Power BI yourself? Use our free Quickbooks Power BI template to visualise your financial statements in 5 minutes!
Learn more about our connector below:
We offer a no-code integration that extracts the data from the Quickbooks Online API into an Azure SQL Server database. This database can then be connected to Power BI using the native Azure SQL Server connector. The integration between Azure SQL Server and Power BI is very stable even for large volumes of data and allows our clients to set up additional data security rules on Azure.
Install
Find the Quickbooks Online connector inside of our client portal and click install. This will create all the tables inside of the selected database. Your data will later flow to these tables.
Connect new company
Authenticate to your Quickbooks Online account and select one or more companies you want to connect to.
Wait for the data to sync
The first database refresh will take a few hours as all the historical data will be extracted. Every refresh afterwards will take a couple of minutes. You can use the refresh status tab to view the refresh status.
Install our free Quickbooks Power BI template
Install our free Quickbooks Power BI template to visualise your data in Power BI in 5 minutes! Feel free to customise the PBIX file afterwards!
Our Power BI Quickbooks Online connector extracts data in a very convenient format saving you dozens of hours in data blending efforts. You will get tables like:
Additional customisations are available upon request.
You get a FREE dashboard when you purchase our connector
The template includes the following pages:
P&L Visualised
P&L Table
Balance Sheet Visualised
Balance Sheet Table
Cash Flow Visualised
Cash Flow TableOld price of the dashboard – $3000
New price – free with the purchase of our connector.
$1200 per year
14 days free trial
Unlimited number of Quickbooks Online accounts
Free Power BI dashboard
Challenge
Fractional CFO Consultancy
The client has an ongoing need to report to 35 clients based on the standard Power BI templates. Extracting data manually into Excel used to take 6 hours per month, resulted in manual errors and the process wasn’t scalable.
Solution
The Power BI Quickbooks Online connector by Vidi was used to extract data automatically from all the clients and combine it in a single database. The free Quickbooks Power BI template was used to visualise the data immediately after purchase.
Challenge
Retail Company
The client is the CEO of the retail company with 5 locations with one Quickbooks Online account per location. They needed some way of viewing the data of all the 5 locations together.
Solution
The client used the “add a company” feature of the Power BI Quickbooks Online connector by Vidi to add all 5 of their QBO accounts into the same dataset. As a result, they were able to see the data for all the 5 companies together in a Power BI management report.
Challenge
Software Development Company
The client struggled with building the Power BI reports from the native Quickbooks Online Connector. After spending dozens of hours trying to blend the data and not getting their numbers to match, they inquired about our connector.
Solution
The easy data format inside of the Power BI Quickbooks Online connector by Vidi allowed the client to build the custom reports they needed with ease! The free Quickbooks Power BI template also allowed them to get started with the reporting quickly!
The product gave me the ability to analyze data more in-depth and on a cost-center level. This automated previously very time consuming tasks.
Carl De Geer
Ivisys
The product gave me the ability to analyze data more in-depth and on a cost-center level. This automated previously very time consuming tasks.
Carl De Geer
Carl De Geer
