Hello, C_L-Concrete.
I'll share another way to match transactions with different dates in QuickBooks Desktop for Mac.
The auto-match feature will only function if the check number, amount, date, and payee name match those in the QuickBooks transaction. I understand how you feel right now, especially since the transactions are identical except for the clearing date.
As a workaround, set up payee renaming rules If the payee from your downloaded bank transactions has the same name as one of your vendors in QuickBooks. This makes matching easier because QuickBooks renames the transactions you download based on the conditions you specify.
Here's how:
- On the Downloaded Transactions window, select Renaming Rules.
- Click the + button to add a new rule.
- Set up your rules. Choose a condition and enter the text.
- Begins with - this applies to any payee that begins with the text you enter.
- Contains - this applies to any payee that has the text you enter.
- Ends with - this applies to any payee that ends with the text you enter.
- Exactly matches - this applies to any payee that exactly matches the text you enter.
- Select the action for the conditions you set.
- Rename to - this renames the payee to a vendor name you select. If you want to add a new vendor, just enter the name and QuickBooks will prompt you to set up the vendor.
- Don’t rename - the payee isn’t renamed. QuickBooks adds a default list of these “don’t rename” rules for checks, deposits, and withdrawals.
- Once done, hit OK.
For your reference, you can visit this article for more information: Manage renaming rules for payee names in QuickBooks Desktop for Mac.
In addition, I've included the following resource how to fix reconciliation discrepancies in QuickBooks Desktop for Mac for future use: Find reconciliation discrepancies (Mac).
If you need further assistance, let us know. We're always available to help you.
