To determine what Closing ID to use when performing the year-end process, consider the following:
  • The Closing ID will be a masked version of your Fund Balance or Net Asset account.  Enter a mask that represents the fund balance account(s) used to close revenue and expense entries.
  • You must mask at least the fund dimension of your account. If you mask any other digit, this will mean that that digit will be derived from the revenue/expense account.
    • Example 1: Closing ID - Axx 00 00 3110 will close all Fund 01 accounts into account A01 00 00 3110, Fund 02 accounts into A02 00 00 3110, etc.  Each fund has one Fund Balance account.
    • Example 2: Closing ID - Axx xx 00 3110 will close all Fund 01, Department 01 accounts into A01 01 00 3110, all Fund 01, Department 02 accounts into A01 02 00 3110, etc.  This will result in many more Fund Balance Accounts than Example 1.
  • The Closing ID should never be all X's. The Account Object dimension (in this example 3110) always needs to be specified.
  • If you do not know the Closing ID, you can produce a chart of accounts report and select to Include only attributes NA or FB (depending on your system setup). The same information can be seen by choosing the NA or FB attribute on the Chart of Accounts Grid.  
    • Also, if you have previous years of history, you can verify what closing entries were produced for the previous year by producing an account detail report.  Produce the report with an account mask of all Xs and use the report date range equal to your year end date for the previous year.  IMPORTANT:  for the Include period, deselect All and select ONLY Closing, and Include first position attribute NA/FB/OE as appropriate.  Be sure your report definition contains all of the dimensions of your account.  Typically, Transaction Report ACDTL will contain all of your dimensions, so you may want to produce this one.