Bank Feeds Transaction List Resets When a Transaction Changes

JABUIL · ‎May 08, 2024

Hello

I'm using QB Desktop Premier Contractor Edition 2020 and I'm running into a lot of annoyance when I try to use the Bank Feeds feature.

For example, in the image below, I have the list sorted by Date (Descending) and no transactions are checked. If I go create a new QB transaction to match that $1,539.46 bank feed transaction, then QB will reset this list: it will go back to the default sort (Date Ascending), and a bunch of transactions will be checked off again according to the rules I have.

How do I make it stop doing this? It's so frustrating. The window should preserve the sort I selected and it should never re-check the boxes I unchecked until I import more transactions or close the window. To be clear, this is not a new problem. It's been happening for as long as I've used QBDT 2020 and it's persisted through the various times I've already verified the files and run the QB File Doctor toolhub thing for the other unrelated problems I've had with QB over the years, so they aren't going to fix it now either.

Tori B · ‎May 08, 2024

Thanks for reaching out to the QuickBooks Community, @JABUIL.

How's your week been so far? I hope it's been great.

It sounds like it's the auto-match feature kicking in. QuickBooks Desktop will auto-match transactions when:

The check numbers match.
The amounts are the same.
Dates are within a few days of the downloaded transaction, clearing the bank.
Payees are the same, or the downloaded transaction is identified by a renaming rule.

There is an option to stop matching the transaction by changing it to the Not a match option in the ACTION column. You can use the steps I'm including below to mark the transactions as Not a match.

Set the STATUS to All and TYPE to DEP.
Check in the boxes under STATUS.
Choose Not a match in the drop-down list under the ACTION column.

That should do the trick. Please let me know if you continue to have issues. Don't hesitate to share any questions or concerns you may have. Take care!

JABUIL · ‎May 09, 2024

How does that solve my problem? Once the transaction has been auto-matched, then it's too late, the transaction list has already been rearranged and reset. The point is that I'm trying to stop it from rearranging and resetting the list in the first place.

AnneMariee · ‎May 09, 2024

Let me provide some information about using QuickBooks Desktop (QBDT) bank feeds, JABUIL.

I recognize the need to have the list sorted to your preferred settings. However, this option is unavailable. This means that once QuickBooks identifies a match, the list will refresh into its default sorting system. As a workaround, you can manually sort the arrangement when it refreshes. You can also follow my colleague's suggestion above to use the Not a match option.

I'll leave this article for more information on matching transactions in QBDT: Add and match Bank Feed transactions in QuickBooks Desktop.

You can also refer to this article to ensure your QuickBooks accounts correspond to your real-life ones: Reconcile workflow.

You can always come back to this post if you have any other banking concerns in QuickBooks, JABUIL. Our team is always available to support you.

Topics

Training

Community

Resources

Bank Feeds Transaction List Resets When a Transaction Changes