How do I Reconcile Quicken with my bank statement, when the paper statement and quicken dates (and t

Question

How do I Reconcile
Quicken with my bank statement, when the paper statement and quicken
dates (and transactions don’t match?

Bank Statement
Activity From: 1/11/19 to 2/7/19

Ending Statement
Date: 2/7/19

Ending Balance (from
paper statement) 1,183.61.

Prior   Balance
6,678.47 (when I started to do the Quicken Reconcile I put 0.00 in
this box; later it 					populated to this figure.

Next Step

Your Account May Be
Out of Date.

Next Step

Reconcile without
downloading (I did this because I know that the account is up to
date.

Next Step

Reviewed the paper
bank statement with Quicken statement. The bank statement has at
least 6 transactions totaling 1,1700.00 which these transactions
don’t show up in Quicken.

I also noted that
the Quicken Reconcile window shows dates ranging from 1-11-19 to
2-7-19.

Sherlock · Accepted Answer

If there are valid transactions in the 2-7-19 bank statement that are not present in the Quicken register, I suggest you enter the transactions in the Quicken register.

q_lurker · Accepted Answer

[All my comments here are based on matching the Quicken reconcile process with your "paper" once-a-month statement, even if you are looking at that "paper" statement online.]* "Prior Balance 6,678.47 (when I started to do the Quicken Reconcile I put 0.00 in this box; later it populated to this figure."

The prior reconciled balance in Quicken is the total of all reconciled transactions for all dates for the account.  You should not need to change the value.  The value should agree with your bank statement for the "Starting Balance" or similar at the beginning of the period.  If the value does not agree, you should be trying to determine the discrepancy.  If you enter a different value that Quicken calculates, Quicken will create a transaction to make up the difference (not a generally good choice).  * "Reviewed the paper bank statement with Quicken statement. The bank statement has at least 6 transactions totaling 1,1700.00 which these transactions don’t show up in Quicken."

Note Sherlock's comment was to look at the register (not the reconcile window listing).  If the transactions are not in the reconcile window listing, they may be in the register with a date after 2/7/19 or with a Clr status of "R" = reconciled.  If they are on your bank statement, they should not already be reconciled. Correct or keep as shown.  Already being reconciled would affect the starting balance then would not affect the final balance.

Also note that the reconcile window listing should possibly go back to the beginning of the account listing all uncleared transactions through 2/7/19.  The 1/11/19 start date is immaterial.  You may have written and recorded a check in December that would be listed in the window as possibly clearing in January (or February or March...)