Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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:
Thanks - will give this a go!
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
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.
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.
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
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]
Cheers
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!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.