End of year Balances in actual currencies

Welcome to the Community forum, @ukgeltd. 

I understand that each company has unique needs, and it's always handy to be able to run a report according to their currency. I can also see how pulling up a report for daily balances on a specific date would help you track them easily.

At this time, QuickBooks Online can only run reports using the home-currency. Thus, I encourage you to submit feedback to our Product Development Team. They will evaluate these and pick some of them to include in future updates.

Here’s how:

1. Go to the Gear icon.
2. Under the Profile column, select Feedback.
3. Enter 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.

As a workaround, we can customize and filter the Balance Sheet Detail report to get the data you need. I’ll show you how:

1. On the left pane, go to the Reports menu.
2. Search for Balance Sheet Detail report.
3. In the Report period drop-down, select the specific date you want to show on the report.
4. Click the Customize button.
5. Go to the Rows/Columns section and click Change columns.
6. Put a checkmark to the Currency and Foreign Amount checkboxes.
7. Hit Run report.

Once done, you'll be able to see accounts with different currencies on the report.

See this article to learn more about personalizing reports: Customize reports in QuickBooks Online. It includes managing and sharing custom reports over email.

You'll also want to memorize this report if you want to run the same settings in the future. Check this article for a guide: Memorize reports in QuickBooks Online. 

I wanna make sure I got you covered. Tap on the Reply button for any follow up questions about reports. Have a wonderful weekend!