cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

In QBD there was a foreign balance column but in QBO I can't find any report that shows a foreign balance. On my Balance Sheet Detail reports I want to be able to verify my account balances as of certain dates and these accounts aren't in my home currency.
13 Comments
Highlighted
QuickBooks Team

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Glad to have you here in the Community, @Drew_E.

 

You can customize the Balance Sheet Detail report to show accounts balance with a different currency. Let me guide you through the steps.

 

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

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

 

Here's an article you can read for more details: Customise reports in QuickBooks Online.

 

Just in case you want to memorise this report, feel free to check out this article for the detailed steps and information: Memorise reports in QuickBooks Online.

 

Please keep in touch if there's anything else I can do to help you succeed with QuickBooks. I've got your back. Have a great day and be safe.

Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Yes, I realize I can show a foreign amount for each transaction that shows in a balance sheet detail report, but there is not way to show the foreign balance of that account in the balance sheet detail report. For example I have a bank account that is in EUR but my home currency is in USD. In Quickbooks desktop there was a foreign balance column that showed a beginning balance in EUR, a running balance from each foreign amount transaction, and an ending EUR balance in addition to the home currency balance column. So, I can't see any way to see the balance of this EUR account all I can see is the USD equivalency.

Highlighted
QuickBooks Team

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Hello there, @drewecherd.

 

You'll need to turn on the multi-currency feature to view the foreign balance in QuickBooks Online (QBO).
 

Here's how:

  1. Go to the Gear ⚙️ icon, then click the Account and Settings.
  2. Select Advanced.
  3. Click  Edit ✎ in the Currency section and choose your Home Currency.
  4. Select the Multicurrency checkbox and confirm that you understand that you can't undo this option.
  5. Hit Save and close.

For more information about the Multicurrency feature, I’m adding links that provide an overview of the Multicurrency feature. You’ll find instructions on how to add another currency account and assign it to a customer.

Let me know whenever you have any questions or concerns. I’m here to help and make sure you’re taken care of. Have a good one.

Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

So far the two responses to this question have not been very helpful. Yes, I have multi currency turned on. I'm wanting someone to answer my question and not copy and paste an answer for a related question. I am very clearly and very specifically asking about whether QBO has the ability to show a foreign balance on a balance detail sheet or any other report for that matter. It seems that QB employees just want to respond to questions with some answer to try to show they are helpful when actually not answering the question isn't helpful. Please don't copy and paste anymore somewhat related topics such as: how to do a home currency adjustment, how to set an exchange rate, how to memorize a report, etc. That would not be helpful and those answers already exist in many other places just as the two answers already give already exist in many other places. If we want to help the QB community then lets provide new information to them with this thread.

Highlighted
QuickBooks Team

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

I'd like to share a report, drewecherd.

 

The foreign balance is unavailable in the Balance Sheet Detail report. You'll want to run the General Ledger. This report shows the beginning balance, transactions, and total for each account in your chart of accounts.

 

Here are the steps:

 

  1. On the left panel, click Reports.
  2. Type General Ledger in the search box.
  3. Select the Report period, and click the Customize button.
  4. Click the Change columns link under Rows/Columns.
  5. Put a check mark on the Foreign Open Balance box.
  6. Hit the Run report button.

I'm also adding this article that you can bookmark: Reports included in your QuickBooks Online subscription.

 

I'll be around if need more help with QuickBooks Online. Take care and stay safe.

Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Yes, I had looked at that report as well. It allows the addition of foreign debit, foreign credit, and foreign open balance columns, however, the foreign open balance is blank and again I can only see the running balance in the home currency. Where can I run a report that shows the balance of all my accounts including both their home currency equivalency and the account's foreign currency. Again, in QBD this was easily done in the balance sheet detail with the addition of the foreign balance column. As you say that isn't available on QBO balance sheet detail reports. So, my question is how can I see this information in any report on QBO?

Highlighted
QuickBooks Team

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Hello there, drewecherd.

 

I understand that you need a report to show the foreign balance.

 

What I can suggest is to add the Exchange rate column and export that report into an Excel file. From there, we can get the foreign balance by calculating the home currency balance and the exchange rate.

 

Here are some of the articles you can refer for more details:

Post again here if you have other concerns. Wishing you all the best!

Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

This also is an unsatisfactory answer because, neither the General Ledger nor Balance Sheet Detail reports give an exchange rate for the opening and ending balance so how can someone know on the date range for the report what the exchange rate was to use for this manual calculation? Additionally this doesn't account for drifting currencies and assumes that home currency adjustments have been run for both the beginning and ending date range of the reports. This is not accurate.

Can someone from QB clearly state in this thread that if I have a bank account in EUR and my home currency is in USD that there is no report anywhere in the lists of reports that employees have posted here that can give me my beginning balance of that account in EUR for the date range and the ending balance for that account in EUR?

Doesn't that seem like a very basic feature? When will this functionality be added to QBO? I'm surprised that when 'Multi-currency' functionality is advertised that there is no way to run reports showing my balances of these accounts in their local currency.

Highlighted
Moderator

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Hi, Drew_E.

 

I can see how important for you to run a report that shows the foreign balance. However, the availability of this type of report is not yet an option in QuickBooks Online. Please note that our goal here is to help you save time and keep things simple when doing a task in QuickBooks. For now, we can take this as a product suggestion.

 

You may want to visit our QuickBooks Online blog. From there, you'll be updated with the features and enhancements that our developers are currently working on.

 

Feel free to add a comment below if you have any other concerns.

Highlighted
Level 3

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

@GlinetteC 

 

Yes, this is important, but I would think that it is important to anyone who has accounts in multiple currencies. You seem to have eluded to the fact that the absence of this 'feature' is for simplicity sake. I'm surprised that QBD 2013 had this basic ability. I also don't think that being able to report the value of an account on a given day is asking for a lot. Honestly, aside from this issue I've been happy with QBO. Is there a way to see what features are in current development? My suggestion would be to simple add a 'foreign balance' column to either the balance sheet detail (as QBD has) or to the General Ledger.

Highlighted
Level 2

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Drew E is completely right from what I can tell. I am running into the very same problem, and it seems extremely basic. It also seems like QBO is taking the wrong approach when creating Balance Sheets on Multicurrency accounts. 

 

I am paying extra for "multicurrency" option on my QBO account. My "home" currency is US$, but I have an "other asset" (deferred expense) account is in Euros, and it represents a true Euro bank account where the money is kept in Euros and spent in euros.

 

The balance sheet treats my "other asset" account account as a US$ account (though confusingly, as it does not label currency), and for every transaction it converts the transaction amount from euros to dollars using the day's currency conversion rate.  It then adds or subtracts that calculated dollar rate from the last dollar balance at the time of the previous transaction. However, this leads to the dollar balance drifting away, for away, from the true euro balance. 
 
This particular "current asset" account is a euro account and the euro balance is the true one, not the dollar equivalent on any given day. So for any given day it should calculate the dollar balance on the balance sheet based on the current euro value, it should not string along and add up the historical dollar values on each date that a transaction occurred (as it appears to be doing), that leads to a huge drift away from the actual true euro balance.  For example on 12/31/19 the balance sheet is showing me a balance of $-2,824.20. But the actual Euro balance, which thank god we can still see in the register, is €-3,928.99. With each transaction between 1/1/18 (when I started) and 12/31/19, the running count of the US$ balance drifts farther and farther away from reality. So much so that the "balance sheet" value eventually becomes completely meaningless. For example I genuinely have €-3,928.99 in the account on 12/31/19 (counting the actual euros that have really come and gone during many transactions over the months) — but, on 12/31/19 €-3,929.99  (the actual value of my euro bank account)  is worth US$-4,419.32 (when the conversion rate was 1.1248). This is very different that my QB balance sheet value of US$-2,824.20. It's an utterly worthless value not even in the ballpark (off by 37%, not exactly precise accounting).
 
Multicurrency accounts need to have multi-currency balance sheets that reflect the true balance of the non-home-currency accounts and all accounts need to be clearly marked as US$ or € or £ or whatever is the currency of those accounts. That is the true reality. Showing  all accounts in the estimated "home currency" value based on a currency conversion rate (chosen by the user or the bank rate of the last day or the time period considered) should be a secondary option that can be chosen by the user.
 
But, even if the user does want to exercise that option — the way QBO is currently, totally unclearly, calculating the home currency value on that end date of the report (by taking the cumulative value of all the estimated home currency transaction values on the date of those transactions —  plus the home currency starting balance estimate on the starting date, each transaction date with it's own conversion rate based on the bank rate of the day — it's like the bookkeeping version of a game of telephone)  appears to me to be the wrong method, misleading and dangerous and will cause thousands of us to waste thousands of hours trying to figure out what on earth is going on when they look at the balance sheet at the year end. 

Am I right or am I totally missing something?
 
PS (The QB method assumes that the entire account balance is ACTUALLY getting converted to the home currency with each transaction, and that's simply not true — it's hard for me to imagine a scenario where that is true — if that was true you might as well not have a multi currency account and stick with a home currency completely.)

 

 

Highlighted
Level 1

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Hi,

 

I have the same issue. QBs is allowing me to use location and different currency. Now, I need to print the reports in Foreign currency for local tax purposes.  How I can do this?

 

Thank you,

Miriam

 

Highlighted
Level 1

In QBO can I run a balance sheet detail report to show an accounts balance when that account's currency is different than the home currency?

Nobody at QBO seems able to answer this question or understand the issue! In future I'm going to recommend to my clients that they DON'T use the Multi-Currency feature! That way you can record the foreign currency as it is and do 1 foreign exchange journal entry every month to revalue the foreign currency account into Home Currency. The Multi-Currency feature is not very good!