How to Import bank statement excel format into QuickBooks Descktop Pro

maxmar80 · ‎September 27, 2021

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.

ReymondO · ‎September 27, 2021

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 · ‎September 27, 2021

@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 Account	Transaction Date	Payee	Chk No.	Account	Amount	Memo	Class	Billable	Billable Entity
Checking	01/09/2020	AT&T	123	Utilities:Telephone	-100	Check Payment		N
Checking	02/09/2020	Jane Doe	141	Product Sales	150	Deposit		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

ReymondO · ‎September 27, 2021

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 · ‎September 27, 2021

@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 Account	Transaction Date	Payee	Chk No.	Account	Amount	Memo	Class	Billable	Billable Entity
Checking	01/09/2020	AT&T	123	Utilities:Telephone	-100	Check Payment		N
Checking	02/09/2020	Jane Doe	141	Product Sales	150	Deposit		N

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

maxmar80 · ‎September 28, 2021

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 · ‎September 28, 2021

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 :)

Topics

Training

Community

Resources

How to Import bank statement excel format into QuickBooks Descktop Pro