Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Overview

Management of the accounting of financial years is important for reporting and control purposes.

Transactions can only be entered into financial periods if they are open and totals are only rolled when periods are closed.

Note

A period may be open but may be part of a locked BAS statement

  1. Existing transactions cannot be modified
  2. New transactions can be entered - they will be added to the next BAS statement calculation automatically

To populate the information about a financial year select it from the year drop down list.

Warning The Standard Reports in the Financial system rely on maintenance of the financial year in the following way

  • Reports look back to the last closed financial period and use the totals from the closed period results and then calculate forward. This requires a discipline when re-opening periods to make adjustments. If you re-open a period you MUST

...

Financial Year Tab

Auto-create of Financial Years

After a journal is saved, if the latest created financial year for the journal ledger host company ends less than a year after the journal date then a new financial year will be created for the year following

  1. GL Control Configuration form (Admin menu, Finance, GL Control Accounts), GL (Advanced) tab:

    1. New field ‘Financial Year Name Format’.

    2. Name will be converted to upper case.

    3. Key strings in the format will be replaced:

      1. {SY} will be replaced with the 2 digit calendar year that the financial year starts in, e.g. 2021 = 21.

      2. {SY4} will be replaced with the 4 digit calendar year that the financial year starts in, e.g. 2021.

      3. {EY} will be replaced with the 2 digit calendar year that the financial year ends in, e.g. 2022 = 22.

      4. {EY4} will be replaced with the 4 digit calendar year that the financial year ends in, e.g. 2022.

    4. Other characters will be left unchanged, e.g. if the financial year ends 30/6/2022 FY{SY}{EY} = FY2122 or FY {EY4} = FY 2022.

  2. After a journal is saved, if the latest created financial year for the journal ledger host company ends less than a year after the journal date then a new financial year will be created for the year following the latest created financial year, using the name format shown above.

To create a new Financial year

  1. clear the form
  2. Enter a name (eg FY12-13)
  3. Enter the end date (eg 30 june 2013)
  4. Enter the number of financial periods (eg 12)
  5. Save

Image Added

 Each financial year once defined and used cannot be deleted without first removing all transactions that refer to that year.

...

  • To create a new financial year, clear the form, in '''Year''' then fill in the details of the name, end date and number of periods. The year will be created for you.

...

Periods Grid

...

  • Close will close and calculate period totals

...

Opening / Closing Periods

Image Added

When a period is closed the totals for the period are re-calculated + all periods after this that are closed will be re-calculated until the next open period is found

  1. This means that anytime a period is adjusted and closed all following periods will be recalculated to ensure the reports are accurate.

When the last period that was open in a financial year is closed the year will be calculated

Note

The GST Explorer for BAS enables closing of BAS periods without closing financial periods. Any transactions that are added to a closed BAS period are reported in the next BAS period as a change from the previous period.

Roll Account Totals recalculates all the GL Accounts for all time until the last closed period and also updates the retained earnings for each year.

The Standard Financial Reports Module in the system use the calculated Retained Earnings Figure

Reports look back to the last closed financial period and use the retained earning totals and then calculate forward. 

If you do not close your periods then the reports may take longer to run as they will need to calculate more periods back to get the values required.

Period Summary Tab

Once a period has been selected in the Financial year tab the grid shows all accounts for the period with their Debits and Credits total listed and their Currency.

In the bottom of the grid is the total Debits and credits across all accounts.

Opening Balances

...

Usually created by Upload or Import a General Journal from Excel

Cross Period Explorer Tab

This is an audit function to enable searching for Stock Sales Orders that have Revenue journals but not COGS journals in the same or earlier financial period as the revenue. Typically these transactions may have journals entered into the system for accounting purposes on period ends that enable the reporting of the COGS amount for the period and reversing it again at the beginning of the next period. '''Create Journal for''' Button is used to create a single journal for the entire amount of COGS in the period.

How to use the Cross Period Explorer

...