Skip to main content
D
DEBookkeeping
June 14, 2020
Question

Matching bank feed item to a transaction that is posted in QBO but search doesn't find

  • June 14, 2020
  • 1 reply
  • 0 views

I'm doing a cleanup job for a new client for fiscal year July 2018 to June 2019.
The bank feed shows a payroll check cashed on July 10 2018.
The July 2018 bank statement also shows the picture of the cashed check and it's dated 29 March 2018 (previous fiscal year), So the employee cashed the check almost 4 months later.
When I go to the "Payroll Details Report" under the employee name I find the entry on 29 March 2018.

So far so good, the bank shows the check cashed and QBO shows the transaction was entered.
The problem is when I press "Find other records" to find the match, I set the date for the search way back to March 1 2018, but the results shown only go back to end April 2018.
Doesn't matter how far back I set the beginning search date say 1 Jan 2015, it will only show transactions from April 2018 forward..
So it won’t go far back enough for me to find the entry and be able to do the match.

1 reply

J
JamesM
June 15, 2020

Hi there, 

 

Making sure your clients books are clean is a good way to keep them happy. I'd be glad to share more info on this so you can focus on what's important to you and your business.

 

The  reason why you're not seeing the transactions before April 2018 may be because the transactions weren't uploaded to the account. It's important to make sure the transactions were added. If not, there's a way you can manually upload the missing transactions. I recommend checking out this article for info on how to do that: Manually upload transactions into QuickBooks Online.

 

If the transactions were added, I suggest trying to find a match using a private or incognito window. If you're still now seeing them I suggest contacting our support team for further assistance. Here are our contact details:

 

Phone and Chat: Click Contact Us to learn how to reach phone and chat support.

Schedule a Callback: click (?)Help in the upper right > click Contact Us > explain your situation > click Let's Talk > choose Get a callback (Note: Callback hours are the same as regular phone hours.)

Social Media: Facebook, Twitter, and Instagram from Monday to Friday between 9 a.m. and 8 p.m. ET

 

Feel free to leave a comment below. I'm here to help. 

D
DEBookkeepingAuthor
June 15, 2020

The transaction is both in my bank feed and posted in QBO.

The problem is that the amount in the bank feed includes the amounts of two postings.

When I press “Find Match” in the bank feed I can find one posting on the “Home currency” side and the other posting on the “Foreign currency” side.

Together the addition of both amounts match the bank feed total.

But I don’t know how to put them together in the “Match transactions” window

J
JamesM
June 15, 2020

Thanks for getting back to me. Just to make sure we're on the same page, are you trying to match transactions with two different currencies? 

Terms & ConditionsAccessibility statement