Tracking PayPal, Venmo, and Cash App income for taxes (1099-K workflow)

If you get paid through PayPal, Venmo, or Cash App and you're self-employed, tax season now involves a form most freelancers didn't used to think about: the 1099-K. The IRS has been steadily lowering the reporting threshold, and payment platforms are now required to report much smaller freelance-scale income than they used to. Which means reconciling what the platform reported to the IRS against what you actually earned matters more than ever.

This guide walks through the tax-time workflow. Pull the statements, get them into a spreadsheet, categorize business vs. personal, cross-check against the 1099-K, and file Schedule C without missing income or over-reporting it.

What the 1099-K is (and what it isn't)

A 1099-Kis an information return that payment platforms file with the IRS when they process a certain amount of “goods and services” payments to you. The IRS gets a copy; you get a copy; and the IRS uses it to cross-check what you report on your Schedule C.

Key thing to understand: the 1099-K is a report of gross payments processed, not a report of taxable income. It doesn't know which of those payments were:

• Business revenue (taxable)
• Personal reimbursements from friends (not taxable)
• Refunds you later issued (should reduce the total)
• Platform fees you paid (deductible business expense)

That's your job to sort out — which is where the statement reconciliation workflow comes in.

The workflow, high level

1. Pull monthly statements from each payment platform for the tax year.
2. Convert to Excel (PayPal, Venmo, Cash App, Stripe).
3. In one master spreadsheet, categorize each transaction: business revenue, personal (skip), refund, fee, transfer.
4. Cross-check the sum against the 1099-K the platform sent you.
5. File the reconciled numbers on Schedule C.

Step 1: Pull the statements

For each platform, sign in and download the monthly PDF statements for the full tax year:

• PayPal: Activity → Statements → PDF for each month.
• Venmo: Statements → download PDF for each month.
• Cash App: Statements → PDF for each month.

For business use, download from your business account if you have one. If you've been using a personal account for business payments (extremely common), you'll need to sort business from personal in Step 3 — which is more work but doable.

Step 2: Convert to Excel

Twelve monthly statements per platform. Drop each into the converter, download Excel. Consolidate into one master sheet per platform with a column for source month.

See our import guide if you also want to import into QuickBooks or Xero for ongoing bookkeeping. For pure tax prep, Excel is enough.

Step 3: Categorize each transaction

Add a Category column. Then go through each row and tag it as one of:

• Business revenue. A client paid you for work. The gross amount is what counts (see fee handling below).
• Personal. Your friend paid you back for dinner. Not taxable — skip.
• Refund. You refunded a client. Reduces your gross revenue.
• Fee.Platform fee (PayPal's 2.9% + 30¢, etc). Deductible business expense.
• Transfer. You moved money to your bank. Not revenue, not an expense — just a movement.

Sort by counterparty (payer name) — this lumps all Client X's payments together, all your friends' reimbursements together, etc. Categorization goes much faster when related transactions are adjacent.

The “goods and services” vs. “friends and family” distinction

PayPal and Venmo split payments into “goods and services” (business — reported on 1099-K) and “friends and family” (personal — not reported). This distinction is usually visible on the statement — most extractions preserve it in the description field.

Rule of thumb:anything marked goods and services is presumed business. Anything friends and family is presumed personal. You can override either based on the actual nature of the payment, but you'll want a note explaining why if you diverge.

Step 4: Cross-check against the 1099-K

The platform sends you a 1099-K in January or February for the previous year. It reports the gross amount of goods-and-services payments — matching what the IRS sees.

Sum your business revenue category. That number should match (or exceed) the 1099-K figure. Common divergences:

• 1099-K higher than your total:The platform reported some “friends and family” payments as goods and services, or you missed a month of statements. Investigate before filing — you don't want to under-report.
• 1099-K lower than your total:You're reporting income the platform didn't flag as reportable — this is fine (and correct — the 1099-K is a floor, not a ceiling).
• Your total matches within a few dollars:You're good. File Schedule C with your (correct) total.

Step 5: File Schedule C

Your total business revenue goes on Schedule C Line 1. Platform fees go on Line 18 (“Other expenses” if your accounting software puts them there, or Line 20a if categorized as commissions/fees).

Keep the reconciled spreadsheet, the PDF statements, and the 1099-Ks for at least three years — the IRS's standard audit lookback. If they ever question your Schedule C numbers, the spreadsheet is what shows you did the work.

What about the fees you paid on outgoing payments?

If you paid contractors or vendors through PayPal/Venmo/Cash App (some platforms charge a small fee for business payments to international recipients or for certain payment methods), those fees are deductible too. Same category as the fees on incoming payments — “Payment processing fees.”

The outgoing payments themselvesare contractor expenses, materials, or whatever category matches the underlying purchase. Don't lump them together — the IRS distinguishes between different expense types on Schedule C.

Doing this monthly instead of once a year

Everything above is easier if you don't leave a full year until March. The habit is: at the start of each month, download the previous month's PDF, convert it, categorize the transactions, and file it. Ten minutes a month replaces a stressful weekend in March.

If that's a bridge too far, quarterly is the next-best cadence. And if you're reading this in April and panicking about last year — you can catch up in an evening if you follow the workflow. It's not fun but it's doable.