Secondary Sorting within Account View??? (Q Mac)

LargeDoggie

Is there a method to sort an account view first by column x, then by column y, etc.?

For example, assume one has the checking account open.

You click the column "Clear" until all of the cleared transactions are listed/grouped together at the top portion of the register.

The default seems to be that all of the cleared transactions are secondarily sorted by date.

Could one ask that the cleared transaction group secondarily be sorted by check # rather than by date?

Thank you very much!!!

garysmith87

I tried all sorts of combinations in Quicken Mac to get this sorted per your request...to no avail.

I tried on the register level, but the filter selection doesn't even allow for cleared transactions only... only uncleared transactions.

This leaves sorting by the cleared column heading...but allows for no secondary sort process.

And reports don't even allow to filter by cleared transactions as well.

Thus...the only recourse seems to be to sort the register by cleared transactions and then export the register transactions to Numbers, Excel or Google Sheets and sort by check number there.

Or you can just export the register to your spreadsheet and filter/sort from there.

To export register transactions, click on the register in the sidebar or the group or subgroup heading, then File > Export > Register transactions to CSV file.

Good luck.

As a secondary note...what are you actually trying to accomplish by sorting cleared transactions by check number? Maybe there's an alternate way of getting what you need to see. Right now, I don't see the benefit of what you're trying to accomplish...but then again, I'm not the brightest bulb in the pack.

jacobs

I'll second the post above: there is no way to specify a secondary sorting field in Quicken Mac. Exporting transactions and opening in Excel or Numbers is probably your best option.

lhossus

LargeDoggie said:

Our routine monthly bank statements have the cleared items subdivided into check #s versus everything else. 

Because a monthly bank statement is mentioned, I have to ask: are you trying to reconcile your account?

Try this:

• Start Reconcile as one usually would, selecting "Use statement balance".

• Once in the main Reconcile display: enable display of the Check # column and set the sort to ascending by Check #. 

The secondary sort order will be by date, such that transactions with check numbers will be separate from all other transactions. This should be a pretty close match to the bank statement.

garysmith87

I tried all sorts of combinations in Quicken Mac to get this sorted per your request...to no avail.

I tried on the register level, but the filter selection doesn't even allow for cleared transactions only... only uncleared transactions.

This leaves sorting by the cleared column heading...but allows for no secondary sort process.

And reports don't even allow to filter by cleared transactions as well.

Thus...the only recourse seems to be to sort the register by cleared transactions and then export the register transactions to Numbers, Excel or Google Sheets and sort by check number there.

Or you can just export the register to your spreadsheet and filter/sort from there.

To export register transactions, click on the register in the sidebar or the group or subgroup heading, then File > Export > Register transactions to CSV file.

Good luck.

As a secondary note...what are you actually trying to accomplish by sorting cleared transactions by check number? Maybe there's an alternate way of getting what you need to see. Right now, I don't see the benefit of what you're trying to accomplish...but then again, I'm not the brightest bulb in the pack.

jacobs

I'll second the post above: there is no way to specify a secondary sorting field in Quicken Mac. Exporting transactions and opening in Excel or Numbers is probably your best option.

LargeDoggie

Many thanks to both of you for your input!!!

re: "As a secondary note...what are you actually trying to accomplish by sorting cleared transactions by check number?"

Our routine monthly bank statements have the cleared items subdivided into check #s versus everything else. In Q2007 (Quicken 2007) one had all sorts of options for sorting (attached, under "Transaction Sorting"). We seem to have lost that in modern Quicken, but it's definitely a "first world problem"! One can still find the individual check numbers with a little scrolling amongst the other transactions. And thanks for the tip to export and then use Excel's powerful capabilities: it's nice to have that in the back pocket if required, but doubt it will be necessary on a routine basis.

Thanks again!

lhossus

LargeDoggie said:

Our routine monthly bank statements have the cleared items subdivided into check #s versus everything else. 

Because a monthly bank statement is mentioned, I have to ask: are you trying to reconcile your account?

Try this:

• Start Reconcile as one usually would, selecting "Use statement balance".

• Once in the main Reconcile display: enable display of the Check # column and set the sort to ascending by Check #. 

The secondary sort order will be by date, such that transactions with check numbers will be separate from all other transactions. This should be a pretty close match to the bank statement.

LargeDoggie

Hi lhossus:

Elegant answer; spot on!

Thank you very much for sharing your expertise.

All the best.