Data · 1 file
Sample QBO File
QuickBooks Web Connect files are OFX 1.02 (SGML) statements with an Intuit bank ID. Ours is fictional and parses with ofxparse.
QBO · 2.9 KB
QBO Web Connect file (20 transactions)
A QuickBooks Web Connect (.qbo) file: OFX 1.02 SGML with the INTU.BID tag QuickBooks requires. All accounts, routing numbers and transactions are fictional.
CC0 · free for any use · Verified by an independent tool · Report a problem
OFXHEADER:100
DATA:OFXSGML
VERSION:102
SECURITY:NONE
ENCODING:USASCII
CHARSET:1252
COMPRESSION:NONE
OLDFILEUID:NONE
NEWFILEUID:NONE
<OFX>
<SIGNONMSGSRSV1><SONRS><STATUS><CODE>0<SEVERITY>INFO</STATUS><DTSERVER>20260131120000<LANGUAGE>ENG<FI><ORG>Sample Bank<FID>9999</FI><INTU.BID>3000</SONRS></SIGNONMSGSRSV1>
<BANKMSGSRSV1><STMTTRNRS><TRNUID>1<STATUS><CODE>0<SEVERITY>INFO</STATUS><STMTRS><CURDEF>USD<BANKACCTFROM><BANKID>999999999<ACCTID>000123456789<ACCTTYPE>CHECKING</BANKACCTFROM>
<BANKTRANLIST><DTSTART>20260101<DTEND>20260131
<STMTTRN><TRNTYPE>CREDIT<DTPOSTED>20260102120000<TRNAMT>3250.00<FITID>202601020001<NAME>ACME Payroll<MEMO>Income</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260103120000<TRNAMT>-1450.00<FITID>202601030002<NAME>Sample Apartments<MEMO>Rent</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260104120000<TRNAMT>-122.68<FITID>202601040003<NAME>Grocery Market<MEMO>Groceries</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260105120000<TRNAMT>-78.61<FITID>202601050004<NAME>City Power & Light<MEMO>Utilities</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260106120000<TRNAMT>-6.92<FITID>202601060005<NAME>Coffee Corner<MEMO>Dining</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260107120000<TRNAMT>-37.00<FITID>202601070006<NAME>Online Bookstore<MEMO>Shopping</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260108120000<TRNAMT>-25.00<FITID>202601080007<NAME>Transit Pass<MEMO>Transport</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260109120000<TRNAMT>-38.29<FITID>202601090008<NAME>Gas Station<MEMO>Auto</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260110120000<TRNAMT>-55.18<FITID>202601100009<NAME>Grocery Market<MEMO>Groceries</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260111120000<TRNAMT>-89.25<FITID>202601110010<NAME>City Power & Light<MEMO>Utilities</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260112120000<TRNAMT>-7.96<FITID>202601120011<NAME>Coffee Corner<MEMO>Dining</STMTTRN>File details
Download from the command line
curl -L -o sample-bank-statement.qbo https://files.samplefiles.com/data/qbo/sample-bank-statement.qbowget https://files.samplefiles.com/data/qbo/sample-bank-statement.qbohttps://files.samplefiles.com/data/qbo/sample-bank-statement.qboprintf '%s %s\n' 70cafdf46921558efcd26da7860a58322f0df07ca3578e24f6d95ba30496bcc9 sample-bank-statement.qbo | shasum -a 256 -cOr check the download in your browser with the checksum calculator.