Skip to main content
T
tfinan
September 11, 2017
Solved

Reconcile pulls in transactions after reconcile date

  • September 11, 2017
  • 3 replies
  • 0 views

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.

    Best answer by Raywhite28

    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.

    3 replies

    AliciaRoy
    AliciaRoy
    September 12, 2017

    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
    Raywhite28
    September 12, 2017

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

    "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

    T
    tfinanAuthor
    September 13, 2017

    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
    Raywhite28Answer
    September 14, 2017

    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.

    Terms & ConditionsAccessibility statement