cancel
Showing results for 
Search instead for 
Did you mean: 
tfinan
Level 1

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 September 13, 2017

Best Answers
Raywhite28
Level 7

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.

View solution in original post

8 Comments 8
AliciaRoy
Level 8

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. 

Raywhite28
Level 7

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.

john-pero
Community Champion

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

tfinan
Level 1

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

Raywhite28
Level 7

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.

scottscheffer
Level 1

Reconcile pulls in transactions after reconcile date

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.

RCV
QuickBooks Team
QuickBooks Team

Reconcile pulls in transactions after reconcile date

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.

Takachan
Level 1

Reconcile pulls in transactions after reconcile date

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.

Need to get in touch?

Contact us