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

How do I add them missing AMEX transactions in reconciliation? First time reconciling AMEX and all transactions from second card user are missing.

 
1 Comment 1
Kevin_C
QuickBooks Team

How do I add them missing AMEX transactions in reconciliation? First time reconciling AMEX and all transactions from second card user are missing.

Thanks for visiting the Community space, @bookbridget. I'll provide some information about manually importing your AMEX transactions into QuickBooks Online (QBO).

 

Beforehand, you'll want to ensure that you have set up your bank accounts correctly so it will seamlessly download all of your transactions. You'll want to visit this article to help manage your accounts in QBO: About bank or credit card sub-account setup.

 

Regarding your concern, we can manually import your missing AMEX transactions so you can proceed with reconciling the account. Let me guide you on how:

 

  1. Sign in to your bank's website and follow the instructions to download the CSV files (maximum file size of 350KB). Every financial institution has different steps.
  2. Ensure to download only those missing transactions to avoid duplicates.
  3. Once done, go to the Banking menu on the left pane.
  4. From the Banking tab, select the blue tile for the account to which the transactions will be uploaded.
  5. Choose the Link account dropdown arrow, and then click Upload from file.
  6. Tap on Browse and select the file you downloaded, then select Continue.
    image.png
  7. In the QuickBooks account ▼ dropdown, select the account you want to upload the transactions. Then click Continue.
  8. Match the columns on the file with the correct fields in QuickBooks, then choose Continue.
    image.png
  9. Select the transactions you would like to import, then click Continue.
  10. Tap on Yes, then click Done.
    image.png

 

For more information about this process, you can visit this article: Manually upload transactions into QuickBooks Online. After that, you can now categorize and match your online bank transactions.

 

If everything's good, you can now proceed to reconcile an account in QBO. If everything matches, you know your accounts are balanced and accurate.

 

I'm always around and ready to help if you have more questions about managing your bank transactions in QBO. Just click the Reply button to add your comment so I can assist you further. Have a good one!

Need to get in touch?

Contact us