Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
This QBO file has a home currency of NIO (Nicaraguan Cordoba). The account in question is a Accounts Receivable account, based in USD, so a foreign currency.
As of 12/31/2018, the balance on the Trial Balance is 1,273.72, but the balance on the Balance Sheet is 1,443.88. The difference is in Unrealized Gain or Loss, which has a balance of 170.16 on the Profit and Loss, but a balance of 0.00 on the Trial Balance. Every other account matches (between the Trial Balance and the Balance Sheet and the Profit and Loss).
(Also, when I did the "Revalue Currency" as of 12/31/2018, this A/R account in USD is the only USD account that had an adjustment of 0.00. Is it being treated differenty than other foreign (USD) balance sheet accounts because it's an A/R account? Maybe this is the reason why the difference exists?)
I need a Trial Balance that matches both my Balance Sheet and my Profit and Loss. How can I overcome this current discrepancy?
Hello there, @karen_labase!
One of the possible reasons why your accounts receivable balance doesn't match is the changes in the currency used in your reports. I'm here to help you with this.
To start, let's pull up your Balance Sheet report. And then, click the amounts of your Accounts Receivable account. This way, you'll be able to identify the changes of currency used in each transaction.
From there, you'll be able to review the currency of each transaction and change them if needed.
Please let know how it works by leaving a comment below. I'll be waiting for your response. I'll be always around to lend a helping hand.
It turned out to be the Unrealized Gains/ Losses related to the A/R balances. But it's possible to run the Balance Sheet and Profit and Loss reports without the Unrealized Gains/ Losses by unchecking the box. So that's what we've done for now.
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.
For more information visit our Security Center or to report suspicious websites you can contact us here