Skip to main content

Convert financial transactions in CSV format to QIF files.

Project description

csv2qif

Usage

CSV to QIF

usage: csv2qif [-h] [--verbose] [-v] -a ACCOUNT -t ACCOUNT_TYPE 
               [-i INPUT_FILE] [-o OUTPUT_DIR] [-f OUTPUT_FORMAT] [-c COL_SPEC] [-b BACKUP_INPUT]

Convert financial transactions in CSV format to QIF files.

options:
  -h, --help            show this help message and exit
  --verbose
  -v, --version         show program's version number and exit
  -a ACCOUNT, --account ACCOUNT
                        The full hierarchical name of the account in GnuCash.
                        (default: None)
  -t ACCOUNT_TYPE, --account-type ACCOUNT_TYPE
                        One of "Bank", "Cash", "CCard", or "Invst"
                        (default: None)
  -i INPUT_FILE, --input-file INPUT_FILE
                        Input file in CSV format; define location of required fields using "col-spec"
                        (default: stdin)
  -o OUTPUT_DIR, --output-dir OUTPUT_DIR
                        Directory to write output
                        (default: stdout)
  -f OUTPUT_FORMAT, --output-format OUTPUT_FORMAT
                        Format of output, either "qif" or "json"
                        (default: qif)
  -c COL_SPEC, --col-spec COL_SPEC
                        Specify column of required fields (date, name, amount, check_number)
                        (default: {"date": 1, "name": 2, "amount": 3, "check_number": 6})
  -b BACKUP_INPUT, --backup-input BACKUP_INPUT
                        Save a copy of input CSV alongside the QIF file, with same filename.
                        (default: None)

MIT License: ©2023 Edward Q. Bridges

Development

  1. It is recommended to use pyenv to ensure correct python version is in use. Cf.: .python-version
  2. Set up virtualenv: python -m venv venv
  3. Activate virtualenv: source ./venv/bin/activate
  4. Update pip: pip install --upgrade pip

Release process

  1. Format code using: black .
  2. Commit/push all final code.
  3. Increment version in csv2qif/__init__.py and commit/push.
  4. Tag release in format x.y.z, using same version string as in csv2qif/__init__.py. Push tag to remote.
  5. Publish a new release version; doing so will trigger an upload to PyPI.

License

MIT

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

csv2qif-0.4.0.tar.gz (6.7 kB view details)

Uploaded Source

Built Distribution

csv2qif-0.4.0-py3-none-any.whl (7.6 kB view details)

Uploaded Python 3

File details

Details for the file csv2qif-0.4.0.tar.gz.

File metadata

  • Download URL: csv2qif-0.4.0.tar.gz
  • Upload date:
  • Size: 6.7 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.11.2

File hashes

Hashes for csv2qif-0.4.0.tar.gz
Algorithm Hash digest
SHA256 c84f51615b3176ae3dc04d3afe05966346ec9b7d26ea9dfa53e64d79b6233a6f
MD5 b9d15a582cfe1fb0a2621bdf84dc6c05
BLAKE2b-256 14833c1078a5948740a0dca68c5b8615f835cd7fc997ff5347dd15ce27c53173

See more details on using hashes here.

File details

Details for the file csv2qif-0.4.0-py3-none-any.whl.

File metadata

  • Download URL: csv2qif-0.4.0-py3-none-any.whl
  • Upload date:
  • Size: 7.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/4.0.1 CPython/3.11.2

File hashes

Hashes for csv2qif-0.4.0-py3-none-any.whl
Algorithm Hash digest
SHA256 314947c4fb90d065c7332419c42d05510c46dfcf6ca7af3a6d2214508efcb04d
MD5 d42cdebbed96f5035142a3c35ae8e2fa
BLAKE2b-256 cbcad227064ee2ca63e024e92d912bb4978d8044691af31708c4326fef8eb02f

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page