Skip to main content
R
Richard2025
April 29, 2025
Question

Bank accounts transfer when switching to multicurrency

  • April 29, 2025
  • 1 reply
  • 0 views

I am looking for help how to fix the issue with negative amount showing on balance sheet for the bank account in USD. I realized, the beginning of the problem started when we switched from single CAD currency to multicurrency. Because company is dealing with CAD and USD, before the "switch" for the bank account i\there was USD account with nominal USD, but for QB was just an CAD account because the single currency mode. The exchange on US$ account was handled manually.

Because QB does not let to change CAD account to USD account when in multi currency mode, I just created in QB new bank USD account and made the bank transfer from old USD account to new USD account with exchange rate 1 to get the correct beginning for new account  to be able to do reconciliation. As to this point all works fine, the bank register and chart of accounts shows correct amounts in USD. However when I open the balance sheet the beginning transfer is not recalculated to CAD as the rest of transactions and the balance slowly went to negative because the beginning is nominal value in USD but the rest on balance sheet is recalculated to CAD. I am hoping I explained this as clearly as possible. I am not sure how to fix the balance sheet. Any thoughts or help will be greatly appreciated. Thanks!

1 reply

S
ShangY
April 29, 2025

Thank you for reaching out with your concern, @Etter2 and I appreciate your diligence in ensuring accuracy in your financial transactions. I understand how important this matter is to you, and I want to reassure you that I'm here to help you.
 

It seems that you're referring to the transfer you made from a previous USD account to a new USD account, ensuring it reflects the correct currency. I have replicated the steps you described and can confirm that since the transfer involves USD accounts at a 1:1 exchange rate, the transfer transaction in the Balance Sheet Detail report will correctly display in USD. This is determined by the exchange rate settings you've established. Please note that any adjustments to transaction amounts will only take place if different exchange rates are specified for those transactions.

For more details, see this resource: Set up and use Multicurrency in QuickBooks Online. This article will help you understand how to handle different currencies in QuickBooks whether you’re running a small business that deals with other countries or an accountant keeping track of foreign money.
 

Considering the importance of accurate financial record-keeping and balance sheet integrity, I highly advise consulting with your accountant to ensure all entries are correctly recorded and adhere to relevant financial regulations.
 

If you're in need of an accounting professional, you can easily find one by visiting this link: Find an Accountant.

Additionally, feel free to check the frequently asked questions (FAQs) section about multicurrency. This will provide you with more detailed insights and common queries that could further clarify how to manage and maximize the use of multiple currencies in QuickBooks Online. 
 

I trust that the information I've shared has addressed your question. If you have any additional queries or need further clarification, please don't hesitate to reach out. I'm here to assist you in any way possible. Wishing you a wonderful day!

Terms & ConditionsAccessibility statement