cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when the receipt is not provided as an option because it is > than the total?

My downloaded bank deposit is for the net total of all debits and credits for that day.  Quickbooks Online only provides transactions for matching that are less than or equal to the deposit amount.
Solved
Best answer 09-18-2019

Accepted Solutions
Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thanks a lot for coming back and providing us the complete details of your concern, avanzeeland.

 

I appreciate you following the recommended steps above and contacting our QuickBooks Online Customer Care Team. Allow me to chime in this conversation and help match the sales receipt and refund to the bank transaction.

 

You can enter a sales receipt of $112 and a refund receipt of $10. Once done, deposit it to your bank account. This creates a $102 deposit that will automatically match the bank transaction.

 

Let me show you how to:

 

Create a sales receipt:

  1. Go to the Plus sign icon.
  2. Choose Sales Receipt.
  3. Enter the needed details.
  4. Add 112 under the AMOUNT column.
  5. Click Save or Save and close.

Enter a refund receipt:

  1. Follow the first step above and choose Refund Receipt.
  2. Add the necessary information.
  3. Enter 10 under the AMOUNT column.
  4. Click Save and close.

image.png

Make a deposit:

  1. Follow the first step above and click Bank Deposit.
  2. Select the sales receipt and refund.
  3. Click Save and close.

image.png

Now, click Banking on the left pane. The transactions should automatically match.

image.png

For more insights, please check this article: Assign, categorize, edit, and add your downloaded banking transactions.

 

That should get you back on track.

 

I want to make sure you're able to get this done, so please let me know how it goes. I'll be here if you have any questions about matching transactions or in QuickBooks Online. Have a great day.

View solution in original post

Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

It's nice to hear from you again, avanzeeland.

 

QuickBooks requires to download the same amount to match these transactions. 

 

You'll have to exclude the (444.47) from the Banking page. Then, manually enter the Sales Receipt $35.63 and Refund for $80.10 in the Bank Register.

 

Here's how to exclude the 444.47 amount:

 

  1. Click Banking on the left panel.
  2. Select the transaction you'll want to exclude.
  3. Put a check in the box beside the date.
  4. Click the Batch actions drop-down arrow.
  5. Select Exclude selected.

 

To manually enter the $35.63 and $80.10 amount:

 

  1. Select Accounting on the left panel.
  2. Click View Register under Action column.
  3. Click the Add check drop-down arrow to create another transaction.
  4. Click Save.

 

Let me know if you have other questions with QuickBooks transactions.

View solution in original post

12 Comments
QuickBooks Team

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Hi there, @avanzeeland!

 

You can match all your transactions even it has a greater amount than the total of your deposits. I'm here to help you accomplish this.

 

To start with, you'll have to extend the range of your date when finding a match of your transactions.

 

That being said, here's how you can match your transactions:

  1. Go to the Banking page.
  2. Under Bank and Credit Cards, select your bank account.
  3. From the For Review tab, select your deposit.
  4. Click Find match.
  5. Select the appropriate date to filter all your matching transactions.
  6. Choose all your transactions.
  7. Click Save.

This way, you can match all your transactions. In addition, I've included our detailed guide in matching your transactions.

 

Lastly, you can also check out this article for your future reference: How to Exclude Expenses from Downloaded Bank Transactions?

 

Let me know in the comment section down below if you have any other questions. I'm always around here in the Community ready to help.

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

I am very familiar with the matching process but unfortunately this standard process does not work IN THE SITUATION when the sales receipt total is GREATER THAN the bank deposit total.  QBO does not allow me to see any receipts which it does not deem will be a good match.  Adjusting date ranges does not solve the problem.

This issue occurs when I issue a refund on the same date that I also have sales.  Example:

I have a sale for $112 and a refund for $10 on the same date.  The bank deposit is $102.  When I try to match (using the exact steps you outlined), QBO only shows sales receipts that are equal or less than $102, so I am NOT ALLOWED to match to the sales receipt of $112 and then either resolve the $10 difference or match to a Refund Receipt.

I have contacted QBO repeatedly regarding this issue and every time after going through all the same steps, I have been told that this is a limitation in the application.  I have dealt with it by saving refunds and processing them on a day when I have no credit card sales.  I do not like this answer so I continue to ask the question in hopes that Intuit will fix it.

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thank you for your reply.  Unfortunately this does not work.  I am very familiar with the process to match QBO transactions with banking transactions.  I do it every day.

 

The problem I describe occurs when there is a sales receipt which is greater than the total banking deposit.  QBO does not allow you to see any receipts which do not look like they will match so it filters out anything greater than the deposit.  

Example:  In the same day I have a Sales Receipt for $112 and a credit card refund for $10.  The bank deposit for that day is $102.  When you follow the steps outlined in your answer, the Sales Receipt for $112 is not shown as an option for matching despite any adjustments to date ranges or other filters.

 

I have contacted QBO tech support repeatedly and after they gamely attempt to figure out how to do this match, they admit there is a limitation (bug) in the application.  This seems like it would be an easy bug to resolve by providing a "switch" to turn off the built-in filter and allow a user to see ALL unmatched transactions.  I continue to ask and call because I am hopeful it will be addressed in a new version.

Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thanks a lot for coming back and providing us the complete details of your concern, avanzeeland.

 

I appreciate you following the recommended steps above and contacting our QuickBooks Online Customer Care Team. Allow me to chime in this conversation and help match the sales receipt and refund to the bank transaction.

 

You can enter a sales receipt of $112 and a refund receipt of $10. Once done, deposit it to your bank account. This creates a $102 deposit that will automatically match the bank transaction.

 

Let me show you how to:

 

Create a sales receipt:

  1. Go to the Plus sign icon.
  2. Choose Sales Receipt.
  3. Enter the needed details.
  4. Add 112 under the AMOUNT column.
  5. Click Save or Save and close.

Enter a refund receipt:

  1. Follow the first step above and choose Refund Receipt.
  2. Add the necessary information.
  3. Enter 10 under the AMOUNT column.
  4. Click Save and close.

image.png

Make a deposit:

  1. Follow the first step above and click Bank Deposit.
  2. Select the sales receipt and refund.
  3. Click Save and close.

image.png

Now, click Banking on the left pane. The transactions should automatically match.

image.png

For more insights, please check this article: Assign, categorize, edit, and add your downloaded banking transactions.

 

That should get you back on track.

 

I want to make sure you're able to get this done, so please let me know how it goes. I'll be here if you have any questions about matching transactions or in QuickBooks Online. Have a great day.

View solution in original post

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thank you PreciousB!!!!

 

I never created a Bank Deposit from scratch - I created the deposit by using the "Find Match" function in Banking.  This solves several issues I have struggled with for 3 years and was never able to get help from QBO help.  I am so glad I decided to post this to the QBO Community.

 

You made my day :)

Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

That's awesome, avanzeeland.

 

I'm so happy you've successfully matched the transactions in QuickBooks Online.

 

You should be able to easily do this should you encounter the same concern in the future.

 

I'm including some helpful video tutorials that help navigate QuickBooks Online: http://quickbooks.intuit.com/tutorials/.

 

As always, you can check regularly for product updates and feature enhancement through this link: QuickBooks Blog.

 

In case you need tips and related articles in the future, visit our QuickBooks Community help website for reference: QBO Self-help.

 

It's my pleasure to help you @avanzeeland. Please come back to the Community if there's anything else I can do for you. I wish you all the best.

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

I have encountered a new version of the same issue.  Since @PreciousB helped me solve the original issue, I have been utilizing the Bank Deposit function to match my daily QBO transactions with a daily credit card deposit in the cases when I have refunds mixed with sales receipts.  This has worked great until...

I had a day when I only had two transactions:

1. Sales Receipt $35.63

2. Refund for $80.10

Therefore, the credit card transaction for that day is a debit of ($44.47).  I cannot do a Bank Deposit because the net is a negative number.  I cannot use the Match function because the applicable transactions are not provided as selections for the debit.

Any ideas for how to match these two QBO transactions to the credit card debit?

Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

It's nice to hear from you again, avanzeeland.

 

QuickBooks requires to download the same amount to match these transactions. 

 

You'll have to exclude the (444.47) from the Banking page. Then, manually enter the Sales Receipt $35.63 and Refund for $80.10 in the Bank Register.

 

Here's how to exclude the 444.47 amount:

 

  1. Click Banking on the left panel.
  2. Select the transaction you'll want to exclude.
  3. Put a check in the box beside the date.
  4. Click the Batch actions drop-down arrow.
  5. Select Exclude selected.

 

To manually enter the $35.63 and $80.10 amount:

 

  1. Select Accounting on the left panel.
  2. Click View Register under Action column.
  3. Click the Add check drop-down arrow to create another transaction.
  4. Click Save.

 

Let me know if you have other questions with QuickBooks transactions.

View solution in original post

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thank you.  Your instructions were easy to follow and I have added the two items to the register.  I think this leaves my two QBO transactions unmatched to a banking transaction.  Is there a way to get the transactions to match the new items I added to the bank register?

QuickBooks Team

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thanks for joining in this thread @avanzeeland,

 

Allow me to step in and provide you some information about adding transactions from the Banking menu in QuickBooks Online.

 

If these transactions show in your register this means they’re manually created. You can match them by selecting Match under Action column. 

 

Here’s how you can match an existing transaction:

 

1.    Select the transaction to expand the view.
2.    Review the “Records found”. These transactions are ones you already entered in QuickBooks.
3.    Select the link next to each record to get more details.
4.    Review the “Deposit to” field on the forms. 
5.    Once done, select Match.

 

You may check to this article for more information about adding and matching downloaded transactions in QBO: How to Add and Match Downloaded Transactions.

 

If you need further assistance with the workaround, just let me know. I'm here whenever you need more help.

Not applicable

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Thank you.

 

I discovered that the original transactions will match if I change the account in the Sales Receipt and the Refund Receipt to match the checking account.  They were initially set on "Undeposited Funds" while they awaited a match to a downloaded banking transaction.  As soon as I changed this to the checking account, they automatically matched.


Thank you for your help.

Moderator

Re: How can I match a sales receipt of $112 and a refund of $10 to a bank deposit of $102 when th...

Hi, avanzeeland.

It's good to know that you've already found a resolution to your concern.


The information you posted will definitely help others that may have the same concern. And yes, you're right, you'll need to have the same account to be able to match the transactions.

 

You may find the following articles helpful:

 

For account-related discussion, feel free to reach out to our QuickBooks Online Support.

 

  1. Sign in to your QuickBooks Online Company.
  2. Click (?) Help at the upper right corner.
  3. Select Contact US on the pop-up.
  4. Enter a brief description of your concern then hit Continue.
  5. Click Get a callback.
  6. Enter your contact information.
  7. Select Call me.

Feel free to get back in touch with me if you have other matching concerns in QuickBooks. I'd love to help.

Need to get in touch?

Contact us