BooksReady

Cash App CSV to QBO for QuickBooks

In short: Cash App exports one CSV of all activity, newest first, with separate Amount, Fee and Net Amount columns, a Status on every row, and dates that carry a time zone. A .qbo file is Intuit's Web Connect format: an OFX bank statement that also carries an Intuit bank identifier (INTU.BID). QuickBooks Online and QuickBooks Desktop read it without a column-mapping step. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Cash App to QuickBooks (.qbo Web Connect)

cash_app_report_<number>.csv

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

One email when it ships. The address is used for nothing else. Details.

1. Export the file from Cash App

  1. Sign in at cash.app/account on a computer.
  2. Open Activity (or Statements).
  3. Click Export CSV.
  4. Upload the downloaded cash_app_report file here.

Why a raw Cash App export fails in QuickBooks Online and QuickBooks Desktop

Cash App does not offer a .qbo, .qfx or .ofx download, so the CSV has to be rebuilt as a bank statement file containing only the rows that moved money.

QuickBooks cannot read a payment app CSV as a .qbo file, and renaming the file does not help. A .qbo file needs the OFX statement structure, an account type that matches the QuickBooks account you upload into, and an Intuit bank identifier.

What is unusual about the Cash App file

  • Two column orders exist: older files start with Transaction ID, newer files (late 2024 on) start with Date.
  • Dates include a time zone abbreviation, for example "2024-09-26 16:18:23 EDT".
  • Amounts look like "$10.00" and "-$5.00"; older files drop zero cents ("$2").
  • Fees are negative and Net Amount is Amount plus Fee.
  • Rows are newest first. Failed rows and $0 notification rows are left out.
  • Transaction ID is often blank for newer files.

What QuickBooks Online and QuickBooks Desktop requires

  • OFX 1.0.2 SGML file carrying an Intuit bank id (INTU.BID 3000, a bank Intuit's published list shows as active for Web Connect).
  • QuickBooks US needs US dollars; QuickBooks Canada takes CAD or USD with bank id 2.
  • QuickBooks Online: up to 1,000 transactions and 350 KB per upload (we split bigger files between days where possible).
  • Each transaction id is built from its date, amount, description and platform id, so the same row in two overlapping exports gets the same id.
  • Credit card accounts must be exported with account type "credit card".
  • QuickBooks Desktop only imports Web Connect in its supported (recent) releases.

2. Before and after

Before: the Cash App CSV as downloaded

"Date","Transaction ID","Transaction Type","Currency","Amount","Fee","Net Amount","Asset Type","Asset Price","Asset Amount","Status","Notes","Name ...
"2026-01-24 20:39:52 EST","","Account Notifications","USD","$0.00","","$0.00","","","","COMPLETE","New device login","","Cash Balance"
"2026-01-23 11:02:10 EST","#D-824TESTAB","P2P","USD","-$5.00","$0.00","-$5.00","","","","COMPLETE","$5 Payment To Jamie Fakename","Jamie Fakename",...
"2026-01-22 09:30:00 EST","306150405514408","Withdrawal","USD","-$150.00","$0.00","-$150.00","","","","COMPLETE","Cash Out","","SAMPLE BANK"
"2026-01-20 14:15:45 EST","","Bitcoin Buy","USD","-$4.90","-$0.10","-$5.00","BTC","$63,371.65","0.00007732","COMPLETE","","","Cash Balance"
"2026-01-18 08:00:00 EST","","Deposits","USD","$200.00","$0.00","$200.00","","","","COMPLETE","Add Cash","","Visa debit 3333"
"2026-01-15 17:45:12 EST","#D-123TESTCD","P2P","USD","$1,250.00","$0.00","$1,250.00","","","","COMPLETE","$1,250 Payment From Taylor Example","Tayl...
"2026-01-15 17:45:12 EST","","P2P","USD","$20.00","$0.00","$20.00","","","","FAILED","$20 Payment From Taylor Example","Taylor Example","Cash Balance"
"2026-01-10 12:00:00 EST","","Bitcoin Sell","USD","$10.00","-$0.20","$9.80","BTC","$61,000.00","0.00016393","COMPLETE","","","Cash Balance"

After: what QuickBooks Online and QuickBooks Desktop receives

...
<STMTTRN>
<TRNTYPE>CREDIT</TRNTYPE>
<DTPOSTED>20260110120000</DTPOSTED>
<TRNAMT>10.00</TRNAMT>
<FITID>B2FEADCC78F6DD76G</FITID>
<NAME>Bitcoin Sell</NAME>
</STMTTRN>
<STMTTRN>
<TRNTYPE>DEBIT</TRNTYPE>
<DTPOSTED>20260110120000</DTPOSTED>
<TRNAMT>-0.20</TRNAMT>
<FITID>B2FEADCC78F6DD76F</FITID>
<NAME>Fee</NAME>
<MEMO>Fee: Bitcoin Sell</MEMO>
</STMTTRN>
...

Synthetic sample data that follows the real export layout, not a real account. The "after" output was produced from it by the same converter this page runs.

3. Import the converted file into QuickBooks Online and QuickBooks Desktop

  1. QuickBooks Online: go to Transactions > Bank transactions, click Link account (or Update) > Upload from file.
  2. Choose this .qbo file, pick the QuickBooks account to put it in, and click Continue.
  3. QuickBooks Desktop: File > Utilities > Import > Web Connect Files, choose the file, then pick or create the account.
  4. Review the transactions under For review and add or match them.

Questions

Are Bitcoin and stock purchases income or expenses?
Neither. Buying Bitcoin or stock moves money from your Cash App balance into an investment, and selling moves it back. In your books these are transfers to an investment account, and gains or losses are a tax question for whoever prepares your return.
What does "QuickBooks is unable to verify the financial institution" mean?
It is commonly reported when the bank identifier (INTU.BID) inside a .qbo file is missing or not one QuickBooks recognizes. Files from this converter use 3000, an id listed as active for Web Connect in Intuit's published bank list. Intuit does not document exactly how QuickBooks Online checks the id.
What happens to failed payments?
Failed rows and $0 notification rows are listed in the export but never moved money, so the converter leaves them out and counts them as skipped rows.
Should I use .qbo or the QuickBooks Online CSV?
For QuickBooks Desktop, use .qbo: Web Connect is how Desktop brings in bank transactions. For QuickBooks Online either works. The .qbo file skips the column-mapping step, and each transaction carries an id built from its date, amount, description and platform id, so the same row converted from two overlapping exports gets the same id.

Other ways to convert Cash App

Other exports to QuickBooks (.qbo Web Connect)

Common import problems