Skip to content

SUI Quarterly

← Back to Newsletter Archives

June 2019 – Volume 23 Issue 2

June 2019 – Volume 23 Issue 2

When generating and preparing your Annual Report and/or GASB 34 Reports, you will likely encounter account numbers that are considered “missing”.  The “missing” accounts are invalid accounts with no specified location on the Annual Report and/or GASB 34 Reports.  To correct your “missing” accounts, you typically have three options:  (1) crosswalk the accounts, (2) complete manual journal entries to move the balances to valid accounts, or (3) manually edit the report.

By completing crosswalks, the system permanently changes the incorrect (“missing”) account numbers to correct numbers, and the incorrect account numbers go away so you cannot use those accounts in the future.  When account numbers are crosswalked, all the balances for the current year and all the history are moved to the new account number.  Within the School Accounting System, there are several different ways that you can crosswalk account numbers and they are described below.

  • Change Account Number in Chart of Accounts.  If you only have a few accounts to crosswalk, complete the steps to change an account number in the Chart of Accounts to crosswalk an account number from one number to another number (the new account number must not already exist).  To change an account number in the Chart of Accounts, bring up the existing account number to change, key in the new account number over the existing one, click the Save button, and then click the Change button when prompted to Change, Create New, or Revert to Original.
  • Crosswalk Account Numbers Option.  If you have many accounts to crosswalk, use the Crosswalk Account Numbers option.  The Crosswalk Account Numbers option can crosswalk an account number from one number to another number or crosswalk all the account numbers with a particular reference piece number to a different reference piece number (for example, change all account numbers using the object piece 110 to be 111 instead).  For step-by-step instructions on using the Crosswalk Account Numbers option, refer to the Crosswalking Account Numbers topic in the Help File.
  • Change Reference Piece in Reference File.  If you need to crosswalk all the account numbers with one reference piece number to a different reference piece number, complete the steps to change a reference piece in the Reference File.  To change a reference piece, bring up the existing reference piece (number) to change in the appropriate Reference File, key in the new number over the existing one (the new reference piece number must not already exist), click the Save button, and then click the Change button when prompted to Change, Create New, or Revert to Original.
  • Change a Fund in Fund File.  If you need to crosswalk all the account numbers in one fund number to a different fund number, complete the steps to change a fund in the Fund File.  To change a fund in the Fund File, bring up the existing fund number to change, key in the new fund number over the existing one (the new fund number must not already exist), click the Save button, and then click the Change button when prompted to Change, Create New, or Revert to Original.

Once the crosswalks have been completed, then regenerate the Annual Report and/or GASB 34 Reports.