Why am I receiving an error when importing a .csv file from my bank

Hello there, carrbd1.

I've got methods to help you import a.csv file from your bank to QuickBooks Self-Employed smoothly.

First off, may I know which specific bank you are using? This way, I appreciate any further details so I can provide accurate information.

For now, please note that importing error messages is usually caused by an incorrectly formatted file. The program supports CSVs with either a 3-column or 4-column format. With this, I recommend making sure that you use the appropriate CSV format before uploading your transactions to QuickBooks. These are the two kinds of formats you can follow:

• The first is where columns include the Date, Transaction name/description, and Amount. The date format should be DD/MM/YYYY, and the amount column should show the figures with a plus or minus symbol so the program can see if it's income or an expense.
• The second is similar to the first. The CSV can have four columns: Date, Transaction name/description, Credit, and Debit. Again, the date format should be DD/MM/YYYY.

To learn more about CSV formats, you can check out this article: Format CSV files in Excel to get bank transactions into QuickBooks. Although it is for QuickBooks Online, it also works the same way for QBSE.

Once everything is working, you can now follow the steps below to import your data in QBSE.

Here's how:

1. Click the Profile ⚙ icon and choose Imports.
2. Select Import transactions.
3. Follow the onscreen steps to upload the CSV file.
4. Select Import.

In case you need steps on how to categorize the imported entries to organize them so you know what areas of your self-employed business have the biggest impact, you can read this article: Categorize transactions in QuickBooks Self-Employed.

You can always get back to this thread if you have other importing concerns or questions about managing your self-employed transactions in QBSE. I'm always here to help you further, carrbd1. Take care!

@carrbd1 

You can use one of the converter tools (e.g csv2qbo @ $60 one time license) as a workaround.

https://www.moneythumb.com/?ref=110