Accounting API
Welcome to our official feedback forum for the Xero Developer API.
The Xero Community site is the best place to submit feedback for improving Xero Business
15 results found
-
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…
131 votes -
Get Journals by Account Type
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 -
Expose reversal information in Journal endpoint
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.
<Journal>
<IsReversalOf>originalJournalNumber</IsReversalOf>
...
</Journal>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 -
Allow Paging for Journals GET
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.
Eg.
Extract Journals for April 2015.13 votes -
add Contacts as an element to GET Journals
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!
8 votes -
Make the journal narration visible to the API
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 -
Manual Journal Webhooks
Hi,
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.
7 votes -
Get deleted Journal Lines
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 -
Manual Journals: Add Customer and Business unit to the API
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 -
Add journal count to the Organisation endpoint.
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 -
Populate the reference field on Journals API with bills reference fields
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 API
3 votes -
Journals updated with "Find and recode" are never retrieved by the API
When using the If-Modified-Since header, journals updated via "find and recode" are never retrieved.
There are two main issues with this:
There is no way via the API to know when journals have been modified, so we're reporting numbers which don't reflect the GL.
In order to resolve the issue, we need to reload all transactions since the earliest created date of the recoded journal. This could be hundreds of thousands of journals.
3 votes -
Expose Conversion Date in Accounting APi
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 -
yoga teacher training in India
Embarking on a Yoga Teacher Training journey in India is more than just an educational experience; it’s a profound opportunity to transform your life and deepen your connection to yoga. India, the birthplace of yoga, offers an unparalleled environment for personal growth and professional development in this ancient practice.
https://gyanyogbreath.com/1 vote
- Don't see your idea?