Can a summary report be run for accounts payable or receivable, in two separate currencies?

Hi John

Thanks for your response.

The below is for detailed report right?

What about summary?

Thanks

Hi moniquevanrooyen

Sorry, I was referring to the detail report as it is not possible to include the forgien amount in the summary report.

Thank you for your help

Stay safe

God Bless

HI - our finance team is puzzled: 

"This will not give you totals however you can export the report to Excel and total the column." - WHY?  why would it NOT give the total?  (thanks for sending me to google sheets - it is free!) 

Thanks, our finance team. 

Hello @finance-techcore,

Allow me to step in and share some clarification about the report in QuickBooks Online.

Currently, the Customer Balance Detail report only shows the entire total for the Amount and Open Balance column (see screenshot below). Since Foreign Open Balance is a custom column, the ability to add another total is unavailable.

We recommend exporting the report to Excel and manually add the necessary information.

I've attached some articles about running reports, like how you can customise them to acquire the info you need, as well as the exporting process to Excel or PDF:

• Customise reports in QuickBooks Online
• Export reports, lists, and more

I'm only a few clicks away if you have any other questions. Wishing you and your business continued success.