Question

Importing transactions manually into quickbooks pro 2011

Forum|Forum|4 years ago
March 23, 2022
2 replies
1 view

I have been using quickbooks pro 2011 for 11 years. I recently attempted to switch to quickbooks online, but I'm not liking it. I am planning to switch over to the most recent quickbooks pro desktop, but I want to finish 2021 taxes in quickbooks 2011 before I switch. I'm trying to finish it up soon and am running into too many problems learning new systems. The problem right now is I manually typed all transactions for 2021 into an excel document (because my bank wouldn't sync more than 90 days) and I need all those documents to be uploaded into quickbooks 2011. Is this possible? Quickbooks 2011 just prompts me to link my bank account, which isn't going to be a help to me, because it won't sync more than 90 days. I'd rather not manually type all transactions AGAIN into the bank register of quickbooks 2011. Anyone have a solution for me?

QuickBooks Desktop

J

JamaicaA

QuickBooks Team

Thank you for the detailed information, @ivyteachesmusic. Helping you import your transactions to QuickBooks Desktop Pro 2011 is my priority.

You can enter your transactions into the program in various ways. Before doing so, ensure you back up your QuickBooks Desktop company file. This way, you'll have a copy of your data.

We can start with the Excel CSV file. You can log in to your online banking and download transactions as an Excel CSV file. Please take note that this depends on your bank.

After that, you’ll need to download the QuickBooks Import Excel and CSV toolkit. This contains the PDF instructions and guidelines, as well as a few formatting samples.

Since you’ve manually entered your transactions into an excel file, you’ll want to move them to IIF. To do so, you’ll also need to download and install the .IIF importkit.

Here’s how:

Download the kit.
Select the Save button to download the IIF_Import_Kit.zip file to your Windows desktop.
Use WinZip or any compatible file compression utility to extract the contents of the downloaded file. The contents will automatically extract into a sub folder called .IIF Import Kit.
Open the IIF Import Kit folder to view its contents.

After that, copy your data from the Excel file to the IIF file. Then, import it to QuickBooks. I’ll show you how:

Go to the File menu and select Utilities.
Select Import then choose Import IIF.
Select Import IIF.
Locate the IIF file, then click Open.
Tap OK.

I've added these informative links for more details about CSV and IIF files:

For other ways to import and export info in QuickBooks, you can visit this article. It includes the lists and transactions you can import.

To ensure all entries are accounted for correctly and with no duplicates, you can categorize and set rules for them. Then, reconcile them to ensure your books are accurate.

I've also included these resources as your guide when paying taxes:

I'll be around if you still have questions or require additional assistance with moving your transactions. Just drop them in the comment section below, and I'll be happy to answer them for you.

I

ivyteachesmusicAuthor

Thanks so much! This is to import the files into my desktop version, not into quickbooks online, right?

JessT

Moderator

Hi ivyteachesmusic!

Thank you for posting again! Yes, @JamaicaA's steps are for your QuickBooks Desktop.

You probably have a lot of transactions that's why you asked, which I would do the same if I were in your situation. However, please note that version 2011 has been retired, and there are some updates to the Windows system that may incapacitate some features in that version.

If you'll encounter issues when importing your transactions, you can switch to the newest version first and import your IIF file in there. The catch here is we can't directly move a company file from a 2011 version to the latest or the supported versions. You need to do interim jumps to 2014, 2016,...2022 or call our QuickBooks Desktop Support for assistance.

In addition to the ones shared above, I'm including these articles to guide you through the upgrade processes.

You're free to ask questions if you have other concerns with your transactions or when you do the conversion. I'll be here to assist you further. Enjoy the rest of the day!

Fiat Lux - ASIA

Level 14

@ivyteachesmusic

Prepare your Bank Statements data in XLS 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

When you are ready to upgrade your QB Desktop version, you can use the trial license for QBD 2015 and 2019 later. You can still purchase the one time license for QBD 2021 or the annual subscription for QBD 2022. Contact us in private if you need those trial codes to upgrade your version.

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded