cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
Kyle N
Level 1

My imported transactions have all come in as Income when they aren't . Urrg Do I have to delete them all or can I change them to an expense? THank you

I had a real issue with converting my statements to CVS files. i"ve finally done that and thought HOORAY and imported them but all the transactions are INCOME when they definitely are not. Can I change these or do I have to delete them all and try again?  Thank you

3 REPLIES 3
MirriamM
Moderator

My imported transactions have all come in as Income when they aren't . Urrg Do I have to delete them all or can I change them to an expense? THank you

Hi there, Kyle.

 

I can help you correct imported transactions.

 

In QuickBooks Self-Employed (QBSE), imported transactions cannot be deleted; you can only choose to exclude them. Then, reimport the file again. Before doing so, I recommend editing the file and double-checking the information. You can choose to have it in either a 3-column format or a 4-column format.

 

Then, to delete the imported file, here's how:

 

  1. Go to the Gear icon ⚙ and select Imports.
  2. Click on the imported CSV file and click on the trash icon beside Import Complete
  3. Select Delete to confirm the deletion. 

 

Once done, import the file again. Check out this article for detailed guidance: Manually import transactions into QuickBooks Self-Employed.

 

Please don't hesitate to drop your comment below if you have any other questions. I'm always here to help. Keep safe always.

Kyle N
Level 1

My imported transactions have all come in as Income when they aren't . Urrg Do I have to delete them all or can I change them to an expense? THank you

Hi thank you.

 

This has been so time consuming. I had such a roundabout way to convert my bank transactions to the right format already. I'm not sure that importing again will be any different.

RoseJillB
QuickBooks Team

My imported transactions have all come in as Income when they aren't . Urrg Do I have to delete them all or can I change them to an expense? THank you

I understand that it’s been time-consuming for you to import your bank transactions in QuickBooks Self-Employed (QBSE), @Kyle N.

 

My colleague is correct that once the transactions are imported, there’s no way we can delete them. Instead, we can exclude them from the application and re-import the file with the correct entries. Since they were imported as an income, we’ll need to redo the process to make sure transactions will reflect as an expense.

 

Considering the file format, let’s make sure to check what format we’re using to determine how the transactions will be imported. You can choose to have it in either a 3-column format or a 4-column format. I’ll add the snapshot below for your reference:

 

The 3-column format:
format 1.PNG

 

The 4-column format:

format 2.PNG

 

On the other hand, if you’re using the 3-column format, you’ll have to enter the amounts in negative. This way, the entries will get into your bank feeds as an expense. For the 4-column format, you’ll need to determine if the amounts are income or expense by adding them under a Credit or Debit column.

 

Once you’re done sorting out your file, please follow the steps outlined by my peer, MirriamM, to begin importing them into your company file. 

 

Additionally, here's a helpful resource you can look through to learn more about putting the transactions to the correct line of your Schedule C in QBSE: Categorise transactions in QuickBooks Self-Employed.

 

Feel free to let me know if you need any further assistance with importing files or any QuickBooks-related matters by posting them here. Have a great day!

Need to get in touch?

Contact us