Skip to main content
U
useraccounting33
June 3, 2021
Question

Is there a way to show the amount in the vendor currency?

  • June 3, 2021
  • 1 reply
  • 0 views
Our reporting currency is USD but we will pay in GBP and the vendor currency is CNY. Is there a way to show all these currencies in a report or if not possible in any report, at least on the transaction level?

1 reply

C
Catherine_B
June 3, 2021

You can run a transaction list by vendor and customize it to show the currencies, useraccounting33.

 

Let me show you how: 

 

  1. Go to Reports. 
  2. Enter and select Transactions List by Vendor in the search field.
  3. At the upper-right, click Customize.
  4. Set the Report period and click the Change columns under Rows/Columns.
  5. Check the Currency and Foreign Amount box.
  6. Click Run report.

To guide you in customizing your reports and in handling your currencies, you can use these links: 

 

I'll be here if you need anything else. Take care and have a great day!

U
useraccounting33Author
June 5, 2021

Thank you for your reply. I apologize I was not clear with what I need. A sample transaction is we paid in GBP to a vendor with receiving bank in PHP and our reporting currency is USD. What we need is a report that will show the amount in PHP, not only in GBP and USD.

 

Your help is greatly appreciated.

R
ReymondO
June 5, 2021

Thanks for coming back and adding a clarification, @useraccounting33.

 

QuickBooks supports multiple currencies to help you do business with foreign vendors, customers, or employees.  

 

Although, the currency that will be reported in your reports are the ones you use in paying your vendors. This won't include the currency of the receiving account. 

 

For now, you can export the report to Excel and manually add the PHP currently on it. Simply open the report, then click the Export button and select Export to Excel.

 

 

I can see how this option would be helpful for you and your business. Therefore, let me take note of this as a suggestion to improve your QuickBooks experience.

 

It's important that we always meet our customer's needs. While we continue to make improvements, I want you to be updated with the latest QuickBooks news and product release through our Firm of the Future site. This is where we share recent happenings and future developments, such as updates to newly added features.

 

If you have any other concerns, feedback, or questions, don't hesitate and come back to the Community. I'm always here to help you. Have a great day.
 

Terms & ConditionsAccessibility statement