The default file names of the Categorical State Fund Balances report are:
-
PDF: IA_CAR_Categorical_State_Fund_Report_<MMDDYYYY>_<hhmmss>.pdf
-
Excel: IA_CAR_Categorical_State_Fund_Report_<MMDDYYYY>_<hhmmss>.xlsx
The following table shows the columns, names, descriptions, and the data sources or valid values for the Categorical State Fund Balances report’s .xlsx file format.
|
Column |
Column Name |
Description |
Data Source or Valid Values |
|---|---|---|---|
|
A |
FISCAL YEAR |
The fiscal year of the data. |
The field value is retrieved from the Year field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
B |
DISTRICT ID |
The district ID. |
The field value is retrieved from the District ID field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page. |
|
C |
CAR FUND |
The fund to use for CAR reporting. |
The field value is retrieved from the CAR Fund field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
D |
CAR FACILITY |
The facility to use for CAR reporting. |
The field value is retrieved from the CAR Facility field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
E |
CAR PROGRAM |
The program to use for CAR reporting. |
The field value is retrieved from the CAR Program field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
F |
CAR PROJECT |
The project to use for CAR reporting. |
The field value is retrieved from the CAR Project field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
G |
CAR ACCOUNT |
The account to use for CAR reporting. |
The field value is retrieved from the CAR Account field on the Categorical State Fund Balances Data form of the IA Certified Annual Report (CAR) - Categorical State Fund Balances page. |
|
H |
REVENUE AMOUNT |
The cumulative revenue total for all 13 periods for this organization/account or fund/account. |
Not applicable |
|
I |
EXPENDITURE AMOUNT |
The cumulative expenditure total for all 13 periods for this organization/account or fund/account. |
Not applicable |
|
J |
BALANCE |
The cumulative balance for all 13 periods for this organization/account or fund/account. |
Not applicable |
|
K |
BUDGET CODE1 |
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. |
The field value is retrieved from the *Budget Unit* field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page. |
|
L |
ACCOUNT |
The account as it appears in the ledgers. |
The field value is retrieved from the Account field on the Fund Accounting Data form of the IA Certified Annual Report (CAR) page. |