If you have a mutual-fund account, you probably receive monthly statements in the mail or by email. Keeping track of all your mutual-fund paperwork can help you analyze fund performance and keep accurate records for when you file your taxes. Once you set up a spreadsheet that details your fund activity, you can keep an eye on which ones are outperforming others. Spreadsheets can also be programmed to download mutual-fund data.
1. Collect your mutual-fund paperwork. This may include purchase and sale receipts, performance statements and 1099 statements.
2. Organize each pile of papers into separate mutual funds.
3. Open your spreadsheet program and start a new file.
4. Type headings for "Purchase," "Current" and "Profit/Loss" on the first line of the spreadsheet.
5. Type "Number of Units," "Date of Purchase," "NAV," and "Value" under "Purchase."
6. Type "NAV" and "Value" under "Current."
7. Type "Value" and "%" under "Profit/Loss."
8. Enter in the information for each mutual fund under the corresponding titles. The information should be on your 1099 statements, except for the "current NAV," which is the Net Asset Value.
9. Find a website that lists updated financial information for your particular mutual fund.
10. Go back to your spreadsheet and click "Data" > "From Web."
11. Copy and paste the URL from the website into the address bar and click "Go."
12. Roll your mouse over the table on the website that lists the NAV for your mutual fund. Click the small box next to it to select it.
13. Click "Import" and type in the cell letter and number for the "current NAV" box on your spreadsheet. The spreadsheet will automatically download and update the most current NAV information for your funds.
14. Go through each mutual fund and import the NAV data from the website. Save your spreadsheet.
Items you will need
- Spreadsheet software
- Mutual-fund statements and receipts
- Stockbyte/Stockbyte/Getty Images