Open qif file

broken image
broken image

However, the format is very old now (older than OFX, even). QIF, or Quicken Interchange Format, is a file format developed by Intuit initially for use in their QuickBooks product. Different banks use different header names for the amount, reference and so on, and hard coding every single bank is nigh on impossible. Most banks will allow you to export your bank statement as a CSV, but what a lot of them don’t tell you is how terribly structured these CSV files are. If you’ve ever tried to complete a data science project that revolves around personal finances, you’re probably familiar with the joys of bank-exported CSV files for transaction data.