Advertise here    

QuickBooks Forums      

Go Back   QuickBooks Forums > QuickBooks Software Support > QuickBooks Forum

Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 11-09-2009, 02:52 PM
B. Bach B. Bach is offline
Registered User
 
Join Date: Nov 2009
Posts: 1
Smile Importing Bills through IIF - Troubleshooting

I've created an IIF file in excel to import vendor bills and the import completes and shows no errors but the data does not show. Here is the header and a few line. Can anyone give me some ideas to try?

!HDR PROD VER REL IIFVER DATE TIME ACCNTNT ACCNTNTSPLITTIME
HDR QuickBooks Pro Version 16.0D Release R1P 1 12/15/2007 1197737278 N 0
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR TOPRINT ADDR5 DUEDATE
!SPL SPLID TRNSTYPE DATE ACCNT NAME CLASS AMOUNT DOCNUM MEMO CLEAR QNTY REIMBEXP SERVICEDATE
TRNS BILL 10/8/2009 Accounts Payable Acrylic Specialties & Plastics -228 46683 4165 N N 11/7/2009
SPL BILL 10/8/2009 Barter Account Acrylic Specialties & Plastics 228 N
TRNS BILL 10/19/2009 Accounts Payable Acrylic Specialties & Plastics -100 46720 4266 N N 11/18/2009
SPL BILL 10/19/2009 Barter Account Acrylic Specialties & Plastics 100 N
TRNS BILL 10/13/2009 Accounts Payable Acrylic Specialties & Plastics -564 46693 4267 N N 11/12/2009

Thank-you
Reply With Quote
  #2  
Old 11-10-2009, 04:01 AM
Joe Williams Joe Williams is offline
Registered User
 
Join Date: Jan 2006
Location: Oklahoma
Posts: 8,894
The NAME field on the SPL line is the item name not the Vendor name.
The AMOUNT on the TRNS line is the net amount of the bill, the amount on the SPL line is negitive and is the amount for that line only.
__________________
Joe Williams
joewilliams@wavelinx.net
Piedmont, Ok
Reply With Quote
  #3  
Old 12-21-2009, 01:28 AM
lonewolf lonewolf is offline
Registered User
 
Join Date: Nov 2009
Posts: 5
1. You're missing the "ENDTRNS" lines after the last SPL line of each transaction.
2. The SPLID should show the position of each SPL line among all the SPL lines in each transaction. For example, if a transaction has 3 SPL lines, the first line should have a "1" SPLID, the second "2" and so on.. In your example, since all transactions have only one SPL line each, all SPLID's would have "1" as their values.
3. The NAME fields in the TRNS and SPL lines are both for the vendor names. To indicate item name, the field INVITEM should be used.
4. For bills, since the credit entry to accounts payable needs to be positioned in the TRNS line, its amount would be negative. Because "Accounts Payable" is a liability, bills increase liabilities, and negative amounts increase liabilities, the amount to be posted to the TRNS line should be negative.
Reply With Quote
Reply

Bookmarks
Bookmark and Share
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is On

Forum Jump


All times are GMT -5. The time now is 01:39 AM.


 

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
All contents copyright (c) by AccountingUsers Inc.