Unable to parse Google Finance ("Investment" type) OFX

[ArakTaiRoth]

Hey there, I've just tried parsing an OFX file from a dummy account on Google Finance and I get the following really long error:

Failed to parse OFX: array ( 0 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 11, 'message' => 'Opening and ending tag mismatch: MEMO line 67 and INVTRAN ', 'file' => '', 'line' => 69, )), 1 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 13, 'message' => 'Opening and ending tag mismatch: INVTRAN line 61 and INVBUY ', 'file' => '', 'line' => 89, )), 2 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 12, 'message' => 'Opening and ending tag mismatch: INVBUY line 59 and BUYSTOCK ', 'file' => '', 'line' => 93, )), 3 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 11, 'message' => 'Opening and ending tag mismatch: MEMO line 105 and INVTRAN ', 'file' => '', 'line' => 107, )), 4 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 13, 'message' => 'Opening and ending tag mismatch: INVTRAN line 99 and INVBUY ', 'file' => '', 'line' => 127, )), 5 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 12, 'message' => 'Opening and ending tag mismatch: INVBUY line 97 and BUYSTOCK ', 'file' => '', 'line' => 131, )), 6 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 11, 'message' => 'Opening and ending tag mismatch: MEMO line 143 and INVTRAN ', 'file' => '', 'line' => 145, )), 7 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 14, 'message' => 'Opening and ending tag mismatch: INVTRAN line 137 and INVSELL ', 'file' => '', 'line' => 165, )), 8 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 13, 'message' => 'Opening and ending tag mismatch: INVSELL line 135 and SELLSTOCK ', 'file' => '', 'line' => 169, )), 9 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 15, 'message' => 'Opening and ending tag mismatch: SELLSTOCK line 133 and INVTRANLIST ', 'file' => '', 'line' => 171, )), 10 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 13, 'message' => 'Opening and ending tag mismatch: BUYSTOCK line 95 and INVSTMTRS ', 'file' => '', 'line' => 173, )), 11 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 16, 'message' => 'Opening and ending tag mismatch: BUYSTOCK line 57 and INVSTMTTRNRS ', 'file' => '', 'line' => 175, )), 12 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 22, 'message' => 'Opening and ending tag mismatch: INVTRANLIST line 51 and INVSTMTMSGSRSV1 ', 'file' => '', 'line' => 177, )), 13 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 7, 'message' => 'Opening and ending tag mismatch: INVSTMTRS line 37 and OFX ', 'file' => '', 'line' => 207, )), 14 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 77, 'column' => 7, 'message' => 'Premature end of data in tag INVSTMTTRNRS line 25 ', 'file' => '', 'line' => 207, )), 15 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 77, 'column' => 7, 'message' => 'Premature end of data in tag INVSTMTMSGSRSV1 line 23 ', 'file' => '', 'line' => 207, )), 16 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 77, 'column' => 7, 'message' => 'Premature end of data in tag OFX line 1 ', 'file' => '', 'line' => 207, )), )

This is with the following data:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE

<OFX>
<SIGNONMSGSRSV1>
<SONRS>
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<DTSERVER>20151130171040.594
<LANGUAGE>ENG
</SONRS>
</SIGNONMSGSRSV1>
<INVSTMTMSGSRSV1>
<INVSTMTTRNRS>
<TRNUID>1001
<STATUS>
<CODE>0
<SEVERITY>INFO
</STATUS>
<INVSTMTRS>
<DTASOF>20151130171040.594
<CURDEF>USD
<INVACCTFROM>
<BROKERID>google.com
<ACCTID>StockersTest
</INVACCTFROM>
<INVTRANLIST>
<DTSTART>20100401000000.000
<DTEND>20150401000000.000
<BUYSTOCK>
<INVBUY>
<INVTRAN>
<FITID>1
<DTTRADE>20100401000000.000
<MEMO>
</INVTRAN>
<SECID>
<UNIQUEID>TSE:T
<UNIQUEIDTYPE>TICKER
</SECID>
<UNITS>5
<UNITPRICE>20
<TOTAL>-100
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INVBUY>
<BUYTYPE>BUY
</BUYSTOCK>
<BUYSTOCK>
<INVBUY>
<INVTRAN>
<FITID>3
<DTTRADE>20150101000000.000
<MEMO>
</INVTRAN>
<SECID>
<UNIQUEID>TSE:T
<UNIQUEIDTYPE>TICKER
</SECID>
<UNITS>20
<UNITPRICE>35
<TOTAL>-700
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INVBUY>
<BUYTYPE>BUY
</BUYSTOCK>
<SELLSTOCK>
<INVSELL>
<INVTRAN>
<FITID>2
<DTTRADE>20150401000000.000
<MEMO>
</INVTRAN>
<SECID>
<UNIQUEID>TSE:T
<UNIQUEIDTYPE>TICKER
</SECID>
<UNITS>-20
<UNITPRICE>42.06
<TOTAL>841.2
<SUBACCTSEC>CASH
<SUBACCTFUND>CASH
</INVSELL>
<SELLTYPE>SELL
</SELLSTOCK>
</INVTRANLIST>
</INVSTMTRS>
</INVSTMTTRNRS>
</INVSTMTMSGSRSV1>
<SECLISTMSGSRSV1>
<SECLIST>
<STOCKINFO>
<SECINFO>
<SECID>
<UNIQUEID>TSE:T
<UNIQUEIDTYPE>TICKER
</SECID>
<SECNAME>TELUS Corporation
<TICKER>T
</SECINFO>
</STOCKINFO>
</SECLIST>
</SECLISTMSGSRSV1>
</OFX>

[jmarcelocjr]

Same here, however with another bank (Banco do Brasil) with the following error:

Failed to parse OFX: array ( 0 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 8, 'message' => 'Opening and ending tag mismatch: STATUS line 7 and CODE ', 'file' => '', 'line' => 10, )), 1 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 13, 'message' => 'Opening and ending tag mismatch: SONRS line 5 and SEVERITY ', 'file' => '', 'line' => 13, )), 2 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 11, 'message' => 'Opening and ending tag mismatch: SIGNONMSGSRSV1 line 3 and STATUS ', 'file' => '', 'line' => 15, )), 3 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 76, 'column' => 9, 'message' => 'Opening and ending tag mismatch: OFX line 1 and SONRS ', 'file' => '', 'line' => 31, )), 4 => LibXMLError::__set_state(array( 'level' => 3, 'code' => 5, 'column' => 1, 'message' => 'Extra content at the end of the document ', 'file' => '', 'line' => 33, )), )

File:

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1>
 <SONRS>
  <STATUS>
   <CODE>0</CODE>
   <SEVERITY>INFO</SEVERITY>
  </STATUS>
  <DTSERVER>20151209
  <LANGUAGE>POR
  <DTACCTUP>20151209
  <FI>
   <ORG>Banco do Brasil S/A
   <FID>001
  </FI>
 </SONRS>
</SIGNONMSGSRSV1>
<BANKMSGSRSV1>
 <STMTTRNRS>
  <TRNUID>0
   <STATUS>
    <CODE>0
    <SEVERITY>INFO
   </STATUS>
   <STMTRS>
    <CURDEF>BRL
    <BANKACCTFROM>
     <BANKID>001
     <ACCTID>455000-5 
     <ACCTTYPE>CHECKING
    </BANKACCTFROM>
    <BANKTRANLIST>
     <DTSTART>20151030 
     <DTEND>20151130 
     <STMTTRN>
      <TRNTYPE>DEP 
      <DTPOSTED>20151103 
      <TRNAMT>239.55 
      <FITID>20151103023955 
      <CHECKNUM>252602 
      <MEMO>DOC CRÉDITO EM CONTA      
     </STMTTRN>
    </BANKTRANLIST>
    <LEDGERBAL>
     <BALAMT>239.35
     <DTASOF>20151209
    </LEDGERBAL>
    <MKTGINFO>Banco do Brasil, esse parceiro é todo seu.
   </STMTRS>
  </STMTTRNRS>
</BANKMSGSRSV1>
</OFX>

[asgrim]

What version are you using please? If you're using 1.1.1, please could you try with 1.1.0?

[jmarcelocjr]

it was 1.1.1, tried with 1.1.0 and works fine, however now i'm having charset issues (UTF-8)

[PiX06]

I was having the same problem but found that the issue is resolved by commenting the following line:

$ofxContent = str_replace("<", "\n<", $ofxContent); //add linebreaks to allow XML to parse

I would suggest that the above line could be removed but not sure if it may be required in other circumstances. Perhaps a check needs to be added to the parser to check which version of OFX the file header states the file to be and then only add the linebreaks for versions that require it.

[asgrim]

@jmarcelocjr the "Banco do Brasil" OFX file issue you reported is a separate issue to the original Google OFX format reported by @ArakTaiRoth above. I've resolved that in #27 - but keeping this issue open as the original issue persists.

[asgrim]

Another nice example of "investment" format OFX reported in #37

[billm950]

another example from another brokerage.

OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:42e45d2f2af447c1a5d349340379ca9e

<OFX>
  <SIGNONMSGSRSV1>
    <SONRS>
      <STATUS>
        <CODE>0
        <SEVERITY>INFO
        <MESSAGE>SUCCESS
      </STATUS>
      <DTSERVER>20170206182255
      <LANGUAGE>ENG
      <FI>
        <ORG>ISC
        <FID>5104
      </FI>
    </SONRS>
  </SIGNONMSGSRSV1>
  <INVSTMTMSGSRSV1>
    <INVSTMTTRNRS>
      <TRNUID>400c0cb71ec8404e97bed5007174dbba
      <STATUS>
        <CODE>0
        <SEVERITY>INFO
        <MESSAGE>SUCCESS
      </STATUS>
      <CLTCOOKIE>4
      <INVSTMTRS>
        <DTASOF>20170206
        <CURDEF>USD
        <INVACCTFROM>
          <BROKERID>SCHWAB.COM
          <ACCTID>00000000
        </INVACCTFROM>
        <INVTRANLIST>
          <DTSTART>20170107
          <DTEND>20170205120000
          <BUYOTHER>
            <INVBUY>
              <INVTRAN>
                <FITID>000000002017020112000020170201224327580739145
                <DTTRADE>20170201120000
                <MEMO>Reinvest of POWERSHARES PREFERRED   PORTFOLIO ETF
              </INVTRAN>
              <SECID>
                <UNIQUEID>73936T565
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <UNITS>0.0048
              <UNITPRICE>14.5799
              <TOTAL>-0.07
              <SUBACCTSEC>CASH
              <SUBACCTFUND>CASH
            </INVBUY>
          </BUYOTHER>
          <BUYOTHER>
            <INVBUY>
              <INVTRAN>
                <FITID>000000002017020112000020170201224327580737144
                <DTTRADE>20170201120000
                <MEMO>Reinvest of POWERSHARES PREFERRED   PORTFOLIO ETF
              </INVTRAN>
              <SECID>
                <UNIQUEID>73936T565
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <UNITS>0.0096
              <UNITPRICE>14.5799
              <TOTAL>-0.14
              <SUBACCTSEC>CASH
              <SUBACCTFUND>CASH
            </INVBUY>
          </BUYOTHER>
          <INCOME>
            <INVTRAN>
              <FITID>0000000020170131120000201701312223080748291
              <DTTRADE>20170131120000
              <MEMO>POWERSHARES PREFERRED   PORTFOLIO ETF
            </INVTRAN>
            <SECID>
              <UNIQUEID>73936T565
              <UNIQUEIDTYPE>CUSIP
            </SECID>
            <INCOMETYPE>DIV
            <TOTAL>0.07
            <SUBACCTSEC>CASH
            <SUBACCTFUND>CASH
          </INCOME>
          <INCOME>
            <INVTRAN>
              <FITID>0000000020170131120000201701312223080748281
              <DTTRADE>20170131120000
              <MEMO>POWERSHARES PREFERRED   PORTFOLIO ETF
            </INVTRAN>
            <SECID>
              <UNIQUEID>73936T565
              <UNIQUEIDTYPE>CUSIP
            </SECID>
            <INCOMETYPE>DIV
            <TOTAL>0.14
            <SUBACCTSEC>CASH
            <SUBACCTFUND>CASH
          </INCOME>
          <BUYSTOCK>
            <INVBUY>
              <INVTRAN>
                <FITID>00000000201701181200002017011813201357502010
                <DTTRADE>20170118120000
                <DTSETTLE>20170123120000
                <MEMO>POWERSHARES PREFERRED   PORTFOLIO ETF
              </INVTRAN>
              <SECID>
                <UNIQUEID>73936T565
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <UNITS>1.0000
              <UNITPRICE>14.5200
              <FEES>0.00
              <TOTAL>-14.52
              <SUBACCTSEC>CASH
              <SUBACCTFUND>CASH
            </INVBUY>
            <BUYTYPE>BUY
          </BUYSTOCK>
          <BUYSTOCK>
            <INVBUY>
              <INVTRAN>
                <FITID>000000002017011812000020170118100815858072529
                <DTTRADE>20170118120000
                <DTSETTLE>20170123120000
                <MEMO>SCHWAB US BROAD MARKET  ETF
              </INVTRAN>
              <SECID>
                <UNIQUEID>808524102
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <UNITS>2.0000
              <UNITPRICE>54.8800
              <FEES>0.00
              <TOTAL>-109.76
              <SUBACCTSEC>CASH
              <SUBACCTFUND>CASH
            </INVBUY>
            <BUYTYPE>BUY
          </BUYSTOCK>
          <BUYSTOCK>
            <INVBUY>
              <INVTRAN>
                <FITID>00000000201701181200002017011810034716799110
                <DTTRADE>20170118120000
                <DTSETTLE>20170123120000
                <MEMO>SCHWAB EMERGING MARKETS EQUITY ETF
              </INVTRAN>
              <SECID>
                <UNIQUEID>808524706
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <UNITS>1.0000
              <UNITPRICE>22.4600
              <FEES>0.00
              <TOTAL>-22.46
              <SUBACCTSEC>CASH
              <SUBACCTFUND>CASH
            </INVBUY>
            <BUYTYPE>BUY
          </BUYSTOCK>
          <INVBANKTRAN>
            <STMTTRN>
              <TRNTYPE>CREDIT
              <DTPOSTED>20170118120000
              <DTAVAIL>20170118120000
              <TRNAMT>151.62
              <FITID>0000000020170118120000201701180552448211001516
              <CORRECTACTION>REPLACE
              <NAME>TRANSFER FUNDS FROM SCHWAB BANK
              <MEMO>TRANSFER FUNDS FROM SCHWAB BANK - 00000000000
            </STMTTRN>
            <SUBACCTFUND>CASH
          </INVBANKTRAN>
        </INVTRANLIST>
        <INVPOSLIST>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>73936T565
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>1.0000
              <UNITPRICE>14.6800
              <MKTVAL>14.68
              <DTPRICEASOF>20170205210000
              <MEMO>POWERSHARES PREFERRED   PORTFOLIO ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>73936T565
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>3.0394
              <UNITPRICE>14.6800
              <MKTVAL>44.62
              <DTPRICEASOF>20170205210000
              <MEMO>POWERSHARES PREFERRED   PORTFOLIO ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>808524706
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>11.0000
              <UNITPRICE>23.0500
              <MKTVAL>253.55
              <DTPRICEASOF>20170205210000
              <MEMO>SCHWAB EMERGING MARKETS EQUITY ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>808524805
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>8.0000
              <UNITPRICE>28.7400
              <MKTVAL>229.92
              <DTPRICEASOF>20170205210000
              <MEMO>SCHWAB INTERNATIONAL    EQUITY ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>808524102
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>8.0000
              <UNITPRICE>55.5400
              <MKTVAL>444.32
              <DTPRICEASOF>20170205210000
              <MEMO>SCHWAB US BROAD MARKET  ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>808524797
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>45.4866
              <UNITPRICE>43.3600
              <MKTVAL>1972.30
              <DTPRICEASOF>20170205210000
              <MEMO>SCHWAB US DIVIDEND      EQUITY ETF
            </INVPOS>
          </POSSTOCK>
          <POSSTOCK>
            <INVPOS>
              <SECID>
                <UNIQUEID>808524201
                <UNIQUEIDTYPE>CUSIP
              </SECID>
              <HELDINACCT>OTHER
              <POSTYPE>LONG
              <UNITS>4.0000
              <UNITPRICE>54.6800
              <MKTVAL>218.72
              <DTPRICEASOF>20170205210000
              <MEMO>SCHWAB US LARGE CAP ETF
            </INVPOS>
          </POSSTOCK>
        </INVPOSLIST>
        <INVBAL>
          <AVAILCASH>4.88
          <MARGINBALANCE>4.88
          <SHORTBALANCE>0.00
          <BUYPOWER>4.88
          <BALLIST>
            <BAL>
              <NAME>Cash Account Long
              <DESC>Value of Securities held in Cash sub Account
              <BALTYPE>DOLLAR
              <VALUE>29.26
            </BAL>
            <BAL>
              <NAME>Margin Account Long
              <DESC>Value of Securities held in Margin sub Account
              <BALTYPE>DOLLAR
              <VALUE>3154.74
            </BAL>
            <BAL>
              <NAME>Option Account Market Value
              <DESC>Value of Options positions held in the Option sub Account
              <BALTYPE>DOLLAR
              <VALUE>0.00
            </BAL>
            <BAL>
              <NAME>Schwab One Limit
              <DESC>The maximum amount you can withdraw from your SchwabOne Account
              <BALTYPE>DOLLAR
              <VALUE>4.88
            </BAL>
            <BAL>
              <NAME>Margin Account Equity
              <DESC>The value of securities and funds in the Margin sub Accounts
              <BALTYPE>DOLLAR
              <VALUE>3159.62
            </BAL>
            <BAL>
              <NAME>Equity Percent
              <DESC>Margin Account Equity divided by the market value of the Margin sub Account
              <BALTYPE>PERCENT
              <VALUE>100.00
            </BAL>
            <BAL>
              <NAME>SMA
              <DESC>Special Memorandum Account authorized by the Federal Reserve Board
              <BALTYPE>DOLLAR
              <VALUE>1596.00
            </BAL>
            <BAL>
              <NAME>MTD Div and Interest
              <DESC>The amount of dividends and interest declared for securities and not yet paid
              <BALTYPE>DOLLAR
              <VALUE>0.00
            </BAL>
            <BAL>
              <NAME>MTD Interest Owed
              <DESC>Margin interest due Schwab for the period
              <BALTYPE>DOLLAR
              <VALUE>0.00
            </BAL>
            <BAL>
              <NAME>Total Account Value
              <DESC>Account Net Worth
              <BALTYPE>DOLLAR
              <VALUE>3182.99
            </BAL>
            <BAL>
              <NAME>Day Change Dollar
              <DESC>Net Worth Change
              <BALTYPE>DOLLAR
              <VALUE>-5.89
            </BAL>
            <BAL>
              <NAME>Day Change Percent
              <DESC>Net Worth Change Percent
              <BALTYPE>PERCENT
              <VALUE>-0.18
            </BAL>
            <BAL>
              <NAME>Cash and Cash Investments
              <DESC>Total Funds Balance in the account
              <BALTYPE>DOLLAR
              <VALUE>4.88
            </BAL>
          </BALLIST>
        </INVBAL>
      </INVSTMTRS>
    </INVSTMTTRNRS>
  </INVSTMTMSGSRSV1>
  <SECLISTMSGSRSV1>
    <SECLIST>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>73936T565
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>POWERSHARES PREFERRED   PORTFOLIO ETF
          <TICKER>PGX
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>808524102
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>SCHWAB US BROAD MARKET  ETF
          <TICKER>SCHB
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>808524706
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>SCHWAB EMERGING MARKETS EQUITY ETF
          <TICKER>SCHE
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>808524805
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>SCHWAB INTERNATIONAL    EQUITY ETF
          <TICKER>SCHF
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>808524797
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>SCHWAB US DIVIDEND      EQUITY ETF
          <TICKER>SCHD
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
      <STOCKINFO>
        <SECINFO>
          <SECID>
            <UNIQUEID>808524201
            <UNIQUEIDTYPE>CUSIP
          </SECID>
          <SECNAME>SCHWAB US LARGE CAP ETF
          <TICKER>SCHX
        </SECINFO>
        <STOCKTYPE>OTHER
        <YIELD>0.0000
      </STOCKINFO>
    </SECLIST>
  </SECLISTMSGSRSV1>
</OFX>