cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
mark-arlington-a
Level 1

My file import from Anna bank is entering Quickbooks with the wrong mapping. The payee is entered into No. and the payee field is picking up the first supplier on qb?

 
1 REPLY 1
Ethel_A
QuickBooks Team

My file import from Anna bank is entering Quickbooks with the wrong mapping. The payee is entered into No. and the payee field is picking up the first supplier on qb?

Welcome to the Community, @mark-arlington-a.

 

Let me share information about importing bank transaction in QuickBooks Online.

 

When importing, make sure to choose the right column for each section. Otherwise, your transactions will not be mapped properly when imported.

 

Since your transactions are not mapped properly, I recommend deleting all the incorrect transactions then reimport them. Make sure to map them correctly when importing.

 

Here's how:

 

  1. In QBO, go to the Banking menu on the left pane.
  2. From the Banking page, click the For Review tab.
  3. Find and check the boxes of the imported transactions.
  4. Click the Batch Actions drop-down menu and choose Exclude Selected.

 

Once excluded, these transactions will show in the Excluded tab, where you can delete them. 

 

Here's how:

 

  1. From the Excluded section, check the boxes of the transactions you want to delete.
  2. Click the Batch Actions drop-down menu and select Delete.
  3. Click Yes to confirm.

 

You can then proceed with importing them again with the correct format. Here are some resources you can read for the detailed steps:

 

 

For future reference, you can read this article about reconciliation: Reconcile an account in QuickBooks Online.

 

Don't hesitate to click the Reply button below if you have questions about importing bank transactions in QuickBooks Online. I'm always here to help. Have a great day.

Need to get in touch?

Contact us