Certified Annual Report - Maintain Data | PowerSchool ERP Compliance

You can correct the loaded data before submitting the report. However, you must also update the source data.

Since the data submitted for the report must be consistent with the district's audited financial statements, records should only be added, changed, or deleted if they reflect changes made to the financial statements after the table has been loaded. You can reload the table if necessary; however, all changes will be lost.

If a record is deleted or an account code is changed, the original record is retained in the table to print on the Audit Log. However, the record is not displayed on the IA Certified Annual Report (CAR) page.

On the IA Certified Annual Report (CAR) page, filter records using the filter criteria. To enter filter criteria:
1. Select an option in the first field.
2. Select or enter a value.
3. Select Add if the button is enabled.
  Refer to Search for records for more information.
  - To add a record, click Add Record. Refer to the Field descriptions and enter valid information in the required fields. Select Save, and then Yes.
  - To edit a record, select the ellipsis in the Actions column and then select Edit. Update the information and select Save.
  - To delete a record, select the ellipsis in the Actions column, select Delete, and then select Yes.
  - To download the information, select Download, then select Download PDF or Download as an Excel Document.

Field descriptions

The following table describes the fields on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page.

Field	Description	Load logic - Data source and Valid values
Year	The fiscal year of the data. The default is the current year. This field is view-only and cannot be edited after saving the record.	Not applicable
Account ID	A code used to identify whether an accounting entry is a balance sheet, revenue, or expenditure. For balance sheet items, the account ID is the first position of the account code. This field is view-only and cannot be edited after saving the record.	Valid values: 1 - Current Asset 2 - Long Term Asset 3 - Other Asset 4 - Current Liability 5 - Long Term Liability 6 - Other Liability 7 - Fund Balance 8 - Revenue 9 - Expenditure 1-7 indicates a Balance Sheet account. 8 indicates a Revenue account. 9 indicates an Expenditure account.
Budget Unit	Low organization to record transactions in your Expenditure Ledger, as defined in the Organization Chart. An expenditure record is identified by its budget unit-account combination and the fiscal year. The key organization as it appears in the expenditure or revenue ledgers, or the fund code as it appears in the general ledger. Select the lookup icon to search for and select a key organization.	The field label is retrieved from the Low Orgn field on the Titles tab of the Fund Accounting Profile.
Account	The account as it appears in the ledgers. Select the lookup icon to search for and select an account.	Revenue - revledgr.account Expenditure – expledgr.account Balance sheet – genledgr.account
State Fund	Indicates whether a balance sheet record was created using a non-crosswalk record in the categorical state fund balance table. The default is No. This field is view-only and cannot be edited after saving the record.	Valid values: No Yes
District ID	The district ID. This field is view-only and cannot be edited.	The field value is retrieved from the District ID field on the IA Certified Annual Report (CAR) - Load page.
Amount	The cumulative total for all 13 periods for this organization/account or fund/account.	The sum of actual amounts from all 13 periods in the revledgr, expledgr, or genledgr for the selected records (exp1 through exp13).
CAR Project	The project/reporting code enables school districts to track revenues and expenditures, meeting specialized reporting requirements at the local, state, and federal levels.	Crosswalked from a field in the accounting structure based on the Project level and beginning and ending positions.
CAR Fund	A separate fiscal and accounting entity with a self-balancing set of accounts, recording cash and other financial resources, and all related liabilities and residual equities, balances, or changes.	Crosswalked from a field in the accounting structure based on the Fund level and beginning and ending positions.
CAR Object	This classification describes the service or commodity obtained as the result of a specific expenditure. Not used for revenue or balance sheet.	Crosswalked from a field in the accounting structure based on the Object level and beginning and ending positions.
CAR Facility	A combination of the operational unit and level of instruction. Only required for Charter schools.	Crosswalked from a field in the accounting structure based on the Facility level and beginning and ending positions.
CAR Source	The classification code for recording revenue and other receivables. Required for revenue.	Crosswalked from a field in the accounting structure based on the Source level and beginning and ending positions.
CAR Function	Describes the activity for which a service or material object is acquired. Required for expenditures.	Crosswalked from a field in the accounting structure based on the Function level and beginning and ending positions.
CAR Account	Balance sheet accounts track financial transactions for each fund. Not used for revenue or expenditure.	Crosswalked from a field in the accounting structure based on the Account level and beginning and ending positions.
CAR Program	A plan of activities and procedures designed to accomplish a predetermined objective or set of objectives.	Crosswalked from a field in the accounting structure based on the Program level and beginning and ending positions.