OFX Import Test Accounts for Use by 1040 Tax Software (e.g. Block, Intuit, TaxAct)
Tests
Explanations
- F - Report all sales on Form 8949
- D - Exception 1
- A - Exception 2
- S - Exception 1 and Exception 2
- E - Exception 1 - using PROCSUM tag ✱
- B - Exception 2 - using PROCSUM tag ✱
- T - Exception 1 and Exception 2 - using PROCSUM tag ✱
- C - Exception 2 - including PDF statement ✱
✱ Not publicized but available if supported by 1040 software
Test B Request
USERID TAG: B6207207393722368
USERPASS TAG: 222045
Test B Response Download
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?OFX OFXHEADER="200" VERSION="202" SECURITY="NONE" OLDFILEUID="NONE" NEWFILEUID="NONE"?>
<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
<MESSAGE>Successful Login</MESSAGE>
</STATUS>
<DTSERVER>20250101010306</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>ITIPS Inc</ORG>
<FID>itips</FID>
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<TAX1099MSGSRSV1>
<TAX1099TRNRS>
<TRNUID>b7844fdb-67bc-4818-b50b-6f4ca0f323ba</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
<MESSAGE>SUCCESS</MESSAGE>
</STATUS>
<TAX1099RS>
<TAX1099B_V100>
<SRVRTID>6207207393722368</SRVRTID>
<TAXYEAR>2024</TAXYEAR>
<EXTDBINFO_V100>
<PROCSUM_V100>
<FORM8949CODE>A</FORM8949CODE>
<ADJCODE>W</ADJCODE>
<SUMCOSTBASIS>5686.94</SUMCOSTBASIS>
<SUMSALESPR>7739.60</SUMSALESPR>
<SUMADJAMT>889.63</SUMADJAMT>
<SUMDESCRIPTION>See statement attached to Form 1040 or Form 8453</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCSUM_V100>
<FORM8949CODE>C</FORM8949CODE>
<SUMCOSTBASIS>655.85</SUMCOSTBASIS>
<SUMSALESPR>0.00</SUMSALESPR>
<SUMDESCRIPTION>See statement attached to Form 1040 or Form 8453</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCSUM_V100>
<FORM8949CODE>D</FORM8949CODE>
<ADJCODE>W</ADJCODE>
<SUMCOSTBASIS>8507.62</SUMCOSTBASIS>
<SUMSALESPR>5353.34</SUMSALESPR>
<SUMADJAMT>3327.79</SUMADJAMT>
<SUMDESCRIPTION>See statement attached to Form 1040 or Form 8453</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCSUM_V100>
<FORM8949CODE>F</FORM8949CODE>
<SUMCOSTBASIS>1872.31</SUMCOSTBASIS>
<SUMSALESPR>0.00</SUMSALESPR>
<SUMDESCRIPTION>See statement attached to Form 1040 or Form 8453</SUMDESCRIPTION>
</PROCSUM_V100>
</EXTDBINFO_V100>
<PAYERADDR>
<PAYERNAME1>iTips</PAYERNAME1>
<PAYERNAME2>NA</PAYERNAME2>
<ADDR1>NA</ADDR1>
<ADDR2>NA</ADDR2>
<CITY>NA</CITY>
<STATE>NA</STATE>
<POSTALCODE>NA</POSTALCODE>
<PHONE>NA</PHONE>
</PAYERADDR>
<PAYERID>NA</PAYERID>
<RECADDR>
<RECNAME1>NA</RECNAME1>
<RECNAME2>NA</RECNAME2>
<ADDR1>NA</ADDR1>
<ADDR2>NA</ADDR2>
<CITY>NA</CITY>
<STATE>NA</STATE>
<POSTALCODE>NA</POSTALCODE>
</RECADDR>
<RECID>NA</RECID>
<RECACCT>6207207393722368</RECACCT>
</TAX1099B_V100>
</TAX1099RS>
</TAX1099TRNRS>
</TAX1099MSGSRSV1>
</OFX>