You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

This kind has the following setup:

  • Fiscal Year with start date of 1/1/xxxx to 12/31/xxxx
  • Trial Balance Detail column setup:

Additional setup to easily read and compare financial reports.

When you generate a Trial Balance Detail report, the Trial Balance Detail column designer record is defaulted to the above Filter Types with Column Name selected in the Caption field. For this illustration, so as you will see how these filters work, the Caption is changed to Filter Type. This will show the Date coverage of the data.

Then a Page Header is added to match the column name for better illustration.

Here is how Retained Earnings row type works.

  1. This is the fiscal year setup.
    1. FY2013 - 1/1/2013 to 12/31/2013
    2. FY2014 - 1/1/2014 to 12/31/2014
    3. FY2015 - 1/1/2015 to 12/31/2015
  2. This is the Income Statement Detail report with Net Income per fiscal year.


  3. This is the Balance Sheet Detail report with As Of End of Fiscal Year setup per fiscal year.


  4. Print Trial Balance Detail As of Date = 12/31/2014.
  5. Here is the Trial Balance Detail figures based on As of Date = 12/31/2015.


    Here is the Trial Balance Detail figures based on As of Date = 12/31/2016.


    To further explain, for Retained Earnings account's Beginning and Ending Balance, it will take the previous year's Total Income or Loss, which is computed as Total Revenue - Total Expenses. That is why Income Statement accounts (Revenue and Expense type) is zeroed out and is rolled over to Retained Earnings account as Beginning Balance for the current year. In the case where there are transaction/s created that use Retained Earnings account, then that same will be added if posted on the credit side and deducted on the debit side to the Total Income or Loss to get the Retained Earnings Beginning Balance.

  • No labels