Skip to main content
February 26, 2023
Solved

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

  • February 26, 2023
  • 1 reply
  • 0 views
AN ACH payment showed up as a bank deposit? Can that be changed?
Best answer by DHeraV

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.

1 reply

DHeraV
DHeraVAnswer
February 26, 2023

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.

February 28, 2023

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.