13 results found
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…127 votes
I need to get all those Journals which involves a Bank account. (i.e. one of its JournalLines has an account of type Bank).
Note that If I get all journals using Journal API, it is very time consuming. I hope to use the Journal API in such a way so that it only returns those Journal which involve a bank.26 votes
Problem: if a Journal is reversed, Journal.SourceId may point to an invoice whose LineItems do not correspond to JournalLines.
Proposed Solution: If a Journal is a reversal, expose the number of reversed journal via API, e.g.
When it is useful: in the simplest scenario, when Invoice's LineItem is edited, the original Journal corresponding to the Invoice is reverted and new one is created. We end up with three Journals: Journal1 and Journal2 cancel each other, Journal3 reflects (the new version of) the invoice. Unfortunately, all three Journals have SourceID pointing to the (now modified) invoice. Consequently,…22 votes
Please consider adding Paging for the Journals GET.
Journals represent a considerable size of data when extracting for e.g. a full financial year.
Alternative solution could be filtering options.
It would be beneficial to be able to either FILTER for a range of data or PAGE the data (for timely returns from the web service).
The modified-since and offset options only allow for smaller, recent datasets, not for smaller ranges of data from for e.g. the previous year.
Extract Journals for April 2015.13 votes
Would like to be able to access the journal narration through the API. Currently you can just access the line item reference but this requires too much coding effort by our bookkeeper and as such most reference lines are blank. However, every journal/transaction has a narration so would be great to access this.7 votes
Expose an isDeleted flag or something similar when pulling down Journal Line entries.6 votes
Fix broken linq count() processing on anything that is pagged like journals. Count is defined as the nuber of records, and cannot be pagged.
Fix linq count() to match stanadard, not massed up version..
Count cannot be paged, this is very basic..5 votes
This would allow much greater financial reporting flexibility. Like Tracking Categories, not all Journals have Contacts. Your new Xero report, P&Ls by Contact, leads me to believe the Xero data structure may support this. Thank you!5 votes
There is currently no wat to choose Customer or Business Unit on the line item in the Manual Journals, that I can see.
I am using the c# api.4 votes
I was wondering if there was any plans to implement webhooks for Journals?
Would be a great implementation for building block to Xero and working with the system.4 votes
It would be useful to get a general idea of the size of a particular organisation. The journal count also serves as a maximum on the journal number field. Useful for displaying the percentage completed, if an API user is pulling the entire ledger.3 votes
For all bill journals retrieved through the GET Journals API, the reference field is blank. There is a reference field on bills. It would be great if they could be written to the journals table and exposed through the API3 votes
We have a requirement to extract the Conversion Date of a company to work the total number of fiscal years with data, but it is not available through the API. Please expose it in the Organisation endpoint.1 vote
- Don't see your idea?