My latest bank transaction imports all come up as income, why?

Hi, Catherine.

I'm here to share the cause of why all the uploaded bank transactions show income and provide steps to fix this.

When importing bank or credit data in QuickBooks Self-Employed (QBSE), it's necessary to ensure the CSV file is formatted correctly. It can be the reason why your transactions all show as income.

Please note that imported transactions can't be deleted. To rectify this, I suggest excluding them. Follow the detailed steps in the article to achieve this: Exclude or delete transactions. 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.

If you use the 3-column format, a negative sign (-) before the amount and your deposits or income transaction will only include a positive amount. For the 4-column format, determine if the amounts are income or expense by adding them under a Credit or Debit column.

Once your file is formatted correctly, follow these steps to import your transactions:

1. Open your QBSE account in a web browser.
2. Go to the Gear icon and then select Imports.
3. Choose Import older transactions for the account you want to add transactions.
4. Select Browse and find the file you downloaded from your bank. It's usually in your Downloads folder.
5. Pick the CSV file and select Open to start the import.
6. Review the column headers and data. Ensure the Date, Description, and Amount columns match the columns and order in QuickBooks. The other column headers can be in any order.
7. Click Continue to complete the import.

For more details, please see this article: Manually import transactions into QuickBooks Self-Employed.

Finally, you can browse these resources to help you ensure QuickBooks puts your transactions on the correct line of your Schedule C. They also help organize your income and expenses, allowing you to see if your self-employed business record is accurate:

• Categorise transactions in QuickBooks Self-Employed
• Create bank rules to categorise banking transactions in QuickBooks Self-Employed

We're always here in the Community to help if you have other questions about uploading your transactions into QBSE. My priority is to ensure all the data are added to the program correctly.