Recon the credit card for 2020. imported from amex. spent and received columns reversed the values. is the edit by line? or can i edit entire column at one time? thx

Hi there, achisholm.

When importing bank (Amex) transactions to QuickBooks Online (QBO), you'll have to map the columns so that they're compatible with the system. It's possible the mapping is incorrect reason why columns were reversed. Let's also make sure the CSV format is correct. You can use either the 3-column or 4-column.

Check out this article so you can import the bank transactions without any issues: How to import bank transactions using Excel CSV files.

Feel free to visit these links about reconciliation in QBO:

• Reconcile an account in QuickBooks Online
• Learn the reconcile workflow in QuickBooks

Here's a guide for instructions on how to handle in case you encounter issues when reconciling: Fix beginning balance issues if you've reconciled the account in the past QuickBooks Online.

Also, if you want to run the Reconciliation Report, here's how to locate it in QBO:

Here's how:
 

1. Go to Reports.
2. Type in Reconciliation Reports in the search bar.
3. From the Reconciliation summary tab, choose your bank.
4. You'll be routed to the Reconciliation Report showing transactions information.
   

Learn more about managing reconciliation reports in QuickBooks Online by visiting this link: How do I view, print, or export a reconciliation report?

As always, you can find me here if you need more help with the reconciliation process. It's my pleasure to assist you. Have a good one.

Hi, achisholm.

Hope you’re doing great. I wanted to see how everything is going with your question about the columns being reversed when imported from Amex bank. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at any time.

Looking forward to your reply. Have a pleasant day ahead!