QWin 2017: Deluxe - Downloaded transactions are out of sequence compared to statement

  • 0
  • 1
  • Problem
  • Updated 4 days ago
  • In Progress
  • (Edited)
I have Quicken Deluxe 2017 and have downloaded my transactions from my Charles Schwab checking account. When comparing the transactions against my monthly statement I found that they are not entered in the Quicken register in the same sequence. The result is that the balance column doesn't match as I go line by line.  Is this a bug? Is there anyway for me to correct the Quicken register so that the transactions are in the same order?
Photo of Debbie

Debbie

  • 110 Points 100 badge 2x thumb

Posted 5 days ago

  • 0
  • 1
Photo of Quicken Dave

Quicken Dave, Official Rep

  • 157,652 Points 100k badge 2x thumb
Hi Debbie,

I'm sorry for any confusion or inconvenience this has caused. It sounds like your register is not being sorted by the DATE column. When you get a chance, please move your mouse to the header of the DATE column, and click once, to bring that column into focus. You should see a small triangle pointing either up or down, in the lower right corner of the column header. Selecting on the triangle should cause the transactions to toggle back and forth between "most recent at the bottom" and "most recent at the top".

If that doesn't resolve the problem, please comment below so we can help you get the answers you need, as quickly as possible. To help other users who may be having a similar problem, please select the blue LIKE button at the top of this post, if this information was helpful and resolved the issue. 


I hope this helps,
Dave
Photo of Debbie

Debbie

  • 110 Points 100 badge 2x thumb
Hi Dave,

Thank you for your response. I tried it and either way the transactions appear out of order. For example: On my statement I have:

Beginning Balance
Visa Debit Kaiser
Visa Debit Trader Joe's
Deposit Mobile Banking

The Quicken register shows:

Beginning Balance
Deposit Mobile Banking
Visa Debit Trader Joe's
Visa Debit Kaiser

It appears to have something to do with the Deposit Mobile Banking transactions because as I look further down my statement and compare to the Quicken Register, the Deposits always appear first in Quicken but not on my statement.
Photo of Debbie

Debbie

  • 110 Points 100 badge 2x thumb
To further clarify this.... when looking at all the transactions for a given date, if any of the transactions are Deposit Mobile Banking transactions they are always listed before any of the other transactions for that date.
Photo of UKR

UKR, SuperUser

  • 318,410 Points 100k badge 2x thumb

Usually, in a banking register that is sorted by Date, transactions for the same day are arranged
- Deposits first.
- Withdrawals next.

That's so that the register doesn't show a negative running balance if withdrawals would appear to overdraw the account. People always complain if the register does that.

If you want to make sure that your account register's running balance matches the bank statement running balance for any given day, only look at the last transaction of the day. Any apparent discrepancies throughout the day should resolve themselves at the end of the day.

Photo of mshiggins

mshiggins, SuperUser

  • 320,640 Points 100k badge 2x thumb
Debbie, why are you using the register to compare to your bank statement? Have you tried using the reconcile feature?