cancel
Showing results for 
Search instead for 
Did you mean: 
maxmar80
Level 2

How to Import bank statement excel format into QuickBooks Descktop Pro

Hello, I am having hard time to import the bank statement from my bank that dose have only CSV option format, please help me to understand how to do it. I have QB desktop PRO.

I got until the Import file - mapping name(I put the account of the bank)- import type(I put account) and I got stock, I don't know how to set up correctly, my excel downloaded from the bank doesn't have many column's:

-date

-description

-withdrawal

-deposit

-balance

How do I match in the mappings? Please help if anybody know, I would really appreciated.

 

Thank you.

Solved
Best answer September 27, 2021

Best Answers
ReymondO
QuickBooks Team

How to Import bank statement excel format into QuickBooks Descktop Pro

Good day, @maxmar80.

 

The option to import bank transactions using the .CSV file is unavailable in QuickBooks Desktop (QBDT). You have to use a QuickBooks Web Connect (.qbo) file to bring your data into the program. 

 

For now, you can look for a third-party app that can help convert your file to into a .QBO format. Just check out this link to find one: https://desktop.apps.com/home

 

After successfully converting your file, you can now import them into QBDT.

 

Additionally, I got you this article that can guide you in reconciling your accounts accurately: Reconcile an account in QuickBooks Desktop.

 

You can always get back to me whenever you have other concerns. I'm always here to help you anytime. Keep safe!

View solution in original post

Fiat Lux - ASIA
Level 15

How to Import bank statement excel format into QuickBooks Descktop Pro

@maxmar80 

If you are using a supported version (i.e QBD 2019-2021), you may utilize a 3rd party app to convert XLS/CSV to QBO file and import it into your QB Desktop file.

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

 

Otherwise, prepare the Bank Statement data with the following template

Bank AccountTransaction DatePayeeChk No.AccountAmountMemoClassBillableBillable Entity
Checking01/09/2020AT&T123Utilities:Telephone-100Check Payment N 
Checking02/09/2020Jane Doe141Product Sales150Deposit N 

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

View solution in original post

4 Comments 4
ReymondO
QuickBooks Team

How to Import bank statement excel format into QuickBooks Descktop Pro

Good day, @maxmar80.

 

The option to import bank transactions using the .CSV file is unavailable in QuickBooks Desktop (QBDT). You have to use a QuickBooks Web Connect (.qbo) file to bring your data into the program. 

 

For now, you can look for a third-party app that can help convert your file to into a .QBO format. Just check out this link to find one: https://desktop.apps.com/home

 

After successfully converting your file, you can now import them into QBDT.

 

Additionally, I got you this article that can guide you in reconciling your accounts accurately: Reconcile an account in QuickBooks Desktop.

 

You can always get back to me whenever you have other concerns. I'm always here to help you anytime. Keep safe!

Fiat Lux - ASIA
Level 15

How to Import bank statement excel format into QuickBooks Descktop Pro

@maxmar80 

If you are using a supported version (i.e QBD 2019-2021), you may utilize a 3rd party app to convert XLS/CSV to QBO file and import it into your QB Desktop file.

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

 

Otherwise, prepare the Bank Statement data with the following template

Bank AccountTransaction DatePayeeChk No.AccountAmountMemoClassBillableBillable Entity
Checking01/09/2020AT&T123Utilities:Telephone-100Check Payment N 
Checking02/09/2020Jane Doe141Product Sales150Deposit N 

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

maxmar80
Level 2

How to Import bank statement excel format into QuickBooks Descktop Pro

Thank you so so much, I really appreciate the details and information you provided me. It will save me so much time now, I am very happy.

 

Have a wonderful day :)

 

maxmar80
Level 2

How to Import bank statement excel format into QuickBooks Descktop Pro

Hello, you are the best :) thank you very much for the reply, it is very appreciated.

 

I waste hours looking for an answer but now I got it, I knew  that should be a solution.

 

Have a wonderful day :)

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us