cancel
Showing results for 
Search instead for 
Did you mean: 
inpro
Level 1

Amex undefined on main page and cant fix it the balance in wells fargo bank.

amex undefined message on main page. Cant fix that balance in registers.
7 Comments 7
SarahannC
Moderator

Amex undefined on main page and cant fix it the balance in wells fargo bank.

Hello there, inpro.

 

If you mean the transaction category is not clear, we can use your bank statement to compare the transactions from there and the ones added to the registers. There are a number of reasons why the balance in the register doesn't match or may need to fix because of the outstanding transactions, duplicate, deleted, edited, or manually created transaction.

 

If there's need to take action, let's make sure everything is matched to your bank statement and what's in QuickBooks. You can also refer this article to check issues when reconciling: Fix issues when you're reconciling accounts.

 

We have here some articles that you can check from time to time about handling and correcting balance in QBO:

 

 

Please let me know if have other questions with QuickBooks. Take care and have a good one!

inpro
Level 1

Amex undefined on main page and cant fix it the balance in wells fargo bank.

AMEX transactions uploaded to expenses by quickbooks yesterday....the 3 amex costs are in there now...but the AMEX register still shows just the 3 transactions of 500 dolllars....how specifically can those now be removed or cleared.....

inpro
Level 1

Amex undefined on main page and cant fix it the balance in wells fargo bank.

Uploaded the amex transactions yesterday and those 3 transactions to pay IBM bills about 500 dollars were now in quickbooks...but amex register still shows those 3 transactions .....need those to be cleared....

IamjuViel
QuickBooks Team

Amex undefined on main page and cant fix it the balance in wells fargo bank.

Let me help sort his out, @inpro.

 

Depending on how the transactions were recorded in QuickBooks, we can match these transactions to avoid having duplicate records or exclude the other one.

 

Just to clarify, the AmEx transaction that you have uploaded, are you referring to manually importing it into QuickBooks? Also, are the transactions that were showing in the AmEx register were downloaded directly using Online banking or manually entered as expense or credit card transactions?

 

If you have uploaded the transactions using a CSV file and at the same time downloaded it directly from your AmEx online banking, this will create two duplicate records in QuickBooks. You'd want to exclude the newly-uploaded transactions. Here's how:

  1. Go to Banking menu.
  2. Choose Banking tab.
  3. Check the box for beside the transactions you want to exclude.
  4. Click the Batch actions drop-down and choose Exclude Selected.

 

However, if the transactions that were in the register manually added as an expense or credit card transaction, you can match it to the uploaded ones. You can use the Find Match tool and turn on Suggested Matches to see options that might match. Or, you can use filters/searches to locate transactions. Here's how:

  1. From the Banking menu, select Banking.
  2. Go to the For review tab.
  3. Click the transaction and select Find match.
    • If you can't find the match, click Find other matches.
  4. Turn on the Suggested Matches button.
  5. Then, look for the match transactions and check their boxes. 
  6. Click Save.

You can check this article as an additional reference to help you in matching your transactions: Tips for Working in QuickBooks Online’s Bank Feeds: Matching Transactions.

 

Also, I've added these articles to learn more about managing your bank transactions:

Drop your comments below if you have other questions or concerns. I'm always happy to help.

inpro
Level 1

Amex undefined on main page and cant fix it the balance in wells fargo bank.

qboScreenshot 2021-01-12 144242.pngqboScreenshot 2021-01-12 144514.pngqboScreenshot 2021-01-12 144740.png

Mark_R
QuickBooks Team

Amex undefined on main page and cant fix it the balance in wells fargo bank.

I appreciate the screenshot you've shared, @inpro.

 

Based on your screenshots, I can see that you already added the three (3) transactions from your Banking page. Let's go to the Categorized tab and undo the transactions from there. This way, you can exclude them and clear them in your QuickBooks Online (QBO).

 

  1. Go to the Banking page, then click Categorized.
  2. Find the added three (3) transactions and select Undo under the Action column.1.PNG
  3. Then, go to the For review tab and put a checkmark on the transactions.
  4. Click Exclude.2.PNG
  5. To completely delete the transactions, click the Excluded tab and delete them from there.3.PNG

After excluding those transactions, it'll balance your Wells Fargo bank account. I'm adding this article for more guidance: Exclude a bank transaction you downloaded into QuickBooks Online.

 

Just in case you are ready to reconcile your bank account, you can read this article for the detailed steps and information: Reconcile an account in QuickBooks Online.

 

Should you need any additional assistance while managing your bank transactions, you can leave a comment below. I'll be sure to get back to you.

inpro
Level 1

Amex undefined on main page and cant fix it the balance in wells fargo bank.

nope....

Need to get in touch?

Contact us