Reporting Account Fees (Detail Transcations with TOTAL)

[Good_Vibe]

As part of tax preparation, I'd like to print a detail report of every account fee paid for any sub-portfolio during the previous calendar year.

All fees were imported via the generic import facility with transaction type of REINV_F. The fee values were specified as negative values at share price of $1. The default cash account(s) were properly decremented throughout the year.

The annual (calendar year) total is simple enough to report with such reports as the distribution summary (a single value; no detail) or using a customized report and specifying "Account Fee Distributions (between)" (again, no detail).

The individual (detail) fee transactions are available via the Investment Transaction Report specifying "Reinvested Distributions" and "Account Fee". Their transaction type is "RnvAcctFee".

The problem is that I want to print a report showing the detail transactions WITH TOTALS.

Simply haven't found a way to do this. Hope you can help.

Thanks,
Phil

[Mark]

Hi Phil,

You may have to use the combination of these 2 reports, or export your Transaction report to Excel, and sum it there. The Investment Transaction report does not show totals. The Custom and Distribution Summary reports will show details down to the investment level, but not the transaction level.