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 T Request
USERID TAG: T6207207393722368
USERPASS TAG: 222045
Test T 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>20250101010307</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>ITIPS Inc</ORG>
<FID>itips</FID>
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<TAX1099MSGSRSV1>
<TAX1099TRNRS>
<TRNUID>651b87ca-b3c9-40be-9b97-45f40953187d</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>
<SUMCOSTBASIS>3531.28</SUMCOSTBASIS>
<SUMSALESPR>6473.57</SUMSALESPR>
<SUMDESCRIPTION>Total of transactions reportable on Sch D line 1a</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCSUM_V100>
<FORM8949CODE>A</FORM8949CODE>
<ADJCODE>W</ADJCODE>
<SUMCOSTBASIS>2155.66</SUMCOSTBASIS>
<SUMSALESPR>1266.03</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>
<SUMCOSTBASIS>833.87</SUMCOSTBASIS>
<SUMSALESPR>1007.38</SUMSALESPR>
<SUMDESCRIPTION>Total of transactions reportable on Sch D line 8a</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCSUM_V100>
<FORM8949CODE>D</FORM8949CODE>
<ADJCODE>W</ADJCODE>
<SUMCOSTBASIS>7673.75</SUMCOSTBASIS>
<SUMSALESPR>4345.96</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>