Skip to main content
December 11, 2018
Solved

How to correct the home currency value for foreign bank account closing balance? Thank you.

  • December 11, 2018
  • 2 replies
  • 0 views

I am using QB Pro 2014 multi currency version. Home currency is HKD. 

I have a JPY S/A bank account.

The year beginning balance + the year total deposit - the year total withdrawal = The year-end closing balance (a positive figure) = bank statement. But the Home currency value for The Year beginning balance + the year total deposit - the year total withdrawal = The year-end closing balance = a negative figure.

I cannot figure out why the foreign balance is a positive figure but the home currency value is a negative figure.  I did not do the year-end adjustment for JPY to home currency value at the last year-end and this year-end yet.  Is this the possible reason to have this result ?

How and what can I do to correct it?  Can I adjust the last year-end home currency value after the ending of the last year?  Thank you very much for your help!

Best answer by arkvalleyinfo

The apparent discrepancy is the result of changes in the exchange rate during the year, and transactions that are not recorded at the actual exchange rate at the time of the transaction.  Failing to enter the home-currency adjustment at year-end is one contributing factor.  Note that this apparent discrepancy is just a result of doing business in multiple currencies at fluctuating exchange rates - it is a natural consequence, it is not an error.  The year-end home-currency adjustment records the result of the differing exchange rates - a gain or loss.

At a minimum, a home-currency adjustment should be recorded at every year-end.  Failure to do this may result in misleading financial and tax reports, and errors in tax payments.  For some businesses it may be desirable to record a home-currency adjustment more often - quarterly, monthly, immediately following an unusually large transaction, or on some other criteria unique to your business.  

You should discuss this with your own professional accountant to help determine the best course of action with respect to the previous year-end currency adjustment, the current year-end adjustment, and the most appropriate timing of adjustments between year-ends.

2 replies

JianCarlo_S
December 11, 2018

Hi @m.hui,

Let's see if our AllStars @Safari818 and @qbteachmt might be able to help with this. They've been extremely helpful before with questions about home and foreign currencies.

arkvalleyinfoAuthorAnswer
December 11, 2018

The apparent discrepancy is the result of changes in the exchange rate during the year, and transactions that are not recorded at the actual exchange rate at the time of the transaction.  Failing to enter the home-currency adjustment at year-end is one contributing factor.  Note that this apparent discrepancy is just a result of doing business in multiple currencies at fluctuating exchange rates - it is a natural consequence, it is not an error.  The year-end home-currency adjustment records the result of the differing exchange rates - a gain or loss.

At a minimum, a home-currency adjustment should be recorded at every year-end.  Failure to do this may result in misleading financial and tax reports, and errors in tax payments.  For some businesses it may be desirable to record a home-currency adjustment more often - quarterly, monthly, immediately following an unusually large transaction, or on some other criteria unique to your business.  

You should discuss this with your own professional accountant to help determine the best course of action with respect to the previous year-end currency adjustment, the current year-end adjustment, and the most appropriate timing of adjustments between year-ends.

December 11, 2018
Thank you for your advice.  What is the steps I need to do if I want to adust the last year end home currency value and this year home currecny value?  Thank you.