Unable to Match Stripe Payout in Bank Account

kellyr2 · ‎July 13, 2023

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!!

ReymondO · ‎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:

Go to Reports and open the Profit and loss report.
Filter its report period and click the amount on the report.
Find the transaction and open it.
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.

View solution in original post

ReymondO · ‎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:

Go to Reports and open the Profit and loss report.
Filter its report period and click the amount on the report.
Find the transaction and open it.
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.

kellyr2 · ‎July 13, 2023

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

DebSheenD · ‎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.

Click Banking on the left pane.
Select the For Review tab.
Choose the transactions to open.
Select the Find other records or Find match button to open the Match transactions window.
By default, the Match transactions window lists All transactions within the date range, but you can narrow the results.
Use options on the Show drop-down menu to specify the type of transaction you're looking for.
If the transaction you're looking for is outside the default date range, select the From and To date fields to change the dates.
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.
If necessary, you can use the Add new transaction button to add multiple resolving transactions.
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.

Topics

Training

Community

Resources

Unable to Match Stripe Payout in Bank Account