be able to retrieve account transactions via the api.
Provide an API to retrieve the transactions of an account. (e.g. something like this Profit & Loss report-> click on the YTD value of an account)
More discussion in the thread <https://community.xero.com/developer/discussion/326819/>
Currently, we’ve no plans to work on this feature but please continue to add your votes and comments.
We’re continually adjusting our priorities as different features are completed and your feedback is really important.
Dang Dinh Dang commented
I really need this one, please do it asap.
I'm very surprise this feature is not your top priority, being able to extract all transactions is accounting 101.
wee needed to as an urgent matter
An Accounting software API without a way of getting account transactions really looks lacking
Leslie Viljoen commented
We've had to work around this not being available, and are still providing clients with a confusing and sub-par experience when using reports in our Xero app. Please can we have a Transactions API Xero?
Can't express enough how valuable this API would be.
Paul Jervis commented
Both myself and my clients would benefit from being able to access an API feature like this.
Need this one too!
i need this also
This would be a very useful upgrade.
Any updates on how this is going? We have lots of clients that would like this feature.
I need this as well.
Christian Burgos commented
i was looking for the account transaction, unfortunately the api doesn't have this. i tried using the journal endpoint but it's also incomplete.
Jeronimo Cabrera commented
Any updates on this?
Intuit Quickbooks & MYOB ARL both have this feature in their API. Xero is the innovator so please bring it in ASAP
Has there been any update to this?
I am after an endpoint(s) where i can retrieve every income and expense transaction at an Account level, showing me:
> when and how much was invoiced (accrual basis), and
> when and how much was actually paid / received (cash basis).
Gill Goddard commented
This is the one area that will make a huge difference to have via the API - you have tracking categories and these are now available to pull down via API for Profit and Loss by tracking and Balance Sheet by tracking but not actually being able to pull transactional data of a various sorts doesnt fit with teh message that Xero likes to work with Addons. We find the current setup of the transaction detail which can be exported into Excel - less a few columns we can use to update our solution today -- what is missing is the ability to do that online rather than users having to manually run and then reload into our solution. One option to consider when this is made available is the abilty to have the data pre accumulated for same tracking categories. Any idea of timing for this?
Giving the journal endpoint the same set of parameters as the GET for manual journals would solve this problem. Specifically being able to use a WHERE parameter on the journal GET.
We have a few use cases for this.
1. Reporting the full content of an arbitrary nominal over an arbitrary period.
2. Consolidating entities by copying transactions into a pesudo group entity. Having a more refined way of pulling all journals in user definable segments (rather than just an offset) would be helpful.
Peter Baumgartner commented
My use case is fetching all transactions that match a certain segment/tracking ID.
I need this as well; all sorts of automation can be done here for auditing and checking of data. Was a bit surprised there is nothing to do this easily at the moment.