Skip to main content
B
BradRumble
October 2, 2022
Question

Importing Bank Transactions with CSV file (FIGURED OUT)

  • October 2, 2022
  • 1 reply
  • 0 views

Hey there! 

 

I decided to make this post after spending nearly an HOUR having difficulties importing my bank transactions into Quickbooks Self-Employed. Hopefully this saves some of you any headaches. Here is what I did!

 

1. Make sure your bank is connected to Quickbooks

2. In the Transactions tab, go to the far middle right and download your transactions (you can search a smaller transaction so it is not a full list) it is the icon with the arrow going off the page.

3. Now that you have quickbooks format, delete everything in these columns (Bank, Account, Type, Category, Receipt, Notes) *do not delete the columns themselves, just the data inside of them

4. From here, manually copy and paste the correct Date, Description, and Amount information for the correct account.

5. Save as a CSV and upload!

 

Thats it! I know it is a little tedious, but it's the only way that has currently worked for me. Hopefully quickbooks can find an easier workaround in the near future!

1 reply

JessT
JessT
October 2, 2022

Hello BradRumble!

 

I appreciate your effort to share how you were able to import your transactions. This will surely help other users who wish to import their bank transactions to QBSE.

 

Yes, you're right that you only need the Date, Description, and Amount columns in your CSV file. This is the 3-COLUMN format statement. When mapping, a user has to specify the 3 column names, as shown below.

 

 

Usually, banks provide statements with 5 columns (Date, Description, Credit, Debit, Balance). In this case, you don't want to map the Balance column.

 

 

I'm adding these articles for everyone's reference:

 

 

For anyone reading and having challenges with importing transactions, this thread is open to comments and questions. We'll be happy to answer your questions.

Terms & ConditionsAccessibility statement