How to create a report that shows account balances on specified dates? (Q Mac)

truckload-of-art

Hello all, I'm a long-time Quicken/Windows user who recently migrated to Mac.

I've been trying to figure out how to create a report that simply shows account balances for specified accounts for specified dates (with future automatic transactions accounted for). That's it — literally copying the balances on specified dates from the account registers into a report.

I was able to do this (albeit clunkily) in the Windows version, but for the life of me, I can't figure out how to do this in the Mac version. Any help appreciated. Thanks.

jacobs

The report you want is Net Worth.

Go to Reports > Net Worth and select the one called simply "Net Worth". Click Edit, and for the date range, all you need to enter is the ending date, for the date you want the report as of. Click OK and you'll have your account balances for every account as of that date.

If you have older cloased accounts, you may want to go back to Edit, click Selected accounts, and de-select the ones you want to omit because you know they're old, closed and zero. That will give you a cleaner report. You can save this as a custom report, so you don't need to edit the accounts each time you run it.

Whoops, I just re-read your post and saw "with future automatic transactions accounted for". I'm not sure what you mean there. If you run the Net Worth report as of March 31, is will show the account balances as of March 31, period. Future transactions, whether downloaded, entered manaully or scheduled, will not be included in the account totals on that date.

jacobs

The report you want is Net Worth.

Go to Reports > Net Worth and select the one called simply "Net Worth". Click Edit, and for the date range, all you need to enter is the ending date, for the date you want the report as of. Click OK and you'll have your account balances for every account as of that date.

If you have older cloased accounts, you may want to go back to Edit, click Selected accounts, and de-select the ones you want to omit because you know they're old, closed and zero. That will give you a cleaner report. You can save this as a custom report, so you don't need to edit the accounts each time you run it.

Whoops, I just re-read your post and saw "with future automatic transactions accounted for". I'm not sure what you mean there. If you run the Net Worth report as of March 31, is will show the account balances as of March 31, period. Future transactions, whether downloaded, entered manaully or scheduled, will not be included in the account totals on that date.

truckload-of-art

> future transactions shown in dark text are included; future transactions in gray text are not.

This is what was tripping me up. I didn't realize that there was a distinction between the two. There is no such distinction in the Windows version. It seems rather unnecessary to have to review future transactions that I've already purposely scheduled.