Quickbooks 2015 Iff Import

I need to import checks that have items in lieu of expenses. Can this be done?

Thank you.
rjfieldsAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JohnBusiness Consultant (Owner)Commented:
You can import transactions into QuickBooks using IIF files. Please see this Intuit Support Article for this.

http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/core/iif/task_import_trans.html?family=pro

Also, your bank may have an interface into the QuickBooks bank account and you may be able to set this up.

Finally, there are third party transaction import applications that might be easier for you to use.

http://marketplace.intuit.com
rjfieldsAuthor Commented:
Thank you for your response, but perhaps I should have been more specific. I should have expanded the question as follows:

Can a check with only detail on the Items tab be imported correctly using iif headers with Excel? The articles and forums do not address this and I have been unsuccessful working around the requirement that an account designation is mandatory.

Thanks again
JohnBusiness Consultant (Owner)Commented:
Can a check with only detail on the Items tab be imported correctly  <-- If you mean Item List in QuickBooks, the IIF file should be able to support all the fields available to the check.

It may be best to use a Transaction Importer. The IIF file is a bare bones method and third party tools give more flexibility.
Angular Fundamentals

Learn the fundamentals of Angular 2, a JavaScript framework for developing dynamic single page applications.

rjfieldsAuthor Commented:
I do mean item list and yes, the IIF file should (emphasis on that word) be able to handle it. However, account designations for  IIF transactions are mandatory and therein lies the rub. I have contacted the folks who make Transaction Pro and so far their comment has been "items are tricky". Really!?

If QB used a properly designed relational database structure (i.e. 3rd normal form) , many of these issues would evaporate. Just sayin'

Thank you again for your time.
JohnBusiness Consultant (Owner)Commented:
The front end to QuickBooks is a bit tricky in that IIF files are very closely prescribed. I try to avoid them. Yes, account designations are mandatory (but then I use account designations for everything).
rjfieldsAuthor Commented:
In the construction industry, job codes are very detailed and items are the only fit if you want to avoid a gigantic chart of accounts. Oh well.
JohnBusiness Consultant (Owner)Commented:
I have a client where I use accounts (lots), and jobs (lots). Easy to get data out. Not as easy to get data in.
rjfieldsAuthor Commented:
I solved the problem by adding "Invitem Amount" to the Spl header. See below:

!SPL      TRNSTYPE      DATE      ACCNT      NAME      MEMO      AMOUNT      INVITEM      AMOUNT      DOCNUM

This puts the check data into the Item tab instead of the Expense tabl.

The question can be closed though there is really no solution to accept.

Thank you for your input.
JohnBusiness Consultant (Owner)Commented:
If I helped you my comments for using LISTS, please say. Otherwise, use your own answer to close the question.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
JohnBusiness Consultant (Owner)Commented:
Thank you for following up.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
QuickBooks

From novice to tech pro — start learning today.