cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Drew_E
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.
40 Comments 40
Mark_R
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?

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.

Drew_E
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.

GraceC
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.

Drew_E
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.

RenjolynC
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.

Drew_E
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?

AlexV
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!

Drew_E
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.

GlinetteC
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.

Drew_E
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.

jdq-qb2
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.)

 

 

MErl
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

 

xrobin
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!

vbal
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?

Yeah, QBOs FX reporting leaves to be desired.  Fact is there's no separate ledger type really to view amounts in foreign currency.  The only way...sad to say..is to "almost" run revaluation, say, at your year-end.  Only there can you see balances in currencies other than your base / domestic currency.  You don't actually have to "revalue and save" at least it gives you the foreign balance as at a specific date.

leebrendalee
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?

ok, I am pretty sure I have the answer as I used to show both the USD and CDN ..............so that I know if its balanced properly.  I think this might be what the original posted was trying to say was how can we show the balance in both currencies.  Please advise if this is what you mean.  I am testing my theory.

leebrendalee
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?

ok it worked beautifully!  So what I did was ensure that the deposits when into the USD account as USD.

Then on the balance sheet it showed the balance correctly matching the USD account.  

 

Then what I did was save it.

Then I revalued and it converted to my USD and I saved it.  So now I will record on spreadsheet

so that I can clearly see both the USD and CDN home currency and know that everything is balanced properly.

 

Santa Monica
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?

Hello - did this issue ever get resolved?  I read the frustrated responses to the "canned" QBO answers.  Hope I don't get the same run-around.  It's been over a year, maybe this is fixed.   

I've just started using QBO (5 months ago) and finally trying to produce financials.  We have foreign currency.

I am trying to tie my balance sheet cash accounts to the reconciliations.  The foreign currency bank reconciliations are in foreign currency but the balance sheet only displays home currency (USD).

How can I get the balance sheet to display the foreign currency amount for those cash accounts that are foreign currency cash account?

 

On another note, sometimes it seems like the QBO help is from users who have never used the software in a foreign currency business environment.  It would be nice to have foreign currency specialists for this particular section of QBO.

 

Drew_E
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?

Hi, I can confirm this issue has NOT been resolved. I've been using QBO for over a year now and I am the OP for this thread. There is no way to run a balance sheet report and see the foreign balance. The only way to get around this is to export a General Ledger report in Excel and starting from the opening balance of the 'Foreign Amount' column you can manually sum all the transactions and manually calculate your Foreign Balance. The obvious downside of doing this that over time this means summing quite a lot of rows and it can become tedious. I know of no other way to verify a foreign balance in a report. I really hope that they will add this to QBO since it was part of the QB Desktop software's standard reports.

RCV
QuickBooks Team
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?

Providing the best experience with the product is what we aim for, Santa Monica and Drew_E.

 

I can see how important on your business to run a report that shows the foreign balance. However, the availability of this type of report is unavailable in QuickBooks Online (QBO). We recommend submitting product suggestions to our engineers about this one by following these steps:

  1. Click the Gear icon at the top. 
  2. Choose Feedback.
  3. Enter your comments or product suggestions.
  4. Then select Next to submit feedback.

 

Your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Requests website. 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.

 

To keep updated with any upcoming QuickBooks updates and enhancements, feel free to visit these blogs:

 

I'll be right here to continue helping if you have any other concerns or questions about QuickBooks. Assistance is just a post away. Have great weekend. 

RCV
QuickBooks Team
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?

Providing the best experience with the product is what we aim for, Santa Monica and Drew_E.

 

I can see how important on your business to run a report that shows the foreign balance. However, the availability of this type of report is unavailable in QuickBooks Online (QBO). We recommend submitting product suggestions to our engineers about this one by following these steps:

  1. Click the Gear icon at the top. 
  2. Choose Feedback.
  3. Enter your comments or product suggestions.
  4. Then select Next to submit feedback.

 

Your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Requests website. 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.

 

To keep updated with any upcoming QuickBooks updates and enhancements, feel free to visit these blogs:

 

I'll be right here to continue helping if you have any other concerns or questions about QuickBooks. Assistance is just a post away. Have great weekend. 

3d_accounts
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?

What IS working for me is using the QuickBooks app on my mobile phone.  On the phone, it allows me to see our bank account balances in their local currencies (i.e. our company is GBP home currency, but we have bank accounts in USD and EUR).  While I cannot see the USD and EUR balances in QB Online, the QB app does show these, so while it's not ideal, at least it's a solution that works for now.

Drew_E
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?

It would be helpful to include a bit more info. Are you running the Android or iOS app? What type of device? iPhone, iPad, other? On my iPhone I'm not seeing a way to run a balance sheet detail report that shows the foreign balance at a certain date in the foreign currency. If I go to the equivalent of the chart of accounts in the app I see the current balance in the appropriate currency but that is also available in QBO.

3d_accounts
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, I'm running it on the IOS app.

 

Note that what I'm seeing is definitely not a balance sheet or I/S that is fully translated.  The issue I had (and that I thought people were battling with in this thread) was that there were certain accounts (bank and loan accounts) that I needed to see in their local currency (i.e. not in our main reporting currency).  QuickBooks Online allows us to see the local value of each transaction, but not the full account balance in local currency (so for instance, QBO cannot tell us how many US dollars we have in our USD bank account, which is honestly madness).  The IOS app can show an account listing, and each account is showing it's 'local' balance.  For our purposes, that is sufficient (not ideal that we have to look in the app, but at least it's a real-time balance in the currency of the account, as opposed to the translated reporting currency).

Maggie-MTL
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?

I have exactly the same problem. Not only the bank balance but also have this trouble on AR and AP reports

 

I have a lot of customers/suppliers that I need to check their daily balance at their original currency. It is frustrating that can't identify a correct balance by its own currency in a specified period for the "foreign" clients or suppliers from AR/AP reports.

 

What I am doing is: manually change the rate to "1" (1usd=1cad) and book exchange loss/gain when create entries.

For example: supplier-usd, enter "1" at the rate box, don't take QBO rate.

Debit purchase 130.00 (home currency on income statement)

 credit: usd AP 100 (can see $100 on AP, but must make an journal entry/reverse JE to revalue to home currency at month end to show correct AP value on balance sheet.) 

credit: exchange gain/loss 30.00 (home currency on income statement)

 

My question is: Can I stop QBO generating their rate automatically for each transaction? So I don't need to waste my time to change each one to "1".