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
  1. API access to General Ledger report

    Please add the GL report to the API Reports list

    63 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  ·  Flag idea as inappropriate…  ·  Admin →
  2. Create API to get information from Inventory reports (sales by item)

    I would like an API which tells me the same information as I can see in the Sales by Item report, this would mean I can see how much I sell in a month, or selected dates, of a particular item.

    For example I have an item called hourly rate I would like to GET the total invoiced in the month for hourly rate

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  3. Have the Aged Receivables API actually match the report in Xero

    Just have the API produce the aging buckets like the report

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  4. fix the Balance Sheet report via the API to support periods and timeframe

    You have recently completed "fix the Profit and Loss report via the API to support periods and timeframe", but not for Balance Sheet.

    This means can't do weekly cashflow reporting as balance sheet items are end of the month only which defeats the purpose of the P&L fix as need to balance this across to the balance sheet.

    Should be able to do as at any date.

    BUT can do this report via the Xero Reports in Xero. Needs to be consistent.

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  5. Sort your reports out

    Why are Xero reports so frustrating??? Is it just me?
    Another one that has wasted extreme amounts of time, the vat audit report.
    Why is it spread over a ridiculous area so you have to view it in wide view to see any useful information. What is the point? It fits it on a normal view then expands itself and you lose half the useful information?

    Then you have to randomly click all the blue underlined options to find the ONE that drills down to the detail. You check what you need to - ie why the hell there are…

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  6. Tracking Summary Report with Account Groups and Tracking Categories

    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  ·  Flag idea as inappropriate…  ·  Admin →
  7. Include statementLineID in Bank Statement report

    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  ·  Flag idea as inappropriate…  ·  Admin →
  8. report

    I would like the Receivable Invoice Detail report exposed to the API, if possible. Right now I have to generate the report (with some custom settings) and export it in order to copy over sales data on specific SKUs to our custom system so we can do some analysis on those items. This is all a manual process, and it would be so much nicer to be able to automate it to run as a daily task that uses the API. Thanks for your help!

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  9. Contact's & Supplier's Transaction Report?

    How can I get Contact's and Supplier's Transactions Report like general ledger?

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  10. indigenous employee report

    Add an employee flag for indigenous/non-indigenous to allow reporting of the number of indigenous employees for all payroll type reports. This is grant reporting requirement for indigenous corporations.

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  11. Trial Balance Report - Add Parameter to specify sort order

    At the moment the Trial Balance report via the API can only be sorted by Account Name. I would like to see a new parameter to allow us to specify the sort order for the report, e.g. by Account Name or Account Code. These are the same options available in the Xero UI.

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  12. add an option BankSummary to include accounts with zero balances and no transactions

    When an account has a zero balance and no transactions for the specified time period in the Bank Summary Report, it is excluded from the returned data.

    The request is to provide an optional parameter, 'includeZeroBalances' or the like, that includes these accounts and displays them in the report with zero balances.

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  13. create a new report for suppliers customers

    We need a report which can show all activity in suppliers/customers ledger by date ie invoice date, description, payment date. I cannot see anywhere a report like that which would be very useful.

    2 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  ·  Flag idea as inappropriate…  ·  Admin →
  14. Give the API the ability to provide the minimum of every report that Xero has

    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

    48 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  ·  Flag idea as inappropriate…  ·  Admin →
  15. be able to retrieve account transactions via the api.

    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,117 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    62 comments  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  16. 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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  17. Is it possible to have the Management Report and more budget reports available to export via API?

    I use QWD and would like to see the Management Report exportable as well as more budget reports eg budget per month from budget manager.
    This would allow far more flexibility in building reports and dashboards.

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  18. Get a Summary Tracked item sales report for a period

    Currently the "Inventory Item Details" report shows all the sales per item, but very difficult to work with. Can you please incorporate a Slaes for the period column in the "Inventory Items Summary"

    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  ·  Reports  ·  Flag idea as inappropriate…  ·  Admin →
  19. be able to retrieve Reports in PDF format as it is with the website

    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.

    29 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  ·  Flag idea as inappropriate…  ·  Admin →
  20. API report Sales by Item

    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.

    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  ·  Flag idea as inappropriate…  ·  Admin →
  • Don't see your idea?

Feedback and Knowledge Base