Skip to main content
L
LisaW47
December 9, 2021
Solved

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

  • December 9, 2021
  • 2 replies
  • 0 views

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

Best answer by GeorgiaC

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. 👩‍💻

2 replies

G
GeorgiaCAnswer
December 9, 2021

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. 👩‍💻

L
LisaW47Author
December 9, 2021

Thanks - will give this a go! 

G
GG6
February 7, 2022

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! 

Terms & ConditionsAccessibility statement