cancel
Showing results for 
Search instead for 
Did you mean: 
Volunteer Treasurer
Level 3

Create Rule to Automatically Exclude Transactions?

Hello,

 

Is it possible to create a rule to automatically exclude transactions from the banking feed? Our PayPal feed has a separate transaction for the fee we pay on each payment we receive. Right now we manually exclude them all and then add one transaction per month with the total amount of fees we pay. Is there a way to automate this with a rule (or some other function in QB) so that these fee transactions are automatically excluded?

 

Thanks for your help.

Solved
Best answer December 13, 2020

Best Answers
GlinetteC
Moderator

Create Rule to Automatically Exclude Transactions?

I've got a way on how to handle your fees, Volunteer Treasurer.

 

While the ability to create a rule to automatically exclude transactions is unavailable, what I can suggest is to assign them into a specific categorization or add a memo so you can easily identify them and Batch exclude them on the For Review tab. Please make sure that the auto-add feature is disabled.

 

To exclude them:

 

  1. Go to the Banking menu and select the Banking tab.
  2. Select the For Review tab.
  3. Put a checkmark on the boxes of the transactions to exclude.
  4. Select Exclude.

For more details, please read through this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Also, you can reconcile your account to make sure it matches your bank and credit card statements.

 

Please get back to this thread if you need additional help reconciling your accounts. I'll be around to help.

View solution in original post

1 Comment 1
GlinetteC
Moderator

Create Rule to Automatically Exclude Transactions?

I've got a way on how to handle your fees, Volunteer Treasurer.

 

While the ability to create a rule to automatically exclude transactions is unavailable, what I can suggest is to assign them into a specific categorization or add a memo so you can easily identify them and Batch exclude them on the For Review tab. Please make sure that the auto-add feature is disabled.

 

To exclude them:

 

  1. Go to the Banking menu and select the Banking tab.
  2. Select the For Review tab.
  3. Put a checkmark on the boxes of the transactions to exclude.
  4. Select Exclude.

For more details, please read through this article: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Also, you can reconcile your account to make sure it matches your bank and credit card statements.

 

Please get back to this thread if you need additional help reconciling your accounts. I'll be around to help.

View solution in original post

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

Need to get in touch?

Contact us