Skip to content
Home How to Process Stripe Transactions in Quickbooks

How to Process Stripe Transactions in Quickbooks

    Last updated on February 11th, 2022 at 12:28 pm

    We have tried several different ways to process Stripe transactions to Quickbooks.

    1. Quicbooks and Stripe DOES not have a direct app/connection.
    2. Need to go through 3rd party app/service.
    3. We tried,, PayPal|Stripe|Square sync – PayTraQer, etc, DON’T work well. With, you have NO control on what is importing, it just syncs the data and it’s hard to monitor.
    4. We chose and we found it easy to work, follow the steps below.

    STEPS on how to process transactions from Stripe to Quickbooks via SaaSant.


    PayPal|Stripe|Square sync - PayTraQer Integrate with Quickbooks

    Process SALES

    1. Push to QB – each SALE to record revenue + fees.
      1. Must match the “accounts” well, all “stripe” markers
    Stripe and Quickbooks easy integration

    DEPOSIT (transfer to bank account)

    3.  After SALE is recorded, do the DEPOSIT sync.

    Stripe and Quickbooks easy integration Deposit

    4. BANKING, match transfer from “Stripe Bank acc” → “Transferwise” bank

    5. After MATCH transfer, go here and make sure BALANCE is $0 = so all matches.

    Stripe Bank Register:

    Stripe and Quickbooks easy integration Match Deposit

    Transaction in EURO.  

    1. Process in all USD accounts (client, bank account). This is recommended to avoid another account in EURO and MOST importantly, when you match the transfers, the amounts will match.  If you have 2 accounts in USD/EURO, and the transfer from Stripe contains transactions in EURO and USD, the transfer will NOT MATCH.
    2. when processed, go to QB and change the amount to match Stripe amount in USD

    Stripe and Quickbooks easy Integration Sales Receipt
    1. MATCH stripe amount

    Stripe and Quickbooks easy Integration process-refund


    1. Find the transaction in  and process in USD
    1. Same process as SALE, change the amount in QB to USD based on exchange rate of Sripe’s transaction

    1.  After each sale or refund processed in QB, the bank register for strip need to be $0.00


    1. Process refunds same way as SALE, select customer “Stripe”, etc. while syncing to Quickbooks.
    2. The Refund will show automatically in the P&L as “refund”
    Stripe and Quickbooks easy Integration transaction-report


    Need to record a REFUND and EXPENSE for the fee, 2 separate transactions

    1. Go to search (upper/right corner), type “refund” and you will be able to add a refund.
      1. For the refund, add the original Stripe transaction ID, so you have track of it.
      2. Select “Stripe Refunds”
    2. For the FEE: Add new “EXPENSE” and select type “Stripe Charge Back”.
      1. It is usually $15
    Stripe and Quickbooks easy Integration chargeback

    WITHDRAWAL by Stripe (difference in refund amount)

    Be careful when you do a refund, as the amount maybe LARGER than what you have charged. If you wordpress woocommerce, this may happen, so just double check the transaction.

    IMPORTANT: before you record as expense, check if there is another “Bank Deposit/Withdrawal” transaction.

    Here is the difference that may happen by different exchange rates. Charge is for one amount, then refund is larger amount:

    How to fix? Record that as a Stripe fee and make a note “refund difference possibly by exchange rate”. The money went to Stripe, so this is an expense and can be recorded as Stripe Fee.

    Sign up for Quickbooks here and get FREE months >>



    Just a hobby to write about interesting topics in our daily lives. Always looking for improvements and better ways of doing things...🚀