Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Convert the IIF timedate stamp to a readable date to track the history of a QuickBooks list entry

This article describes a method for tracking list entry history, to answer the following questions:

  • How many customers/vendors/items have been added in the past (two) years?
  • How many customers/vendors/items are new this year?
  • Which customers/vendors/items have been in QuickBooks the longest amount of time?
  • How many customers/vendors/items did we add last year?
  • How long have our customers/vendors been doing business with us?
  • When did we add this item to our QuickBooks Inventory List?

In QuickBooks, the only way to determine the length of time an entry on the Customer or Vendor list has been associated with the company file is to examine each entry one at a time, using the snapshot in the Customer or Vendor Center. Unless a note was added to an item as it was entered into the Inventory Center, QuickBooks does not associate a date when adding an item.

For a report showing when customers, vendors, or items were added to the company file, export an iif file and perform this conversion.

CAUTION: Before performing any of the following tasks, create a backup of your data file(s) with a unique name or saved to an isolated location.

NOTE: Intuit does not provide live telephone support for creating or importing IIF files, however, there are resources available if help is needed:

  1. Browse, search, or post a question in the QuickBooks Community Forum: Importing and Exporting Data.
  2. If the IIF file was created by a third-party application, contact the application's technical support department.
  3. Refer to the documentation provided with the import kit.
  4. Search the QuickBooks knowledge base, which includes In-Product Help.
Detailed instructions

Collapse All or Expand All


KB ID# HOW20892
10/20/2016 5:32:31 PM
PPRDQSSWS407 9138 Pro 2017 f32587