What the Stripe QuickBooks Integration Books Each Month
The import reads Stripe's balance reports, the same figures Stripe uses for its own financial reports. This is how each kind of activity is booked:
| Stripe activity | Where it lands in SparkReceipt |
|---|
| Charges | Sales on the month's Income |
| Refunds | Refunds on the month's Income |
| Tax collected with Stripe Tax | Tax on the sales and refund lines, by customer country and rate |
| Processing fees and dispute fees | The month's fee Expense, with Stripe as the Merchant |
| Tax Stripe charged on its fees | Tax on the fee Expense |
| Disputed amounts | Not booked as sales or refunds; follow disputes in your Stripe Dashboard |
| Payouts | Matched to the deposit in your bank, never booked as Income again |
| Top-ups, reserves and Issuing spend | Left out of your sales |
The Income is dated on the last day of the month, so a sale made on the 30th counts in that month even when Stripe pays it out a few days later. If you sell in more than one currency, each currency gets its own Income for the month.
Stripe Tax, Sales Tax and VAT
If you use Stripe Tax, the tax it collected goes on the month's Income separately from your sales. On a US account, it's one Tax collected line, so the sales tax you owe is easy to find. Outside the US, each line keeps the customer's country and is matched to that country's tax rate on the day of the sale. Sales to customers abroad keep their country too, which is what your OSS, EC sales list or export reporting needs. In Canada, HST provinces book as HST and GST-only provinces as GST.
When SparkReceipt can't tell which rate a line was taxed at, the line states no rate instead of a guess, so you or your accountant can set it before you publish.
Stripe Accounting for the Month End
A month of Stripe accounting used to mean three steps: export the balance report, work out gross sales, refunds and fees from it, then match the payouts against your bank. With Stripe connected, all three happen in the import:
- The month's sales, refunds and tax are booked as Income, dated in the month you made the sales.
- Stripe's fees are booked as an Expense, ready to deduct.
- The month's payouts are matched to the deposits in your bank.
What's left for you is a review. Open the month's Income and Expense, check the totals against your Stripe Dashboard, and publish. If you work with an accountant, invite them to your account for free and they can do the review themselves.
What the Restricted Key Can and Can't Do
Stripe's restricted keys carry only the permissions you give them. The key SparkReceipt asks for can read your balance, payouts and report files, and create report runs, which is why Financial Reports needs Write. It can't charge your customers, issue refunds or move money, because those permissions stay at None.
SparkReceipt checks the key when you connect. If it's missing a permission, the connect window tells you and lists the permissions the key needs. If you later delete the key in Stripe, the Stripe card on your Integrations page shows Needs attention until you paste a new one with Replace key. Disconnecting deletes the key from SparkReceipt and stops the imports; the months already imported stay as they are.
Your Stripe 1099-K
Stripe sends a Form 1099-K when your payments pass the federal threshold. Box 1a is your gross volume before fees and refunds, as the IRS explains, so it won't match your deposits. With your Stripe months booked as gross sales, refunds and fees, you can check the form against your own records. Our Form 1099-K guide shows how.
Is This the Right Stripe QuickBooks Integration for You?
SparkReceipt books Stripe as one Income and one Expense a month. That suits a business whose accountant wants clean monthly totals for sales, refunds, tax and fees, with each payout matched to the bank. It also suits a business without accounting software, where SparkReceipt is the books and the monthly Income feeds your Profit & Loss report and tax exports directly.
If you need each Stripe charge as its own transaction in QuickBooks, a per-transaction sync app is the closer fit, and you'd publish your Stripe months from one place only. Most small businesses and freelancers don't need that level of detail, and their accountant would rather not wade through it either.
The same SparkReceipt account also scans your receipts, imports your bank statements and bank feeds, and tracks the rest of your income, so your Stripe sales sit next to everything else your books need. When you connect Stripe, the Stripe QuickBooks integration starts with the months you choose, and each new month arrives on its own.