cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Visit this post for a list of recent banking issues in QuickBooks Online.
LisaW47
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

Hi,

Our online shop automatically posts sales in QB as sales receipts (which is fine). These are paid via stripe and we match the banking transaction to the receipt (and put an adjustment in to show the expense of the stripe fee). This all works fine until you get a payment from stripe for a single sales receipt (rather than a batch of receipts) which means the payment is lower than the value of the receipt (because of the fee) and therefore QB won't show that sales receipt in the list of transactions you can match to. 

 

e.g. 

 

sales receipt £10     stripe payment £9.50

 

if stripe paid this as part of a batch of receipts, so total received £300, then £10 sales receipt shows up and we can match it and put the expense fee against it. 

 

if stripe pays it on its own, so £9.50, it won't show up at all. 

 

We are at a loss as to how to sort this - any ideas? 

 

Thanks

Solved
Best answer December 09, 2021

Accepted Solutions
GeorgiaC
QuickBooks Team

how to match sales receipt to stripe deposit when deposit is less than the receipt!

Hi LisaW47, to do this, you can manually edit the sales receipt to post to 'Undeposited funds' on the 'Deposit to' field instead of the payment account. After this, create a bank deposit (+ New > bank deposit) and select the payment account, date, and tick the sales receipt listed under 'Select the payments included in this deposit' then scroll to 'Add funds to this deposit' to enter the stripe fee (enter the fee account under 'Account', the fee as a negative amount under 'Amount' and select No VAT. 

 

This will reduce the total of the receipt by the fee amount and once saved will allow you to match to the downloaded transaction in your bank. :woman_technologist:

View solution in original post

7 REPLIES 7
GeorgiaC
QuickBooks Team

how to match sales receipt to stripe deposit when deposit is less than the receipt!

Hi LisaW47, to do this, you can manually edit the sales receipt to post to 'Undeposited funds' on the 'Deposit to' field instead of the payment account. After this, create a bank deposit (+ New > bank deposit) and select the payment account, date, and tick the sales receipt listed under 'Select the payments included in this deposit' then scroll to 'Add funds to this deposit' to enter the stripe fee (enter the fee account under 'Account', the fee as a negative amount under 'Amount' and select No VAT. 

 

This will reduce the total of the receipt by the fee amount and once saved will allow you to match to the downloaded transaction in your bank. :woman_technologist:

LisaW47
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

Thanks - will give this a go! 

GG6
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

I NEED HELP. Hoping for a MORE macro resolution.

With nearly 5000 transactions and most of the 2021 bank deposits reconciled this suggestion is not a 'workable' solution. 

Recognizing that the actual deposit is already understating INCOME is there some GJ action to adjust SALES and record the FEE as an EXPENSE.

The example:

Payout to bank 35534 [Amount reported as SALES& reconciled in bank account]

Fees captured    1212 [Remain to be recorded as EXPENSE]    

Gross sales        36746 [Stripe income BUT not YET captured in QB]

 

What would a GJ entry look like to record additional INCOME/Sales of 1212 and 1212 of EXPENSE? Would that be allowed or acceptable?   

REALLY need some guidance!   Thanks to all who burn some brain cells to help me.

Cheers

 

 

TirzahC
QuickBooks Team

how to match sales receipt to stripe deposit when deposit is less than the receipt!

You've come to the right place! I've got all the steps to make sure everything is accounted for,GG6.

 

You can use the Resolve Difference option to fix your payment difference. This helps match your transaction . Let me walk you through the steps.

  1. Go to Accounting from the left menu and then, choose Banking.
  2. Choose the transactions to open.
  3. Tick Resolve Difference to open the Add resolving transactions fields.
  4. Make sure to enter a negative amount for the bank fee, 
  5. Click Save and close.

Also, QuickBooks will create an adjustment or journal entry when you use the Resolve difference feature. You usually do this when you're matching the same transactions, but their amounts don't quite add up.

 

For additional resources, you can check out this link: Resolve the difference in a matched transaction.

 

Check out this article: Categorize and match online bank transactions in QuickBooks Online. It has the steps on how you can add, match, and review bank transactions.

 

If you need further assistance with matching deposit or have other follow-up questions in mind regarding QuickBooks Online, please let me know. I'll stick around to help you out.

GG6
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

FIRST, your quick and thorough response is APPRECIATED.

Next, I am probably overthinking the solution, but I will explore the steps in a real time [DESKTOP] environment with a sample company because I have no idea where the funds will appear after the Adjustment.

 

Your specificity is reassuring but the magic in the background is still scaring me. 

I hope to see a new expense for fees, an increase in Gross profits and a bank account that is still capable of being reconciled.

I will report the outcome soon.

Cheers

GG6
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

TirzahC,

I fell into the trap that I am using QB Desktop Pro 2019 and the information was probably for QBO.

In any event, I do appreciate your effort to assist.

I will continue to research a DESKTOP solution that will accomplish the three issues [there may be more to a complete holistic result]

  • see a new expense for fees,
  • see an increase in Gross profits
  • maintain a bank account that is still capable of being reconciled.

Cheers

GG6
Level 1

how to match sales receipt to stripe deposit when deposit is less than the receipt!

DESKTOP Pro Query

I NEED HELP. Hoping for a MORE macro resolution.

With nearly 5000 transactions and most of the 2021 bank deposits reconciled this suggestion is not a 'workable' solution. 

Recognizing that the actual deposit is already understating INCOME is there some GJ action to adjust SALES and record the FEE as an EXPENSE.

The example:

Payout to bank 35534 [Amount reported as SALES& reconciled in bank account]

Fees captured    1212 [Remain to be recorded as EXPENSE]    

Gross sales        36746 [Stripe income BUT not YET captured in QB]

 

What would a GJ entry look like to record additional INCOME/Sales of 1212 and 1212 of EXPENSE? Would that be allowed or acceptable?   

REALLY need some guidance!   Thanks to all who burn some brain cells to help me.

Cheers

Rec'd prompt and thorough answer from yesterday BUT looks like a QBO solution! 

Need to get in touch?

Contact us