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

  • or

32 results found

  1. The exchange rates are automatically calculated in Xero and not available for query. I want to use the same exchange rates in a third-party software (otherwise the reported money amounts will not match), so I need a way to query the exchange rates that were valid on a certain invoice date.

    71 votes
    How important is this to you?
  2. Currently when entering a payment for an invoice in a foreign currency I need to enter the exchange rate. Generally I have to final AUD value and the final USD value, so would prefer the fx rate is calculated automatically.

    In addition, it seems the fx rate has limited precision; I end up needing to put in manual adjustments when reconciling which is also a pain.

    6 votes
    declined  ·  0 comments  ·  Admin →
  3. Create and API entry point to set default exchange rates, just like we do on the Settings page.

    Rational: here in Poland, we're obliged to use the Polish Central Bank exchange rates on accounting. Having an API for it makes it possible for us the call it once everyday to set the rate for the next day. Without this we're not able to use Xero officially for bookkeeping. (we have to setup the rates for this whole calendar year!)

    41 votes
    How important is this to you?
  4. Can we have the exchange rate returned when returning invoice information for foreign currency invoices using the invoices endpoint?

    6 votes
    completed  ·  2 comments  ·  Admin →
  5. Return discount rate info of Contacts in a GET Contacts response

    12 votes
    completed  ·  3 comments  ·  Admin →
  6. In the app you can override the currency rate with your own. Would be great to do this with invoices generated via the API as I get my rates from another provider (ie. not XE)

    28 votes
  7. Currently, we can enter employee cost rate data into Xero, but this data is not available back to us through the API. This limits our company's ability to accurately track project profitability, especially through more sophisticated solutions using BI tools outside of Xero. A simple solution would be to expose this data through the Projects endpoint (User table) or another Xero API endpoint (Accounting?). Such a limitation has sparked recent conversation in our LT to migrate away from Xero as our company grows > 50 employees. Without this data available in the API, messy workarounds are…

    18 votes
    How important is this to you?
  8. UK VAT law requires that invoices present VAT amounts in Sterling, even when the invoice is in a separate currency. As a result, it's possible to have a Euro invoice with Sterling VAT amounts. (See VAT Guide 16.4 and 16.3.1). Obviously when charging the customer, these have to be converted to Euros and the total expressed in Euros, but the business owes VAT in Sterling, not Euros.

    Currently it's only possible to specify a single currency per invoice; now, if it were possible to stipulate the exchange rate to be used, that might make matters better, but in general…

    4 votes
    1 comment  ·  Admin →
    How important is this to you?
  9. This is especially important for an initial sync of a new customer with our product as we need every invoice in the database (including the PDFs, which we are happy to trickle into the system over time).

    40 votes
    not planned  ·  4 comments  ·  Admin →
    How important is this to you?
  10. This almost seems to be a bug, since the Xero web interface works differently than the API.

    In the "Tax" section for a Contact, the help message states: "Each account you code an invoice to will have a default rate as specified in the Chart of Accounts but if you have specified a rate for the Contact here, this rate will override the default rate from the Chart of Accounts."

    This works when adding an invoice using the web interface, but adding an invoice using the API results in the wrong tax type and wrong calculated total.

    12 votes
    0 comments  ·  Invoices  ·  Admin →
    How important is this to you?
  11. Specifically the tax rate components that make up a tax rate i.e. the name, the rate and compounding indicator, this is very useful information for our application

    3 votes
  12. At present when a GET is performed on the Credit Notes end point, the LineItem elements are not returned. On other endpoints this issue is alleviated with the option of Paging, which when used returns all elements.

    At present we are forced to GET a list of list of all Credit Notes that have been modified since the last GET and then loop through each Credit Note making an API call for each individual Credit Note just so that we can get the LineItems. The issue with this is that we are often exceeding the 60 second rate limit.

    If…

    37 votes
  13. When you change something simple on a product item (say the description) then a request for modified since returns this item.

    But if the stock in-hand figure changes (because you've sent an invoice) then the modified date doesn't change and this item isn't returned in the atli query.

    So, in effect there is no easy to tell (via API using modified dates) when the stock on- hand has changed. You would have to load all items every ten minutes to know what the current in-hand stock is... And then you would get rate limiting issues.

    18 votes
    How important is this to you?
  14. 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
    0 comments  ·  Reports  ·  Admin →
    How important is this to you?
  15. 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
    0 comments  ·  Reports  ·  Admin →
    How important is this to you?
  16. At the moment, its rather difficult to recover from a network interruption that happens when you send the request to Xero API, and you loose the connection before you receive the response from Xero. There is a fair number of reasons why this could happen at any time.
    In such a situation you really have no way of knowing if your request was even sent fully, or if it was received by Xero, nor what was Xero's response.

    This is not specific to Xero, as all APIs out there have this same problem, as its simply how the web works.

    87 votes
  17. It would be good to be able to get the usual payment days number which is shown in Xero's contacts page through the API in order for displaying that data in in house software used to rate customers payments against their established payment terms.

    3 votes
    0 comments  ·  Contacts  ·  Admin →
    How important is this to you?
  18. Invoices has a filter of InvoiceNumbers. But this functionality is missing from Credit Notes even though Credit Notes are basically a negitive invoice. We need to be able to query for the status and existence of Credit Notes but keep hitting our API rate limit. We are using an WHERE OR statement but it's slow and we cannot check more than a few credit notes at a time.

    4 votes
    How important is this to you?
  19. It would be really useful to be able to access (and ideally edit) staff billable rates via the Practice Manager API.

    Many other fields can be accessed via the Staff endpoint:

    https://developer.xero.com/documentation/api/practice-manager-3-1/staff

    This would be a really useful addition.

    4 votes
    How important is this to you?
  20. We need to be able to fetch bulk, paginated History and Notes via the API. Now it only has the ability to fetch records for single invoice. It will be great if we are performing one time ETL and we are getting the time out 429 status in error and rate limiting issue.

    3 votes
    0 comments  ·  Invoices  ·  Admin →
    How important is this to you?
← Previous 1
  • Don't see your idea?