Skip to content

About

Bank-by-bank statement layouts (Chase, Bank of America, Wells Fargo, Capital One) with converted sample months, plus fictional sample QFX and OFX files.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

7 Commits

Folders and files

Repository files navigation

Bank statement formats

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.

Check every sample month

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.

How to use these files

  • Open a .qfx or .ofx file 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 ofxtools handles OFX 1.x, OFX 2.x and QFX.

License

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.

About

Bank-by-bank statement layouts (Chase, Bank of America, Wells Fargo, Capital One) with converted sample months, plus fictional sample QFX and OFX files.

Topics

Resources

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages