Service Item in Journal Entry

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!

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.

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:

• Export, import, and edit IIF files
• IIF Overview: import kit, sample files, and headers

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!

Is there an IT expert within QuickBooks who knows how to format a file that would be accepted by Quickbooks?

Thank you for the prompt response, @JLB16. 

I can see how important it is to find an IT expert to help you format your Intuit Interchange Format (IIF) file for QuickBooks. I'm here to clarify things for you.

We're unable to suggest a specific IT expert here in the Community. You can find someone outside of QuickBooks instead.

I can see that my peer, MadelynC, included a great resource above to learn more about the IIF files. Feel free to check them out.

Additionally, I'm adding this article in case you need to access reports in the future. This contains the description of each report and the information you can get: Run payroll reports.

Don't hesitate to leave a comment on this thread if you have additional questions about this. We're always here to help you. Have a good one!