cancel
Showing results for 
Search instead for 
Did you mean: 
E21J
Level 3

Foreign currency bank account balance

I have reconciled my USD bank account to nil as per the statement but when I run a transaction report, QB shows that there is a balance.

 

Yet if I go to run the next reconciliation, the brought forward is nil.

 

What is wrong and how can I fix this please?

 

Thanks.

Solved
Best answer April 30, 2019

Best Answers
JessT
QuickBooks Team

Foreign currency bank account balance

You're welcome, E21J, and thank you for the additional details.

 

When you transfer the funds from your USD bank account to your GBP bank account, please be sure to choose US Dollar as the transfer currency. Then, you will enter the USD amount and the exchange rate at that time. This will zero out the balance in your USD account.

 

 

Please let me know if you have other questions.

View solution in original post

14 Comments
JessT
QuickBooks Team

Foreign currency bank account balance

Hi E21J,

 

It’s good to hear to that you’re able to reconcile your account.

 

Reconciliation will not affect your account balance unless you create an adjustment entry, which I believe you didn't have since you got a nil difference.

 

On the other hand, the balance you see is the account balance within the period specified in your report. What report is it, by the way?

 

Thanks in advance for your reply.

E21J
Level 3

Foreign currency bank account balance

It shows a balance on the balance sheet, both on the face of it and then if I drill down into the individual line for the account.

 

Many thanks.

GlinetteC
Moderator

Foreign currency bank account balance

Thanks for getting back to us, E21J.

Reconciliation is not a posting entry.

It does not reduce the balance of your balance sheet unless you created a transaction.

 

You might want to compare each transaction recorded on the register versus the transactions showing on the balance sheet. This will help us identify as to where the amount is coming from.

If you have other concerns, I'm always here to help.

E21J
Level 3

Foreign currency bank account balance

Thank you.

 

I do understand that the reconciliation is not a posting entry.

 

What I am seeking to understand is why when the following places show the account balance to be zero:

1) the Chart of Accounts - zero balance on USD account

2) account register - zero balance on USD account

 

the Balance Sheet and Account Transactions report show a balance of around a $100.

 

Many thanks.

 

 

 

 

Mark_R
QuickBooks Team

Foreign currency bank account balance

Thank you for getting back to us, @E21J.

 

Allow me to chime in and provide some information about the account balance.

 

Just to clarify, are these transactions recorded to a different currency? If so, the exchange rate of this currency is set per transaction. So even the balance in the Chart of Accounts has zero balance, it does not convert the report to Home currency by running balance, but converts per transaction.

 

Also, when converting per transaction to Home currency and total them to the report, it'll cause a balance even if the bank balance showing zero for foreign banks. That means, your Balance Sheet and Account Transactions report will have the balance but your Chart of Accounts have zero.

 

That answer your question. Let me know if you have any other questions. I'll be around if you need any help.

E21J
Level 3

Foreign currency bank account balance

Ok, thank you for your reply, @Mark_R .

 

How do I make the Balance Sheet and Account Transactions show zero at a given date as this is what I need to do because there is nothing in the account.

 

Many thanks.

 

E21J
Level 3

Foreign currency bank account balance

Thanks for your replies @Mark_R  and @GlinetteC .

 

I have been through the transactions on the BS report and compared them to those on the register as suggested by @GlinetteC .  This shows that every time we received some money in USD and then converted that money and transferred it to the GBP account a couple of days later, there was a small variance.  Overtime, these variances have accumulated and now amount to c. £100.

 

 

Please can you advise how I can adjust this home currency balance to zero so that my balance sheet agrees to the bank statements at a given date?

 

If I am not able to do this, my balance sheet will show a balance in the USD account which does not exist.  If there are no USD in the USD account, I am not able to withdraw any whether in USD or GBP and therefore, no amount should show on the Balance Sheet.

 

Many thanks.

JessT
QuickBooks Team

Foreign currency bank account balance

Thanks for the reply and for the additional details, E21J.

 

I would recommend consulting an accountant to help you with the adjustment.

 

Going forward, you can let QuickBooks calculate the gain or loss for you, so you won't have to receive money to a USD account, convert, and then transfer to a GBP account. Normally, you can receive the payment from your customer like receive the actual amount on the invoice. Then, when you deposit it to your bank account (GBP) that's the time you enter the exchange rate, so QuickBooks will calculate the exchange gain or loss for you.

 

 

 

If you have other questions, you can always go back to this thread.

E21J
Level 3

Foreign currency bank account balance

Thank you for this @JessT .

 

However, please can you advise the best way to input these transactions when the funds are received to a USD bank account?  It is great that I can do this in principle however, it is not what actually happens.  As we are not able to receive USD into our actual bank account (as against the QB one), we receive the money into our USD bank account and, then once we have received the funds (checked via online banking), we transfer it to our GBP account.  So, these are transactions which actually happen via the banks rather than just the way it has been done in QB.

 

Many thanks.

 

JessT
QuickBooks Team

Foreign currency bank account balance

You're welcome, E21J, and thank you for the additional details.

 

When you transfer the funds from your USD bank account to your GBP bank account, please be sure to choose US Dollar as the transfer currency. Then, you will enter the USD amount and the exchange rate at that time. This will zero out the balance in your USD account.

 

 

Please let me know if you have other questions.

View solution in original post

Marianne
Level 1

Foreign currency bank account balance

@E21J 

Hi! Were you able to resolve this issue?  I have the same problem.  Winding down my client's company and all bank accounts are now at zero on bank statement, bank reconciliation and chart of accounts except on the Balance Sheet, like your example. 

Catherine_B
QuickBooks Team

Foreign currency bank account balance

Hi Marianne,

 

E21J was able to solve the questions by following the steps provided by my colleague @JessT. Just make sure that when transfer funds or create deposits from one account to the other, the US Dollar is selected as the transfer currency. Then, you will enter the amount in USD and the exchange rate at that time. This process will zero out the balance in your USD account.

 

We still suggest reaching out to an accountant if there's a need for you to create an adjustment. You can also get in touch with our Phone Support Team if you get the same result after selecting the transfer currency. I'll be attaching an article about the Multicurrency feature in QuickBooks Desktop

 

Let me know if you have other questions. Keep safe!

Marianne
Level 1

Foreign currency bank account balance

@Catherine_BThanks for the reply.  I am actually using QBO not desktop.  Also, if I make a transfer entry, it will affect my bank reconciliation which is now all balanced and at zero.

Tori B
QuickBooks Team

Foreign currency bank account balance

Hey there, @Marianne

 

Thanks for following up with us and letting us know that you're using QuickBooks Online. 

 

As mentioned by my colleagues above, the best solution is to consult with your accounting professional. Your accountant will know what would be the best steps to take for your business. If you don't have an accountant, don't sweat. You can find one here in our Resource Center

 

In the meantime, I've included a few handy articles below that cover more details about multicurrency in QuickBooks Online that you may find beneficial. 

 

Please let me know if you have additional questions or concerns. I'll be here every step of the way. Feel free to reach back out to the Community at any time. Have a great day! 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up