EtradeStatementFormat2004

• Download the statement from www.etrade.com to $b/ETrade Statements-yyyy/6603-2893/yy.mm.pdf
• View the PDF in Acrobat.
• Do a Quicken Online Update and then Quicken to the corresponding account
• Click the Transactions tab in Quicken
• Reconcile the statement's "Dividends" for current period with transactions in Quicken. Change corresponding transactions from C to R in Quicken.
• Click the Summary tab in Quicken. Set "As of" to the statement end date, and set the "Show" listbox to "Value".
• Match the Quicken "Market Value" column (the "total" row) with the statement's "This statement's closing equity" value. If they're equal, you're happy.
• Open the "Etrade Cash" account in Quicken.
• Click the Reconcile button.
• Statement "Net Closing Money Balance" at the end of the prior month should match the "Opening Balance" in Quicken.
• Copy statement "Net Closing Money Balance" at the end of the statement period into Quicken's "Ending Balance"
• Adjust the Statement Ending Date in Quicken as required.
• Click OK in Quicken to start reconciling.
• Set the green checks to match. Once "Difference" = 0 in Quicken, click Finished.

[[LinkedFrom2]]