Skip to main content
June 22, 2024
Question

How to fix a bank download error. The bank transaction was a withdrawl. QB OL is showing it as a deposit. How do I prevent or change the incorrect transaction type?

  • June 22, 2024
  • 1 reply
  • 0 views
Original commenter did not share additional details

1 reply

June 22, 2024

Hi there, LLC. Let me share information regarding the downloaded bank transactions in QuickBooks Online (QBO).

 

When downloading bank transactions into QBO, we rely on what the bank gives. Therefore, to fix the transactions shown as deposits instead of withdrawals, we have to exclude them and manually upload them, ensuring that all transactions from your statements are correct.

 

To start, let's exclude your deposited transactions in your QBO account. Kindy follow the steps provided below:

 

  1. Go to the Transactions menu.
  2. Choose which bank the transactions belong to, then click the For Review tab.
  3. Find the transactions you want to exclude, then mark-check the box.
  4. Click Exclude.

 

After that, log into your bank account website and download your transactions. Let's then upload your transactions manually in QBO.

 

Here's how:

 

  1. Go to Transactions, then choose Bank Transactions.
  2. Select the blue tile for the account you want to upload the transactions.
  3. Click on the Link account▼ dropdown, then pick Upload from the file.
  4. Select Drag and drop or select files, then choose the file you downloaded from your bank. Then, click Continue.
  5. Choose the account you want to upload the transactions into in the QuickBooks account▼ dropdown. Then, click Continue.
  6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
  7. Choose the transactions to import, then select Continue.
  8. Click Yes, then Done.

 

You can refer to these helpful materials in the process of excluding and manually importing the said transactions for further information:

 

 

In addition, if you have your transactions with you, learn how to reconcile your accounts in QBO through this article to ensure your books align with your bank or credit card monthly statements:  Reconcile an account in QuickBooks Online.

 

Return to this thread if you have additional inquiries about your downloaded bank transactions in QBO, LLC. I'll be sure to answer them as soon as I get your reply. Keep safe!