Use the MN UFARS Report - Setup - Data Crosswalk - GL page to create a crosswalk (translation table) that converts your district's internal General Ledger (GL) account codes to the corresponding state-defined UFARS GL account codes during the UFARS report generation process.
The GL crosswalk specifically handles balance sheet accounts and other General Ledger accounts that require translation for UFARS reporting. This is separate from the revenue and expenditure account crosswalks and focuses on asset, liability, and fund balance accounts.
-
On the MN UFARS Report - Setup - Data Crosswalk - Fund page, select GL from the Crosswalk Type drop-down list.
-
Select the Year.
-
Filter records using the filter criteria. To enter filter criteria:
-
Select an option in the first field.
-
Select or enter a value.
-
Select Add if the button is enabled.
Refer to Search for records for more information.-
To add a record, select Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, then Yes.
-
To edit a record, select the record and select Accept. Update the information and select Accept.
-
To delete, select Delete, then Yes.
-
To download the information, select Download, then select Download PDF or Download as an Excel Document. The default file names are:
-
Excel: MN UFARS Report GL Crosswalk_<MMDDYYYY_hhmmss>.xlsx
-
PDF: MN UFARS Report GL Crosswalk_<MMDDYYYY_hhmmss>.pdf
-
-
-
Field descriptions
The following table describes the fields on the MN UFARS Report - Setup - Data Crosswalk - GL page.
|
Field |
Description |
|---|---|
|
Year |
The fiscal year of the GL crosswalk. |
|
District Fund |
The district-level fund code to which this General Ledger mapping applies. Enter a specific fund code to limit the mapping to that fund, or enter an asterisk (*) to apply the mapping to all funds. |
|
District GL Account |
The district-level General Ledger (GL) account code that needs to be translated to a UFARS code. This typically includes balance sheet accounts such as assets, liabilities, and fund balance accounts. |
|
UFARS GL Account |
The corresponding state-level UFARS GL account code that will be reported to the Minnesota Department of Education. |