BooksReady

Convert a Cash App CSV to QuickBooks Online

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. QuickBooks Online imports bank CSV files with exactly 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit), one header row and one date format throughout. Drop the file below. It is converted on your device and never uploaded.

Convert your file

Cash App to QuickBooks Online (CSV)

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

Imported raw, QuickBooks Online sees more than a dozen columns and has to be told which one is the amount; pick Amount and the fees vanish, pick Net Amount and gross income is understated. Failed payments are in the file too, and they never moved money.

QuickBooks Online maps the first row as column names and expects every following row to be a transaction. Extra header lines, balance and total rows, currency symbols, and cells that contain only zero are common reasons an upload fails or imports wrong amounts.

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 requires

  • Columns exactly Date, Description, Amount.
  • Money in is positive, money out is negative; no currency symbols or thousands separators.
  • One date format for the whole file.
  • Up to 1,000 rows and 350 KB per upload (we split bigger files).

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 receives

After: cashapp-2026-01-10-to-2026-01-23-quickbooks-3col.csv
DateDescriptionAmount
01/10/2026Bitcoin Sell10.00
01/10/2026Fee: Bitcoin Sell-0.20
01/15/2026Taylor Example - 1,250 Payment From Taylor Example1250.00
01/18/2026Add Cash200.00
01/20/2026Bitcoin Buy-4.90
01/20/2026Fee: Bitcoin Buy-0.10

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

  1. Go to Transactions > Bank transactions > Link account (or Update) > Upload from file.
  2. Choose this CSV and the account to put it in.
  3. Map the columns: Date to Date, Description to Description, Amount to Amount (one column).
  4. Pick the date format MM/dd/yyyy (or the one you chose here) and confirm that the first row is a header.
  5. Review the transactions under For review.

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.
Should I choose 3 columns or 4 columns?
Both import the same transactions. The 3-column file has one signed Amount, negative for money out. The 4-column file splits money in (Credit) and money out (Debit) and leaves the unused side blank, which is what Intuit asks for. Use 3 columns unless your accountant prefers the other; switch "To" in the converter to get the 4-column file.
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.
Why does QuickBooks reject my file as too large?
Intuit documents a limit of 350 KB and 1,000 lines per manual upload in QuickBooks Online. When your converted file is bigger, the converter also gives you numbered parts that each fit; upload them one after another.

Other ways to convert Cash App

Other exports to QuickBooks Online (CSV)

Common import problems