Skip to main content
February 26, 2022
Question

How to match the invoices paid via Stripe and Stripe fees?

  • February 26, 2022
  • 1 reply
  • 0 views

Hi, 

 

I created an invoice amounting is $497.77. However, Stripe deducts its fee and sends to my bank $478.06. 

 

How to match this transaction with this invoice and record Stripe's fee? 

 

Best regards. 

1 reply

Rose-A
February 26, 2022

I'm here to help keep the process of matching and recording a Stripe fee easy and simple, serkanhaslak.

 

You can record the Stripe fee using the Resolve | Difference option from the banking page when matching the payment to the open invoice. Below are the steps to complete the process:

 

  1. Click Transactions in the left panel and choose Banking.
  2. Tap the correct bank.
  3. Locate the Stripe payment and click Find match.
  4. Filter the transactions to Show all open invoices and customize the dates.
  5. Select the invoice.
  6. Enable the Resolve | Difference button.
  7. Under Add resolving transactions section, choose the bank fees account as Category.
  8. Enter the Stripe fee amount.
  9. Hit Save.

Another way to record a fee is by manually receiving the invoice payment, creating a deposit and entering the fee as a negative amount. Here's how:

 

  1. Click + New in the left panel and choose Receive payment.
  2. Choose a customer.
  3. Select the invoice.
  4. Hit Save and close.

 

Once done, record the bank fees when creating a bank deposit and enter the charge in a negative amount. Here's how:

 

  1. Click + New in the left panel and choose Bank Deposits.
  2. Select the invoice payment.
  3. In the Add funds to this deposit field, choose the relevant account.
  4. Enter a negative amount, under Amount.
  5. Hit Save and Close.

 

After that, you can now match them from the Banking page. See the sample screenshot below:

 

 

In case you want to reconcile the account, you can follow the guide in this article: Reconcile an account in QuickBooks Online. This will provide you with steps on how to manually reconcile your account that's not connected to online banking.

 

Let me know if there's anything else you need in QuickBooks, I'll be around to help. Have a good one.

Rose-A
February 27, 2022

Hi,  serkanhaslak.

 

Hope you're doing great. I wanted to see how everything is going about matching and recording a Stripe fee. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I'd be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

March 14, 2023

Hi

 

All the above makes sense unless one syncs the invoices and payments with Dubsado which uses Stripe as the merchant.  So the invoices and payments come from Dubsado, and the funding comes from Stripe into Quickbooks.  The amounts reflect the fees already deducted.  My cash is off and the funds are sitting in undeposited funds.  I tried the above but nothing is working as I cannot change the amount of the payment to have the second option work.  Any thoughts?

 

Thanks Adriana