how can i see a total for my foreign currency column?

Hey Delia. To be direct, you actually can't see a total for the foreign currency column on the report itself. It's because QuickBooks is built to only show the final total in your home currency at the bottom.

A workaround for this is to check your Chart of Accounts. When you look at a specific bank or credit card account held in that foreign currency, the balance shown there stays in that currency.

Another workaround is to add a foreign amount column, export the report, and manually calculate the foreign currency's total.

If you have any more questions, just let us know in the comments. We’re always here to help.