At the end of every financial year, all information for that year should be verified for accuracy and checked against other records, such as those received from banks and auditors. Then the accounting periods should be frozen and moved to the history file to prevent users from making entries that change the year's totals. This is called “closing the year” in CATS. This process is essential to preserving all data in CATS for historical and auditing purposes.

Closing the year cannot be undone.
Make sure that the data in the current and end-of-year isolation is accurate before closing the year.

The following steps should be made before closing the financial year in CATS:

  1. Ensure that the information in the isolated area to be used as the year end is correct. If you have made any changes to the current area that need to be reflected in the isolated area, you will need to re-isolate or make changes in the isolated area.
  2. Run the Accounting Recalculation in the end-of-year isolated period and correct any errors that may appear on the report.
  3. Make sure the ending balances in the isolated area match the G/L trial balance. These balances will be brought forward as the opening balances in the beginning of the new year.
  4. Post or delete all pending invoices dated from before the year-end close. If invoices need to be unposted and corrected, do so before running the year end procedure. Once the year is closed, CATS will not allow the posting of invoices from the prior year.
  5. Enter and post all accounting transactions dated from before the year-end close.
  6. Check that the General Ledger has an account for the Retained Earnings consolidation entries. Make sure the “System” field for this ledger account is set to GL_RET.
  7. Back up the data from the current period and from the year-end isolated period.
  8. Run the Check Contracts procedure and, if needed, reindex all files.
Please note that no other users can work in CATS while you are doing the following procedure.

In CATS, from the File menu, select Maintenance > General Maintenance > Accounting Setup > Close Year.

Accessing the Close Year Feature

CATS will ask you for the standard password.

Enter the Password

After you input the password a menu will pop up allowing you to edit the selections for the close year process.

Click Setup to Pick Year End

Choose Setup to change the accounting period to use to close the year. Select the appropriate accounting period from the list on the right, then choose Save to continue closing the year.

Select Year End Period

As CATS warns you, a secure and permanent backup should be made right before the year is closed.

Backup Warning

Click anywhere to proceed.

Choose All to begin the year-end close process.

Choose All to Proceed

Choose where to print the result from the usual CATS print menu. For easy viewing, pick HTML > Open in Browser.

Print the Close Year Report

After reviewing your selections, click the Start Now button to begin the process. Data will flash on screen as CATS closes the year.

Choose Start Now to Begin

When it has finished, CATS will display the Maintenance Menu and you can Exit to continue working in CATS.

Close Year Finished
  • Loans - Loan balances become opening balances. Inactive loans are removed.
  • 1099 - Recalculates all of the 1099 values for records within the year selected.
  • Set up current charges - Current period inventory transactions include only transactions with dates later than the closing date of the period.
  • Set Account Balances to Opening Values - Account opening period balances are set to the current balance. A/R and A/P and bank balances are updated.
  • Update History File - G/L transactions for the period being closed are moved into the history file.
  • Purging Transaction File - All completed transactions from before the current year are removed.
  • Setting Invoice Balances - The opening period balance for any open invoices is set to the current balance. Open invoices, A/R, and A/P carrying over from the prior year are retained.
  • General Ledger - Revenue and expense accounts are zeroed by summing them and placing the result into the Retained Earnings account. Ledger account opening balances are copied from the end-of-year isolated area.
  • Purchase - Opening period quantities and amounts are set for purchases.
  • Sales - Opening period quantities and amounts are set for sales.
  • Update Journal Pages - Journal Page numbers for the start of the period are recorded.
  • Check That Journals Have Been Printed - All journals should be printed before closing a period. Otherwise transactions from the journals will cover two periods. The opening pages for journals for the new period are set. The date of last update will be reset. The update date must be the last day of the month.
  • Check that the ending balances from the end-of-year isolated period match the current area's opening balances.
  • Move the accounting periods forward one year in the current area. The current area's Period 1 should be the first period of the new year (e.g. January 31). Be careful not to run this procedure in the isolated area. The end-of-year isolation should not be modified.
  • Run an Accounting Recalculation in the current area to set the new periods and to check that no errors have appeared since you closed the year.

The close year process is now complete and you can work in CATS as normal.

  • cats/procedures/closeyear.txt
  • Last modified: 2022/06/29 16:52
  • by wiki_admin