Showing results for 
Search instead for 
Did you mean: 
NEW Connect to DBS IDEAL direct bank feeds Click here
Level 1

How can I change imported data as deposit to expenses?

While importing data  I have made a mistake and all the expenses are showing as deposit now how can I change them?
1 Comment 1

How can I change imported data as deposit to expenses?

Hello there, johnson.


After importing, we don't have a direct option to change the deposit to expenses. We can instead delete them and manually recreate each one in QuickBooks.


However, you can easily correct it by reimporting them. Before doing so, ensure to review the mapping correctly in Excel to display them as intended in the system. This way, we can correct all of them at once.


First, exclude the deposits.


  1. Go to the Transactions menu and select the Bank transactions tab.
  2. Tick all the deposits and select Exclude. 
  3. To delete, go to the Excluded section and choose Delete.


Next, ready your Excel with the correct mapping. For expenses, put a negative sign before the amount. If you're using the 4-column format, place the amount in the Credit column. Then, follow these steps to import again


  1. Follow steps 1 and 2, then click the Link account drop-down arrow.
  2. Choose Upload from file.
  3. Upload your file and select Continue.
  4. Follow the on-screen instructions.


Here are some articles for more tips about managing bank data:



Please inform me if you have further concerns regarding bank data and other aspects within QuickBooks.