Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Thanks for joining this thread, Benjamin.
Joining in to share some insights about this foreign exchange rate concern.
At the moment, QuickBooks is unable to provide this information or file. The system uses the most current foreign exchange rates on transactions and only keep a record of it for reporting purposes. However, keeping the history of daily exchange rates isn't part of our program processes. This is why we're unable to generate a file for it.
For now, what you can do in QuickBooks is to run reports of previously entered transactions and filter it by exchange rates.
If you'd like to see the raw data based on the currency billed for a foreign client, you can use the A/R Aging Detail or a Transaction List by Customer Report. Here are the steps to do that:
- Go to the Reports menu and type Transaction List by Customer on the search field. You can also find this under Sales and customers.
- From there, click the Customise button.
- Tap the blue Change columns link to expand the options.
- Update the Report period.
- Mark the boxes for Foreign Amount, Foreign Net Amount, Currency, Exchange Rate, Due Date and A/R Paid.
- Press Run report when you're done.
Post here anytime if you have other questions or concerns in the program. Me and my colleagues are ready to help you out. Have a good one!