Convert QFX to CSV

Script to convert and patch qfx files to csv files.

Table of Contents

1. About The Project
2. Getting Started
   • Prerequisites
   • Installation
3. Usage
4. License
5. Contact

About The Project

This is a quick and dirty script to convert and patch *.qfx files to CSV files. It will:

• process all *.qfx files in the ~/Downloads folder
• output each file as *-patched.csv in the ~/Downloads folder
• patch the Payee and Category fields based upon a mappings file
• create/update the memo field for bank transactions

Notes:

• All folder locations and filenames can be easily adjusted at the top of the index.js file.

(back to top)

Getting Started

Prerequisites

1. Create a transaction mapping file, ~/Documents/Financial/transaction-mappings.json. It is a basic json dictionary, for example:

{
   "AA WINDOW & GUTTER": {"payee": "AA Window & Gutter", "category": "Home"},
   "ADTSECURITY": {"payee": "ADT Security ↺", "category": "Bills & Utilities"},
   "ALASKA AIRLINES": {"payee": "Alaska Airlines", "category": "Travel"},
}

where the key is a regular expression that will match on payee or memo/note fields.

Installation

1. Clone the repo.

   git clone https://github.com/michaelpmaley/convert-qfx.git

2. Install NPM packages: csvjson, dayjs, ofx-js.

   npm install

(back to top)

Usage

1. Browse to each financial institution and download the latest transactions in Quicken (qfx) format.

2. In the project folder, run the script.

   npm run start

3. Import each *-patched.csv file into the financial application.

(back to top)

License

Distributed under the MIT License. See LICENSE for more information.

(back to top)

Contact

Your Name - @twitter_handle - email@email_client.com

Project Link: https://github.com/michaelpmaley/convert-qfx

(back to top)