Filtered account view - balance is inaccurate
I'm using Quicken for Mac 2019 on Mac OS X Mojave 10.14.2 and many times I have been thrown off by this, but when I use filters to view an account register, such as 'Uncleared,' the balance that appears with each transaction is way off. It appears that Quicken recalculates the balance based on only the filtered transactions but isn't that flawed? Should it not simply filter the transactions, keeping the balance for each transaction consistent with the unfiltered view? The only way to see accurate balances is to use an unfiltered view. Either the balance in a filtered view should be accurate or it should be hidden. Or am I missing something?
0
This discussion has been closed.

Comments
Quicken does not store the balance that a printed bank statement would show for this transaction on that date. It calculates a running balance as the sum of the shown transactions in the sort order in effect.
Because a filtered view's balance is not meaningful, in Q Mac 2019 it will be shown as greyed out. In some other versions of Quicken it may not be shown at all.
So on second look, I actually found that when a register view is filtered and it is sorted by date in Q for Mac, it appears no differently from when the register is unfiltered - balances are not grayed out. Negative balances are red and positive balances are black and they are not accurate. Only the entire row for future transactions are grayed out.
However, when I switch to any other sorting method other than date, whether filtered or unfiltered, the running balance is indeed grayed out and italicized. That looks fine - although it might make more sense simply to make them blank, especially for filtered views. So maybe the problem is that with filtered views that are sorted by date, the running balance should be grayed out and is not?
For the record, I was against this change to make the balance column visible when except when unfiltered and date sorted. But the dev team felt that some people use that as a method to total up transactions. The compromise was to turn the column gray/italic. Apparently that didn't make it to the filtered view as it should have.
- List of Requests for Report Related Features,
- with the essential ones described and listed here
- List of Requests for Report Types
Click on each underlined link, then follow the instructions to add your vote to more related ideas. Your VOTES matter!For background, you may want to read this post too. BTW, the columnar-type report is the basis for MANY other reports, as described in detail in this post a little lower; only the selection and formatting criteria are different.
(If you find this reply helpful, please be sure to click "Like", so others will know, thanks.)
- Where to find a Help Guide for Quicken for Mac?
- Quicken Mac FAQ list
- Quicken Windows FAQ list
- Help Guide and FAQs for Quicken Mobile
COMPLETE list of Product Ideas - Quicken for Mac to VOTE onObject to Quicken's business model, using up 25% of your screen? Add your vote here:
Quicken should eliminate the LARGE Ad space when a subscription expires
(Canadian Q user since '92, STILL using QM2007)
The other thing to note in regards to reports is that Quicken Mac doesn't show many reports by default. You need to click on New Report to create a report from scratch. Quicken Mac supports, transaction, summary and comparison reports and you can group them by category, payee, tag, etc and then customize them with specific date ranges, or accounts, categories, etc. There's quite a lot of power under-the-hood but people used to the old versions of Quicken think they have to start with a default report. We plan to expose more reports by default but just haven't had the time to do it yet. We're still building the engine out to support more types of reports before we loop back to extend the default reports.