In This Article
- The Problem: Your Bank Says One Number, the IRS Says Another
- Why the Mismatch Happens: Six Root Causes
- What Gets Worse If You Ignore It
- How to Fix It: QBO Step by Step
- When to Hire a Professional
- Frequently Asked Questions
If your Stripe or Shopify deposits do not match your gross sales, you are not alone, and you are not necessarily doing anything wrong. The mismatch happens because payment processors deposit the net amount (after fees, refunds, and reserves) while the IRS receives a 1099-K reporting the gross amount. When you report only what hits your bank account, you understate both your revenue and your deductible expenses, creating a discrepancy the IRS will eventually flag. The fix is straightforward: record gross revenue on one line, then record platform fees, refunds, and chargebacks as separate expenses or contra-revenue entries in QuickBooks Online. This ensures your reported gross matches the 1099-K, your deductions are properly claimed, and your net income stays accurate. Starting in 2026, the Form 1099-K reporting threshold drops to $2,000 per payee, which means millions of additional sellers will receive these forms for the first time. If your books are not set up correctly before that threshold kicks in, you are walking into a CP2000 notice.
The Problem: Your Bank Says One Number, the IRS Says Another
Every e-commerce seller eventually notices the same thing: the total deposited into their bank account over the year does not match the gross sales figure on their Stripe dashboard, their Shopify analytics, or the 1099-K they receive in January. The gap can be significant. A business processing $250,000 in gross sales through Stripe at the standard 2.9% + $0.30 per transaction rate will see roughly $7,250 in processing fees alone deducted before the money ever reaches the bank. Add refunds, chargebacks, rolling reserves, and currency conversion adjustments, and the actual deposits could be $15,000 to $30,000 less than the gross figure reported to the IRS.
The IRS does not care what landed in your bank account. It cares about gross receipts. The 1099-K reports gross transaction volume. When the number on your tax return does not match, the IRS Automated Underreporter (AUR) program flags the discrepancy. The AUR cross-matches third-party information returns against filed tax returns, identifying over 20 million discrepancies annually. Even though the IRS processes roughly 20% of flagged returns into formal notices, that still means millions of CP2000 notices go out each year. You do not want to be on the receiving end of one.
Why the Mismatch Happens: Six Root Causes
1. Platform Fees Deducted Before Deposit
Stripe charges 2.9% + $0.30 per successful card transaction at standard rates. Shopify Payments charges variable rates depending on your plan tier, ranging from 2.4% to 2.9% + $0.30. These fees are deducted from your payout, not billed separately. A $100 sale results in a $96.80 deposit (at the 2.9% + $0.30 rate), but the 1099-K reports $100.
2. Refunds and Chargebacks Processed After the Original Sale
When you refund a customer in March for a January sale, the refund reduces your March payout. But the January sale was already counted in your gross volume. If you only record net deposits, the January revenue is overstated and the March deposit is understated. Chargebacks compound this further because they often include an additional $15 to $25 dispute fee that also reduces your payout.
3. Rolling Reserves and Payout Timing
Stripe may hold a percentage of your payouts in reserve, particularly for new accounts or businesses in higher-risk categories. Shopify Payments typically operates on a 2-business-day payout lag, but delays can stretch longer around holidays or during account reviews. Money earned in December may not deposit until January, creating cross-year timing differences that distort both your income and your bank reconciliation.
4. Currency Conversion Differences
If you sell internationally, Stripe and Shopify convert foreign currency transactions at the exchange rate on the transaction date. By the time the funds settle, the rate may have shifted. The difference, sometimes a gain, sometimes a loss, creates another line-item discrepancy between the platform dashboard and the bank deposit.
5. Multiple Deposit Batches vs. Individual Transactions
Stripe and Shopify batch multiple transactions into a single bank deposit. A single $4,300 deposit might represent 47 individual transactions across three days. If you try to match individual sales to individual deposits, you will never reconcile. The batching is by design, but it makes manual reconciliation nearly impossible without a systematic approach.
6. Tips, Shipping, and Sales Tax Included in Gross
The 1099-K gross figure includes everything the customer paid: product price, shipping charges, tips, and sales tax. Shipping you collected is revenue (offset by shipping expense). Sales tax collected is a liability, not income. Tips may or may not be taxable depending on your structure. If you do not break these components out, your gross revenue figure will be inflated or your expense deductions will be incomplete.
What Gets Worse If You Ignore It
The IRS estimates that 55% of nonfarm sole proprietor income is misreported. The projected Tax Year 2022 gross tax gap stands at $696 billion. These numbers are why the IRS has invested heavily in automated matching systems. The DIF (Discriminant Information Function) scoring system flags returns where reported income deviates from statistical norms for your industry and income level.
Audit rates for business returns range from 0.9% to 1.3%. For taxpayers with income between $1 million and $5 million, the audit rate climbs to 1.6%. But formal audits are not the primary risk. The bigger threat is the CP2000 notice, an automated letter stating the IRS believes you underreported income based on third-party data. You then have 30 days to respond with documentation or accept the proposed additional tax.
If you simply recorded net deposits as income and never claimed the processing fees as deductions, you actually understated both your gross income and your expenses. The net effect on taxable income might be zero, but the IRS does not see it that way initially. The notice assumes you failed to report the full gross amount, and the burden shifts to you to prove otherwise.
Penalties for information return failures are steep. Under IRC Section 6721, 1099 filing penalties range from $60 to $340 per form on a tiered schedule, with intentional disregard penalties reaching $680 per form. For failure to file your own return, IRC Section 6651(a)(1) imposes a penalty of 5% per month up to a maximum of 25% of the unpaid tax.
How to Fix It: QBO Step by Step
Record Gross Revenue, Not Net Deposits
This is the single most important rule. When a customer pays $100 and Stripe deposits $96.80, do not record a $96.80 sale. Record a $100 sale and a $3.20 processing fee expense. This keeps your gross revenue aligned with the 1099-K and ensures you claim the fee deduction.
Create Dedicated Accounts in Your Chart of Accounts
Set up the following expense accounts:
- Stripe Processing Fees (Cost of Goods Sold or Expense, depending on your preference and industry) - Shopify Fees (includes subscription fees, transaction fees, and app charges) - Chargebacks and Dispute Fees (separate from refunds for clearer reporting) - Refunds Issued (contra-revenue account that offsets gross sales)
Use the Undeposited Funds Workflow for Batch Deposits
When Stripe or Shopify batches multiple transactions into a single deposit:
- Record each sale individually as a Sales Receipt or Invoice Payment, posting to the Undeposited Funds account. 2. Create a Bank Deposit in QBO, selecting all the individual transactions that make up that single bank deposit. 3. Add a negative line for processing fees so the deposit total matches the actual bank deposit amount.
This approach lets you track gross revenue at the transaction level while matching batched deposits to your bank statement.
Reconcile Platform Dashboard to Bank Deposits Monthly
Do not wait until year-end. At the close of each month:
- Download the Stripe or Shopify payout report for the month. 2. Compare total payouts to total deposits in your bank account for that period. 3. Identify any timing differences (payouts initiated in late month but deposited in the following month). 4. Verify that total gross sales minus fees, refunds, and reserves equals total deposits plus any outstanding balances.
Match 1099-K Gross to Your Recorded Gross
At year-end, pull your total gross sales from QBO and compare it directly to the 1099-K. They should match within a small tolerance (rounding, timing). If they do not, you have a categorization error somewhere. Common culprits include:
- Sales tax collected but recorded as revenue instead of a liability - Shipping income not recorded - Refunds netted against revenue instead of tracked separately - Manual adjustments that bypassed the normal sales workflow
Never Record Only the Net Deposit Amount
This bears repeating because it is the most common mistake. Recording only the net deposit understates your revenue (which triggers the 1099-K mismatch) and eliminates your ability to deduct thousands of dollars in legitimate processing fees. On $250,000 in gross sales, you could be missing $7,000 to $12,000 in deductible fees. At a 22% federal tax bracket, that is $1,540 to $2,640 in unnecessary taxes, plus self-employment tax impact.
When to Hire a Professional
Consider professional help if any of the following apply:
- You have received a CP2000 notice referencing a 1099-K discrepancy - You process through multiple platforms (Stripe, Shopify, PayPal, Square) and cannot reconcile the combined totals - You have multi-year mismatches that need correction on amended returns - Your gross sales exceed $250,000 and you have never formally reconciled platform reports to your books - You sell internationally and have currency conversion entries you cannot classify - You collect sales tax through your platform and are unsure whether it is correctly excluded from revenue
Correction work after the fact typically costs 3 to 5 times more than setting up the process correctly from the start. A bookkeeper who understands e-commerce workflows can configure your QBO file in a few hours and save you thousands in tax overpayments and penalty exposure.
Related reading: Why Good Bookkeeping Matters | Catch-Up Bookkeeping | 7 Bookkeeping Mistakes | How to Separate Business and Personal Finances | QuickBooks Online Setup
## Frequently Asked Questions
Why does my 1099-K show more income than I actually received?
The 1099-K reports gross transaction volume, which includes the full customer payment before Stripe or Shopify deducts processing fees, refunds, and chargebacks. A business with $250,000 in gross sales might only see $235,000 deposited after approximately $7,250 in processing fees and $7,750 in refunds and chargebacks. The 1099-K still reports $250,000, and the IRS expects your tax return to match that gross figure.
What happens if I just report the net deposits as income?
Recording only net deposits understates your gross revenue and eliminates your ability to deduct processing fees as a business expense. The IRS AUR program cross-matches your return against the 1099-K and will likely flag the discrepancy as underreported income. You will receive a CP2000 notice proposing additional tax on the difference, and the burden shifts to you to prove your actual gross and deductible fees.
How do I handle Stripe or Shopify payouts that cross year-end?
Record revenue based on when the sale occurred, not when the deposit arrived. If a December sale does not deposit until January, the revenue belongs in December for accrual-basis taxpayers. For cash-basis taxpayers, the deposit date controls. Either way, document the timing difference so your bank reconciliation balances and your 1099-K matching is accurate across both years.
What is the 1099-K reporting threshold for 2026?
Starting in 2026, the Form 1099-K reporting threshold drops to $2,000 in gross payments per payee (down from the previous $20,000/200-transaction threshold that was repeatedly delayed). This means millions of additional sellers who previously did not receive a 1099-K will now get one, making proper gross-vs-net bookkeeping critical for avoiding IRS mismatches.
Ready to File With Confidence?
Tax rules change frequently. If anything in this guide applies to your situation, a quick review with a CPA can prevent costly mistakes. Greg Monaco is a NJ-licensed CPA (License #20CC04711400) who prepares every return personally.
