be able to get Bank Account balances via the API
Would be awesome to be able to GET /accounts or /bank_accounts and grab a listing of all our bank accounts and their associated balances!
We have exposed a number of reports via the Xero API. One of which is the BankSummary report, which shows the opening and closing balances for a specified date range. This can be used to get the current balance of a bank account.
See http://blog.xero.com/developer/api/Reports/#BankSummary for more information.
Dan..
-
Shayen Yatagama commented
We require the account balance debits and credits for all accounts (not only bank accounts). Is there an API to get this done?
-
Mohammed Hassem commented
To effectively work with Xero and produce various regulatory reports I need access to the account balances without this we are unable to automate this process. This means we have to go in on the day the data is required and produce excel files for all the reports that we require to facilitate the production of these reports.
The current report API does not expose all the fields required in the API. One of the reports we have to use requires an extract of the trial balance which has the account balance MTD and YTD values which are not part of the current Trial Balance API.
We also require the account balance debits and credits for all accounts.
-
Jiro Olcott commented
The Bank Summary Balances and the Dashboard Statement Balance are two different things. How do we get the Dashboard Statement Balance?
-
damon commented
Any way to get the "Statement balance" via the api? Because I have bank feeds activated the statement balance is a more accurate reflection of our cash position.
-
SEOJoe commented
why piece mill these API requests vs. getting all information available via API?
http://xero.uservoice.com/forums/5528-xero-api/suggestions/230113-expose-everything-via-the-api
-
Tim Sheppard commented
To get our payroll integration working, just being able to get the bank account codes would be a great help
-
Sam Johnston commented
Ideally everything visible in the web interface would be available via the API as well - including the transactions themselves.
-
ezero commented
soz i can.. just had javascript disabled ... you im one of those 1% that don't allow javascript.
-
ezero commented
why can't i vote
-
Nik Wakelin commented
Even just the count of unreconciled transactions would be cool...
-
Nik Wakelin commented
just Bank Account balances is totally enough. Anything more is just bonus.
Number of unreconciled could be interesting. Might be nice to get a nag every morning reminding me that I need to update Xero. :p
-
owenevans commented
Would just bank accounts be useful or would you also need unreconciled amount/individual payments to account?