This program is designed to convert CSV files to Quickbooks IIF format. It also can code your transactions before they are imported into Quickbooks by searching the transaction descriptions for keywords and coding accordingly. Useful with web transaction ledgers that don't support Quickbooks.
It has only been tested with Quickbooks 2012, but may work with other versions.
- Copy the included files to your PHP-enabled web server.
- Make sure MySQL is installed on your server.
- Edit config.php, and enter your MySQL credentials like so:
$sql_user = " ... ";
$sql_pass = " ... ";
$sql_server = "localhost"; //or put your external hostname here
- Load the main page in your browser:
http://servername/iif - Set up your account codes under 'Manage Codes' i.e.:
Advertising 6020 Bank Service Charges 6060 Business License & Fees 6090 Car/Truck Expense 6100
- Under 'Manage Aliases', start by adding your most common payees. When you add records here, the software will look for the 'Search String' and substitute it for the full string in the 'Alias' column. Useful for hard-to-read POS output seen on statements. ie, LITTLE CAESA becomes Little Caesar's. Select the accounting code from the dropdown box and click 'Save'.
- Go back to the main 'Conversion' page
- Enter your bank account name as it is shown in QuickBooks
- Select transaction type (Checks and Deposits must be processed separately)
- The default format string works in most cases
- Paste or load your CSV data from a file. Make sure the data is free from extraneous commas and apostrophes, these will not import correctly. Amounts should be positive for both checks and deposits, omitting the dollar sign.
- Click 'Upload'
- Copy the output and paste it into Notepad (or a plain text editor) and save to a .iif file.
- Open Quickbooks, and import from IIF file and chose your saved file.
- Check your ledger and make sure the amount is balanced.
This software is free to use under the MIT license.
Gregory Hedrick www.pixiitech.net