Customer balances report in foreign currency

bogatyij · ‎June 03, 2021

Rea_M · ‎June 04, 2021

You can pull up the Customer Balance Detail report in QuickBooks Online (QBO), and I'm here to show you how, @bogatyij.

Financial and/or transaction reports give you snapshots of different areas of your business. You can easily monitor your customer balances in foreign currency by customising the Customer Balance Detail report. Then, you'll have to add the appropriate foreign currency columns (i.e., Foreign Open Balance and Foreign Amount). To do this, here's how:

Go to the Reports menu.
Type in Customer in the search box and select Customer Balance Detail.
Set the Report period.
Choose the Small Gear icon above the report and add the appropriate foreign currency columns.
Click anywhere on the page or the Run report button to update.

I've attached a screenshot below that shows the last three steps.

After that, you'll have the option to save the report's current customisation settings for future use. If you wish to know more about this, you can check out this article: Memorise reports in QuickBooks Online.

Additionally, most reports are accessible for all QBO users. However, some are only available for certain subscription levels. To know the complete list for your version of QBO, you can refer to this article: Reports included in your QuickBooks Online subscription.

Let me know in the comments below if you have other concerns about managing your customer balances in QBO. I'll be glad to help. Stay safe and have a good one.

View solution in original post

Rea_M · ‎June 04, 2021

You can pull up the Customer Balance Detail report in QuickBooks Online (QBO), and I'm here to show you how, @bogatyij.

Financial and/or transaction reports give you snapshots of different areas of your business. You can easily monitor your customer balances in foreign currency by customising the Customer Balance Detail report. Then, you'll have to add the appropriate foreign currency columns (i.e., Foreign Open Balance and Foreign Amount). To do this, here's how:

Go to the Reports menu.
Type in Customer in the search box and select Customer Balance Detail.
Set the Report period.
Choose the Small Gear icon above the report and add the appropriate foreign currency columns.
Click anywhere on the page or the Run report button to update.

I've attached a screenshot below that shows the last three steps.

After that, you'll have the option to save the report's current customisation settings for future use. If you wish to know more about this, you can check out this article: Memorise reports in QuickBooks Online.

Additionally, most reports are accessible for all QBO users. However, some are only available for certain subscription levels. To know the complete list for your version of QBO, you can refer to this article: Reports included in your QuickBooks Online subscription.

Let me know in the comments below if you have other concerns about managing your customer balances in QBO. I'll be glad to help. Stay safe and have a good one.

bogatyij · ‎June 04, 2021

This is great, thanks. As it turns out, that's exactly what I have been doing for individual customer accounts. What's extra helpful is your suggestion about saving the customisation and using the "memorising" facility, which I shall adopt.

I wonder if I could delve further?

I'm preparing the client to transfer to a new accountant. In order to provide a list of customer balances in Euros and their associated translated balances in GBP, is there one report that can produce this? It would make the transition much smoother.

At the moment, I'm thinking of doing as you set out but showing all customers where it also shows the outstanding transactions, but it's a long report. Any suggestions?

Much appreciated

Matthew

Paul Rossiter · ‎July 24, 2022

Doesn’t do it for me. Very poor “fix” There should be a facility for a report by currency. That solves everything!!

JamaicaA · ‎July 25, 2022

I appreciate you joining this thread, @Paul Rossiter. I'll answer this query for you about foreign currency report in QuickBooks Online.

I recognize the importance of having a facility for your report by currency. However, this is currently unavailable. I can also see how this feature would benefit your business and to the program.

We value your opinion and we look forward to helping you get the most out of QuickBooks. Since this is a great idea, I'd encourage sending feedback to our Product Development Team. They will evaluate and consider adding these for feature development.

Here’s how:

Go to the Gear icon.
Under the Profile column, click on Feedback.
Share your suggestion. Then, click Next.

You'll want to track your suggestion through this website. You can also visit our blog to keep up with all of our recent events and developments.

I have some additional articles about the Multicurrency feature in QuickBooks Online:

I've included this guide to see a wide range of reports in QBO: Reports included in your QBO subscription.

I'm always here to help if you need additional assistance about customizing a report or handling currencies in QuickBooks Online. Just click on the Reply button below and I'll be right here to help you.

Topics

Training

Community

Resources

Customer balances report in foreign currency