Multi-currency options for Balance Sheet and P & L reporting

It's definitely not an option in any "summary" report in Canadian QB.  Summary reports include standard B/S, P&L and T/B reports, also A/R and A/P Aging Summary reports.

It is an option in most "detail" reports.  Add relevant columns such as Foreign Amount, Foreign Balance, Foreign Open Balance.

It's the same as in the Canadian "Premier Multicurrency Edition" and 2007 and earlier Canadian versions, I don't see any difference.

Thanks for clarifying that - I thought I might be missing something.

. . .another example of the Intuit 'help' resources being not-so-helpful.

Back to exporting to excel and working it there.

Some possible work-arounds. ..???

Does the Canadian version have Intuit Statement Writer?  If so, would that give an option to convert the summary reports to foreign currency?

Or, could the user change the global settings to run the reports and, then, change them back?  (or, restore a backup under a separate file name and do it there??)

Ideas?

Hi Laura,

In QB2010 Canada you can run the following reports in their transaction currency:

•A/R Aging
•A/P Aging
•Customer Balance Summary
•Sales by Customer Summary
•Purchases by Vendor Summary

These are reports that when ran will display (Values in Home Currency) in the title. When you see this, you can go to Modify Report and change the "Display amounts in:" from Home Currency only to The transaction currency. The Balance Sheet, P+L and Trial Balance do not have this option.

However, this functionality does not change a report to display all values in another chosen currency. What it does is show the foreign value of the amounts using the exchange rate on the transactions that it is calculated from. This is the same functionality that QB US 2009 has.

The answer that Safari818 provided is half correct in that you can add columns to the detail reports to get foreign values. However, there ARE changes between the 2007/MC version and QB2010 MC implementation when it comes to reports. This new functionality being one of them.

The Financial Statement Designer in QB CA does not have the functionality that you are looking for, it has not had any updates in regards to Multicurrency recently.

If what you are looking for is running a report where the balances are converted to a foreign currency using an exchange rate for a particular day, I would agree that your best bet is indeed to use Excel and multiply each line by the exchange rate for the currency you want your report to display in.