Lloyd's PayPal CSV to QIF Converter

Access the Converter.

About This Tool

Shockingly, PayPal's QIF history download does not contain all transactions affecting your balance. Transactions which are refunded or partially refunded, as well as temporary holds, do not appear at all in the PayPal QIF download. This glaring error makes the PayPal QIF history download practically useless to import transactions into business accounting software such as gnucash.

Fortunately, PayPal's CSV (comma-separated value) "balance-affecting transctions" history download DOES contain the transactions missing from PayPal's QIF history download. However, gnucash (and probably other accounting software) cannot import CSV files, at least not easily.

This tool allows you to easily convert your PayPal CSV "balance-affecting transactions" history download to QIF format, ready to import into gnucash or other accounting software. Note that gnucash QIF import wizard "remembers" the proper expense and income accounts for your frequent transactions, whereas I believe Quickbooks does not.

Security

I have gone to lengths to make this a safe, secure tool. Data is encrypted via SSL (Secure Socket Layer) as it is transmitted to and from my server in USA. The QIF files are stored using a random filename, and are removed from the server after approximately 30 minutes. In my opinion, if you trust SSL to transmit your credit card data over the Internet, you can trust this tool with your financial data. Still, the usual disclaimer applies: neither I nor Tropical Health Foods LLC will assume any liability for losses of any kind, real or imagined, resulting from the use of this tool.

Donation

If you use this tool and would like to thank me, you can email me. I also appreciate donations: PayPal Me

---

Stand-alone Version

A stand-alone version written in perl is available here. It is a perl command-line program. It can process any number of CSV files, more quickly than this online converter. It can also convert files of any size. (The online converter is limited to files under MB.) Perl is required and is available for both Windows and Linux. It is generally installed by default in Linux. I cannot help you install perl in Windows, but I suggest http://strawberryperl.com/.