Skip to main content
C
CamMull
July 6, 2021
Solved

Actual account balance vs Trial balance

  • July 6, 2021
  • 1 reply
  • 0 views

Hi,

 

I have a (South African Rand) ZAR bank account which is reconciled with a R0.00 balance,

 

however the trial balance is showing US$3,951.57 in the credit column

 

I have gone through all the transactions linked to this account, there was no major ZAR/USD exchange error where the exchange rate was mistakenly captured 1:1 as has happened in the past.

How could the USD value be this incorrect and what should i do to fix this?

Best answer by RenjolynC

Hello, CamMull.

 

I'd like to share some details about the exchange rates.

 

In QuickBooks Online, the exchange rate is always calculated as the number of Home currency units that equal 1 Foreign currency unit.

 

If you want to make adjustments with the exchange rates, it's always a good idea to check with your accountant for advice. This is to ensure that your book stays accurate and compliant.

 

Here's how:

 

  1. Go to the Gear > Currencies.
  2. Find the currency you want to adjust.
  3. Under the Actions column, click the small arrow icon next to Edit currency exchange and select Revalue Currency.
  4. Set a date (today or a day in the past) to run a currency revaluation.
  5. Select whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
  6. Choose the account(s) you want to apply the revaluation to.
  7. Hit Revalue.

For more information about the exchange rates, you can read these articles:

 

Please reach out to me again if you have any additional questions or other concerns. I'll be right here to provide the solutions. Have a good day!

1 reply

RenjolynC
RenjolynCAnswer
July 6, 2021

Hello, CamMull.

 

I'd like to share some details about the exchange rates.

 

In QuickBooks Online, the exchange rate is always calculated as the number of Home currency units that equal 1 Foreign currency unit.

 

If you want to make adjustments with the exchange rates, it's always a good idea to check with your accountant for advice. This is to ensure that your book stays accurate and compliant.

 

Here's how:

 

  1. Go to the Gear > Currencies.
  2. Find the currency you want to adjust.
  3. Under the Actions column, click the small arrow icon next to Edit currency exchange and select Revalue Currency.
  4. Set a date (today or a day in the past) to run a currency revaluation.
  5. Select whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
  6. Choose the account(s) you want to apply the revaluation to.
  7. Hit Revalue.

For more information about the exchange rates, you can read these articles:

 

Please reach out to me again if you have any additional questions or other concerns. I'll be right here to provide the solutions. Have a good day!

    C
    CamMullAuthor
    July 7, 2021

    Thank you so much RenjolynC, 

    I really appreciate you time and help on this, it sorted out the issue immediately. Thank you kindly

    Terms & ConditionsAccessibility statement