cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Importing Customer Job Number in IIF File

Can I import the Customer Job Number for a bill in the IIF file? Is so, what heading do I use?

3 Comments
Moderator

Re: Importing Customer Job Number in IIF File

Thanks for reaching out to us in the Community, @dkrumholz.

 

I can share some information about importing Customer Job Number for a bill in the IIF file.

 

Yes, you can! Use the Name column on the SPL (line items on the bill) row to enter the Customer Job Number.

12.PNG

After that, save the file and import it to QuickBooks Desktop (QBDT). Here's how:

 

1. Make sure to login as Admin and you're in a Single User Mode.
2. Now, go to the File menu at the top, then pick Utilities on the drop-down.
3. Select Import, then IIF Files.

13.PNG
4. Locate and open the IIF file, then OK on the pop-up message confirming your data has been imported.

 

I'm adding these articles for future reference:

 

 

This should point you in the right track. Please let me know how it goes or if you need anything else. I'll be happy to answer them. Take care.

Not applicable

Re: Importing Customer Job Number in IIF File

Fritz,

I am working with support on the problem. Thanks!

BRC
Established Community Backer ***

Re: Importing Customer Job Number in IIF File

Yes, put the full customer:job name (in the format [customer]:[job] in the NAME column of the SPL row.

 

If you don't want to spend your time figuring this and many other things out, consider our app which will do it for you: BRC IIF Transaction Creator Pro 

Need to get in touch?

Contact us