To analyze multiple tax filers, the user must specify a csv file with the filers' data. Each row of the csv file represents a filer and each column represents a variable. The file should not have column headings and must be comma-delimited (this is the standard format of CSV files when created in Excel). Please note that the year must be the same for all entries. The input file should have 24 columns in the following order:
- RECID (ID for tax filer)
- year
- mstat (1 - single; 2 - joint (married))
- page (age of primary taxpayer)
- sage (age of spouse)
- depx (number of dependents)
- dep13 (number of children under 13)
- dep17 (number of children under 17)
- dep18 (number of qualifying children for EITC)
- pwages (wage of primary taxpayer)
- swages (wage of spouse)
- dividends (dividend income)
- intrec (interest received)
- stcg (short term capital gains)
- ltcg (long term capital gains)
- otherprop (other property income subject to NIIT)
- nonprop (other non-property income)
- pensions (taxable pensions)
- gssi (gross social security benefits)
- ui (unemployment insurance)
- proptax (real estate taxes paid)
- otheritem (other itemized deductions)
- childcare (child care expenses)
- mortgage (deductions not included in 'otheritem')
For example, a 50-year old single filer with 3 dependents under 13 who makes $50,000 per year could be represented by the following:
1,2019,1,50,0,3,3,3,3,50000,0,0,0,0,0,0,0,0,0,0,0,0,0,0