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 E Request
USERID TAG: E6207207393722368
USERPASS TAG: 222045
Test E 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>20250101010305</DTSERVER>
<LANGUAGE>ENG</LANGUAGE>
<FI>
<ORG>ITIPS Inc</ORG>
<FID>itips</FID>
</FI>
</SONRS>
</SIGNONMSGSRSV1>
<TAX1099MSGSRSV1>
<TAX1099TRNRS>
<TRNUID>3d332114-1d84-4828-9104-598fcee4e18e</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>D</FORM8949CODE>
<SUMCOSTBASIS>833.87</SUMCOSTBASIS>
<SUMSALESPR>1007.38</SUMSALESPR>
<SUMDESCRIPTION>Total of transactions reportable on Sch D line 8a</SUMDESCRIPTION>
</PROCSUM_V100>
<PROCDET_V100>
<FORM8949CODE>A</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20240111</DTSALE>
<SALEDESCRIPTION>30.000 COINBASE GLOBAL, INC. CLASS A COMMON STOCK</SALEDESCRIPTION>
<COSTBASIS>2155.66</COSTBASIS>
<SALESPR>1266.03</SALESPR>
<WASHSALELOSSDISALLOWED>889.63</WASHSALELOSSDISALLOWED>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>C</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241018</DTSALE>
<SALEDESCRIPTION>200.000 BED BATH & BEYOND INC COMMON S TOCK</SALEDESCRIPTION>
<COSTBASIS>627.02</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>C</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241016</DTSALE>
<SALEDESCRIPTION>19.000 PARTY CITY HOLDCO INC COMMON S TOCK</SALEDESCRIPTION>
<COSTBASIS>28.83</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>D</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20240117</DTSALE>
<SALEDESCRIPTION>33.214 TESLA, INC. COMMON STOCK</SALEDESCRIPTION>
<COSTBASIS>7673.75</COSTBASIS>
<SALESPR>4345.96</SALESPR>
<WASHSALELOSSDISALLOWED>3327.79</WASHSALELOSSDISALLOWED>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>F</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241018</DTSALE>
<SALEDESCRIPTION>100.008 BED BATH & BEYOND INC COMMON S TOCK</SALEDESCRIPTION>
<COSTBASIS>1198.91</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>F</FORM8949CODE>
<DTAQD>20210806</DTAQD>
<DTSALE>20240726</DTSALE>
<SALEDESCRIPTION>100.000 CLOVIS ONCOLOGY, INC. COMMON S TOCK</SALEDESCRIPTION>
<COSTBASIS>498.02</COSTBASIS>
<SALESPR>0.00</SALESPR>
</PROCDET_V100>
<PROCDET_V100>
<FORM8949CODE>F</FORM8949CODE>
<DTVAR>Y</DTVAR>
<DTSALE>20241016</DTSALE>
<SALEDESCRIPTION>81.000 PARTY CITY HOLDCO INC COMMON S TOCK</SALEDESCRIPTION>
<COSTBASIS>175.38</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>