Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore QuickBooks Payroll
debcotravel
Level 1

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

I cannot get both sides of two journal entries to match downloaded bank transactions while trying to reconcile my January 2025 bank statement.  I've attached screenshots, but the matching feature does not see the other side of these 2 transactions.  I've tried everything I know to try to match the transactions, but the system just does not see both sides.  Any ideas?  I don't want to mess up my 12-31-24 balance sheet.

 

Thank you,

 

Tony

8 Comments 8
Candice C
QuickBooks Team

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

Hey there, @debcotravel

 

It's great to see a new face here in the Community. 

 

When looking at your screenshot, it seems the majority of the information is mirrored. That is what you want when matching transactions. With that being said, I recommend contacting our Customer Support Team so they can review your account with you by using a screen share tool. 

 

Here's how: 

 

  1. Go to the Help icon in the top right-hand corner. 
  2. Press the Contact Us button. 
  3. Enter your question and hit Let's tak
  4. Scroll down and choose to Get a callback

 

Please come back and let us know how the call goes. We're only a post away if you need us again. Bye for now! 

Rainflurry
Level 15

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

@debcotravel 

 

What type of account is "Possible Overpayments"?  QB will only match the amount spent to debits posted to the same bank account you're attempting to reconcile and the amount received to credits.  So, if "Possible Overpayments" isn't your bank account, that's why you can't match them.   

Rainflurry
Level 15

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

@debcotravel 

 

Oops, correction: Amounts received are debits, and amounts spent are credits, not the other way around.  

Rainflurry
Level 15

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

@debcotravel 

 

Not sure I was clear in my response.  The transactions shown on your bank transaction screen are a debit (amount received) for $3,983.35 and a credit (amount spent) for $4,943.12.  However, your journal entries that hit your bank account (I assume that's what "Operating - Amegy" is) are the opposite - an amount received of $4,943.12 and an amount spent of $3,983.35.  That leads me to believe the journal entries are incorrect/reversed.  If you're trying to match them, you need to reverse the debits and credits on each journal entry. 

debcotravel
Level 1

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

It's the same bank account.  It's really strange.  The system matched the debit on one journal entry, and the credit on the other.  And, the difference is exactly the difference between the 2 unmatched entries.  I just spent 30 minutes on the phone with QB and they cannot understand why, other than because they are journal entries I should contact an accountant.  I have a high degree of confidence in the accounting - I think it's more of a system's issue.  The short story is we were paid twice for the same invoice on 2 occasions, I booked the 2nd payments as a liability, and I'm pretty sure the debits and credits are correct because they were both matched by the system.  I may try your suggestion because, why not, but I think they are correct.

 

Thank you for taking time to respond.

Rainflurry
Level 15

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

@debcotravel 

 

I have been an accountant for almost 20 years and am currently working on my CPA license.  It’s not a system issue.  The journal entries are reversed.  Try to reverse the most recent journal entry and see if QB locates the match.  

debcotravel
Level 1

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

First, I really appreciate your time.  I tried reversing the JEs and it didn't work.  Journal Entry 945 represents the funds we repaid to the property and the reversal of the liability account entry.  The screen shot attached shows the receipt of the first payment as cleared against A/R.  The bank statement shows both deposits.

 

Again, thank you so much.

Rainflurry
Level 15

Why I cannot get both sides of a journal entry to match with a downloaded transaction.

@debcotravel 

 

"Journal Entry 945 represents the funds we repaid to the property and the reversal of the liability account entry. The screen shot attached shows the receipt of the first payment as cleared against A/R. The bank statement shows both deposits."

 

I'm confused (not unusual).  If journal entry (JE) 945 represents the repayment made to the property (it does in your original screenshot and still does on the most recent screenshot of the bank rec), why are you trying to match that to one of the deposits?  You mentioned that the bank statement shows "both deposits".  Where is the entry that represents the second (duplicate) payment received?  Isn't that what you're trying to match to the bank feed transaction?    

 

Your original issue was stated as "I cannot get both sides of two journal entries to match downloaded bank transactions while trying to reconcile my January 2025 bank statement."  That's a confusing statement because you're not trying to match both sides of two JEs, you're trying to match just the two lines on the JEs that hit your bank account.  The two JEs in your original screenshots represent one payment and one deposit.   

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us