Order of transactions on same date

jeanderson
jeanderson Quicken Mac 2017 Member ✭✭✭

For my checking account, I have selected to order transactions by date (Sorting options → by date). When a number of transactions fall on the same day, the order is different every time I view the register. This is most apparent when I have deposits and bill pays scheduled for the same day. Sometimes the deposit is first followed by the debits, and all looks OK. Other times, the deposit is later (or last), and I see a negative balance on at least one line.

Not a big problem, but it would be nice if there were a register preference to put deposits before debits when they fall on the same day. Is there a preference setting I'm missing? (Maybe this should be a suggestion for a new feature).

Tagged:
4
4 votes

Reviewed · Last Updated

Comments

  • Quicken Anja
    Quicken Anja Moderator mod

    Hello @jeanderson,

    I went ahead and changed your post to an Idea so other users who have the same or a similar request can vote on your idea by clicking the up arrow (see below).

    Ideas are also reviewed by our Development and Product teams in order to improve Quicken and implement new features requested by customers.

    Thank you!

    -Quicken Anja
    Make sure to sign up for the email digest to see a round up of your top posts.

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    At every bank where I've either been employed, or consulted, the DEBITS are posted first. This is to detect what's known as "check kiting" and "daylight overdrafts" which are potentially a source of fraud.

    And, before going into Audit, I was in Check Processing Systems for over 30 years.

    I'd vote AGAINST this idea, if that were possible.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • Rocket J Squirrel
    Rocket J Squirrel Quicken Windows Subscription SuperUser ✭✭✭✭✭

    I see no reason for QWin to show transactions in the order the bank posts them. QWin already offers sort options which result in different orderings than the bank's.

    We have one "compound" sort order, "Date/Order Entered". To satisfy this wish, adding a new sort order, "Date/Amount", would be sufficient.

    Quicken user since version 2 for DOS, as of 2025 using QWin Premier (US) on Win10 Pro & Win11 Pro on 2 PCs.

  • Jim_Harman
    Jim_Harman Quicken Windows Subscription SuperUser ✭✭✭✭✭

    One way to accomplish this is the following

    • If you are downloading transactions, accept them manually by going to Edit > Preferences > Downloaded transactions and un-checking the Automatically add to banking registers box.
    • Then when you review and accept the transactions, accept them in the order you prefer.
    • Then click on the gear at the top right of the account's register ands select Sorting options. Select the last option "By Date/order entered"
    QWin Premier subscription
  • HokieYankee
    HokieYankee Quicken Windows Subscription Member ✭✭

    I swore this was an option in Quicken many years ago (meaning, show deposit transactions first). There should really be an option here. I manually enter transactions, either by hand or via Bills & Income. Income transactions should show first to avoid negative balances being shown.

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭

    @HokieYankee You can fool yourself, but you can't fool the bank. DEBITS POST FIRST.

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • Chris_QPW
    Chris_QPW Quicken Windows Subscription Member ✭✭✭✭
    edited January 22

    As stated above, if you want the transactions to be sorted in the order that you entered them, then set the sorting order to Date/Order entered.

    EDIT: you probably also want this new preference to be off:

    Edit → Preferences → Use the data from your Financial Institution for matched transactions.

    Signature:
    This is my website: http://www.quicknperlwiz.com/
  • HokieYankee
    HokieYankee Quicken Windows Subscription Member ✭✭

    I don't download any transactions from my financial institution. I'm old skool and manually enter transactions, then reconcile when I get my bank statements. I understand Debits post FIRST in real life, but I also record transactions ahead of time, weeks out to monitor cash flow.

    The Date/Order sorting setting does not help me as I tend to enter expenses first before the income categories.

  • NotACPA
    NotACPA Quicken Windows Subscription SuperUser ✭✭✭✭✭
    edited January 23

    In my primary checking account, a MMF at Fidelity Investments, I have scheduled transactions currently showing out for 90 days.

    BUT, if the income and expenses are on the same day … Why does it matter? [Removed - Sarcasm]

    Q user since February, 1990. DOS Version 4
    Now running Quicken Windows Subscription, Business & Personal
    Retired "Certified Information Systems Auditor" & Bank Audit VP

  • HokieYankee
    HokieYankee Quicken Windows Subscription Member ✭✭

    Yeah its not a major thing. It would just be nice to avoid seeing the negatives balances if the income transactions were first in a multi-transaction day.