How to add total value for foreign amount column in sales report?

Hello there, Abror. I'm here to provide details about showing the total foreign amount on your sales reports in QuickBooks Books Online (QBO).

In the Sales by Customer Detail report, you can include the FOREIGN AMOUNT column. However, please note that while this report displays the total sales amount, it does not provide a subtotal for the FOREIGN AMOUNT column.

As a workaround, I recommend exporting your sales report to Excel. This will allow you to manually calculate the total for the foreign amount and include it in your report.

Additionally, you can refer to this article about personalizing your reports in QBO: Customise reports in QuickBooks Online.

Let us know if you have other concerns about customising your sales reports in QBO. We're here to help you in any way we can.