Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add support for IIF files (quickbooks) #23

Open
andreva7 opened this issue Jan 29, 2022 · 3 comments
Open

Add support for IIF files (quickbooks) #23

andreva7 opened this issue Jan 29, 2022 · 3 comments

Comments

@andreva7
Copy link
Collaborator

I want to download data from paypal. They support qif, but only for US accounts ?!?!?!? They support IIF for canadian accounts.

@clovett
Copy link
Collaborator

clovett commented Jan 29, 2022

Can you help me find the right specification for IIF ?

@jpdup
Copy link
Member

jpdup commented Jul 14, 2024

Interesting format, it almost looks like CSV content that has multiple doc in a single file, below is the cotent of a single file called "Bill.iif"

!ACCNT	NAME	ACCNTTYPE	DESC	ACCNUM	EXTRA																										
ACCNT	Accounts Payable	AP		2000																											
ACCNT	Utilities:Water	EXP	Water	6410																											

!INVITEM	NAME	INVITEMTYPE	DESC	PURCHASEDESC	ACCNT	ASSETACCNT	COGSACCNT	QNTY	QNTY	PRICE	COST	TAXABLE	PAYMETH	TAXVEND	TAXDIST	PREFVEND	REORDERPOINT	EXTRA													
INVITEM	inventory item	INVENTORY			income	Inventory Asset	Cost of Goods Sold	10	250	50	25	N					1														
!CLASS	NAME																														
CLASS	class																														

!CUST	NAME	BADDR1	BADDR2	BADDR3	BADDR4	BADDR5	SADDR1	SADDR2	SADDR3	SADDR4	SADDR5	PHONE1	PHONE2	FAXNUM	EMAIL	NOTE	CONT1	CONT2	CTYPE	TERMS	TAXABLE	LIMIT	RESALENUM	REP	TAXITEM	NOTEPAD	SALUTATION	COMPANYNAME	FIRSTNAME	MIDINIT	LASTNAME
CUST	Customer	Joe Customer	444 Road Rd	"Anywhere, AZ 85740"	USA							5554443333					Joe Customer				N								Joe		Customer

!VEND	NAME	PRINTAS	ADDR1	ADDR2	ADDR3	ADDR4	ADDR5	VTYPE	CONT1	CONT2	PHONE1	PHONE2	FAXNUM	EMAIL	NOTE	TAXID	LIMIT	TERMS	NOTEPAD	SALUTATION	COMPANYNAME	FIRSTNAME	MIDINIT	LASTNAME							
VEND	Vendor		Jon Vendor	555 Street St	"Anywhere, AZ 85730"	USA			Jon Vendor		5555555555											Jon		Vendor							

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	CLEAR	TOPRINT	ADDR5	DUEDATE	TERMS																	

!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO	CLEAR	QNTY	REIMBEXP	SERVICEDATE	OTHER2																	

!ENDTRNS																															
TRNS		BILL	7/16/1998	Accounts Payable	Vendor	class	-59.25			N	N		8/15/1998	Net 30																	
SPL		BILL	7/16/1998	Utilities:Water	Customer	class	59.25			N		NOTHING	0/0/0																		
ENDTRNS

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants