Reconcile pulls in transactions after reconcile date

Hi tfinan, 

Let's work together to get to the bottom of the reconcile. 

Since this is a transaction imported from the bank, it leads me to believe that this has to do with the date it took place. While the transaction may have posted on 9/1/17, can you verify if it actually took place in August? 

I'll keep an eye out for your reply so we can get this resolved as soon as possible. 

If you entered transactions in August, then download from the bank to match your entered transactions, it just matches everything & ignores the post date. So it will reconcile items in August that cleared in September.

Just uncheck what isn't suppose to be reconciled in that month.

"Am I missing something obvious here?"

I believe so. You can uncheck items within the reconcile period that QB has tentatively marked as cleared. You can even unclear ALL and start checking items off one by one. No need to change dates. You would not change teh date of a written check taht did not yet clear.   Not rocket science

Thanks...yea, I definitely get that I can manually fix this by unchecking the transaction during reconcile, but that
is not my question.  I don't understand WHY Quickbooks choses to include such transactions in the first place.

It is just software;  If I am reconciling with a statement end date of 31-August, QB could very easily just not
include transaction that have a post/clear date of after 31-August. I can't think of any senario where it should
behave as it does.

I can imagine an even more tedius example. Let's say I do payroll and write 25 checks on August 30th (and manually put
the transactions into QB with this date. All 25 checks then don't get cashed until Sept 5th, and QB Banking feeds download
all of these transactions with a post/clear date of Sept 5th.  If I then reconcile my August statement on Sept 6th,  I am going
to have to MANUALLY exculude all 25 of these transactions (even though QB had all the information it needed to not include
them in the first place).

I am a bit of a QB newbie, so I apologize if I somehow have my workflow wrong here, but this sounds like a bug to me.

Thanks

I have the same beef with this software and no one seems to understand what you're saying. Of course you only check the transactions that appear on the statement for the period you're reconciling. That's ABC. But why does QBO show transactions after the end date of the statement? That is just plain dumb and makes it really difficult to reconcile if you're cleaning up books for a client that has been entering for years without reconciling. I've been a bookkeeper since 1988 and in all that time i've worked with many different versions of QB. This is the first one that I've seen that has such a shortcoming, and its no small thing.

This is not the impression we want you to experience when reconciling your bank account, scottscheffer.

When reviewing the transaction, only the accepted transactions that were posted in the bank for the month reconciliation. If  QuickBooks Online doesn't match your bank statement at the end of a reconciliation, we have to check the ending balance you entered. QuickBooks uses this to check for accuracy. Make sure you entered the correct amount:

1. While you're reconciling an account, in the Reconciliation window, select Edit info.
2. Review the Ending balance and Ending date.
3. Check your bank statement. Make edits as needed.
4. When you're done, select Save.

For other troubleshooting solutions, check out this article: Fix issues at the end of a reconciliation in QuickBooks Online. Feel free to visit our Banking page for more insights about managing your bank feeds and reconciling accounts.

The Community always has your back, and I'm just a post away should you ever need anything. Just leave a comment below and I'll get back to you. Have a great day ahead.

I think I understand what you are talking about .

The date range that shows in Reconciliation Window, correct? I had the same question and recently found the answer for this. Just above the Column name "Date" and "Cleared", there is a very small link called "Reset Statement ending date" and "Clear filter / View all". If you click this, you can select the view between all transactions or only up to the statement end date.

Takachan,

You are the man/woman of the year!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Eventhough it was two years ago. L.O.L.