Supplier Bill Activity report - Run in Foreign Currency with totals
The Supplier Bill Activity report is great for showing transactions for a Supplier if you operate only with one currency.
However, for accounts with Multicurrency, it should also include optional columns for the Source Currency amounts and when showing just one currency, the balances in that currency in the list of columns.
-
Mark Alsop commented
This is critical as we operate in GBP USD and EUR. Can we get an update when this can be resolved.
-
Jenny Kanno commented
It would be so helpful to have this report in the base currency of the supplier, as it is a better report for reconciling to the supplier's statement
-
Antoine Chanliaud commented
Hi everyone, my workaround is to bring currency rate in the report and then export to excel to calculate : transaction amount x currency rate to get the original supplier currency amount.
Hope this helps. -
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.
-
Tricia Bracegirdle commented
I agree it’s should be considered. It’s taken me two full days this weekend to sort out what was wrong with my payments which would have been so much quicker with he report showing invoice totals in original currency.
I also find it frustrating you can’t batch pay a foreign currency and choose the currency you pay in. All my invoices are in euros and I pay a broker in pounds. A tiger trap for errors!,
-
Casey Sun commented
updates for this please
-
Andrew Morrison commented
To add to this, below is the current response received from Xero!:
"As you have found, with the new Aged reports, it doesn't show the totals for a customer/supplier in the foreign currency.
The only way to do this is by exporting the report and manually calculating the total or by using a calculator as you mentioned."
-
Montse Lobeira commented
New Reports do not allow Supplier Bill Activity report in another currency, instead I have to run the Receivable Invoice Summary report,which adds more steps to my job as i work with foreign currency only , I would like to be able to run the supplier bill report as previously.
-
Libby Bourke commented
It is very important to get the foreign currency amounts back into the Supplier Activity Report report, as it is what we had previously and now it's been taken away. I know we can go back to the Reports and get an Accounts Payable report but that involves lots of extra steps including filtering for the supplier and adding totals to the source amount column. It also doesn't show what overpayment has been matched with which bill. We need the source currency back asap please.
-
Libby Bourke commented
Do you mean when you click on a supplier name on the screen then look at the supplier activity on the screen?
I have found for our foreign currency suppliers the source currency amount is missing, which is so frustrating because it used to be shown. -
Steve Venton commented
Many of my Suppliers get confused with which of their Invoices my company has paid and which we have not. Occasionally we also make a mistake and pay too much, and then it is very hard to prove to them that they owe us credit.
Whilst we always pay in the same currency as the invoice, the same Supplier may invoice in USD as well as our Default currency.
So to be able to prove to them every transaction that has taken place is a critical requirement for the business..