Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
Jsmith119978
Level 1

Matching transactions default date range

I have software that posts invoices/bills to QB automatically.  I use QB match function to match payments that are received in batches (credit card processor) to the respective bills that are in QB. Unfortunately when there are too many transactions for QB to look at it can't suggest matches.  Unfortunately QB defaults to about a 1 year lookback period.  How can I change this default period to say 1 week?  This doubles or triples the amount of time it takes to match transactions.  I've contacted support and they said there is no way to change this?

1 Comment 1
ShangY
QuickBooks Team

Matching transactions default date range

The option to change the default period is currently unavailable, @Jsmith119978. But, I have a workaround to help you match the transactions. Let me share it with you.

Before anything else, please know that QuickBooks automatically matches transactions based on the date range in the bank feed to avoid duplicate entries and ensure accuracy which is why changing the date range isn't possible.

You can manually select and match transactions within a 1-week period. Use the Undo option to undo any incorrect matches, set the date to smaller range, and use the Exclude option to exclude transactions that don't need to be matched. 

Another way is you can select "Find match" in the Banking page. Here's how:

 

  1. Navigate to the Banking menu and choose Banking.
  2. Select the account you want to reconcile, then select the transactions that need to be match.
  3. Click on Find match.
  4. QuickBooks will automatically search for matching transactions based on the amount and date.
  5. Choose the transactions that matches, then Save.

 

You may refer to this guide: Match online bank transactions in QuickBooks Online.

 

Additionally, to avoid financial discrepancies in the future, I'd suggest reconciling your account regularly.

Please let me know if you need further guidance in locating and matching your transactions in QuickBooks. I'll be here to respond to you and ensure you get the help that you need. 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up