cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Explorer **

Import check information Quickbooks Pro 2007

Hi!

I have an Excel list of check that have been written and I wold like to import that data into QuickBooks 2007 instead of having to rekey the transactions (200+). Is this possible? This is a once-a-year occurance, if that impacts answers

Solved
Best answer 08-08-2019

Accepted Solutions
QuickBooks Team

Re: Import check information Quickbooks Pro 2007

Hello there, @bobby1927.

 

I'm here to help walk you through the steps to import your checks into QuickBooks Desktop (QBDT).


You can use the Intuit Interchange Format (.IIF) file to import the checks to QBDT. Here's how:

 

  1. Sign to to your company file as Admin and ensure you are in a single user mode.
  2. Go to the File menu.
  3. Select Utilities.
  4. Click on Import.
  5. Select IIF Files.
  6. Locate your .IIF file and highlight it. Then Open.
  7. Select OK on the pop up message confirming your data has been imported.

For further details, you can check this article: Export or import Intuit Interchange Format (.IIF) files.

 

I'm also attaching these articles for you future reference about importing/exporting files to and from QBDT:

 

Keep in touch if you have any other questions about importing your checks. I'm always here to help!

View solution in original post

3 Comments
Established Community Backer ***

Re: Import check information Quickbooks Pro 2007

hi @bobby1927 ,

You may consider using a 3rd party data import tools (like TPI).

https://transactionpro.grsm.io/fl-qbd

 

Hope it helps.

QuickBooks Team

Re: Import check information Quickbooks Pro 2007

Hello there, @bobby1927.

 

I'm here to help walk you through the steps to import your checks into QuickBooks Desktop (QBDT).


You can use the Intuit Interchange Format (.IIF) file to import the checks to QBDT. Here's how:

 

  1. Sign to to your company file as Admin and ensure you are in a single user mode.
  2. Go to the File menu.
  3. Select Utilities.
  4. Click on Import.
  5. Select IIF Files.
  6. Locate your .IIF file and highlight it. Then Open.
  7. Select OK on the pop up message confirming your data has been imported.

For further details, you can check this article: Export or import Intuit Interchange Format (.IIF) files.

 

I'm also attaching these articles for you future reference about importing/exporting files to and from QBDT:

 

Keep in touch if you have any other questions about importing your checks. I'm always here to help!

View solution in original post

BRC
Established Community Backer ***

Re: Import check information Quickbooks Pro 2007

Convert your Excel worksheet transaction list into an IIF file using our BRC IIF Transaction Creator 

It support most types of transactions including Checks, Deposits, Bills, and Invoices.

Need to get in touch?

Contact us