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

50 results found

  1. allow filtering in reports at the group level

    A U.S. nonprofit's statement of activities groups expenses by activity, not by account. It would be helpful to be able to add an account to a blank report more than once so the account can appear under different groups, and to be able to apply a filter to each group by one or more tracking categories. This would allow us to create a report using the Blank Report template that mimics the statement of activities.

    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  ·  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. Create a transition plan for Reports via the API

    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…

    16 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)
  3. Get mapping of companies with all embedded integrations

    Suppose, I have more than 500 companies to manage and each one uses different integrations eg: routable, adp, toast, square etc. How can I see which company is associated with how many integrations. I want to have a report or api that can provide me that information.

    Otherwise, there might be a possibility that for example: "Company A" in Xero might accidently or by human error be connected to "Company C" in routable instead of "Company A". Having some kind of metric can help in auditing/correcting such things else it could be a recipe for disaster.

    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  ·  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. Get the percentage of income in the Profit & Loss API

    The profit & loss api requires a % of income exported into their json it'll help report devs like me working on the custom reports to avoid complicated calculations on the reports and bring flexibility of data in 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  ·  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. Allow API Access to run the Bank Reconciliation Report

    In lieu of being able to interact with the Bank Feed information directly via the API - it would be useful to be able to run the Bank Reconciliation Report directly from the API.

    The use case in mind is:

    I would like to set up a proactive notification when there are incoming amounts that are not reconciled in Xero in order to prompt someone to go in to Xero and manually reconcile those items. This will help prevent our customers from getting automated invoice reminders when they've paid.

    We're not at the point yet where someone is in Xero…

    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  ·  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-BalanceSheet API for reporting should spit out data as of the input date parameter

    I've been working with GetBalanceSheet reporting api, I realized while fetching data for all dates and found out that it is returning data pointing to the last date of the month in the input date.

    Example:

    Get-Balancesheet API
    date: 10/24/2021 (mm/dd/yyyy)

    API returns data as of 10/31/2021 instead of 10/24/2021

    Get-IncomeStatement does not have this issue.

    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  ·  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. Ledger for particular account shows corresponding Accounts

    Existing General ledger report gives understanding Summary/detailed Dr and Cr amounts but it does not tell you which Accounts are involved in transactions. Ability to create Summary Ledger for particular Account that shows correspondence with Accounts according recorded transactions. It is very useful to find mistakes if your allocations were wrong. For example, when you created bill and mistakenly choose wrong GST type or expense Account. Another good reason for monthly/quarterly reconciliation AR/AP. For example, creating AR ledger you will see aggregate or detailed amounts of Bank/Cash accounts, GST and Customer deposits. If you made mistake when you reconcile bank…

    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  ·  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. 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  ·  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. Tracking CategoryID/OptionID parameters in Trial Balance endpoint.

    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)
  10. SIE file report/export

    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)
  11. Make it possible to run a report featuring all account codes including those with zero balcance

    When one is running a Cash Summary or Profit & Loss, why not make it possible to view & export the report featuring all active account codes?

    This would save a lot of time formatting excel sheets if the rows lined up every time. And it seems like a simple fix, just add the checkbox:

    "Run report featuring zero balance active accounts"

    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  ·  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. Retrieve custom reports

    Can an API be created to retrieve custom reports outside the current scopes?

    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  ·  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. Add Income By Contact to Reports API endpoint

    It would be extremely useful to us, if the Income By Contact report were to be requestable through the API.

    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  ·  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. Add the date a transaction is created/finalised to appear on all reports as an option

    I have clients that do there own bookkeeping but are on partial exemption VAT and they are forever changing things in prior VAT periods. It would be useful to have a date of the transaction in all reports as it would be easier to make the required adjustments. This also relates to aged debtors/creditors and transaction reports as it would speed up the process of identifying any new transactions that were posted in earlier periods.

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

    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…

    62 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  ·  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. Get Xero Projects Report using API

    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)
  17. Budget Variance Report via the API

    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

    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)
  18. Create API to get VAT return

    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)
  19. 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  ·  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. 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  ·  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?

Feedback and Knowledge Base