Skip to main content
Y
yunke8849-gmail-
July 13, 2024
Question

How to eliminate bank account balance due to time difference of foreign exchange rate?

  • July 13, 2024
  • 1 reply
  • 0 views
My book is recorded in Mexican Peso, and we have an old CNY bank account. We transferred out all money from that account. From chart of accounts, it shows a nil balance in CNY, however it is not nil on balance sheet due to foreign exchange rate. Does anyone know how to close the balance to foreign exchange gain&loss, so we can get both nil balance on chart of accounts and balance sheet?

1 reply

J
JanbonN
July 13, 2024

I'm here to help you balance your Chart of Accounts (COA) and Balance Sheet, Yunke8849.

 

The differences you've experienced could be the reason for the fluctuating exchange rates between the Mexican Peso and Chinese yuan renminbi (CNY).

 

To fix this, we'll have to create a holding account for the discrepancy caused by the fluctuating exchange rates and create a Journal entry (JE) to move the balance to the holding account.

 

Here's how to create a holding account:

 

  1. Go to the Gear icon and select Chart of Accounts.
  2. Click New.
  3. Select Bank as the Account Type.
  4. Choose a name for the account you can easily remember, and fill in the necessary information.
  5. Click Save and Close.

 

As for creating a Journal entry to move the balances, I would recommend consulting with your accountant about this process for further assistance.

 

Additionally, you can refer to this article about personalising your reports: Customise reports in QuickBooks Online.

 

Let us know if you have other concerns with your COA or balance sheet. We're here to help you in any way we can.

Y
yunke8849-gmail-Author
July 14, 2024

I have created a foreign exchange gain&loss account, when I move the balance to this account, it shows an nil balance on balance sheet, however, the balance in chart of accounts shows an negative amount. Would that be possible to have both nil amount on balance sheet and chart of account?

S
SarahannC
July 14, 2024

Thanks for responding, yunke. Yes. It is possible to have a Nil amount on both the Balance Sheet report and the Chart of Accounts. I recommend you consider consulting your accountant for proper recording using a journal entry and the appropriate account.

 

Additionally, you can check this article for tips about customizing reports in QBO: Get the most out of your financial reports.

 

You can always visit this thread if you've other concerns. I'll be around to help.

Terms & ConditionsAccessibility statement