Do we need to convert the bank transactions excel or CSV file into .QBO file format to be able to import it into QB Enterprise 2021?
In QB it looks like we can import excel files (utilities - import -excel) but when I do mapping it doesnt give me option to chose transactions, just costumers, vendors or accounts.
Someone (very known for QB lessons) on youtube said we need to convert it into .QBO file format. Was he just advertising the converter software or indeed we need that?
Thank you for any help!
P.s. please do not tell tell me how to connect direct to bank or to use any other method. I have the data in excel files already - bank statements with description date and amount.
Thank you for posting here in the Community for clarification, @booklover. I’ll share some information about importing transactions into QuickBooks Desktop (QBDT).
There are two ways of downloading transactions into QBDT. First is Direct Connect. This is where you connect your bank to your QuickBooks account to automatically download the transactions.
On the other hand, you can import your transactions using a Web Connect (.QBO) file. These files are online banking transactions from your bank’s website. The (.QBO) files are downloaded to your computer. Then, you import the transactions so they become available in your bank feeds.
Since you’ve mentioned above that you have your data already in an excel file, I suggest you import your transaction using a Web Connect (.QBO) file and utilize a third-party application to convert excel to .QBO format. You can also directly reach out to your financial institution, as they can also provide this file to you.
The other way to get the file is to visit your bank’s website. Let me show you how:
Once you have the Web Connect (.QBO) file, you can then import it into your QBDT company. Here’s how:
Furthermore, you can check out the following articles about adding and matching transactions as well as reconciling your account in QuickBooks Desktop.
Let me know in the comments if you need further assistance with importing. The Community always has your back. Have a great day!