Supplemental Data Report - File Layout and Data Mapping

The default file name for the Supplemental Data report is form9_supplement<MYYYY>.csv.

The following table shows the columns, column names, descriptions, and data sources or valid values for the Supplemental Data report.

Column	Column Name	Description	Data Source or Valid Values
A	Transaction Date	The date when the financial transaction occurred.	For regular expenditure transactions (checks and voids), this is the transaction date as recorded in the transaction table. For employee payroll transactions, this is the payroll payment date from the detailed distribution records.
B	Fund	The specific fund for which financial data is being reported.	Retrieved from the Fund field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.
C	Account	The account as it appears in the ledgers.	Retrieved from the Budget Code field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.
D	Object	The expenditure object code that identifies the nature or type of purchase.	Retrieved from the Object field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.
E	Payee	The name of the person or organization receiving payment. This identifies who received the funds for each transaction in the supplemental report.	For regular expenditure transactions, this is the vendor name from the vendor master file. For employee payroll transactions (when the Report Employee Payroll option on the IN Biannual Form 9 Report - Supplemental Data Report page is selected), this is the employee's full name, constructed from the first name, last name, and name suffix fields.
F	Amount	The cumulative total for all 13 periods for this organization/account or fund/account.	Retrieved from the Amount field on the Biannual Form 9 Data form of the IN Biannual Form 9 Report page.