Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 2

Excluding American Express Rewards Transactions

We recently redeemed some American Express rewards.  When the in/out (+/-) came into QB I just entered them as an expense & then a credit card credit.  But I when I went to reconcile today there was an extra transaction listed & even though it was unchecked my balance was zero.  I figured all good.  Well, I usually delete duplicated transactions but when I did that to this unchecked item for some reason it messed everything up.  So I'm wondering if I just removed the other 2 transactions & then excluded them if it would really do any damage.  Will they still show up somewhere else?  Will them not being on the QB reconciliation but on the cc statement really affect anything?

1 Comment
Moderator

Excluding American Express Rewards Transactions

You can exclude these transactions, LWAY1.

 

Since you've already added these transactions in QuickBooks Online, you just need to clear it on the bank register. Doing this will not affect anything in your books.

 

To exclude, here's how:

  1. Click Banking on the left pane. 
  2. Select For Review tab.
  3. Select the transactions by putting a check mark on the boxes and click the Batch actions drop-down menu.
  4. Choose Exclude Selected.

Once done, the transactions will be added to the Excluded tab were you can undo or delete them. These transactions will only show up in the Excluded tab.

 

Here's an article for reference: Exclude expenses from downloaded bank transactions.

 

To clear the transactions in the bank register:

  1. On the left panel, select Accounting Chart of Accounts.
  2. Click the View register link of the bank account where the check was added.
  3. Find and select the check to show the options. Under the Reconcile (indicated by a check mark) column, click the blank field until you see the letter C. This letter means Cleared and the letter is for Reconciled.
  4. Press the Save button after.

Check out these articles for future reference in categorizing and reconciling accounts:

Stay in touch with me if you have other questions.

Need to get in touch?

Contact us