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.


Accounting API

Categories

JUMP TO ANOTHER FORUM

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

53 results found

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

    451 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    under review  ·  72 comments  ·  Reports  ·  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. 77 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    not planned  ·  15 comments  ·  Reports  ·  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. Please update your Reporting APIs w/ an option to get V2 [new] Balance Sheet and Profit & Loss including the default custom layout.

    It is extremely frustrating that the report that comes from the API often in no way resembles the report that the Xero end-user actually uses via the UI, to the point that they don't even recognize it. They invested a lot of time making a custom layout with groups, rules, etc and the result is a pretty fantastic presentation of their financials, but all that work just gets thrown out when a 3rd party application collects the…

    29 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    3 comments  ·  Reports  ·  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. 27 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Reports  ·  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. Please add the GL report to the API Reports list

    26 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Reports  ·  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. I have found an awesome tool by Quick Win Development (http://www.quickwindevelopment.com/) that allows us to extract data via the API straight into Excel.

    Because 80% plus of the reports I ever generate in Xero are exported directly to Excel, please can Xero build into the API the ability to replicate every report currently supplied by Xero, as a bare minimum seeing as though the Reports are diabolical compared to other accounting systems. Particularly for me the P&L by month for a start/end date period.

    Thanks
    Murray

    21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Reports  ·  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. Currently the Inventory Items Summary report is not exposed yet via Xero API. Please vote so we can keep track the demand for it.

    21 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    6 comments  ·  Reports  ·  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. In lieu of a Bank Statement endpoint, including the statementLineID in Bank Statement report would be really helpful

    We present a view of the Xero bank statement and show the bank account balance in some of our reports. It's difficult to reliably keep the bank statement in sync without some kind of unique ID on the statement line.

    16 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    4 comments  ·  Reports  ·  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. I would like to see how much has been calculated to 'pay to customs' for the current period. The same value seen in the current VAT report.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    2 comments  ·  Reports  ·  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. I would like to export PDF reports via the API to email to management monthly via a 1 click process. I cannot built this presently without converting the report data to PDF format myself.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Reports  ·  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. Because we currently extract accounts through reports, we don't get the internal unique identifier and have to match on number and name. If the user re-names or re-numbers an account in Xero (and this is likely to happen to other entities) we lose the connection to the account stored in our system and the user potentially loses data.

    12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Reports  ·  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. Xero will be retiring the old reports on July 31. By retiring the old reports, you also retire the only place where subscribers can affect the layout of the Profit and Loss report retrieved via the API. However, to date, you offer no replacement and no transition plan to your subscribers or developers.

    We use the Reports endpoint to retrieve data needed for our internal reporting. If not for the API, we'd be pulling and formatting seven reports to compile our monthly reporting. Today, if we add a new account or need to change the layout for the P&L retrieved…

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    10 comments  ·  Reports  ·  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. Provide API to get report Sales By Item. because it will help to analyse sales by Item (Product). Now we can generate the report but I don't see API to get report data as other financial report.

    9 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  14. Able to access the Sale Tax Report via the API

    8 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  15. Per the documentation for Profit & Loss periods, the only way to always get a full month of data for previous periods is to start in a month with 31 days.

    Given we have a 30 June year end this is a pretty annoying workaround.

    The confusing thing is that setting up the Balance Sheet in a month with 30 days doesn't result in this issue and prior periods will automatically show the 31st day where applicable.

    6 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  16. The Xero reporting api needs an overhaul to enable to report content in a format that makes it much easier to parse and retrieve data from it. The current way the data is represented requires custom parsers to be created at the consumer's end

    5 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    5 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  17. Adding in the tracking CategoryID and OptionID parameters to the trial balance endpoint would allow for easier & more detailed analysis across multiple tenants in client-specific use cases. The capability exists in the UI via the "new" Trial Balance, so there's a disconnect between the expected level of detail one can get from the UI vs. the API.

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  18. Can an API be created to retrieve custom reports outside the current scopes?

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  19. Hi,
    We can get and customize Xero projects reports by using API. But unfortunately, Xero reports API for projects is not available. Can you please add this API to your system.
    Thanks

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
  20. I would like the Budget Variance Report to be available via the API:
    https://central.xero.com/s/article/Budget-Variance-report

    It is not listed in the reports available from the API
    https://developer.xero.com/documentation/api/reports

    4 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    0 comments  ·  Reports  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
← Previous 1 3
  • Don't see your idea?