Record a Stripe payment as a sales receipt in QuickBooks

A succeeded payment in Stripe becomes one sales receipt in QuickBooks Online, checked against a log so it is not entered twice.

Updated .

A guide, not professional advice. Test before you use it for real. See terms.

A small business that takes one-off card payments in Stripe and keeps its books in QuickBooks Online.

Problem

Card payments land in Stripe and someone retypes each one into QuickBooks at the end of the week.

What you need

StripeQuickBooks OnlineGoogle SheetsMake

How it connects

Steps

  1. Agree on the item with your bookkeeper

    Pick the QuickBooks product or service and the deposit account the receipts should use. Ask whether Stripe is already synced to QuickBooks some other way; if it is, this recipe would double-count.

  2. Watch the payment

    In Make, add Stripe Watch Events and select payment_intent.succeeded. Stripe sends amounts in the smallest currency unit, so divide cents by 100 before mapping.

  3. Skip what is already logged

    Search Rows in the log sheet for the PaymentIntent id. If a row exists, stop. Stripe can deliver the same event more than once.

  4. Find the customer

    QuickBooks Search for Customers by the email on the payment. If nothing comes back, use one generic customer such as "Stripe sales" instead of creating a new customer on every payment.

  5. Create the sales receipt

    Create a Sales Receipt with the customer, the agreed item, the amount, and the PaymentIntent id in the memo. Then Add a Row to the log with the id, date, and amount.

Time

Build time is about 50 minutes, estimated by the recipe’s author. It is not a measured average.

Saves retyping each payment. Your bookkeeper still reviews the receipts.

Cost

Your Stripe and QuickBooks Online accounts, a Google account, and Make per its current pricing.

What it doesn’t do

It doesn’t record Stripe fees, payouts, or refunds. It doesn’t handle subscription invoices. It isn’t tax or accounting advice: the receipts still need your bookkeeper’s review.

Build it

The account is yours. The Make link is an affiliate link.

Sources

Similar recipes