Every morning I download from the bank cleared checks to match against my QB check register. There are hundreds of cleared checks and most match without an issue. Lately a small number (between 5-20) daily dont match. When I go to find them in the register they are recent (within the last 30 days) and they have the lightning bolt next to them showing me QB found them but for some reason didnt clear them. So the only way I can remove them is to remove the lightning bolt and "manually" match them. QB accepts them without an issue after that.
Its quite annoying to have to manually match some checks everyday when QB has already found and matched them they it hasn't been removed from the queue. Any thoughts as to why? Its not the check number or amount not matching and its not because they are old because I know QB has some lookback period.
Good morning, @Jeff Austin.
It's great to see you back in the Community. Let's work together to get this problem handled.
Before digging further, I suggest trying some troubleshooting steps to help resolve this problem. Here are two actions:
If none of these actions work, then please come back so we can take a further look at the situation. This will assist in determining what solution is best for your business. I'll be waiting for your response!
This seems to work one day in. I will know for sure after a few days. On another note, do you know the look back time period that QB uses when trying to match transactions? For example if a check clears the bank today that was written 180 days ago it doesnt match it. So where is the point it doesnt look back to?
Hey there again, @Jeff Austin.
Thanks for reaching back out and asking more questions. I can share some insight into the back time period.
At the very least, your minimum time frame should match your last 90 days worth of transactions. However, the back time period solely depends on your bank. I recommend checking in your bank to be sure.
For more details, check out this guide: Download Bank Feed transactions in QuickBooks Desktop.
I hope this answers your question. I'm only a post away if you need me again. Have a great rest of your day!
No it has nothing to do with the bank. For example, I write a check on 1/1/2022. When it clears on 4/7/2022 its included in the bank download (bc it just cleared), however QB doesnt match it and I have to manually go back through the register and find it from 1/1/2022 even though all the data matches (check number and amount). So QB is using some lookback period (it feels like 60 days and newer). I understand why they limit the lookback because it could be massive search otherwise.
My question is how far back does QB look in the register in order to make an auto match?
I appreciate you for getting back, Jeff. I can share with you some information about matching transactions in QuickBooks Desktop (QBDT).
Usually, QuickBooks doesn't have a back time period when matching or clearing bank entries. The system tries to match downloaded transactions to any entries in your register automatically given that they have the same pieces of information (ex. check numbers, amounts, dates and payees). If not, then I suggest reviewing your entries as different amounts, dates, or other details may affect this issue.
For more tips, while categorizing your bank feed entries, check out this article: Add and match Bank Feed transactions in QuickBooks Desktop.
On the other hand, QBDT allows your bank to download the latest available transactions up to 90 days old only. For older ones, you need to upload them manually through the Web Connect process.
Additionally, you may utilize the bank rule feature in your bank feed transactions. If you import similar transactions every month, such as direct debits, set up rules to automatically set the type of transaction, account, and others. I'm adding this link as your guide: Use renaming rules for Bank Feeds.
If you have any other questions while matching your bank transactions, let me know by adding a comment below. I'll get back to you as soon as I can help you again. Have a good one!