cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW Connect to DBS IDEAL direct bank feeds Click here
Ivona
Level 1

Customizing trial balance

Dear team, 

 

Thank you for your previous answer on trial balance and balance sheet comparison. (https://quickbooks.intuit.com/learn-support/global/reports/re-balance-sheet-and-trial-balance/01/916...

 

Also, I would like to ask, is it possible to customize trial balance including unrealized gain or loss accounts? Or just in other words, is it possible to create trial balance including accounts which we prefer to see? 

 

Thank you in advance 

5 Comments 5
katherinejoyceO
QuickBooks Team

Customizing trial balance

Hi there, @Ivona. 

 

You can run Transaction Detail or customize the Customer Balance Detail and Vendor Balance Detail to view unrealized gains or losses. Here's how: 

 

  1. Go to the Reports menu, then locate and open the Customer Balance Detail or Vendor Balance Detail report.
  2. Select Customize., then open the Rows/Columns section and select Change columns.
  3. Select the Unrealized Gain or Loss checkbox.
  4. In the Aging section, under the Aging method, select Report date.
  5. Select Run report.

 

For future reference, see this article: Home Currency Adjustments. It also contains answers to frequently asked questions.

 

Let me know if you have other concerns. I'm always around to help.

Christoph MM
Level 1

Customizing trial balance

Dear katherinejoyce0

 

your answer shows how to show the unrealised gains/losses on AR / AP but not how to generate a trial balance which includes all unrealised gains/losses.

 

Do you have a way to do that? We do have loans which are also in foreign currency and which generate a considerable unrealised gain/loss which needs to be part of the final figures. All reporting ist done through the trial balance and I therefore would appreciate if a trial balance including the unreaslised gains/losses is possible

 

Thank you

 

Christoph

Eman_E
QuickBooks Team

Customizing trial balance

I'm here to provide more insights about how to generate all the unrealised gains or losses in QuickBooks Online (QBO), @Christoph MM.

 

The unrealised gains and losses account appears on the Profit and Loss report. The Trial Balance report includes assets, liabilities, and equity. You can also pull up reports like the Balance sheet, Customer Balance Detail, Supplier Balance Detail, and Statements of the Cash Flows to view unrealised gains or losses.

 

To pull up the P&L report, here's how:

 

  1. Sign in to your QuickBooks Online account.
  2. Select the Reports menu on the left pane.
  3. In the search bar type in Profit and Loss.
  4. From there make sure to tick the box beside the Show unrealised gain or loss.
  5. Once done, hit on Run report.

image3.png

In addition, to gain a better understanding of Home currency adjustments while using the Multi-currency feature in QuickBooks Online, the resource also contains a FAQ section that can assist in locating your Home currency adjustments history: Frequently asked questions about Home currency adjustments.

 

Please don't hesitate to reply to this thread if you need further assistance managing your financial reports in QBO. I’m here to help you out.

Christoph MM
Level 1

Customizing trial balance

Dear Eman_E

 

Thank you very much for your quick answer. Unfortunately this does not solve my problem. I need one report to export all data which serves as the key document to import this data afterwards into our group reporting tool. The P&L report is not sufficient as all balance sheet data is missing. The P&L report is also inconsistent with debit and credit not showing it always the same direction. On the trial balance you have a separate column debit and credit. Also just one column would work showing negative or positive figures. 

 

I am a bit puzzled to what the trial balance serves if it does not show the correct figures.

LollyNino_C
QuickBooks Team

Customizing trial balance

Thanks for getting back to this thread, @Christoph MM. Let me share information about unrealised gains or losses in QuickBooks Online (QBO).

 

In QuickBooks Online (QBO), the trial balance report shows account balances at a specific time, excluding unrealised gains or losses. Unrealised gains or losses are included in the P&L statement, reflecting changes in asset or liability values. It helps assess financial performance and understand market fluctuations' impact on profitability, with treatment varying based on accounting standards and business requirements.

 

There are specific reports that include unrealised gains or losses. You can consider pulling up these reports to display such information:

 

  • Profit and Loss report
  • Balance sheet
  • Customer Balance Detail report
  • Vendor Balance Detail Report
  • Statement of Cash Flows

 

As a workaround, you can export both reports and merge the desired information outside QBO. You can check out this guideline for exporting data: Exporting reports in QuickBooks Online.

 

I've added these resources you can check. These will show you the list of available reports and how to customise them:

 

 

For your reference, if you want to run financial reports to manage your business, visit this article for your guide: Common Custom Reports in QuickBooks Online.

 

I'm always around if you need further assistance with running reports. I'm here to ensure you'll find the success you need. Have a wonderful day!