cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
9130355651331426
Level 1

How do I change an incorrect bank download from a Deposit to an Expense?

AN ACH payment showed up as a bank deposit? Can that be changed?
Solved
Best answer February 26, 2023

Best Answers
DHeraV
Moderator

How do I change an incorrect bank download from a Deposit to an Expense?

Welcome to the Community.

I'm here to make sure that you can change the payment transaction to an expense in QuickBooks Online (QBO). 

First off, let's check the transaction in the For Review tab, here's how:
 

  1. On your QBO account, go to the Banking tab, then select For Review.
  2. Locate the ACH payment transaction.


To know if the payment transaction is an expense, the amount should show in the Spent column. If the amount shows under the Received column, it means that the entry was recorded as an income transaction.

To fix this, exclude those transactions you've added then delete them from the Banking page. Here's how:
 

  1. In the Excluded section, select the transactions you want to delete.
  2. Once done, click on Delete.

 

Next, format your expenses properly on your CSV or Excel file. Make sure to code the expenses under Debit or put a negative sign on the amount. That way, the system will recognize them as expenses.

If you need more guidance with formatting, feel free to visit: Format CSV files in Excel to get bank transactions into QuickBooks.


Lastly, you can then re-import your CSV file with the correct format.

Additionally, I'll also share this article that can serve as your reference if you want to learn how to reconcile your account so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.


Don't hesitate to leave a reply if you require further assistance with managing your transactions in QBO. The Community team always has your back. Have a good one.

View solution in original post

2 Comments 2
DHeraV
Moderator

How do I change an incorrect bank download from a Deposit to an Expense?

Welcome to the Community.

I'm here to make sure that you can change the payment transaction to an expense in QuickBooks Online (QBO). 

First off, let's check the transaction in the For Review tab, here's how:
 

  1. On your QBO account, go to the Banking tab, then select For Review.
  2. Locate the ACH payment transaction.


To know if the payment transaction is an expense, the amount should show in the Spent column. If the amount shows under the Received column, it means that the entry was recorded as an income transaction.

To fix this, exclude those transactions you've added then delete them from the Banking page. Here's how:
 

  1. In the Excluded section, select the transactions you want to delete.
  2. Once done, click on Delete.

 

Next, format your expenses properly on your CSV or Excel file. Make sure to code the expenses under Debit or put a negative sign on the amount. That way, the system will recognize them as expenses.

If you need more guidance with formatting, feel free to visit: Format CSV files in Excel to get bank transactions into QuickBooks.


Lastly, you can then re-import your CSV file with the correct format.

Additionally, I'll also share this article that can serve as your reference if you want to learn how to reconcile your account so they always match your bank and credit card statements: Reconcile an account in QuickBooks Online.


Don't hesitate to leave a reply if you require further assistance with managing your transactions in QBO. The Community team always has your back. Have a good one.

9130355651331426
Level 1

How do I change an incorrect bank download from a Deposit to an Expense?

Thank you for the solution.  For some reason I have been worried about re-downloading the Banking CVS file, fearing for duplicates etc.   I appreciate the help.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us