Skip to main content
J
JLB16
April 11, 2022
Question

Service Item in Journal Entry

  • April 11, 2022
  • 1 reply
  • 0 views

We are using Paycom to do our payroll and need to import an IIF file to record the transaction.  The problem arises because I also need to import the service Items associated.  I understand the Journal Entry template doesn't allow for a service Item to be imported but I have seen a screenshot showing that it's possible.  It seems to import it on the back end so you can see it in the transaction journal.  Has anyone successfully imported an IFF for a journal entry with ITEM column?  Using QB Enterprise

1 reply

C
ChristineJoieR
April 12, 2022

I'm glad to see you here, @JLB16. Let me provide you with a few details about the service item in QuickBooks Desktop.

 

This IIF is for importing a general journal into a new QuickBooks data file. If the accounts aren't already set up, the information needed is at the beginning of the file. The class, if relevant, will be listed next, followed by the client, vendor, and other names. These are required for the proper setup of the lists. Moreover, an unidentified item will be imported as a service item by default.

 

Overall, you can:

 

  • Export lists from one QuickBooks company file and import them into another.
  • Import lists or transactions into QuickBooks from another program.
  • Export the list to QuickBooks Pro Timer and import data from it.
  • Share data between different QuickBooks editions and platforms (such as Pro, Premier, and Enterprise, or between Windows and Mac).

 

Furthermore, QuickBooks Desktop makes it simple to import and export IIF files by automatically formatting them. However, if you haven't worked with delimited text files before, creating. IIF files from scratch or adapting data from another program can be tricky. Unless you have a large quantity of data to import, this makes it faster and easier to enter the data directly into QuickBooks Desktop.

 

Additionally, see this article for more information about the IIF import and export limitations in QuickBooks Desktop.

 

Keep me in the loop if you have other concerns or questions about managing data. I would love to help! Have a pleasant day ahead!

J
JLB16Author
April 12, 2022

Thank you for the response but I do not believe this addresses my issue.  I have successfully imported an IIF for a General Journal (see screenshot of IFF layout).  What I am trying to do is add a column for the Service Item.  I understand you can't see this when viewing the Journal Entry, but can see it when you view the transaction journal.  It appears to be possible as I have seen a screen shot of the results (see transaction Journal screenshot).  I am trying to determine how to format my IIF to allow a successful import of the Item column.

M
MadelynC
April 12, 2022

Thanks for reaching back out, @JLB16.


I appreciate you for sharing the Transaction Journal screenshot with us. To help with formatting your Intuit Interchange Format (IIF) file, I recommend contacting an IT expert. They can guide you further to ensure you can successfully import the file with the Item column.


You can read these resources to learn more about IIF files:

 


And in case you need more tips and information on how to manage your company files. We have available resources, webinars, and training videos on our Support page.


If you have any other questions or concerns besides managing your IIF file, you can add them to your reply below. We’ll be here. Have a good day and always take care!

Terms & ConditionsAccessibility statement