cancel
Showing results for 
Search instead for 
Did you mean: 
ironhatllc
Level 2

Need help finding sales receipt associated with daily sales summary

I found that I have a duplicate Daily Sales Summary entry that was entered last month.  I'm trying to delete the duplicate, but QB is complaining that "You need to delete the sales receipt from this deposit before you can delete the transaction itself."  But how do I find the matching sales receipt?

 

We receive credit card transactions on a website and I enter a Daily Sales Summary for each day for all sales from the website.  But we only get a few transactions a day on the website as it is not our main method of taking payment, so it is common for the settlement amount to the bank to be exactly the same amount as other days.  When doing "Make Deposits" to match transactions in the bank feed, there are generally numerous entries with the same amount.  QB auto-associates a deposit with a bank transaction for the same amount, but not necessarily the one associated with that particular sales summary.

 

Long story short, there was likely a deposit made for this duplicate transaction already and I have no way of knowing which one.  I already went through and deleted the deposits for all 13 possible transactions with this particular amount, but I am still getting this error when trying to delete the duplicate Sales Summary.  How do I find what I need to delete in order to delete this sales summary?  Thanks.

3 Comments 3
AileneA
QuickBooks Team

Need help finding sales receipt associated with daily sales summary

Thanks for posting in the Community, ironhatllc.

 

I can provide additional information on how to avoid duplicates transactions in your bank transactions

 

In QuickBooks Desktop, there's a particular Accounts Receivables workflow to record your transactions to evade messing up your accounting data.  

 

There are two ways to delete the duplicate transactions in QuickBooks. It depends on the mode you're using. You can refer to this link: Switching between bank modes.  

 

To remove duplicate transactions in Register mode. Here's how to do it: 

 

  1. Click the Banking
  2. Select Bank Feeds and choose Bank Feeds Center
  3. Find the bank statement from the financial institution. 
  4. Match the transactions. Press Confirm to match them. 
  5. You'll return to the Online Banking Center. 
  6. Locate and select the same statement from the Items Received From Financial Institution section. Then hit Yes to delete. 

 

feed.PNG

 

feed1.PNG

 feed2.PNG

 feed3.PNG 

 

 feed4.PNG

 

For more detailed information's, you can refer to this link: Remove duplicate transactions in QuickBooks Desktop

 

Now, I'm linking an article that will help with process of matching the transactions. 

 

That should do it! Keep in touch with me here in the Community if you have other questions about deleting your duplicate transactions. I'm always here to help. Have a great day, and stay safe!

ironhatllc
Level 2

Need help finding sales receipt associated with daily sales summary

Thanks for your quick response.  My problem is not with duplicates in the bank feed.  The problem was I entered a duplicate sales summary (stupid human error) and both were mapped to deposits.

 

This morning I went through and just deleted all the deposits from the past two months for online sales transactions.  Then I was able to delete the duplicate sales summary successfully.  Now I need to redo all those deposits.

 

When I enter a daily sales summary, it creates an entry in the Undeposited funds for the credit card payment.  Later when the bank feeds shows the deposit, I create a deposit for it.  Quickbooks makes a link in the undeposited funds account between the credit and the debit.  What I was missing was figuring how to tell which credit goes with which debit since there are a whole bunch in the account with the same amount.  And the date matches when I did the deposit and not when the amount was actually deposited in the bank.

ShiellaGraceA
QuickBooks Team

Need help finding sales receipt associated with daily sales summary

I'd like to add some information about the process of your sales transaction, @ironhatllc.

 

You'll want to sign in to your merchant account to see the details of the sales deposited. This way, you'll know which sales receipts associated when creating a deposit in QuickBooks. Let me walk you through how.

 

  1. Sign in to the Merchant Service Center.
  2. Go to the Activity & Reports menu, then Transactions.
  3. Select Search.
  4. Choose the Transaction ID to display a detailed view of a transaction. You will also have an option to print the report or export the data as a .CSV (comma separated value) file.

With these steps, you're able to identify the sales transactions. You can learn more about searching transactions at this link here: Search for transactions in the Merchant Service Center.

 

Moving forward, you can use the undeposited funds account to hold customer payments in QuickBooks until you deposit them at your real-life bank account.

 

I'm sharing this article for your reference. It has details to guide you in combining payments into single record so Quickbooks matches your bank records. Here's the link: Deposit payments into the Undeposited Funds account in QuickBooks Desktop.

 

 

That'll do it. Please know that we're here if you have other questions or concerns; so don't hesitate to swing by. Thanks for coming in today and have a wonderful day ahead.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us