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?

QuickBooks Team

Banking

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!
 

Level 1

Banking

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! :)

QuickBooks Team

Banking

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!

Level 1

Banking

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? 

QuickBooks Team

Banking

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.