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 S Request
USERID TAG: S6207207393722368
USERPASS TAG: 222045
Test S 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>20250101015029</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>ITIPS Inc</ORG>
<FID>itips</FID>
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<TAX1099MSGSRSV1>
<TAX1099TRNRS>
<TRNUID>6b14fdc0-c646-49f5-b257-e9ee12afa64f</TRNUID>
<STATUS>
<CODE>0</CODE>
<SEVERITY>INFO</SEVERITY>
<MESSAGE>SUCCESS</MESSAGE>
</STATUS>
<TAX1099RS>
<TAX1099B_V100>
<SRVRTID>6207207393722368</SRVRTID>
<TAXYEAR>2024</TAXYEAR>
<EXTDBINFO_V100>
<PROCDET_V100>
<FORM8949CODE>A</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>Total of transactions reportable on Sch D line 1a</SALEDESCRIPTION>
<COSTBASIS>3531.28</COSTBASIS>
<SALESPR>6473.57</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>A</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>See statement attached to Form 1040 or Form 8453</SALEDESCRIPTION>
<COSTBASIS>2155.66</COSTBASIS>
<SALESPR>1266.03</SALESPR>
<WASHSALELOSSDISALLOWED>889.63</WASHSALELOSSDISALLOWED>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>C</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>See statement attached to Form 1040 or Form 8453</SALEDESCRIPTION>
<COSTBASIS>655.85</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>D</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>Total of transactions reportable on Sch D line 8a</SALEDESCRIPTION>
<COSTBASIS>833.87</COSTBASIS>
<SALESPR>1007.38</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>D</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>See statement attached to Form 1040 or Form 8453</SALEDESCRIPTION>
<COSTBASIS>7673.75</COSTBASIS>
<SALESPR>4345.96</SALESPR>
<WASHSALELOSSDISALLOWED>3327.79</WASHSALELOSSDISALLOWED>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>F</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241231</DTSALE>
<SALEDESCRIPTION>See statement attached to Form 1040 or Form 8453</SALEDESCRIPTION>
<COSTBASIS>1872.31</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_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>