If you have ever tried to track your finances by manually typing transactions into a spreadsheet, you know how tedious and error-prone it gets. JE-PFM eliminates that pain by letting you import bank statements directly. The whole process takes about 60 seconds.
What Are OFX and QFX Files?
OFX (Open Financial Exchange) is a standardized data format that banks use to export transaction history. QFX is Quicken's branded version of the same format. Unlike CSV exports, which vary wildly between banks, OFX files follow a strict specification. That means every transaction comes with a unique identifier (FITID), proper dates, signed amounts, and merchant details. JE-PFM uses these identifiers to automatically prevent duplicate imports, so you never have to worry about double-counting.
Downloading From Your Bank
Most banks offer OFX or QFX downloads from their online banking portal. Here is the general process:
- Log into your bank's website or app
- Navigate to your account's transaction history
- Look for a "Download" or "Export" option (often found near the date range selector)
- Choose OFX, QFX, or "Microsoft Money" as the format
- Select your desired date range and download the file
If your bank only offers CSV, JE-PFM can handle that too, but OFX is always the better choice because of the structured data and deduplication support.
The JE-PFM Import Flow
Once you have your file, importing is straightforward:
- Upload — Drag your OFX file onto the import page or click to browse. JE-PFM instantly parses the file and shows you a preview of transactions.
- Auto-categorize — The system matches transactions to spending categories using merchant names and patterns from your history. Each match includes a confidence score so you know what was reliably categorized.
- Review — Scan through the categorized transactions. Adjust any categories that need correction. Your changes train the system to be more accurate next time.
- Done — Confirm the import. Transactions are written to your account with full deduplication against any previously imported data.
What Happens Next
After your first import, head to the insights dashboard. You will immediately see your spending broken down by category, a timeline of transactions, and your account balance history. With just one file, JE-PFM already starts showing you patterns in your spending that would take hours to uncover manually. Import a few months of history and you will have a clear picture of where your money goes.
See It In Action
Want to see the import flow working? Explore the Component Demo for a live walkthrough, or browse the import components in Storybook to see how each piece is built.