Skip to main content
January 29, 2024
Question

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?

  • January 29, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

January 29, 2024

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.