Financial Year Configuration

You perform the configuration of the financial year on the Financial Year (GL101000) form. To configure the financial year, you do the following on this form:

  1. Decide which year should be the first year, and specify it in the system.
  2. Define its structure—that is, define the periods of the year in the system.
  3. If it is necessary to have a special period for posting adjustments at the end of the year, add an adjustment period.

After you have saved the configuration of the financial year, you can generate periods in the system, as described in Master Calendar Generation.

In this topic, you will read about these steps in detail.

Defining the First Financial Year

The first financial year usually designates the year when the company starts processing its operations in MYOB Acumatica. However, we recommend that you define the first financial year so that it includes the last period before the company started to use MYOB Acumatica, even if that means defining an extra financial year. You can then upload the ending balances of accounts to that period.

Note:
You cannot post transactions with dates earlier than the start date of the first period of the first financial year defined in MYOB Acumatica.

For example, if you plan to start using MYOB Acumatica from the first period of the 2024 financial year, you should select 2023 as the first year. You then generate all periods of 2023, open only the last period of 2023, and enter initial balances in the last period of 2023.

If your company starts operations in MYOB Acumatica after the first financial period of the year, you select the current year as the first financial year and open only the periods for which you are going to enter transactions. For example, if you intended to start operations in November 2024, define financial years as calendar years, and use monthly financial periods, you would select 2024 as the first financial year and open periods for October 2024, November 2024, and December 2024.

You define the first financial year by selecting its start date in the Financial Year Starts On box on the Financial Year (GL101000) form. After you have selected the start date, you can see the first financial year defined by its start date in the First Financial Year box.

In some organizations, the financial year starts in the current year but belongs to the next year. For example, the United States Government's financial year begins on October 1 of the previous calendar year and ends on September 30 of the year that gives the financial year its number—so the financial year 2024 ran from October 1, 2023, to September 30, 2024.

In this case, you indicate that the financial year starts in the current year but belongs to the next year by selecting the Belongs to Next Year option. The system automatically calculates the end date of the financial year as the end date of the last period.

Defining Periods for the Financial Year

The financial year is divided into financial periods, which can have equal durations or different ones. The total length of all periods may or may not be equal to the year. In the Period Type box, you set up periods as follows:

  • To set up duration of each period based on months, you do one of the following selections:
    • If duration is one month, you select Month.
    • If duration is two months, you select Two Months.
    • If duration is four months, you select Quarter.
  • To set up duration of each period based on weeks, you do one of the following selections:
    • If duration is one week, you select Week.
    • If duration is two weeks, you select Two Weeks.
    • If duration is four weeks, you select Four Weeks.
  • To divide financial year into four quarters with periods of different duration, you do one of the following selections:
    • If each quarter includes two four-week periods and a five-week period, you select 4-4-5 Weeks.
    • If each quarter includes a four-week period, a five-week period, and a four-week period, you select 4-5-4 Weeks.
    • If each quarter includes a five-week period and two four-week periods, you select 5-4-4 Weeks.
  • To divide financial year into user-defined number of periods, you select Custom Number of Periods.

For instructions, see:

Other years will have the same structure as the first financial year. You can make limited modifications to the financial year and periods, as described in Financial Year Modification and Modification of Periods for a Year.

Setting Up Periods Based on Months

If you set up financial periods based on months (Month, Two Months, or Quarter), the periods will start and end on the same dates each year (except the leap years). Each successive financial year will start and end on the same date.

To define periods in the system, you click Create Periods on the form toolbar of the Financial Year (GL101000) form after making the needed selections on the form. After you have generated the periods, you can review the defined year.

Setting Up Periods Based on Weeks

If you set up financial periods based on weeks (Week, Two Weeks, Four Weeks, 4-4-5 Weeks, 4-5-4 Weeks, or 5-4-4 Weeks), the start and end dates of same-name periods will vary within the year, and the number of periods per year may vary. Financial periods based on weeks always start on the same day of the week and always end on the same day of the week.

However, a calendar year has either 365 or 366 days, which is 52 full weeks plus 1 or 2 extra days. For a financial year based on the 4-4-5, 4-5-4, or 5-4-4 type, if the gap between the end of the financial year and the end of the last period exceeds three days, the system automatically adds an additional week to the last period.

For example, you set up the first financial year to start on January 1, 2023 with periods of the 5-4-4 Week type. In the 2020 financial year, the last period of four weeks ends on December 26. The gap between the end of the financial period and end of the financial year is 5 days. The system automatically adds a week to the last period so that it lasts 5 weeks.

When you configure week-based periods (4-4-5 Weeks, 4-5-4 Weeks, and 5-4-4 Weeks), you need to specify the Financial Year Starts On setting on the Financial Year (GL101000) form. The system generates a financial year as follows:

  1. It creates the first 12 periods, which is 52 weeks or 364 days.
  2. It tries to add the 53rd week. If the larger part on the week (4 days) belongs to the next year after the Financial Year Starts On day, the week is not added.

Suppose that you want the financial year to end on the last Sunday of August (which is August 30). You should specify 8/29/20XX in the Financial Year Starts On box. In this case, the system will add the 53rd week only if the week ends on August 31 or earlier or starts not later than August 25. This means that the Financial Year Starts On date must be set to August 29 (August 25 + 4 days). The following table illustrates the selection of the Financial Year Starts On date.

Date Can This Date Be Start Date of Week 53? Notes
August 24 Yes
August 25 Yes The latest possible start date
August 26 No
August 27 No
August 28 No
August 29 No Financial Year Starts On date
August 30 No
August 31 No
Note:
For a week-based period type of calendar, because the financial year does not have a fixed start date and structure, you cannot generate a year template on the Financial Year (GL101000) form.

Setting Up Periods of Week Type

For a financial year with Week period type, you select the day of the week on which each period will start in the Periods Start Day of Week box. According to the selected day of the week, the system calculates the start date of the first period. You can view this date in the First Period Start Date box.

To process the difference between the length of a calendar year and the length of all week-long periods, you can set up the system to add an additional (53rd) period by selecting one of the following options in the Year-End Calculation Method box of the Financial Year (GL101000) form:
  • To set up the system to add an additional period if the last period ends four or more days earlier than the financial year ends, you select Last Day of the Financial Year. The system adds no additional period if the last period ends fewer than four days before the financial year ends.
  • To set up the system to add an additional period if the year's last period does not include the last occurrence of the day of the week that is displayed in the Day of Week box in the financial year, you select Include the Last <Day of Week> of the Financial Year. The system adds no additional period if the last period includes the last occurrence in the financial year of this day of the week.
  • To set up the system to add an additional period if the year's last period does not include the day of the week specified in the Day of Week box that is nearest to the end of the financial year, you select Include <Day of Week> Nearest to the End of the Financial Year. The system adds no additional period if the last period includes the day of the week that is nearest to the end of the financial year.
Note:
When you select the start day of the week for the periods in the Periods Start Day of Week box, the day of the week in the Day of Week box is automatically specified as one day earlier so it is the last day of the period. The system uses this day of the week to calculate whether an additional period is necessary to be added as described above.

Defining an Adjustment Period

An adjustment period is a special one-day period added after the last period in a year. Its start date and end date are the same as the end date of the last period of the current financial year. An adjustment period can be used for posting only adjustment transactions. If you need to, you can add an adjustment period during the initial setup of the financial year by selecting Has Adjustment Period check box on the Financial Year (GL101000) form before you generate periods. The number of periods in the Number of Financial Periods box increases by one. With the adjustment period configured, when you generate periods, each year will have an adjustment period.

After initial setup of the financial year, you can add an adjustment period for a particular financial year or delete it for a particular financial year (if the adjustment period was configured) by using the Master Financial Calendar (GL201000) form. For details, see Modification of Periods for a Year. For instructions on how to add the adjustment period, see To Add an Adjustment Period.

Shifting the First Financial Year Earlier

If you realize that some financial data (such as beginning balances for general ledger accounts) should be posted before the start date, you may need to shift the first financial year earlier—that is, add a year before the current first financial year; the added year will become the new first year.

To shift the first financial year, you use the Generate GL Calendars dialog box on the Master Financial Calendar (GL201000) form.