Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
kellyr2
July 13, 2023
Solved

Unable to Match Stripe Payout in Bank Account

  • July 13, 2023
  • 4 replies
  • 128 views

Hello.  I have an issue that I've not encountered before involving a Stripe payout.  Typically, when a Stripe deposit occurs (which is almost daily), I simply "Match" it.  A week ago, a Stripe deposit went into the company bank account for which I am unable to use the "match" function in QuickBooks.  Upon researching, I found this deposit consists of 3 payments, however only 2 of those payments are in the "Bank deposit" area of QuickBooks which is where they normally hang out until they are matched.  However, all 3 payments can be identified in the P&L account.  So if I match the 2 available payments and then do a journal entry for the 1 that's not there, it will end up in the P&L twice.  Has anyone experienced this before?  How can I get this deposit categorized correctly?  Thank you for your help!!

Best answer by ReymondO

Good day, @kellyr2.

 

I'm here to provide you with information on how QuickBooks matches transactions in the Banking page.

 

In some cases, certain transactions may not find a match from existing records. Here are the possible reasons why:

 

  • The payees don’t match
  • The amounts don't match
  • The dates don't match or aren't close
  • The transaction is older than 6 months.
  • The bank account on the payment is not the same as the bank where the match is located
  • The payment has been reconciled
  • The transaction is already matched to something else
  • There’s a multicurrency issue with the exchange rates, or the transaction doesn't pass through the home currency at some point.

 

Since the payment is appearing in the Profit and Loss report, I suggest reviewing the transaction. Ensure that the payee, amount, transaction date, and bank account match the downloaded transaction. This will allow you to pair them correctly.

 

To view the transactions that make up the amount in the Profit and Loss report, follow these steps:

 

  1. Go to Reports and open the Profit and loss report.
  2. Filter its report period and click the amount on the report.
  3. Find the transaction and open it.
  4. Make any necessary corrections.

 

Once you've made the corrections, return to the Banking page and use the Find match feature to pair the transactions. For further guidance on reviewing downloaded bank and credit card transactions, please refer to this article: Categorize and match online bank transactions in QuickBooks Online.

 

Additionally, you can streamline your review process by creating a bank rule. This will enable QuickBooks to automatically categorize transactions for you.

 

If you're planning to reconcile your account, I recommend reading our reconciliation guide to ensure the accuracy of your QuickBooks accounts.

 

I want to ensure that you're able to match these transactions successfully, so please let me know how it goes by clicking the Reply button.

4 replies

ReymondOModeratorAnswer
Moderator
July 13, 2023

Good day, @kellyr2.

 

I'm here to provide you with information on how QuickBooks matches transactions in the Banking page.

 

In some cases, certain transactions may not find a match from existing records. Here are the possible reasons why:

 

  • The payees don’t match
  • The amounts don't match
  • The dates don't match or aren't close
  • The transaction is older than 6 months.
  • The bank account on the payment is not the same as the bank where the match is located
  • The payment has been reconciled
  • The transaction is already matched to something else
  • There’s a multicurrency issue with the exchange rates, or the transaction doesn't pass through the home currency at some point.

 

Since the payment is appearing in the Profit and Loss report, I suggest reviewing the transaction. Ensure that the payee, amount, transaction date, and bank account match the downloaded transaction. This will allow you to pair them correctly.

 

To view the transactions that make up the amount in the Profit and Loss report, follow these steps:

 

  1. Go to Reports and open the Profit and loss report.
  2. Filter its report period and click the amount on the report.
  3. Find the transaction and open it.
  4. Make any necessary corrections.

 

Once you've made the corrections, return to the Banking page and use the Find match feature to pair the transactions. For further guidance on reviewing downloaded bank and credit card transactions, please refer to this article: Categorize and match online bank transactions in QuickBooks Online.

 

Additionally, you can streamline your review process by creating a bank rule. This will enable QuickBooks to automatically categorize transactions for you.

 

If you're planning to reconcile your account, I recommend reading our reconciliation guide to ensure the accuracy of your QuickBooks accounts.

 

I want to ensure that you're able to match these transactions successfully, so please let me know how it goes by clicking the Reply button.

kellyr2Author
July 13, 2023

The reason I can't match is because there's a Stripe payment that is simply not there.

DebSheenD
Level 5
July 13, 2023

Glad to have you back, @kellyr2.

I see the challenges you've been through with your Stripe transactions. I'll share insights to guide you through handling them.
 

You can use the Resolve Difference option to fix your payment difference. This helps match your transaction through its difference until it will be equal to zero. Let me walk you through the steps.

  1. Click Banking on the left pane.
  2. Select the For Review tab.
  3. Choose the transactions to open.
  4. Select the Find other records or Find match button to open the Match transactions window.
  5. By default, the Match transactions window lists All transactions within the date range, but you can narrow the results.
  6. Use options on the Show drop-down menu to specify the type of transaction you're looking for.
  7. If the transaction you're looking for is outside the default date range, select the From and To date fields to change the dates.
  8. If the amounts are different, you can locate additional matched transactions, or select Resolve Difference to open the Add resolving transaction fields to add the Category and Amount (and, optionally, Payee) of a resolving transaction until the difference equals zero.
  9. If necessary, you can use the Add new transaction button to add multiple resolving transactions.
  10. Click Save.

 

Finally, you can now match your transactions in QuickBooks Online.

 

You might want to categorize your downloaded banking transactions in the future, please check this article for more information: Assign, Categorize, Edit, And Add Your Downloaded Banking Transactions.

 

Also, read the following articles about how to solve reconciliation and import issues:

 

 

I always check my notifications to respond to any answers. With that, don't hesitate to leave a comment if you have any further questions. I'm delighted to assist you again. Keep safe.

DivyaModyCommunity Manager
Community Manager
August 19, 2026

The reason one payment is missing from the Bank Deposit area is almost always that it was set to deposit straight to your bank account instead of to Undeposited Funds. It still shows in your P&L because the income was recorded when the payment came in, but because it isn't sitting in Undeposited Funds, it isn't available to group into the deposit that matches your Stripe payout. And you're right to be cautious: adding it with a journal entry would record that income a second time, so don't do that. Instead, redirect the payment so all three can be grouped into one deposit.

1. Find the missing payment and check where it was deposited

  1. Go to Reports and open the Profit and Loss, set the period, and click the amount to find the third payment. Open that payment transaction.
  2. Look at the Deposit to field. If it shows your checking/bank account (or anything other than Undeposited Funds), that's why it's missing from the Bank Deposit window.

2. Change it to Undeposited Funds so it rejoins the group

  1. On that payment, change Deposit to to Undeposited Funds, then save.
  2. All three payments will now be available together in the Bank Deposit area.

3. Build one Bank Deposit that equals the Stripe payout

  1. Select + New, then Bank Deposit.
  2. Choose your bank account, then check all three payments that make up the payout.
  3. If Stripe deposited the payout net of fees, scroll to Add funds to this deposit, choose your Stripe fees expense account, and enter the fee as a negative amount so the deposit total equals the net amount Stripe actually sent.
  4. Save. Then go to the bank feed and Match the Stripe payout to this deposit.

A note on "Resolve Difference"

Resolve Difference is meant for small gaps like processing fees, where you add a resolving line so the match nets to zero. It's the right tool for the Stripe fee, but it's not the way to add a whole missing payment, because pointing a resolving line at income would double-count it, the same problem as the journal entry. Fixing the payment's Deposit to field is the clean solution.

Stop it from happening again

Check your payment defaults so Stripe payments consistently land in Undeposited Funds: go to Settings (the gear), Account and settings, Payments, and review the deposit accounts. For a more robust long-term setup, some businesses use a dedicated Stripe clearing account, recording gross sales into it, fees out of it, and the payout as a transfer to checking, so payouts reconcile cleanly.

Once the third payment is back in Undeposited Funds and the fee line is added, the deposit should match the payout exactly. Let us know if the amounts still differ and we'll help you find the gap.

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement