Solved

How to Import bank statement excel format into QuickBooks Descktop Pro

Forum|Forum|4 years ago
September 27, 2021
2 replies
0 views

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.

QuickBooks Desktop

Best answer by ReymondO

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!

R

ReymondOAnswer

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!

M

maxmar80Author

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

Fiat Lux - ASIA

@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