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

50 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/

    1,243 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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. 195 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    not planned  ·  14 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…

    71 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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. 69 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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

    66 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  ·  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

    51 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  ·  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.

    46 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    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.

    46 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  ·  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. 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.

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

    31 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  ·  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. 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.

    30 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  ·  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…

    22 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    7 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.

    21 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  ·  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

    18 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  ·  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. 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

    13 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  ·  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. 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.

    12 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  ·  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. 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

    8 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  ·  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. Xero is awesome for Financial data management and manipulations. Its API providing the extra strength to Xero for integrating Xero with other webapps. Of course Most of the APIs are in still Xero Development Phase, But we need an extensive API for getting the reports(at minimum Tracking Summary Report) to make the use of tracking summary data inside webapps.

    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  ·  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. 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

    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  ·  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. SIE is a universal data format to exchange accounting information between different systems.

    Our auditor prefer having a SIE4 file, which he would import into his own system, to do the final revision and making necessary documentation for the government. W/o this file he has to tap in the data manually, which takes more time and cost us more money.

    We would like to add the SIE file format as an alternative for export.

    For mor information
    https://en.wikipedia.org/wiki/SIE_(file_format)

    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  ·  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?