Fullscreen Image

Manage Fiscal Calendar

The calendar that an organization uses has an enormous impact on their lease accounting. Lucernex supports the use of 13-period years, 4-4-5 quarters, 4-5-4 quarters, and English / Scottish quarters.

You will also need to select the date your fiscal calendar ends on the Manage Company page of the System Administrator Dashboard.

If you are using a 13-period fiscal calendar AND you are planning on using percentage rent accruals, you need to select the calendar month that you want to associate with two fiscal periods. You can do so from the Financial Settings page in Manage Company pane of the System Administrator Dashboard.

To navigate to the Manage Fiscal Calendar page:

  1. Select Admin in the toolbar in the upper-right corner of the window.

    The System Administrator Dashboard page opens.

  2. Click Manage Fiscal Calendar link in the Portfolio/Capital Program Administration column.

    The Manage Fiscal Calendar page opens.

  3. Follow a procedure below.

ClosedEnglish / Scottish / Irish quarters

Choose from several quarterly payment frequency options for expenses. The following table shows the default quarter start dates for each option.

Frequency Q1 begins Q2 begins Q3 begins Q4 begins
Quarterly January 1st April 1st July 1st October 1st
Quarterly (England) March 25th June 24th September 29th December 25th
Quarterly (Irish) February 1st May 1st August 1st November 1st
Quarterly (Scottish Old) February 2nd May 15th August 1st November 11th
Quarterly (Scottish New) February 28th May 28th August 28th November 28th

Create a custom payment frequency.

Quarterly payment frequency calculation

When you select the standard Quarterly payment frequency, Lucernex uses the default quarter start dates shown in the table if the contract’s Expense Schedule start date matches one of those dates. If payments start on a different date, Lucernex calculates quarters based on the Expense Schedule start date for the contract (not fixed calendar dates). For example, if the schedule starts on February 15, the quarterly periods are February 15 to May 14, May 15 to August 14, and so on.

To align quarterly payments to fixed calendar quarter dates (such as January 1, April 1, July 1, and October 1), set the contract’s Expense Schedule start date to the quarter start date you want.

Example:

If the contract’s expense schedule starts on February 10, the quarterly periods are:

  • Q1: February 10 – May 9
  • Q2: May 10 – August 9
  • Q3: August 10 – November 9
  • Q4: November 10 – February 9 (the following year)

ClosedAdd a Fiscal Calendar

The system calculates the dates for subsequent years based upon the initial record you enter. However, subsequent years may be offset by extra calendar days in the year. Verify that the dates of your fiscal years match what you expect.

You can set both a global fiscal calendar and calendars for specific portfolios. To create a fiscal calendar for a specific portfolio, select the portfolio from the Portfolio at the top of the page. To set your global fiscal calendar, select <SELECT> from the field.

To configure your fiscal calendar:

  1. To use a 13-period calendar:

    1. Enter the year you are beginning your accounting in the Year of the Multi-Period Add (Equal Period Length) row.

    2. Enter 13 in the Total Periods of the Multi-Period Add (Equal Period Length) row.

    3. Enter the begin date of your fiscal year in the Fiscal Year Start field.

      Select Calendar A small button with a picture of a calendar on it. to open the date picker.

    4. Enter the end date of your fiscal year in the Fiscal Year End field.

      Select Calendar A small button with a picture of a calendar on it. to open the date picker.

    5. Click Create Periods for Year.

      The year you created appears in the Year Summary (non-computed years) table.

    6. To view the details of the year, click the year in the Year Summary (non-computed years) table.

      The details of the year appear in the Year Details table.

  2. To use a 4-4-5 quarter or 4-5-4 quarter calendar:

    1. Enter the year you are beginning your accounting in the Year of the Multi-Period Add (by weeks) row.

    2. Select either 4-4-5 or 4-5-4 from the Weeks in Quarter field.

    3. Enter the begin date of your fiscal year in the Fiscal Year Start field.

      Select Calendar A small button with a picture of a calendar on it. to open the date picker.

    4. Click Create Periods for Year.

      The year you created appears in the Year Summary (non-computed years) table.

    5. To view the details of the year, click the year in the Year Summary (non-computed years) table.

      The details of the year appear in the Year Details table.

  3. To use English / Scottish quarters:

    1. Enter the year you are beginning your accounting in the Year in the row below the Multi-Period Add (by weeks) row.

    2. Enter the begin date of your fiscal year in the Fiscal Year Start field.

      Select Calendar A small button with a picture of a calendar on it. to open the date picker.

    3. Enter the number of weeks in each period in the fields provided.

    4. Click Create Periods for Year.

      The year you created appears in the Year Summary (non-computed years) table.

    5. To view the details of the year, click the year in the Year Summary (non-computed years) table.

      The details of the year appear in the Year Details table.

ClosedEdit a Period

To edit a period:

  1. Select the year whose period you want to edit from the Year Summary (non-computed years) table.

    The periods in the selected fiscal year appear in the Year Details table.

  2. Select Edit in the Actions column of the record.

    The Edit window opens.

  3. Make your changes.

  4. Select Update.

    The window closes. Your changes are saved.

ClosedDelete a Period

To delete a period:

  1. Select the year whose period you want to delete from the Year Summary (non-computed years) table.

    The periods in the selected fiscal year appear in the Year Details table.

  2. Select Delete in the Actions column of the record.

    A dialog opens, asking you to confirm your choice.

  3. Select Yes.

    The dialog box closes. The period is deleted.

ClosedDelete a Fiscal Calendar

You may need to refresh the page after deleting a fiscal calendar to see the update.

To delete a fiscal calendar:

  1. Find the fiscal year you want to delete in the Year Summary (non-computed years) table.

  2. Select Delete in the Actions column of the record.

    A dialog opens, asking you to confirm your choice.

  3. Select Yes.

    The dialog box closes. The fiscal year is deleted.