Giter Site home page Giter Site logo

qiftoiif's Introduction

A Python utility to convert QIF files to IIF files.

For Luddites like me who can't quite get used to the idea of
using Mint for finances, are stuck with QuickBooks, and have
banks that refuse to pay the Intuit charge for web connect.

	status: testing

To run, 

    python src/qiftoiif.py <in.qif> <out.iif> <acct_name>

Requires that you export your chart of accounts and vendor
list from Quickbooks to the files coa.iff and vendors.iif. 
These two files are expected to be in the current working
directory of python.

To export your chart of accounts in Quickbooks,

	(1)	Open Quickbooks

	(2)	Open the "File" menu

	(3)	Pick "Export"

	(4)	Pick "Lists to IIF File"
	
	(5)	Check the "Chart of Accounts" box (and only
		that box).

	(6)	Click OK

	(7)	Enter coa.iff as the filename and save to
		the same directory as the qiftoiif.py script.

Vendor export is identical, but check the "Vendor List" box
in step (5).

Files in ./src/:

	tokens.py + grammar.py
		Lex and yacc combo to parse qif files.
	qif.py
		Data structures that store result of parsing
		qif file.
	coa.py + vendors.py
		Interface to Chart of Accounts and Vendor list
		exports from QuickBooks.
	interpreter.py
		Another lex and yacc combo, this time to parse
		user input in response to prompts about current
		QIF record.  Lots of code, but main purpose
		is to assign an account to the payee.
	vendoraccount.py
		Save account/vendor associations to save data entry.
		One QuickBooks feature I really like.
	iif.py
		Logic that outputs IIF text.

qiftoiif's People

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.