CP2100 - CSV Ingestion Template Guide
Below is the format of the CP2100 file received from the IRS, which can be ingested directly to the Taxbit Dashboard. The CP2100 file is a pipe-delimited text file that contains information about recipients with name and TIN mismatches.
See Publication 1281 for more details.
|
Field |
Format |
Length |
Example |
|
Record Type |
Enum |
1 |
B |
|
Recipient TIN |
String |
9 |
123456789 |
|
TIN Result Code |
Enum |
1 |
1 = Missing 2 = Not Issued 3 = Mismatch |
|
TCC |
String |
5 |
288T3 |
|
Document Type Code |
Enum |
2 |
02 = Form 1042-S 10 = Form 1099-K 21 = Form W-2 27 = Form 5498-S 28 = Form 5498-S 31 = Form 1099-Q 32 = Form W-2G 71 = Form 1099-H (through tax year 2019) 71 = Form 1099-NEC (tax year 2020 and later) 72 = Form 5498-ESA 73 = Form 1099-CAP 75 = Form 1099-S 79 = Form 1099-B 80 = Form 1099-A 81 = Form 1098 83 = Form 1098-T 84 = Form 1098-E 85 = Form 1099-C 86 = Form 1099-G 91 = Form 1099-DIV 92 = Form 1099-INT 93 = Form 1099-LTC 94 = Form 1099-SA 95 = Form 1099-MISC 96 = Form 1099-OID 97 = Form 1099-PATR 98 = Form 1099-R |
|
Account Number |
String |
20 |
28KJDF289JKDFLDD88JG |
|
Recipient Name Line 1 |
String |
40 |
John Doe |
|
Recipient Name Line 2 |
String |
40 |
Junior |
|
Recipient Address |
String |
40 |
101 Mapleton Dr. |
|
Recipient City |
String |
30 |
Seattle |
|
Recipient State |
String |
2 |
WA |
|
Recipient ZIP Code |
String |
5 |
98101 |
|
TIN Indicator |
Enum |
1 |
0 = None 1 = EIN 2 = SSN |
|
Payer Office Code |
String |
4 |
WEST |
|
Sequence Number |
Number |
8 |
1 |