cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about connecting your bank and credit cards in QuickBooks Online
Influence Map CIC
Level 1

Discrepancy in Chart of accounts and Trial Balance for a bank account in foreign currency

We have recently closed a bank account in a foreign currency; the Bank reconciliation (which is in the non-sterling amount) always balanced, and Chart of accounts showed nil balance in the account (in the non-sterling currency) on the date the account was closed / date of last transaction. Then my accountant, noticed a remaining GBP balance in this account but in Trial Balance. I have meticulously been posting each transaction in this foreign currency bank account to correspond to the correct FX daily rate in the home currency (based on our bank rates and not Quickbook rates) so I do not understand why there is a remaining GBP ££ value in this account in Trial Balance, when Chart of Accounts showing nil $$. The accountant posted a journal to clear the GBP amount from the Trial Balance (since the account is empty and now closed) but now this GBP amount is in Chart of accounts, which is no longer nil $$.

Anyone has any explanation what may have happened there? Where does the difference comes from when workinig with non-home currency bank accounts (USD, EUR etc): you can see a well balanced account in non-GBP currency in Chart of Accounts (correct per Bank statements)  and then Trial Balance showing an incorrect amount in GBP?

4 REPLIES 4
Ashleigh1
QuickBooks Team

Discrepancy in Chart of accounts and Trial Balance for a bank account in foreign currency

Hello Influence Map CIC, welcome and thanks for posting on the Community page. The reason it is still showing a figure is that it could be due to the exchange rates, as it is usually reported in the home currency, and since QBO uses the exchange rates at the time transactions were entered into the system. You can try to re-evaluate the currency on the settings to fix the discrepancy on the TB report. If you still have any issues, I recommend reaching out to support via chat or phone. The line is open Monday to Friday, 8am-7pm, so you can set up a screen share with the agent so the issue can be looked into more for you and resolved. Thanks.
Influence Map CIC
Level 1

Discrepancy in Chart of accounts and Trial Balance for a bank account in foreign currency

Hi Ashleigh1 - thanks for the reply. I just wanted to note that I have been manually adjusting the FX rates of each transaction in "Bank Transactions -> For Review" and all transactions, converted into the Home currency (GBP), are correct as per the FX rate on the day. Do you mean that the foreign currency has to also be adjusted in "revalue currency" menu (in Settings)?

Even though I have posted each transaction with the correct FX rate, at the end of each month when I run the Trial Balance (and Balance sheet) I get incorrect GBP value for this Bank Account - while in Chart of Accounts I have the correct Non-Sterling value (which is reconciled as per Bank statements). 

Ashleigh1
QuickBooks Team

Discrepancy in Chart of accounts and Trial Balance for a bank account in foreign currency

Hello Influence Map CIC, thanks for coming back to us. It is due to the exchange difference. For example, if $100 goes in one day worth £70, and comes out the following week worth £68, there will be a $0 balance, but a £2 balance remains due to the exchange rate difference. Revaluing the currency is the correct thing to do to resolve that difference you are having.  You can reach out to support via chat or phone. The line is open Monday to Friday, 8am-7pm, and set up a screen share with the agent so the issue can be looked into more for you and resolved. Thanks.
Tommy_S
Level 1

Discrepancy in Chart of accounts and Trial Balance for a bank account in foreign currency

Hi,

I'm having the same problem. Two bank accounts in foreign currency (MXN and AUD) show a nil balance in the chart accounts, but a small existing USD balance in the trial balance as of December 31 last year. For audit reasons, I cannot update last year's financial statements, and I need to correct the discrepancy this year.
How can I resolve the discrepancy in the trial balance, knowing that entering a new journal entry always starts with the foreign currency, such as 1 MXN or 1 AUD = x USD? If it were the other way around, I could enter 1 USD = 0 MXN or 0 AUD and decrease the bank account in foreign currency by the amount shown in the trial balance in USD. This way, there would be no impact on the chart of accounts due to the exchange rate chosen.

 

What do you recommend?

Need to get in touch?

Contact us