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.
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
How it connects
- StripeNative app
Make: Watch Events, with payment_intent.succeeded selected. Stripe describes it as a PaymentIntent that has successfully completed payment.
- QuickBooks OnlineNative app
Make: Search for Customers and Create a Sales Receipt. The n8n QuickBooks Online node has no Sales Receipt resource, so this recipe is Make only.
- Google SheetsNative app
A log with one row per PaymentIntent id. Make: Search Rows and Add a Row.
Steps
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.
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.
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.
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.
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
- QuickBooks modules in Make
- Stripe in Make
- Stripe event types
- Google Sheets modules in Make
- n8n QuickBooks Online node
Similar recipes
Accounting
Alert the team and draft an email when a Stripe invoice payment fails
On invoice.payment_failed, Slack gets an alert and Gmail gets a draft to the customer. A person reviews and sends it.
Accounting
Send a weekly Slack digest of overdue QuickBooks invoices
Once a week the flow lists invoices with an open balance past their due date and posts one message to Slack.