Connector: Capture unrealised currency gains for customers using multi-currency Quickbooks/Xero
Quickbooks and Xero calculate on demand the unrealised currency gains/losses for open invoices when reporting on the income statement. This is not a journal line you can capture yet, so you need to check open invoices and calculate this on demand and add to the GL.
If you don't do this, the open invoices will compound any forex accounts over time and what Fivetran captures will be materially different than what is in the accounting system
Context from Fivetran employee: https://github.com/fivetran/dbt_xero/issues/48#issuecomment-2159730894
-
Brandon, I am dealing with the same issue with Quickbooks right now. I am comparing the Payment/Invoice data and the Bill/Bill Payment data to attempt to calculate the gain/loss. Not perfect, but a step in the right direction. Have you had any luck finding a solution?
Please sign in to leave a comment.
Comments
1 comment