How to handle 529 fund expenses?

So:

I happen to have a couple of 529 plans for the two kids in college. They work pretty much as expected: grow tax-free, and withdrawals aren't taxed so long they're matched up with the appropriate kind of college expenses.

However, there's this one bit that I've never managed to get straight in Quicken and would appreciate a bit of advice.

These particular plans have a management fee that comes due once a month. To satisfy the fee, each plan sells off a certain number of the

529 plan holdings, then removes the money from the fund. And that's pretty much how I handle the register: Sell off shares of each of the funds, then do a "Miscellaneous Expense" transaction in the mutual fund register, with the Category set to Investment Expense.

Now comes the interesting bit. So, say I want to see how the overall account is doing. In Quicken 2011, I pull up Reports->Investing->Investment Performance and then customize the results so only one or the other of the two accounts are shown.

In the resulting report, one has the various dates of the transactions, the initial securities balance and any deposits into the 529 plan in a column labelled Investments, and any withdrawals and the final securities balance in a column labelled Returns. Quicken then plays math and comes up with an Average Annual Return, which I take to be the IRR of the funds.

So far, so good. However, there's what appears to be a problem: In the same column as the Returns, all the various management fees that are withdrawn in the course of time show up as Returns.

So, in a given year, in the Returns column, I'll see a dozen $20.00 or so charges for the management fee, whatever college expense withdrawals done that year, the final securities value, and the overall sum of the above, that being the summary Return value.

However, that roughly $240 gone to management fees - that sure doesn't look like a return. I don't get it - the management company does. So, really, those management expense shouldn't show up in the Returns column at all!

I've tried editing the various transactions parameters to get rid of those Returns in the report without much luck. Anybody out there got a solution, beyond exporting the report into Excel and doing the IRR by hand?

Ken B.

Reply to
Ken
Loading thread data ...

I think you have the right picture of what Quicken does. There are no alternate processes I am aware of. Quicken does not differentiate if you took the money out to buy book, buy bubble gum, or pay management fees. They consider that you took money out and that makes it part of your return.

Your options as I see it are to deduct $240/(Account value) = x% from the return Quicken calculates or export to Excel, exclude the mgt fee transactions, and let Excel calculate it XIRR function. I have done both.

Reply to
Tod

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.