Skip to content

Accounting API

Welcome to our official feedback forum for the Xero Developer API.

The Xero product ideas site is the best place to submit feedback for improving Xero.


  • Hot ideas
  • Top ideas
  • New ideas
  • My feedback

16 results found

  1. 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:

    1. Retained Earnings journals (this is instead calculated by a report)
    2. Unrealised FX journals (again calculated and shown only in the report)
    3. 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…

    132 votes
    4 comments  ·  Journals  ·  Admin →
    How important is this to you?
  2. 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
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?
  3. 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
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?
  4. 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
    2 comments  ·  Journals  ·  Admin →
    How important is this to you?
  5. Support for Batching Manual Journal Updating by IDs in the Xero API

    We are requesting a new feature in the Xero API to support batch updating of Manual Journals by IDs in a single API request. Currently, the lack of this capability presents significant limitations for high-volume organizations that need to update arbitrary subsets of journals efficiently. They can batch insert new transactions, but they are very limited when it comes to batch update.

    Current Challenges:

    1. Arbitrary Subset Retrieval:
      • Our use case involves retrieving a specific subset of Manual Journals by their IDs, as requested by our clients. Without batch retrieval, we are required to make individual API calls for each journal…
    12 votes
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  6. 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
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?
  7. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  8. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  9. Get deleted Journal Lines

    Expose an isDeleted flag or something similar when pulling down Journal Line entries.

    6 votes
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  10. 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
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?
  11. 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
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?
  12. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  13. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  14. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  15. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  16. 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
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?
  • Don't see your idea?

Feedback and Knowledge Base