How do you deal with unrealized gains and losses affecting ending balances in bank accounts. my discrepancies are quite significant

Hello, 

In today's globalized world, it's inevitable that many small businesses will buy and sell goods in foreign currencies. QuickBooks Online Essentials and Plus makes this simple, offering powerful multicurrency tools that will help you get your work done. If you're noticing an ending balance that's affected by your unrealized exchange gains and losses, I'd be happy to point you in the right direction to resolve that. 

Depending on exactly what you're seeing in your account, you may need to enter a home currency adjustment for your foreign balances. Home currency adjustments change the home currency value of your foreign balances, recalculating them based on a new rate. These adjustments affect your balance sheet accounts.

To find out more about home currency adjustments and how to create one in QBO, check out this helpful Community article: Enter home currency adjustments for your foreign balances. As explained in this article, "until you recalculate the home currency value of your foreign balances using current exchange rates, your reports show the home currency value based on the exchange rates you used at the time of each transaction. At the end of a reporting period, when you need your financial reports to show a current home currency value of your foreign balances, you can enter a home currency adjustment."

Without the opportunity to review your specific account and balances, it may be difficult to give you a complete picture of why you're noticing these discrepancies in your account. If you review the home currency adjustment option and you still need further assistance, please reach out to our tech support team directly so an agent can work with you one-on-one. 

Take care.