Why is the Income and Expense Grand total incorrect?

Debra Clark

If you look at the associated image you can see a basic out of the box crappy income vs budget report with no filters...I checked all tabs and everything is set for include all... Note the $358k actual grand total... Look at the line items... they don't come close. To the right is a register report of the checking account. Most of the lines are the same ( interest isn't because of a money market account I didn't include), but the grand total nicely shows you an under $200k balance... The actual difference between the printed grand total and the detail is exactly $168,000. Moderately disconcerting. It means I have to take the report into excel every time I run it to recalculate the grand totals ( which for some obscure non accounting reason are on the top of the detail instead of below it)

It has to do with the inclusion of the transfers category, but they net to $0. They don't display in the income or expense detail. Yet when I exclude them on the category group tab, the report foots fine.

The $168 is also not twice the transfer amount which is $82k.

Puzzling. However, writing up the question at least showed me what to do to fix the report ( exclude the transfer group)

UKR

The budget report's Actual column includes Scheduled Reminders for the rest of the year as if they were real transactions already whereas the transaction based Income and Expense report does not.
Use the Current Budget report (which uses Year-to-Date as the date range) instead of the Historical Budget report.