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
541 results found
-
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 -
Default Tracking option for line items
Hi, the Xero api offers creation of Tracking options against line items but is missing a way to add Default Tracking option for line item so that the generated line item will have this option as preselected. Currently we have to ask our customers to go and set the proper tracking option themselves. Maybe if we can have an endpoint to associate a certain option as default for the line item that would be great and save our clients the work to assign it manually.
1 vote -
add the ability to trigger email of creditnotes to customers.
We can trigger emailing invoices from XERO to the customers email address, using the /email end point on the INVOICES api. We urgently require the same functionality for credit notes and we do not understand why this feature was not extended from invoices to credit notes. Urgently required for customer integration project.
13 votes -
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 -
Linked Transactions via API - multiple in one call.
Linked Transactions are limited to one per call via the API. This results in having to make a great many API calls unnecessarily. For instance linking the invoice line items to a project after several invoices with many lines are added via API will require many more calls than are allowed. For now I will have to put in place a costly work-around to trickle in the linked transaction calls.
3 votes -
Offer the Account Transactions report as an ODBC table
I would like to be able to select a table in the ODBC connection that is the same as the Account Transactions report. This allows me to create financial statements and analysis based upon the full 'general ledger' of a company's transactions data set.
1 vote -
Online Invoice URL - Allow fetching with invoice or in bulk
Currently we can only grab the Online Invoice URL Field via a standalone API callout to the Invoice endpoint which includes the invoice number in the callout.
This proves to be a big issue with applications that grab and store historic data in the application.
For example:
We connect our application with Xero and there are 20,000 historic invoices in Xero.
We store the invoice data in our application for these 20,000 invoices, but we want to get the Online Invoice URL so the customer can add it to custom templates.
Because we can only callout to 1 invoice at…
6 votes -
Allow bulk retrieval of all outstanding balances by grouped contact
Currently we can get the amount owing by querying individual contacts. However, given the API limits this becomes impossible to do on a daily basis for reporting once a reasonable number of customers is being queried.
While it's possible it's better to do it in a web-hook-update kind of way when new information comes into Xero and is pushed externally, it would make more sense to me to have an endpoint that simply allows a contact summary to be obtained in a single API call which could have simple aggregates, like amount owing, shown.
1 vote -
Allow more than one contact with the same name so API does not overwrite existing data incorrectly.
We have had several 'David Smiths' buy from us via our website. As the API feed sends the data to Xero - Xero looks for a 'David Smith' and then automatically overwrites existing address and phone number etc with the new info.
The result is data that is totally incorrect. Furthermore I recently sent a product to the wrong client which was costly and embarrassing.
The simple solution is for Xero to have a 2nd and 3rd 'identifier' i.e. email address, post code. For example:
If the name + the email address and/or the postcode are a match then =…
1 vote -
Fix Bug: Override TaxAmount in BankTransaction Endpoint
Suggestion: Allow the overriding of the TaxAmount within the BankTransaction Endpoint. This currently works through the UI but not the API.
Issue: Importing a 'Spend' BankTransaction using the API with an adjusted TaxAmount results in a Validation Error:
[Message] => Tax amount 936.09 is incorrect for INPUT2 tax type, should be 187.22Works: Using the UI
Doesn't Work: Using the API6 votes -
Return account & bank connection status
It would be valuable to be able to obtain a status or timestamp of the last successful sync with the bank account. This way, we can inform customers if there is a problem with their bank or if their transactions or accounts are out of date.
3 votes -
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 -
expose Cashflow Statement via the API
Expose Cashflow statements via the API
1 vote -
assign item to project
Ability to assign items to a project is currently missing in the API, which makes Projects API totally useless to us.
7 votes -
Allow Quotes in API Previewer
Please add quotes to the API Previewer so we can test our queries easily.
6 votes -
Add some extra data to web hook events
Specifically for Invoices, some items like 'status' would help the code responding to the webhook to decide what to do - otherwise for every web hook event we need to access Xero to get the invoice - that's a lot of data when all I need is the status.
There may be a case for some other fields to be included.
1 vote -
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 -
Contact search should be case insensitive via API
While creating the sales invoice via API, usually we check if the contact is already created or not, to search the contact the name/keyword must be used in the same case that is available on Xero, if its different then it will not search.
1 voteHi Swapnil,
Thanks for the post.
We currently have a work around for the issue you are currently facing which may be of use.
It is possible to include ToLower() in the where clause when quering the endpoint. ie. ?Name.ToLower()=="{name}’
See the following commultiy thread for more information: https://stackoverflow.com/questions/60265042/can-xero-contacts-be-filtered-by-name-case-insensitive
-
Search option for items not reconciled
Search functionality to go through items not yet reconciled in statements/bank accounts such as credit card.
3 votes -
Search option for credit card or bank transactions
Enable a search option to go through transactions on credit card that have not yet been entered
1 vote
- Don't see your idea?