We processed a refund in Shopify for an order. We had a smaller transaction during the week, so Shopify withdrew the net amount from our bank account.
How can we reconcile/match the difference in the bank feed for the Credit Memo created in QBO because of the Shopify refund and the Shopify order? Here's a simple example of the transactions:
Refund for $100.00 in Shopify. This creates a Credit Memo in QBO.
Sale in Shopify for $50.00 (Invoice in QBO).
Withdrawal of $48.00/Spent in our Bank Feed. The withdrawal from Shopify is $50.00 invoice, less $100.00 CM less $2.00 Shopify Credit Card Fees.
I don't understand why QBO has a match function for deposits, but doesn't include Credit Memos in the list of open transactions. We could try to use 'Receive Payments' but that obviously won't accept a negative number. This seems like something should be pretty basic - essentially the reverse of the Receive Payments should be 'Make Payments' or 'Direct Refund' or an even better description.
Thanks! ~ B
Thank you for posting in the Community, @BrentSo.
I have some information to share with you about how you can handle refunds on your account.
You can make a Credit Memo if a customer paid more than what was owed, returned a product, asked a refund, or was given a store credit. You may then apply it to an open invoice for a specific customer.
Here's how you can apply a credit to the invoice:
Let me also add a guide you can access in keeping track and managing your transactions in QuickBooks Online:
The Community has your back always. Feel free to comment back if you have other concerns with this matter or QuickBooks in general. Take care and have a good one!
Thanks for the reply. Unfortunately, I think there is a misunderstanding. Hopefully, this explains it a little better:
1. We have one customer set up for our website sales.
2. The payment for the original invoice for the website sale was already processed in the bank feed in the Shopify deposit and was matched to that invoice. The invoice is marked as Paid in QBO ($100 Sale).
3. We have a Credit Memo in QBO for the refund given for the invoice above ($100 Credit).
4. We had an additional sale in Shopify and this is an invoice in QBO. This invoice is smaller than the Credit Memo ($50 Sale). The are $2.00 in Shopify credit card fees for this $50 sale.
5. Instead of Shopify depositing funds, it withdrew them from our bank for the transactions in #3 and #4. They withdrew $52.00 from our bank account ($50 Sale - $100 Refund - $2.00 in fees)
6. The bank feed shows $52.00 spent.
How do we match up the $52.00 spent in the Bank Feed to the two transactions?
Normally with the Bank Feed we'd apply desposits from Shopify against the website invoices and do a resolving transaction for the credit card fees.
Hope this helps.
I've got your back on matching two transactions to your downloaded transactions in the Bank Feeds, @BrentSo.
Since QuickBooks doesn't have an option to match a credit memo, you'll need to create a check and link the credit memo. This way, you can use the check to match it with your downloaded transaction. Let me guide you through the process.
Firstly, let's create a check and associate it with an Account Receivable (A/R) account. Here's how:
Once done, you can now link the created check to the credit memo. To do so, you'll need to use the Receive Payments window. Let me show you how.
After linking both transactions, let's go ahead and match the check and the credit card fees to your downloaded transaction. Please follow the steps below:
I'm adding this article to learn more about matching transactions in QBO: Categorize and match online bank transactions in QuickBooks Online.
Once you're ready to reconcile your account, feel free to check out this article: Reconcile an account in QuickBooks Online. This will help make sure your QuickBooks transactions match your bank or credit card statements.
Should you need any additional assistance while matching your bank transactions, you can leave a comment below. I'll be sure to get back to you, @BrentSo.
Thanks for the speedy reply. Following your guidance, here's what I've done:
Creating the check - Not a problem, but the Credit Memo for this example is $100, not $50.
Receive Payments - I selected the check and the Credit Memo, which nets the transaction to $0. It does show that the full amount of the check was applied to the credit. Is this amount supposed to be $100?
Match - The check transaction for the 'Spent' amount doesn't appear.
I have noticed that ticking and unticking the checkboxes in the Receive Payments window gives really weird results, and doesn't necessarily change any values in the Receive Payment field text box.
Thanks for coming back to our forum, brentsyn.
I appreciate the detailed explanation this gives me more clearer view. When you apply the credit memo, make sure you choose the customer or project you selected in the invoice. And ensure the date is accurate and verify the total amount to pay so you can match the transaction.
The following articles are good references in creating a credit memo as well as matching your transactions in QuickBooks:
Also, for the ticking and unticking, the checkboxes, let's try to clear the cache to get rid of the junk files and stored site data.
Additionally, if you need further assistance with the steps, I'd re comment getting in touch with our Support Team. They have the necessary tools that can guide you through the steps.
If you need further help, I'll be right here anytime. Just mention me so I can provide additional assistance. Have a nice day and take care!