Revised: 12/05/2013
If you have extended the fiscal year past the actual year, you must remove the extended months from the Accounting Period Master before you close your fiscal year. The program will not close the year if there are extended periods. See How to Remove Extended Months from a Fiscal Year and follow the instructions shown.
Before you close the fiscal year, it is recommended that you run Rebuild General Ledger Reporting for the year. Follow the instructions shown in the link.
General Ledger Trial Balance
Go to Reports>>Trial Balance
Run the Trial Balance report for the year you are closing.
Check that your ledger is in balance.
If your account totals should balance by segment control, such as Fund, AMP, Department, etc., then it is recommended that trial balances should be run and filtered on a segment control for each possible value.
Alternate sort method:
Select a Sort Order that would show your Balance Control segment first.
If you do not have an appropriate Sort Order, see How to Add a User Defined Order
Beginning with the last segment, Check Segments to Summarize.
Do not place a check mark in the segment that is your balance control segment.
The beginning and ending balance for each summarized fund should be zero.
If the report shows *C* in front of general ledger accounts, the previous fiscal year should be closed.
If the report shows *R* in front of the general ledger accounts, the current fiscal year needs rebuilt.
The final totals for the Begin Balance & Ending Balance columns should be 0.00
If your general ledger is in balance proceed to Review GL Accounts
If they are not zero you should review your entries to find and fix the error before you continue to close your fiscal year.
If you preview or print the GL Account List you can see all the closing accounts listed on the report. If you prefer, you may go directly to Maintain>>GL Account Master to review your account setup.
Go to Lists>>GL Account List
Preview or Print the GL Account List to review the chart of accounts
All Income & Expense accounts should have a Closing Account. If the account does not have a closing account, the closing process will use the Default Closing Account number entered in General Ledger Settings. If the Default Closing Account is also blank, then the closing process will be halted and a list of errors will be reported.
If your account totals should balance by segment control, such as Fund, AMP, Department, etc., then the closing account selected should be in the same Fund, AMP, Department as the profit-loss account that is being closed.
Important: If your accounts close to different closing accounts based on Fund, AMP, Department, etc., then do not enter a Default Closing Account in General Ledger Settings. If an account is missing the closing account it will close to the Default, which will most likely not be to the correct segment control.
Go to Maintain>>GL Account Master
Fix any accounts that have missing or incorrect closing accounts in the GL Account Master found under Maintain>>GL Account Master.
OR see How to Update Closing Accounts to update closing accounts for a range of general ledger accounts.
Go to Utilities>>End Year Process
Enter or select the fiscal year you wish to close in Year to Close or select the Segment to close
If your company does not use "Using Segment Controlled Accounting Periods", selecting by Year or Segment will return the Year to Rebuild and Segment as "Master Control". This process will process the selected year for the entire company.
If your company does use "Using Segment Controlled Accounting Periods" but NOT the "Segments Can be in Different Accounting Years", you may select the "Master Control" segment to close the entire company or you may select a segment to only close that segment. Every segment will need to be selected and closed separately when not using the "Master Control" segment to close the year.
If your company does use "Using Segment Controlled Accounting Period" AND ALSO the "Segments Can be in Different Accounting Years" you must select a segment and the year as each segment must be closed separately. The "Master Control" segment will not be available to close.
Select a Closing Mode. The default mode is Standard Close.
Standard Close - the selected Year or Segment will be closed and the Accounting Periods will be locked. Balances will be brought forward into the new year. Entries into the old fiscal year will not be allowed unless an Accounting Period is unlocked.
Close Year - Leave Open (Will not lock accounting periods) - the selected year or segment will be closed but the closing year's accounting periods will not be locked. Balances will be brought forward and Accounting Periods for the new year will be created. Entries into the old fiscal year and the new fiscal year will be allowed. The old fiscal year should be closed using Standard Close at some point.
Create Next Year Only - the accounting periods for the new fiscal year will be created. The current accounting periods will not be locked and balances will not be brought forward. Entries will be allowed into both years. The old fiscal year will need closed using Standard Close at some point so that balances are brought forward.
Note: If the year/segment combination you are attempting to close is not in the browse, then corrections may be needed to these accounts. Run a trial balance for the period and segment. Do any accounts have a *C before it? If so, a previous year has had a change to the activity and will need to be closed first. An *R indicates that the accounts need rebuilt before closing. See: How to Rebuild General Ledger Reporting. If you need assistance, please call the Horizon help desk.
Press Close Year on the Quick Links>>> bar
The process will be halted and an error message displayed if the fiscal year needs rebuilt, please see How to Rebuild General Ledger Reporting
If there are extended periods in the Accounting Period Master, please see How to Remove Extended Periods for a Fiscal Year.
The process will be halted if closing accounts are missing or invalid. Please review the GL Account listing again. Closing accounts can be added or corrected in the GL Account Master or updated with the Update Closing Accounts tool.
After correcting any errors, run the End Year Process again.
All of the Closing Modes will create the next fiscal year, for the Year or Segment that were closed, in the Accounting Period Master if it has not already been created and the Year or Segment will be rebuilt for the next fiscal year.
Closing Report
You may print a Closing Report by going to Reports>>Journal Listing.
Change Sort Information to Transaction Date and enter the last day of your Fiscal year in both the Start and End Date fields.
You may enter a First and Last Account number to limit the account range on the report.
Select Only Memo Entries as the Memo Closing option
Preview or Print the report.
This Journal Listing report will include only the Fiscal Year Closing Entries.
General Ledger Trial Balance
Go to Reports>>Trial Balance
Run the trial balance for the year again. This time place a check mark in the "Include Memo Closing Entries"
Your Closing Account's activity will include the Net Income/Loss for the year.
The Income and Expense Accounts (Profit-Loss Accounts) should have an Ending Balance of 0.00. If they do go to Check Beginning Balances.
If any Income and Expense Accounts (Profit-Loss Accounts) show a balance, then recheck those accounts in the GL Account Master and fix the Closing Account.
After you have fixed the closing accounts Close the Fiscal Year again.
If Funds or Departments use balance controls, run the Trial Balance again to check that all funds/departments balance after closing.
Select a Sort Order that would show your Balance Control segment first
Beginning with the last segment, Check Segments to Summarize
Do not place a checkmark in the segment that is your balance control segment
Include Memo Closing Entries should be checked
The beginning and ending balance for each summarized fund should be zero. If any ending balances are not zero, the fund is out of balance. This will usually be caused by a revenue or expense account that has a closing account set to a different balancing segment. Review the Journal Listing Closing Report. The Memo field shows the account closed from and to. Find the accounts that cross segment control, correct the GL Account Master Closing Account and then close the year again.
Go to Reports>>Trial Balance
Run the Trial Balance for the new year.
Do not check mark the "Include Memo Closing Entries".
The beginning balances should match the ending balances from the year before.
*******************
In the General Ledger Settings program on the System Information tab under Accounting Period Control:
Using Segment Controlled Accounting Periods
This box should be unchecked if the company only has one Accounting Period to track. The End of Year Processing and Rebuild General Ledger Reporting programs will only have the “Master Control” option for each fiscal year.
If this field is checked, the system will support multiple Accounting Periods based upon the Master Segment. The purpose is to track the opening and closing of each Accounting Period separately. A fiscal year should be set up for each Master Segment in the Accounting Period Master.
Segments Can be in Different Accounting Years
If this option is UNCHECKED then:
The Accounting Periods dates must be the same for all Segments of the same Fiscal Year. I.E. All Segments for Fiscal Year 2011 must start 7/1/2010 and end 6/30/2011, or all Segments for Fiscal Year 2011 must start 1/1/2011 and end 12/31/2011. You cannot have any Accounting Periods for a Fiscal Year that contain different dates
You may run the End Year Process and Rebuild G/L Reporting individually per Master Segment or all together using the “Master Control” option for the Fiscal year.
If this option is CHECK MARKED then:
"Using Segment Controlled Accounting Periods” must also be CHECK MARKED in order to function. If not the program will disregard this option and only the Master Control Segment will be available.
Your Accounting Periods may have different fiscal years. I.E. One Segment for Fiscal Year 2011 could start 1/1/2011 and end 12/31/2011, and another Segment for Fiscal Year 2011 could start 7/1/2010 and end 6/30/2011.
You must run End of Year Processing and Rebuild General Ledger Reporting individually per Master Segment.
The Master Control period will not be available for this company.