Forum Discussion

afvijay's avatar
afvijay
Regular Visitor
7 years ago

Inaccurate Data between Quickbooks Online and PowerBI Data Set

We recently decided to try out PowerBI and linked our QBO account with Power BI.   When we got our data, our balance sheet data on banks are way off compared to the QBO data. When we ran a Balance...
Need Help
afvijay's avatar
afvijay
Regular Visitor
7 years ago

Thanks for the kind reply. Please refer to the below for screenshots. 

 

  • We made sure the accounts are all in RECONCILED status to ensure our GL data reflects the latest figures.
  • These are all bank accounts
  • GL shows the data right no QBO reports and GL registers.
  • PowerBI is throwing numbers that doesn't make any sense.

Screenshot of side by side compare : https://ibb.co/5K1fp9z 

 

Thank you

 

afvijay's avatar
afvijay
Regular Visitor
7 years ago

After doing a little digging on one account that had a $3,000 GL balance on PowerBI Dataset and compared it line by line to QBO transactions we found there the PowerBI dataset is NOT calculating the GL Ledger data due to currency conversions.

 

  1. We had one Canadian Invoice for $11,300 and we got paid $11,300 in Canadian dollars.
  2. The check got deposited in the US bank account
  3. When the bank processed the check, it deposited ROUGHLY $8,000.
  4. The transaction was reconciled with ending balances matching both on A/R and bank.

So in this scenario, the invoice has been paid fully and the A/R is zero, the bank converted and deposited the correct USD amount.

 

However PowerBI somehow calculates the difference between the CAD invoiced amount and USD as the correct GL balance. 

  • In QBO the current bank GL balance = 0
  • In PowerBI data set the current bank balance is $3300.

So if I am calculating CASH on hand scenario, right now PowerBI shows we got $3300 at hand which is wrong. Is there a different way to look at this ??