https://store-images.s-microsoft.com/image/apps.61799.ce5b41b2-fbf6-447b-926c-277b2d188620.8389df20-e10f-419d-9aa7-4d284b3416a7.56523522-f04b-4f33-8d0a-1a1aa8823491

QuickBooks Online To Power BI Connector

by Vidi Corp LTD

(1 ratings)

Quickbooks Online To Power BI Connector


Quickbooks Connector by Vidi solves multiple problems:

  1. No need to recreate P&L, Balance Sheet and other reports from 100+ different tables! All the data is combined for you in an easy-to-use format
  2. Multiple QBO accounts can be combined in one dataset
  3. Enables QBO connectivity to any BI tool including Power BI and Excel

You get a FREE dashboard when you purchase the connector 📊

If you find a table that you need, please contact us. We customize our code to include more tables for you.

Our data format has been used by Vidi Corp to create the following dashboards which we offer to our clients as products

You will get access to this data through a database (Azure SQL Server or Big Query). This could be a database owned by you or Vidi Corp can host the data for you.


Profit and Loss Detail

This table returns the profit and loss statement. The data is broken down by day rather than aggregated for a time period. The statement can be broken down to transaction level and is available on both cash and accrual basis.

No need to reconstruct this statement with formulas!

If your P&L statement has more than three layers of hierarchy, those will be automatically captured by the connector.

CONTACT US TO GET THIS SOLUTION

Balance Sheet Detail

Just like the P&L statement, this table returns the data broken down by day. It also groups individual transactions to balance sheet accounts mirroring the hierarchy of accounts in your Quickbooks Online. The data is available both on cash and accrual basis.

Cash Flow

This table returns cash flow activity by account

Accounts Receivables

This table shows how much particular customers owe you and how long the payment was outstanding for.

CONTACT US TO SEE OUR QUICKBOOKS CONNECTOR IN ACTION

Budget

If you have multiple budgets in your company, we can extract data from all of them. Our connector can extract the budget table below. This table can be joined with “Budget Detail” using ID.

Budget detail

Budget detail contains the actual budget numbers. It can be joined with

Customer Sales Report

This table groups sales by customer so that you can analyse how much each customer spent with you.

Other tables

The tables mentioned above are unique to our connector. On top of that Vidi Corp is extracting some more standard tables including:

The data format for them can be viewed on QuickBooks website. Simply follow the hyperlink above

At a glance

https://store-images.s-microsoft.com/image/apps.45502.ce5b41b2-fbf6-447b-926c-277b2d188620.072f8277-c841-4be7-8dfb-a3bb8ba66794.5b6aee59-3521-474b-89a9-3a4197c8449f
https://store-images.s-microsoft.com/image/apps.2830.ce5b41b2-fbf6-447b-926c-277b2d188620.072f8277-c841-4be7-8dfb-a3bb8ba66794.9f1d9efd-e92d-4f1a-93e3-380099bbe4ff
https://store-images.s-microsoft.com/image/apps.14551.ce5b41b2-fbf6-447b-926c-277b2d188620.be0fdbb9-9594-4c4e-9d4d-7560c7889725.007b3857-44d0-42fe-8583-d08dfcdf974e
https://store-images.s-microsoft.com/image/apps.13342.ce5b41b2-fbf6-447b-926c-277b2d188620.26579d15-ce31-4fb3-913e-2a2005623c3a.25d7e0c5-7650-4839-a0d4-7dfc4d34df57
https://store-images.s-microsoft.com/image/apps.26431.ce5b41b2-fbf6-447b-926c-277b2d188620.8389df20-e10f-419d-9aa7-4d284b3416a7.63978b62-70c9-44e2-816c-2b627de78b89