Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
InfoIn November 2022 (version 8.1.21) we changed the composition of the Trial Balance statement. This page outlines the new functionality.

The financial year end data impacts your financial statements in different ways, as explained in the following expandable sections. After you set your year end date, you can add other dates as required. You can edit those dates later.

Expand
titleTrial balance

The Trial Balance displays the end of period balances, in particular:

  • For the Balance Sheet accounts, it displays the total balances.

  • For the Profit and Loss accounts, it displays the balances since the start of the financial year.

  • For the

Retailed
  • Retained Earnings account, it excludes Profit and Loss movements during the financial year. The current year earnings is displayed for information purposes, which forms the sum of the Profit and Loss accounts.

    Image Added

To ensure the closing balances in the Trial Balance are correct, you need to set your financial year end date. When you and other users open your Trial Balance, if the financial year end date is not set, you will see a warning message at the bottom of the screen. Users with permission to manage financial statements will also see a button you can click to set the date.

Image Removed
Image Added

When you set the date, the warning message no longer displays. You can then edit the date or add more dates via the Settings

(blue star)

button, as outlined below.

Expand
titleBalance Sheet

By setting the financial year end date, the current year earnings displays on the Balance Sheet, mapped to the same location as the Retained Earnings account.

Image Added
Expand
titleRetained Earnings

Insert excerpt
Design a finance database
Design a finance database
nameretainedearnings
nopaneltrue

Set your financial year end date

  1. Select one of these methods as applicable:

    1. Click the Financial Year… button in the warning message.

    2. Click the Settings button > Financial Year in the top right corner.

  2. In the Financial Year window, click the Our fiscal/financial year ends Open (blue star) button and select the required year end date from the list, for example June 30. If your year end date does not display in the list, select the Other option, then specify the date.

Image Removed
  1. Image Added
  2. (Optional) Add another year end date. You can add as many

year end dates
  1. as

you need
  1. required. Click the Add

(blue star)
  1. button

to add another
  1. , then specify the date range and select the year end date (as above)

.Image Removed
  1. .

    Image Added
  2. Click Save.

  3. Refresh your browser or click the Reset button, then open the Trial Balance again to view your changes.

Edit your financial year end date

  1. Click the Settings (blue star) button > Financial Year in the top right corner.

  2. In the Financial Year window, edit your financial year end date and/or add other dates as required.