Balance sheet accounts for the fiscal year you enter are selected from the general ledger table, including entries with zero balance. Only the portion of the account code defined by the beginning and ending positions on the IA Certified Annual Report (CAR) - Setup - Reporting Structure page is used as the account in the state structure. When a user-defined crosswalk defines a fund or account, the state code is used for the state account structure.
The state account structure's facility, project, and program portions must be defined as a crosswalk-only record in the Categorical State Fund Balances table. Amounts of Liability and Equity accounts defined in the Fund Accounting profile are reversed (multiplied by –1) before being stored. Credit balances are stored as negative amounts. Also, records are created for Categorical State Fund balances based on the non-crosswalk records in the Categorical State Fund Balances table. Refer to Categorical State Fund Balances for more information.
Revenues for the fiscal year are selected from the revenue ledger table. The organization level and beginning and ending positions on the setup page determine the CAR fund, facility, function, program, project, and source. If any part of the accounting structure is defined in a user-defined crosswalk, the state code is used for the state account structure.
Fiscal year expenditures are selected from the revenue ledger table. The organization level and beginning and ending positions on the setup page determine the CAR fund, facility, function, program, project, and object. If any part of the accounting structure is defined in a user-defined crosswalk, the state code is used for the state account structure.
Encumbrance amounts, which should be zero at year-end, are bypassed for revenues and expenditures. In addition, all control accounts defined in the Fund Accounting profile are also ignored when loading revenue and expenditure data.
Amounts for all 13 periods on a record are summarized. Each record on the CAR table contains an account ID indicating whether it is a balance sheet, revenue, or expenditure record.
-
On the IA Certified Annual Report (CAR) page, select Load.
-
Select the Fiscal Year.
-
Enter the District ID.
-
Select Load Using Fund Groups to use fund groups.
-
Select Report Optional Revenue Function to report the optional revenue function.
-
Select Load, and then Yes.
-
If data for the selected criteria is extracted, select Yes to delete and extract the data again.
-
Save the Load Summary report file and select OK.
-
Navigate to the file location.
-
Inspect the file. Update data if needed.
-
Repeat these steps until all required data is loaded.