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

Bank Feed imported incorrectly

I have just started setting up and connected by bank account. It is showing my business payments/expenses as incoming payments and my business/client invoice payments received as a negative or outgoing. Any idea how I change that to swap it over?

7 Comments 7
KhimG
QuickBooks Team

Bank Feed imported incorrectly

Thanks for dropping by the Community space, @NinaVA.


When connecting for the first time, QuickBooks pulls as much of your transactions as possible. The amount of data and how they’re classified depends entirely on the bank. 


For me to check if there’s currently a reported issue regarding the entries showing in reverse, can you tell me the name of the financial institution? 

 

Meanwhile, let’s exclude the downloaded transactions. Here’s how:

  1. Go to the Transactions menu.
  2. Mark all the incorrect transactions, then click Exclude.

exclude.PNG

For more details, take a look at this article: Exclude or delete transactions.


Once done, you can manually upload your bank entries to QBO using a CSV format. Export them from the bank and save it on your computer. 

 

Follow these steps to import the file:

  1. From the Gear icon, select Imports.
  2. Click Import older transactions under the Action column.
  3. Follow the on-screen instructions to complete the import process.
  4. Hit Import.

I’m adding this article for reference: Import transactions from other sources.

 

Let me know how everything goes and if you have additional concerns. I’m here to keep helping. Have an awesome day!
 

NinaVA
Level 1

Bank Feed imported incorrectly

Its ANZ bank. I have no idea why it would read the opposite way when importing over automatically...seems strange to me.

I will have to do this manually as you suggest later on when I have some time. Hopefully it's not too painful! :)

Joey Ann
QuickBooks Team

Bank Feed imported incorrectly

Hi NinaVA, 

We appreciate your patience on this. This was brought to our attention for ANZ transactions and quickly actioned by our engineers and this issue has already been fixed this morning. We truly apologise for the inconvenience. 

Moving forward all transactions will now be on the correct debit and credit columns. 

For the transactions that are already downloaded though, you need to exclude them and import a csv file like what was mentioned on the previous response. To help make this a better experience for you to create the csv file and import and map the fields in QBO, here's a great article which also has screenshots and easy to follow step by step instructions. 

 

https://quickbooks.intuit.com/learn-support/en-us/bank-transactions/import-bank-transactions-using-e...

 

Please let us know if you have further questions regarding this. Cheers!

kaykay331
Level 1

Bank Feed imported incorrectly

I am having this exact same issue, but with my Merrill Lynch CMA account. I already excluded the incorrect transaction and uploaded them manually from the bank, but am I going to have to do this every month? 

ShiellaGraceA
QuickBooks Team

Bank Feed imported incorrectly

Thanks for joining us today, @kaykay331.

 

I have some information about the incorrect transaction. While we don't have a reported case about the  Merrill Lynch CMA bank downloading incorrectly, you'll want to exclude the incorrect transaction as a workaround.

 

In the meantime, I recommend contacting our Customer Care Support so we can create a ticket and investigate further. Here's how to reach out:

 

  1. Go to Help at the top, then select Contact Us.
  2. Enter a brief description of your case, then hit Let's talk.
  3. Click Chat

Please know that our chat support agents are open during these hours 8:00 AM-10:00 PM (AEDT) Mon-Fri and 8:00 AM-8:00 PM (AEDT) Sat-Sun.

 

If you need help with other tasks in QuickBooks Online, you can browse a topic at this link here and then select an article. 

 

Please let me know if you still have questions or concerns about the program. I'll be around for you. Take care and have a happy holiday.

jdown
Level 1

Bank Feed imported incorrectly

I had the same problem. Adding the negatives didn't make a difference until I went back and made sure my Wells Fargo transaction download was "saved as" a CSV-UTF 8 (Comma Delimited) format... Then it uploaded correctly! 

IntuitAika
Intuit

Bank Feed imported incorrectly

Hi jdown, thank you for joining the thread. Happy to hear that you're able to upload your transactions via CSV-UTF 8 comma delimited. In addition, you can also check this article on how to import Bank transactions via CSV

 

Message us back if you have any other questions, we're here to help. Have a great day!