Investment Income not appearing in Profit & Loss Comparison Report
My business primarily generates real estate rental income. Last year I added a brokerage account in order to park excess cash in a money market mutual fund paying interest higher than I can get at the bank. This has generated dividend income (_DivInc).
THE PROBLEM: I cannot get the dividend income to appear in the Profit & Loss Comparison report I have long used, comparing last year to the prior year period. In customization I made sure all accounts and categories were selected, specifically the brokerage account and _DivInc.
I CAN get the dividend income to appear in the Income/Expense Comparison by Category report, but the business is on accrual basis and that report is cash basis only, so the rental income doesn't appear properly.
Finally, I can get the dividend income AND rental income to appear on the Income/Expense by Category report, but then I lose the comparison to the prior year. It seems I can't have it all - investment income, rental income, and comparison to the prior year - on one report.
Any ideas? Many thanks.