GUIDE FOR CREATING THE SCHEDULE C .CSV FILE 

 STEP 1: Add data to fields following max field lengths and format. DO NOT include header records containing column (field) names in the file.

STEP 2: Save as .csv file (file name should be ScheduleC.csv without any spaces)

STEP 3: Follow steps to upload and import file

Excel Template | Example

CANDIDATE
Field Name Example Length Description
Unique Number 1 - first column must contain the line number
First_Name John 50 required
Last_Name Doe 50 required
Address_Number 3334 6 required
Sub_Number 1/2 or A 3  
Prefix_Direction E 3 must be E, S, SE, SW, N, NE, NW, W
Street_Name CEDAR 30 required
Suffix_Direction W 10 must be E, S, SE, SW, N, NE, NW, W
Street_Type AVE 4 examples AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
Unit_Number 300 4  
City Topeka 20 required
Zip1 66633 5 required
Zip2 1114 4  
Purpose_of_expenditure Tickets 50 required, must be Candidate (self), Cell Phone, Consultant, Donation/Contrib, Electronics/Computers, Electronic/Website Advertising, Filing Fee, Fundraising Expenses, Gift, Meeting/Travel, Mileage, Miscellaneous, Newspaper Ads, Newsletter, Polling, Postage/Shipping, Printing, Radio/TV, Reimbursement, Refund, Rental, Subscription, Supplies, Tickets, Voter file, Yard signs
Expenditure_amount 44.99 - required, must have two digits to the right of the decimal
Date 2/9/2008 - required
PAC_Name John's PAC 100 required if no first name, last name, or Business Name entered
Other PO Box 332 100 required if no Address No. or Street Name entered
State KS 2 required, must be two-letter state abbreviation
Description_of_Expenditure Reimbursement 50
Unit_Type STE 10 must be APT, BSMT, BLDG, CONDO, DEPT, FLOOR, FRNT, HNGR, KEY, LBBY, LOT, LOWR, OFC, PH, PIER, REAR, RM, SIDE, SLIP, SPC, STOP, STE, TRLR, UNIT, UPPR
Business_Name Signs R Us 50 required if no first name, last name, or PAC Name entered

Click here for .csv file example

POLITICAL ACTION COMMITTEE OR PARTY COMMITTEE
Field Name Example Length Description
Line Number 1 - first column must contain the line number
First_Name John 50 required
Last_Name Doe 50 required
Address_Number 3334 6 required
Sub_Number 1/2 or A 3  
Prefix_Direction E 3 must be E, S, SE, SW, N, NE, NW, W
Street_Name CEDAR 30 required
Suffix_Direction W 10 must be E, S, SE, SW, N, NE, NW, W
Street_Type AVE 4 must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
Unit_Number 300 4  
City Topeka 20 required
Zip1 66633 5 required
Zip2 1114 4  
Purpose_of_expenditure Tickets 50 required, must be Candidate (self), Cell Phone, Consultant, Donation/Contrib, Electronics/Computers, Filing Fee, Fundraising Expenses, Gift, Meeting/Travel, Mileage, Miscellaneous, Newspaper Ads, Newsletter, Polling, Postage/Shipping, Printing, Radio/TV, Reimbursement, Refund, Rental, Subscription, Supplies, Tickets, Voter file, Yard signs
Expenditure_amount 44.99 - required
Date 2/9/2008 - required
PAC_Name John's PAC 100 required if no first name, last name, or Business Name entered
Other PO Box 332 100 required if no Address No. or Street Name entered
State KS 2 required, must be two-letter state abbreviation
Description_of_Expenditure Reimbursement 50
Unit_Type STE 10 must be APT, BSMT, BLDG, CONDO, DEPT, FLOOR, FRNT, HNGR, KEY, LBBY, LOT, LOWR, OFC, PH, PIER, REAR, RM, SIDE, SLIP, SPC, STOP, STE, TRLR, UNIT, UPPR,
Business_Name Signs R Us 50 required if no first name, last name, or PAC Name entered
If independent or in-kind expenditure in excess of $300 is made for a candidate, list candidate name & address.
Candidate_First_Name Jane 50 required
Candidate_Last_Name Doe 50 required
Candidate_Address_Number 3334 6 required
Candidate_Sub Number 1/2 or A 3  
Candidate_Prefix_Direction E 3  must be E, S, SE, SW, N, NE, NW, W
Candidate_Street_Name CEDAR 30 required
Candidate_Suffix_Direction W 10 must be E, S, SE, SW, N, NE, NW, W
Candidate_Street_Type AVE 4 must be AVE, BLVD, CIR, CT, DR, HWY, LN, PK, PKY, PL, PLZ, RD, SQ, ST, TER, TFW, TRL, WAY
Candidate_Unit_Number 300 4
Candidate_City Topeka 20 required
Candidate_Other PO Box 332 100 required if no Address No. or Street Name entered
Candidate_State KS 2 required, must be two-letter state abbreviation
Candidate_Unit_Type STE 10 must be APT, BSMT, BLDG, CONDO, DEPT, FLOOR, FRNT, HNGR, KEY, LBBY, LOT, LOWR, OFC, PH, PIER, REAR, RM, SIDE, SLIP, SPC, STOP, STE, TRLR, UNIT, UPPR,
Candidate_Zip1 65544 5 required
Candidate_Zip2 1114 4  

If you need further assistance with the online application, please contact our Elections Division at (785) 296-4561. If you need assistance completing the Campaign Finance forms, please contact the Governmental Ethics Commission at (785) 296-4219.

click here to close this window