User Tools

Site Tools


Sidebar

Table of Contents

general:financeeoyprocess:closefiscalyear

Close fiscal year

This utility provides an easy, streamlined method to efficiently end the old fiscal year and begin the new fiscal year. Only one Finance accounting period can be open (i.e., The Finance current and next accounting period should be the same). Also, all other application accounting periods should match.

The following Finance EOY tasks are automatically completed when you execute the Fiscal Year Close process:

  • Delete 1099 work table.
  • Delete payroll deduction checks.
  • Delete payroll transfer transactions.
  • Copy current to new file ID.
  • Delete credit memos for ending funds.
  • Delete prior year and funds marked for deletion.
  • Mass change account codes.
  • Delete budget amendments only for increment funds.
  • Create new accounts by fund/carry forward totals if selected.
  • Update the file ID of all Finance document attachments to the new file ID.

Reminder: Before processing continuing funds, review overdrawn accounts and/or accounts that have expenditures with no budget. If these deficit balances are not corrected, the negative budget balance will be rolled forward as a negative budget and will need to be corrected in the new year with a JV (Journal Budget).

If an LEA is switching to a July 1 fiscal year, they must change the Starting Accounting Period from 09 to 07 on the Finance > Tables > District Finance Options > Finance Options tab BEFORE closing the year. This allows their data to be updated with the correct month after performing the closing process.

Process the fiscal year close:

Fiscal Year Close Page

When you access this page, last year's options are selected by default. This allows you to review what was done last year and think about how to proceed this year.

To clear last year's selections, click Reset. This resets all funds to Increment allowing you to manually update each selection as needed.

Field Description
New File IDClick Drop-down Arrow to select the new historical GL file ID to which you want to copy all tables and transactions. The field defaults to the last digit of the “to” school year. The drop-down displays a list of all GL file IDs that are not in use. This is a required field.
Accounting PeriodDisplays the Starting Accounting Period. This accounting period is used for all JVs created in file ID C. Only one accounting period can be open.
JV NumberType an alphanumeric journal voucher number. This JV number is used for all system JV entries. This is a required field.
Historical Transaction DateType the historical transaction date in the MM-DD-YYYY format or select a date from the calendar. This date is used for all system entries in the new historical file ID. This is a required field.
New Year Transaction DateType the new year transaction date in the MM-DD-YYYY format or select a date from the calendar. This date is used for all system entries in the new current file ID. This is a required field.

❏ Under Fund Selection, a list of each Fund/Year in the signed-on GL file ID is displayed. Select the appropriate option(s) for each fund.

Notes: The following occurs for all funds:

  • All funds are copied to the new historical file ID.
  • All budget amendments are deleted.
  • All current year requisitions are reversed.
Increment

Select for the funds to be incremented (i.e., funds that will change their fiscal year at the same time that the LEA’s new fiscal year will begin). The increment option is not available if the incremented fund already exists. For example, in September 2022, funds 211/2 and 211/3 already exist; therefore, 211/2 can only be continued or deleted.

If selected, the following actions are automatically completed:

The fiscal year is incremented on credit memos.

The fiscal year is incremented on outstanding Accounts Receivable invoices.
The fiscal year is incremented on the payroll and PMIS distributions for active employees only.

Only purchase orders that include continuing funds are re-encumbered. Purchase orders that are split-funded and include funds where the fiscal year is only being incremented will be deleted. For example, if a purchase order is split between 211 (continuing fiscal year) and 199 (incremented fiscal year), then you will have to re-enter the purchase order in the new file ID.


The following are optional:

Carry Forward Balances
Create 5XXX-8XXX Accounts

Continue

Select for the funds to be continued into the new fiscal year (i.e., funds maintaining the fiscal year even after the LEA begins the new fiscal year).

If selected, the following actions are automatically completed:

The 1XXX-4XXX account balances are carried forward (the Carry Forward Balances field is automatically selected).

The 5XXX-8XXX account balances are created (the Create 5XXX-8XXX field is automatically disabled).

The budget amounts that match the ending balances in the historical file ID are set up for the 5XXX-8XXX accounts. For example, if only $8,000 of a $10,000 grant has been received, then the difference of $2,000 is established as the estimated revenue.

The difference between revenue and expenditures will post to the Obj.Sobj in the Actual Fund Balance Obj.Sobj field on the Finance > Tables > Account Codes > Fund tab.

In the new historical file ID, accounts are inactivated for all continuing funds. Incremented funds remain active.

Only purchase orders that include continuing funds are re-encumbered. The purchase order is re-encumbered in file ID C for the original amount +/- encumbrance adjustments, +/- liquidation amounts from check and credit card transactions. Purchase orders that are split-funded and include funds where the fiscal year is only being incremented will be deleted. For example, if a purchase order is split between 211 (continuing fiscal year) and 199 (incremented fiscal year), then you will have to re-enter the purchase order in the new file ID.

Be aware that purchase orders containing continuing funds will be displayed in both the historical and new current file ID but should be paid in the new file ID.

The fiscal year is not updated on credit memos.

The fiscal year is not updated on outstanding Accounts Receivable invoices.

The fiscal year is not updated on payroll and PMIS distributions.

Continue & Increment

Select for the funds to be incremented and continued into the new fiscal year. The increment option is not available if the incremented fund already exists. For example, in September 2021, funds 211/1 and 211/2 already exist; therefore, 211/1 can only be continued or deleted.

If selected, the following actions are automatically completed:

The 1XXX-4XXX account balances are carried forward for the fund in the fiscal year that is continuing (the Carry Forward Balances field is automatically selected). The accounts for the incremented fund/fiscal years are established with a zero balance.

The budget amounts that match the ending balances in the historical file ID are set up for the 5XXX-8XXX accounts. For example, if only $8,000 of a $10,000 grant has been received, then the difference of $2,000 is established as the estimated revenue.

The difference between revenue and expenditures will post to the Obj.Sobj in the Actual Fund Balance Obj.Sobj field on the Finance > Tables > Account Codes > Fund tab.

In the new historical file ID, accounts are inactivated for all continuing funds. Incremented funds remain active.

Only purchase orders that include continuing funds are re-encumbered. The purchase order is re-encumbered in file ID C for the original amount +/- encumbrance adjustments, +/- liquidation amounts from check and credit card transactions. Purchase orders that are split-funded and include funds where the fiscal year is only being incremented will be deleted. For example, if a purchase order is split between 210 (continuing fiscal year) and 199 (incremented fiscal year), then you will have to re-enter the purchase order in the new file ID.

Be aware that purchase orders containing continuing funds will be displayed in both the historical and new current file ID but should be paid in the new file ID.

The fiscal year is not updated on credit memos.

The fiscal year is not updated on outstanding Accounts Receivable invoices.

The fiscal year is not updated on payroll and PMIS distributions.


The following is optional:

Create 5XXX-8XXX Accounts for the incremented fund

DeleteSelect to delete the fund. If selected, no additional action occurs for these funds.
Carry Forward BalancesSelect to carry forward 1XXX-4XXX account balances into the new fiscal year. This field is automatically selected when Continue is selected for a fund.
Create 5XXX-8XXXSelect to create 5XXX-8XXX accounts. This field is disabled when Continue is selected for a fund.

❏ After carefully selecting the appropriate options for each fund, click Execute to begin the Finance year close process.

Note: After you click Execute, your selected options are saved and will be available the next time you open the Fiscal Year Close page.

Under Processing Reports, the following reports are available:

  • Fiscal Year Close Options Report
  • Pending Purchasing Requisitions - File ID C only
  • Deduction Checks (Unprocessed) - File ID C only
  • Transfer Transactions (Unprocessed) - File ID C only
  • Unprocessed Budget Amendments
  • JV for Create New Accounts - Continuing Funds

Fiscal Year Close Process Reports Page


❏ Select the check box next to each report you want to generate or click the top Select check box to select all reports.

❏ Click Generate Reports to generate the selected reports. Print and/or save the reports and review them for accuracy. The Fiscal Year Close Report Display page is displayed.

Fiscal Year Close Process Report Display

  • Click Continue. The first report selected is displayed. Click Continue to display the next selected report. When you are done viewing all of the selected reports, you are returned to the Processing Reports page.
  • Click Return at any time to return to the Processing Reports page.

Fiscal Year Close Process Reports

❏ Click Process to process the fiscal year close. You are prompted to create an export. A series of end-of-year Finance tasks will begin to run in the background. After the process is completed, you are returned to the Fiscal Year Close page.

After processing, the Current (Open) Accounting Period on the Finance > Tables > District Finance Options > Accounting Period tab is updated to match the Starting Accounting Period on the Finance > Tables > District Finance Options > Finance Options tab (i.e., the accounting periods will be set to 07 or 09 depending on the LEA). In order to update the File ID and Account Period in the top-right corner of the page, you must exit and re-enter the Finance application.

❏ Click Cancel to return to the Fiscal Year Close page.

Fiscal Year Close Process Status

❏ Click Process Status to view the details (error report, status, user details, etc.) for the process. The Fiscal Year Close Processing pop-up window opens with the Status, Extract Type, Start date and time, End date and time, User ID, and user Email address.

Fiscal Year Close Print Report

Fiscal Year Close Status Report

  • Click Continue to continue through the list of reports for the selected extract. Click Return to return to the Fiscal Year Close page.
  • Verify that the Finance Fiscal Year end process was completed.
  • Click Close to close the Fiscal Year Close Processing pop-up window and return to the Fiscal Year Close page.
general/financeeoyprocess/closefiscalyear.txt · Last modified: 2023/05/09 13:49 by emoreno