Skip to main content
November 7, 2017
Solved

Matching Sales Receipts and Payments to Bank Deposits

  • November 7, 2017
  • 2 replies
  • 0 views

How do I "Match" these sales receipts and payments to deposits to get them out of my way? The list is getting quite long and making deposits is getting cumbersome. The deposits have been made and reconcilled. Why don't they go away when I add them to a deposit? 

    Best answer by AliciaRoy

    Hi BPRamsey, 

     

    Matching these transactions should be a quick ordeal, so I'd like to take a deeper look at what's going on. 

     

    The following article explains what transactions the program looks for when matching deposits and credits: https://community.intuit.com/articles/1164872. The steps to match them are as simple as going to the Banking page, clicking on the transaction, choosing Find Match, checking off the applicable transaction, and clicking Save

     

    Can you please let me know the steps you've been taking, and provide a screenshot of the issue? Thanks so much. 

    2 replies

    AliciaRoy
    AliciaRoyAnswer
    November 8, 2017

    Hi BPRamsey, 

     

    Matching these transactions should be a quick ordeal, so I'd like to take a deeper look at what's going on. 

     

    The following article explains what transactions the program looks for when matching deposits and credits: https://community.intuit.com/articles/1164872. The steps to match them are as simple as going to the Banking page, clicking on the transaction, choosing Find Match, checking off the applicable transaction, and clicking Save

     

    Can you please let me know the steps you've been taking, and provide a screenshot of the issue? Thanks so much. 

    November 9, 2017

    Hi, I'm having similar problem. Shopkeep is integrated with Quickbook. In QB I go to review my bank statements and select a deposit (from Shopkeep to Bank); select "match"; there are no matches. I go under Sales and pull up a receipt and its showing as a transaction in the QB.  I think its not matching because the amounts are different. My deposits don't include the total sale, only sale by card reader, while my sales receipts contain all sales made, including cash. The dates off to account two day delay and one day to post to my account 

    AliciaRoy
    November 10, 2017

    Hi Zaffron, 

     

    You're absolutely correct about the amount and date. These are key factors the program uses to find matching transactions. If the amount is off as well as the date, it looks like two separate transactions. You could always exclude the deposit from the banking page, since you already have the sales receipt recorded. I recommend checking out Intuit Meg's answer in the following article for additional details: https://community.intuit.com/questions/831895-can-t-match-downloaded-transaction-to-register.

     

    Please let me know if this helped clarify things, or if you have any further questions for me. 

    April 24, 2019

    I am having a similar issue with Kindful. We have integration set up and the transactions are synced over as sales reciepts for each individual transaction (including the donors name), but the money is direct deposited as a lump sum every week or 2. Because the dates and amounts are different they don't match-up. On the profit and loss, both the sales receipts and the deposit shows up in 2 different income accounts.

    HoneyLynn_G
    April 24, 2019

    Hello there, @IGF0828.

     

    Thanks for joining this thread. I'm here to help direct you in correcting your integration setup.

     

    The data you have in QuickBooks is dependent on the integration process of Kindful. I recommend reaching out to their Customer Service to update your settings and syncing method. They have the necessary tool to help you with your request.

     

    After correcting the data, you should be able to match your transactions with no hassle.

     

    Keep me posted on how the call went, @IGF0828. If you have any follow-up question, just add a comment below. I'll be here if you need further assistance about QuickBooks.