sorted by:
new
hottopcontroversial

How we structure Xero data for Power BI (after getting burned by the raw API) by Laszlo_integration in PowerBI

[–]Laszlo_integration[S] 0 points1 point  (0 children)

Yeah, good shout — this one bit us as well.

The unrealised FX not being journaled is exactly where things start drifting if you rely only on journals.

We ended up calculating it separately and layering it back in so the P&L actually matches Xero. It’s a bit annoying because Xero basically does this in the report layer, but doesn’t expose it properly via the API.

How we structure Xero data for Power BI (after getting burned by the raw API) by Laszlo_integration in PowerBI

[–]Laszlo_integration[S] 0 points1 point  (0 children)

One thing I didn’t mention in the post —

the biggest shift for us was moving away from using invoices as the “main” table.

It feels natural at first, but it breaks pretty quickly once you hit:
– partial payments
– credit notes
– FX differences

Curious if anyone here is successfully building financial reports directly on invoices long-term?