Stubbook help
Open a QFX, OFX, QBO or QIF file without Quicken
You downloaded your account activity from the bank, double-clicked the file, and Windows asked which app should open it. Here is what the file is and what you can do with it.
What the files are
- QFX is a bank statement in the format Quicken reads. Banks label it "Quicken", "Quicken Web Connect" or "QFX". Inside, it is the same thing as an OFX file with one extra line naming the bank.
- OFX (Open Financial Exchange) is the same kind of statement in the open format. Banks often label it "Microsoft Money" or "OFX". It holds each line with the bank's own number for it, and the balance on the statement date.
- QBO is the same statement again, labelled for QuickBooks (the "QuickBooks" or "QuickBooks Web Connect" choice on the download menu). Under its different name it is an OFX file.
- QIF is an older, simpler list of register lines. Some banks still offer it, and Quicken and Microsoft Money can export it.
None of them is a program or a document you can read in Word. They are plain text meant for a checkbook or money program, which is why Windows has nothing to open them with until you install one.
Where the download button is
- Sign in to your bank's website on a computer (most phone apps can't download these files).
- Open the account (checking, savings or a credit card) and look for Download, Export, a downward arrow, or a link under Activity or Statements.
- Pick the dates you want, then the file type: choose Quicken (QFX), Microsoft Money (OFX), OFX or QuickBooks (QBO) if they are offered; QIF or CSV (sometimes called Excel or spreadsheet) otherwise.
- Save it. It lands in your Downloads folder with a name like Checking1114.qfx.
What Stubbook does with one
Stubbook is a checkbook register for Windows: one line per check, deposit or card payment, with a running balance on every line. Double-click the bank's file (or right-click it, then Open with › Stubbook, or drop it on Stubbook's window):
- No register yet? "Start my register from this file" makes the account (named like "Checking ··4417"), works the starting balance back from the bank's balance, and brings every line in ticked cleared. Your own checkbook, agreeing with the bank, in under a minute.
- Already keeping one? Lines you wrote yourself are matched (same amount within 6 days, and the same check number when both have one) and ticked cleared. Lines you hadn't written, like a service charge, are listed for you to tick; nothing is added on its own. One Undo takes the whole file back out.
- No doubles next month. Stubbook remembers the bank's own number for each line, so downloading an overlapping month never brings a line in twice.
- Your bank says, your register says. After the file comes in, Stubbook shows the bank's balance on the statement date beside yours, and Reconcile to this statement opens the reconcile with that date and balance filled in.
- Card statements, savings accounts and files with several accounts in them work too. Investment accounts in the same file are left out, and Stubbook says so.
Nothing is uploaded
Stubbook reads the file where it is, on your PC. It never connects to the internet (it refuses every network request), never asks for your bank login, and keeps only the last 4 digits of the account number. The file isn't copied anywhere; you can delete it from Downloads afterwards.
If Windows asks which app to use
Windows lists the apps that can open the file. Pick Stubbook, and tick "Always use this app" only if you want that; Stubbook never makes itself the default on its own. If Stubbook isn't installed, "Browse apps in the Microsoft Store" opens the Store on apps for that kind of file.
What it costs
$6.99 once from the Microsoft Store, with a 7-day free trial. No subscription, no account, nothing to renew.
More: Stubbook help · privacy · hello@tomorrowish.dev (if a bank's file won't read, say which bank; if you send a sample, remove the account numbers first).