Question

Retained Earning - Different Value of TB and BL

Forum|Forum|6 years ago
February 20, 2020
2 replies
28 views

Hi,

The retained earnings value appearing on the TB is different than the BL

As December 31st 2018, RE figure matches but when at the time of closing it appears different

The issue was highlighted by our auditor, please help

Thanks

QuickBooks Online

C

ChristieAnn 11

Level 9

Hi there, ACCOUNTS_EVO.

The screenshot provided shows only the Trial Balance is incorrect. To sort this issue, I suggest clicking each amount in the Trial Balance report to see if there are changes. If so, enter the correct amount to match the transactions with the Balance Sheet.

Here's how to check in the trial balance report:

1. Click Reports at the left panel.

2. Select the search icon and choose Trial Balance.

3. Click each amount under the Debit and Credit column.

Once done, you can customize both reports to see the specific information or data you want to show. Please check this article to see the steps: Customize reports in QuickBooks Online.

You may also refer to this article on how to find transactions in your account registers so you can review and make any changes if necessary: Find, review, and edit transactions in account registers.

Please know that you're always welcome to post if you have any other concerns. Wishing you and your business continued success.

A

ACCOUNTS_EVOAuthor

Hi Christie,

Thanks for your quick response,

As per your instructions, I cross-checked TB and BL accounts and found that there is a system-generated FX unrealized gain and loss account,

I am not been able to book a reversal entry for this account,

Any solution? (screenshot attached)

Thanks

R

RaymondJayO

QuickBooks Team

I appreciate you for performing the steps shared by my peer above to help fix your reporting concern, @ACCOUNTS_EVO. Also, the screenshot you've added helps me determine the root cause of this issue, and I've got some details to resolve this.

The Unrealised Gain or Loss account on your report is an indication that you haven't made the revaluation of your foreign currency. That's why the system generated this account.

To help fix this, let's first revalue your foreign currencies. I'd suggest consulting with your accountant before entering these adjustments. He can determine the specific accounts you want to apply the revaluation to. This way, you'll have the most updated unrealized gain or loss amount on the report so your books will be accurate. I'll guide you how.

Go to the Settings (Gear) icon at the upper right.
Select Currencies under Lists.
Locate the currency you want to adjust.
From the Edit currency exchange drop-down list in the Action column, click Revalue currency.
Set a Revalue date.
Select whether you'd like the revaluation will be based on the market exchange rate or a rate you specify.
Choose the account you want to apply the revaluation to.
Click Revalue and save.

The screenshot below shows you the last six steps.

Once done, QuickBooks will automatically create a journal entry and adjust the Unrealised Gain or Loss amount on your report. For more details, go through this article: Frequently Asked Questions about Home Currency Adjustments.

If you still want to book a reversal entry for the Unrealised Gain or Loss account, I recommend consulting your accountant again. He can verify if this is the appropriate method to correct the difference in your TB and BL reports. Once confirmed, proceed with the steps below.

Go to Accounting from the left menu.
Select Chart of Accounts.
Locate the Accounts Receivable or Accounts Payable account.
From the Action column, select View register.
Select the journal entry for Unrealised Gain or Loss and select Edit.
In the transaction window, choose Reverse.
Click Save and close.

For detailed instructions, check out this article: Reverse or Delete A Journal Entry.

As always, you can visit this website: Year-end Checklist. This link provides you a series of tasks to complete your year-end process, such as closing your books to lock past transactions.

Please know that I'm here anytime you have other concerns. Have a great day, @ACCOUNTS_EVO.

A

AccountingInCanada

I am having the same issue. I revalue the currency every month.

The problem is that I can have "Unrealized Gain/Loss" account on my P&L and on my Balance Sheet but it won't appear on the Trial Balance.

How can I get the account "Unrealized Gain/Loss" on the Trial Balance?

JasroV

Level 8

Good to have you join this thread, @AccountingInCanada.

I can share with some insights about the Unrealized Gain/Loss.

The Unrealized Gain/Loss account is the result of home currency adjustments due to changes in exchange rates.

These are realized only after the transactions have been completed when money has been collected or paid. Thus, it'll not reflect on your general ledger or trial balance report.

You can also check out these articles for more details about this:

Once everything is in place, you might want to utilize this link for reference in seamlessly managing your accounts: Reconcile an account in QuickBooks Online.

If there's anything else you need assistance with about your reports and currencies, please feel free to tag me in your response. I'm always here to assist you. Have a good one!

Sign up

Login with SSO

Let's get you signed in

Login with SSO