cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Super Contributor **

Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Screen capture below is an IIF file for invoice capture from the Internet. I don't the differences among the following keywords:

  1. ACCNT
  2. INVITEM
  3. TRNS,SPL

Can anyone explain to me?

Invoice.iif.gif

Solved
Best answer 10-28-2018

Accepted Solutions
Established Community Backer ***

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

It's not Inventory Item. It's just your Items, from your items list. "Charge items" = INVITEM. "Invoice or sales" item.

 

It helps to start with the QB program interface, before trying to code .iif (Intuit Interchange Format).

 

Transaction = the Input forms on screen, such as Invoice and Check and Credit Card Charge and Sales Receipt and Bills. In the Purchase transactions, you see the Top part = that Transaction. For Customer Activities, the Transaction is the part that is Header = has the Customer Name info and other sales or order info on it. That is the TRNS = Transaction Type.

 

Splits are the Details. The Bottom part of a Write Check, enter bill, credit card charge = the expenses and items tab. For Sales, that is the Details = charge items and taxes.

 

Details total the Amount on the TRNS.

 

It isn't clear why you want to use this; there are conflicts to be aware of. This is Coding. You can include INVITEM (item listings) with a different Account linked to them here, than is in your real QB file, in that relational database. The customer info in the Sales receipt or Invoice stream from the .iif will never access the Customer Name info in the QB file; terms, etc need to be provided in that stream.

 

And lastly, these are often not fully relational to the file, when imported. Part of housekeeping is to Rebuild the file once in a while.

 

And there are certain transactions that cannot be imported, such as Paycheck details.

 

Imported transactions are not Linked. Importing invoices, and later, their payments, will not stop the Aging reporting from showing everything, until you use the QB interface to apply the payment credits to the open invoice charges.

View solution in original post

10 Comments
Anonymous
Not applicable

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hey @BenTam,

 

It looks like:

  • ACCT is Account
  • INVITEM is Invoice Item (or data fields related to invoices, like Sales Tax),
  • TRNS,SPL is Transaction and Split Transaction.

 

I don't pull IIFs very often, but here's a bit of documentation on what you can do with these files.  Try creating data points for each of those on an invoice and then double check the IIF. 

 


 

Getting Started with QuickBooks Online

QuickBooks Team

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi there, BenTam,

 

Welcome to the Community. Let's get this concern straightened out for you.

JamesOngs' answer is correct those are abbreviations for specific accounting terms.

 

Also, I got here an article that you could refer to about IIF overview for your future reference: https://community.intuit.com/articles/1501233.

 

That should do it. Don't hesitate to reach back out to us if you have further questions. Have a great day!

Super Contributor **

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

James,


Thanks for your reply.

Then what is the field ACCNT in INVITEM for?  I am not quite understand the use of SPLIT. Could you explain?

Super Contributor **

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi Betty,

Thanks for your reply. The links you provided are useful.

Anonymous
Not applicable

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hey @BenTam,

 

Each Inventory Item is tied to an account (generally an income account). If this field is nestled under an inventory on the IIF, I am fairly certain it's this attached account. Have a look at a few of your current inventory items to verify. 

 

A split is when you split the money from a transaction (either income or an expense) between two or more accounts. For instance, let's say you received $100 from an invoice, but you'd want to track the money in two different expense accounts - you could split the money and put $50 in each income account. 

 

Does that make more sense? 

Super Contributor **

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi James,

 

Thanks for your reply. I will do a test later.

 

QuickBooks Team

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi @BenTam.

 

That's great to hear. 

 

Let me know how the test goes, I want to ensure this is all making sense for you.

Super Contributor **

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi SterlingD,

FYI I decide to use the "Invoice (Sales Tax Preference=off).iif" template. Thus I will not do the test.

Established Community Backer ***

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

It's not Inventory Item. It's just your Items, from your items list. "Charge items" = INVITEM. "Invoice or sales" item.

 

It helps to start with the QB program interface, before trying to code .iif (Intuit Interchange Format).

 

Transaction = the Input forms on screen, such as Invoice and Check and Credit Card Charge and Sales Receipt and Bills. In the Purchase transactions, you see the Top part = that Transaction. For Customer Activities, the Transaction is the part that is Header = has the Customer Name info and other sales or order info on it. That is the TRNS = Transaction Type.

 

Splits are the Details. The Bottom part of a Write Check, enter bill, credit card charge = the expenses and items tab. For Sales, that is the Details = charge items and taxes.

 

Details total the Amount on the TRNS.

 

It isn't clear why you want to use this; there are conflicts to be aware of. This is Coding. You can include INVITEM (item listings) with a different Account linked to them here, than is in your real QB file, in that relational database. The customer info in the Sales receipt or Invoice stream from the .iif will never access the Customer Name info in the QB file; terms, etc need to be provided in that stream.

 

And lastly, these are often not fully relational to the file, when imported. Part of housekeeping is to Rebuild the file once in a while.

 

And there are certain transactions that cannot be imported, such as Paycheck details.

 

Imported transactions are not Linked. Importing invoices, and later, their payments, will not stop the Aging reporting from showing everything, until you use the QB interface to apply the payment credits to the open invoice charges.

View solution in original post

Super Contributor **

Re: Differences among ACCNT, INVITEM and SPL in IIF for Invoices

Hi qbteachmt. Thanks for your reply which provide me with much information.

Need to get in touch?

Contact us