Can someone help me to add the foreign balance amount in the account report? I have tried to look anywhere but it is not listed on the customize tab. Thanks in advance.

Hello there, usermark-catigbe. Yes, I'm here to help!

I can see the effort you've given to find the foreign balance amount in the account report. The foreign balance amount is available to other reports in QuickBooks. We can run the Transaction Detail by Account report to get this thing done. Here's how:
 

1. Go to Reports and enter Transaction Detail by Account in the search box.
2. Click the Customize button at the upper-right corner.
3. In the Rows/Columns section, put a check-mark in the Foreign Open Balance box. You can include A/R Paid if you want to see how much they've paid you already. 
4. In the Filter section, you can select a specific account that you'll only want to generate on the report.
5. Click Run report.
6. Then, make sure the dates are correctly setup.
   
   

 That will do. When you run QuickBooks reports, you can include and exclude the details. Afterward, you can keep what you've currently customized. Check these articles for additional reference:

• Customize a report to focus on the details that matter the most to you.
• Memorize reports in QuickBooks Online.

If you have further clarification, please don't hesitate to comment below. Keep safe and have a great day!

Hi Admin Sarah,

First of all, I would like to thank you for your kind response. I have tried all the steps you provided and it seems it didn't answer my inquiry, actually, I am looking for "Foreign Total Balance" please see attached picture I am referring to.

I'm working with the US and Foreign currency and I need to generate the reports on both accounts and with this option, I cannot able to provide the correct reports. I hope QB will able to generate or add this option, appreciated your help in this inquiry.

Hi Admin AlcaeusF,

I appreciated your feedback, I believe that your recommendation exporting the report to Excel is the best way for now.

I am looking forward that this feature will be available in the future in QBO when running reports. Again thank you for your assistance.

Best regards,

MarkC