Actual account balance vs Trial balance

CamMull · ‎July 06, 2021

Hi,

I have a (South African Rand) ZAR bank account which is reconciled with a R0.00 balance, Screenshot 2021-07-07 at 03.11.47.png

however the trial balance is showing US$3,951.57 in the credit column Screenshot 2021-07-07 at 03.10.14.png

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?

RenjolynC · ‎July 06, 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:

Go to the Gear > Currencies.
Find the currency you want to adjust.
Under the Actions column, click the small arrow icon next to Edit currency exchange and select Revalue Currency.
Set a date (today or a day in the past) to run a currency revaluation.
Select whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
Choose the account(s) you want to apply the revaluation to.
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!

View solution in original post

RenjolynC · ‎July 06, 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:

Go to the Gear > Currencies.
Find the currency you want to adjust.
Under the Actions column, click the small arrow icon next to Edit currency exchange and select Revalue Currency.
Set a date (today or a day in the past) to run a currency revaluation.
Select whether you'd like the revaluation to be based on the market exchange rate or a rate you specify.
Choose the account(s) you want to apply the revaluation to.
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!

CamMull · ‎July 06, 2021

Thank you so much RenjolynC,

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

CamMull · ‎July 06, 2021

If I may ask another question RenjolynC,

I see now the value is correct for each date I revalue the currency. Our end of financial year was 30 April, so if I revalue to then the Balance is zero. However it now shows the value as a debit as of today. If I revalue the currency for today's date the value is correctly zero.

Do I need to just revalue the currency each time I do my end of year financials reports to ensure the resulting journal entry is created and captured for those reports?

Thanks again in advance

Topics

Training

Community

Resources

Actual account balance vs Trial balance