Retained Earnings / unrealised FX (system account) journals
Xero has 'system' accounts where journals are not posted, but values are calculated by reports. Therefore when pulling the journals from Xero, we can not accruately recreate the balance sheet and P&L (as vital journals are missing). Therefore in this respect the Xero API is incomplete.
Specific examples of the Journals API misses:
- Retained Earnings journals (this is instead calculated by a report)
- Unrealised FX journals (again calculated and shown only in the report)
- May also be the case for other system accounts.
The calculations made by the reports could be made available via the API to provide a complete set of journals in the API. This would allow third party developers to mirror the full transaction level journal detail that should exist in Xero, and accurately recreate the P&L and Balance Sheet at each period end date based on the conversion balances and all journals posted since.
Joe Grilli
shared this idea
-
Lucas Vandenbussche commented
Dear Xero support team,
When will progress be made on this?
Since this is vital for third party integrations -
Will Ferguson
commented
Has there been any progress or Acknowledgemnent from Xero on this request?
Have any other integrators discovered a work around? -
Will Ferguson
commented
The ability to fetch unrealised gains figures from the Accounting API at the GL Transaction Level is critical to our ability to accurately report in the Phocas Finacial Statements for Xero offering
-
Swati Shroff
commented