cancel
Showing results for 
Search instead for 
Did you mean: 
StoverMcPieces
Level 2

Editing uploaded transactions

I uploaded CSV files and now all bank transactions look like deposits- Can I change them to be withdraws without uploading them all over again? 

Solved
Best answer July 02, 2023

Best Answers
Kevin_C
QuickBooks Team

Editing uploaded transactions

Hello  there, @StoverMcPieces. I'm here to provide details about fixing uploaded bank transactions in QuickBooks Online (QBO).

 

At this time, there's no direct way to edit the uploaded bank transactions that showed up as deposits instead of withdrawals. What we can do is to exclude all of the uploaded transactions in bulk, then edit the CSV file and make sure the amounts have a negative sign (-) before importing them again.

 

To guide you further, follow the steps below:

 

  1. Go to the Banking menu, then click the Banking tab.
  2. Navigate to the For Review tab.
  3. Select the checkbox of the transactions to exclude or the checkbox beside the Date column to select all.
  4. Choose Exclude.

 

You can also go to the Excluded tab if you need to delete them permanently.

 

After that, review your csv file and edit it to ensure the withdrawal transaction amounts have a negative sign (-). Once everything's good with the CSV file, you can proceed to import them back into QBO.

 

See this sample screenshot for your visual reference:

image.png

 

Additionally, here are some articles that you can read to help speed up the review process of your online bank transactions:

 

 

Please keep me posted if you still have questions or concerns about managing your bank transactions in QBO. I'm always ready to help. Have a great day!

View solution in original post

4 Comments 4
Kevin_C
QuickBooks Team

Editing uploaded transactions

Hello  there, @StoverMcPieces. I'm here to provide details about fixing uploaded bank transactions in QuickBooks Online (QBO).

 

At this time, there's no direct way to edit the uploaded bank transactions that showed up as deposits instead of withdrawals. What we can do is to exclude all of the uploaded transactions in bulk, then edit the CSV file and make sure the amounts have a negative sign (-) before importing them again.

 

To guide you further, follow the steps below:

 

  1. Go to the Banking menu, then click the Banking tab.
  2. Navigate to the For Review tab.
  3. Select the checkbox of the transactions to exclude or the checkbox beside the Date column to select all.
  4. Choose Exclude.

 

You can also go to the Excluded tab if you need to delete them permanently.

 

After that, review your csv file and edit it to ensure the withdrawal transaction amounts have a negative sign (-). Once everything's good with the CSV file, you can proceed to import them back into QBO.

 

See this sample screenshot for your visual reference:

image.png

 

Additionally, here are some articles that you can read to help speed up the review process of your online bank transactions:

 

 

Please keep me posted if you still have questions or concerns about managing your bank transactions in QBO. I'm always ready to help. Have a great day!

StoverMcPieces
Level 2

Editing uploaded transactions

Thank you so much Kevin_C! I started this as a guess so it’s great to hear I’m on the right track.

StoverMcPieces
Level 2

Editing uploaded transactions

Thank you so much for your help! I actually started this exact process as a guess so I’m grateful to know I’m on the right track.

 

Thank you again!

MirriamM
Moderator

Editing uploaded transactions

Hello there, StoverMcPieces.

 

I am glad to know that the recommended steps provided by my colleague worked for you. 

 

In case you need tips and related articles in the future about the "How Do I" steps in QuickBooks Online, visit our QuickBooks Community help website for reference: QBO Self Help.

 

If you need additional help with QuickBooks, please let us know. We’ll be right here to further assist. Take care, and I wish you continued success.

Need to get in touch?

Contact us