Bank-by-bank PDF statement layouts (Chase, Bank of America, Wells Fargo, Capital One, RBC, TD) and
sample download files. QFX and OFX are tagged text files that banks and card issuers offer as
transaction downloads. OFX (Open Financial Exchange) is the open standard, and
QFX is OFX with Intuit's INTU.BID tag added so Quicken accepts it. Neither
carries an opening balance, so a download alone can't prove a month is
complete.
| Folder | Format | Guide |
|---|---|---|
qfx/ |
Quicken Web Connect (OFX with Intuit's INTU.BID tag) | What is a QFX file? The format line by line |
ofx/ |
Open Financial Exchange, 1.x SGML and 2.x XML | What is an OFX file? How the format is put together |
chase/ |
Chase business checking PDF layout, with a converted sample month | Chase bank statement to Excel |
bank-of-america/ |
Bank of America business statement layout and how its section names changed | Bank of America statement to Excel |
wells-fargo/ |
Wells Fargo's single transaction table with separate credit and debit columns | Wells Fargo statement to Excel |
capital-one/ |
Capital One credit card statement: which sections become rows and how the card proof works | Capital One statement to Excel |
rbc/ |
RBC Royal Bank business chequing: debit and credit columns, dates without a year, a sample month in CAD | Bank statement converter |
td/ |
TD Canada Trust business chequing: same debit and credit pattern with a different column order, a sample month in CAD | Bank statement converter |
Every bank name, account number, payee and amount in these files is made up.
balances.csv lists each sample's printed opening and closing balance.
check_samples.py proves every month against them, and also checks the CSV
shape: the header Date,Description,Type,Amount, ISO dates inside one
calendar month, two-decimal amounts and no blank descriptions.
$ python3 check_samples.py
chase USD 6 rows 8642.18 -> 9877.33 ties
bank-of-america USD 6 rows 21406.90 -> 24311.35 ties
wells-fargo USD 5 rows 5318.44 -> 8191.26 ties
capital-one USD 6 rows 3846.20 -> 3733.64 ties
rbc CAD 6 rows 8240.19 -> 10742.35 ties
td CAD 5 rows 3105.60 -> 5883.12 ties
Run it on your own conversion by adding a folder and a row to balances.csv.
A month that doesn't tie prints the gap, which is usually one misread or missing
row. Python 3, standard library only.
- Open a
.qfxor.ofxfile in any text editor. The comments explain each block. - Strip the comments before testing an import, because some readers reject them.
- To read either format in code, the open-source Python library
ofxtoolshandles OFX 1.x, OFX 2.x and QFX.
The content and data in this repository are licensed under CC BY 4.0. Free to use and adapt with credit to ZeraBooks.
Maintained by ZeraBooks. ZeraBooks itself reads PDF statements and writes Excel or CSV checked against each statement's printed opening and closing balances; it does not read or write QFX or OFX files. Corrections and additional formats are welcome as pull requests.