Are there Stripe payments that don’t match any customer in my books?

Unmatched Stripe payments create tax, accounting, and refund problems

A customer pays $2,400 through Stripe. The money lands in your bank account. But in QuickBooks, there is no matching invoice, no customer record, nothing to tie that deposit to. Your bank feed shows a deposit from “Stripe Transfer” and your bookkeeper either guesses at the categorization or leaves it unreconciled.

This creates three problems. First, your revenue reports are incomplete because the payment was never properly recorded. Second, if the customer requests a refund, you have no paper trail connecting the Stripe charge to a customer or invoice. Third, at tax time, your accountant has to chase down every mystery deposit, which costs you time and money.

One or two unmatched payments is manageable. Twenty or thirty is a recurring headache. And the longer they sit unresolved, the harder they are to trace back to their source.

Why Stripe payments go unmatched in the first place

• Guest checkouts. The customer paid without creating an account. Stripe has a charge but only an email address, and that email was never added to QuickBooks.
• Different emails. The customer used their personal email for Stripe and their work email for QuickBooks. The systems cannot tell it is the same person.
• No integration. Stripe and QuickBooks are not connected at all. Payments and invoices are managed separately, and reconciliation happens manually (or not at all).
• Name mismatches.Stripe shows “Robert Smith” and QuickBooks has “Bob Smith Consulting.” The payment matches a real customer, but the data does not line up.

How to find unmatched Stripe payments manually

1. 1
   Export successful payments from Stripe

   In Stripe Dashboard, go to Payments. Filter for “Succeeded” status and the date range you want to check. Click Export and download the CSV. Include columns for customer name, email, amount, and date.

2. 2
   Export your customer list from QuickBooks

   Go to Sales → Customers. Click the export icon and choose “Export to Excel.” Alternatively, pull the Customer Contact List report from Reports for more fields.

3. 3
   Match Stripe customers to QuickBooks customers by email

   In your spreadsheet, use VLOOKUP to check each Stripe customer email against your QuickBooks customer email list. Flag any Stripe payment where the email does not appear in QuickBooks.

4. 4
   Check unmatched payments by name

   For Stripe payments that did not match by email, scan the customer names manually against your QuickBooks list. This is tedious but catches cases where different emails were used.

5. 5
   Total the unmatched amount

   Sum the dollar value of all Stripe payments that could not be matched to a QuickBooks customer. This is your unreconciled revenue.

New unmatched payments appear every month

Even if you reconcile everything today, next month will bring new payments from new customers, guest checkouts, and email mismatches. This check needs to happen monthly, ideally within the first week of the month so your bookkeeper is not chasing mystery deposits at tax time.

Or catch unmatched payments automatically, every month

Bottomline connects to both Stripe and your accounting software. It runs identity resolution on every payment, matching by email, name, phone, and transaction reference. Payments that cannot be matched to a customer in your books are flagged immediately.

$8,200 in unmatched payments means $8,200 your books do not properly account for. Bottomline flags these in your monthly report so your bookkeeper can resolve them quickly, before they pile up into a year-end headache.