Skip to content

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

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

13 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…

    127 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    4 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    2 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  5. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  6. Get deleted Journal Lines

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

    6 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  7. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  8. 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!

    5 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  9. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  10. 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.

    4 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  11. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  12. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  13. 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
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    0 comments  ·  Journals  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  • Don't see your idea?

Feedback and Knowledge Base