Multicurrency - Supplier Statement in multi currency
The attached 'Supplier Statement' report has been 'retired'. Please consider reinstating this in Xero. We buy in euro and for financial audit purposes at every year end we need to issue this report. There is now nothing like this on Xero which makes no sense as we can't report without a mass of manual work to make a report outside of Xero.
Gillian Taylor
shared this idea
-
Joseph Kiptibai
commented
We need Creditors/Suppliers Statements in Multi-currency or Non-Base Currency formats more frequently. I often need to provide suppliers with statements that detail their invoiced amounts, payments made, and outstanding balances.
-
Sharon Davis
commented
I absolutely support this idea, I am trying to reconcile a large complicated supplier and for the most part the supplier bill activity has worked for my little clients. More complex clients this does not work in the slightest. In fact this particular client that is large and more complex, also uses multi-currency. Instead of being able to download a simple supplier statement, like we could previously, I have had to manually go through each record and manually put it into and excel spreadsheet. It has taken a day for me to do this....when a simple Supplier Statement would have VERY easily have taken me an hour to cross check with what they had. It would have taken even longer had the supplier not sent me a statement from themselves, so I wasn't working off a blank canvas, but it still took me a days work.
Why can't I use a Supplier Bill Activity....well, there is no option to change the currency! I certainly could not use it to check off a USD Statement against a AUD Statement. This is a major issue with the report. Xero support took 6 hours to come back to me advising I use a Payable Invoice (Detail/Summary) Report, that is NOT what I am after, I can quite as easily view in the supplier file all the invoices, I am in need of the suppliers ACTIVITY, vastly different to seeing invoices as being paid or not. And more importantly, viewing it in the currency in which the supplier uses. It's really not helpful providing a document in another currency.
Please consider re-instating supplier statements. I don't know why it was removed in the first place.