cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Reconcile pulls in transactions after reconcile date

I am using QB online, and use bank feeds to import all of my transactions. For the second month
in a row I had the same issue; If a certain bank transactions posts on the first day of a statement
period (say, 9/1), when I go and reconcile the previous month (statement end date of 8/31), Quickbook
pulls in the trasaction that posted on 9/1!  In order to get QB to reconcile that month, I need to change
the post date of those transactions to 9/2 (instead of 9/1).


Am I missing something obvious here?  If my reconcile end date is 8/31, QB should not be using 
transactions from the following date, right?

 

Any help would be appreciated.

Solved
Best answer 09-13-2017

Accepted Solutions
ProAdvisor

Re: Reconcile pulls in transactions after reconcile date

Try this.

 

When reviewing the transaction, only accept the transactions that were posted in the bank for the month reconciling. After you complete th reconciliation, go back & review & accept the transactions for the next month.

 

this will stop you from having to manually uncheck items.

5 Comments
Established Community Backer ***

Re: 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. 

ProAdvisor

Re: Reconcile pulls in transactions after reconcile date

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.

Established Community Backer ***

Re: Reconcile pulls in transactions after reconcile date

"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

Not applicable

Re: Reconcile pulls in transactions after reconcile date

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

ProAdvisor

Re: Reconcile pulls in transactions after reconcile date

Try this.

 

When reviewing the transaction, only accept the transactions that were posted in the bank for the month reconciling. After you complete th reconciliation, go back & review & accept the transactions for the next month.

 

this will stop you from having to manually uncheck items.

Need to get in touch?

Contact us