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

sample-bank-statement.qbo — first lines
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 &amp; 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 &amp; Light<MEMO>Utilities</STMTTRN>
<STMTTRN><TRNTYPE>DEBIT<DTPOSTED>20260112120000<TRNAMT>-7.96<FITID>202601120011<NAME>Coffee Corner<MEMO>Dining</STMTTRN>

File details

Size
2.9 KB (3,029 bytes)
MIME type
application/vnd.intu.qbo
Rows
19
SHA-256
70cafdf46921558efcd26da7860a58322f0df07ca3578e24f6d95ba30496bcc9
MD5
a95c267c56e9e95c0012ed4661c2f9a4

Download from the command line

curl -L -o sample-bank-statement.qbo https://files.samplefiles.com/data/qbo/sample-bank-statement.qbo

Or check the download in your browser with the checksum calculator.