Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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).
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?

You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.