Skip to main content
D
doug107
November 7, 2022
Question

When is QBOnline going to give us a USER administrable filter for matching deposit transactions?

  • November 7, 2022
  • 1 reply
  • 0 views
Problem: Some sales receipts are not presented to match a deposit downloaded from the bank account.
This typically occurs when a single sales receipt should match a single deposit. In my case, a donor contributes online using donorbox. Donorbox then processes the contribution using Strip resulting in a processing fee that varies, deducted from the contribution. QBOnline tries to match the deposit amount to the sales receipt and fails because the amount isn’t within matching range. This forces the user to use a WORK-AROUND and:
1) manually find the matching sales receipt; 
2) modify the sales by adding a line to deduct the processing fee; 
3) save the receipt and then; 
4)return to the banking screen to complete the match. 
Currently, sales receipts are filtered by the system if the receipt amount differs from the deposit amount downloaded from the bank by more than a certain percentage (it seems to be <5%).
Please stop the asinine WORK-AROUND and give us a user administrable filter setting or present all sales receipts within a wider range.

    1 reply

    R
    RCV
    November 7, 2022

    That's not the kind of impression I want to leave, doug107. I appreciate all your efforts in coming up with a workaround to match the sales receipts.

     

    The sales receipts will only show up in the Match transactions section if you deposit them to the Undeposited Funds account. In this case, we can review your sales transactions and ensure a bank account isn't selected. You can refer to the sample screenshots below:

     

     

     

     

    For the processing fee, we can deposit the sales receipt to the desired bank account, then add the fee under the Add funds to this deposit section in a negative amount. The amount will match to the downloaded deposit. Here's how:

     

    1. Click Bank Deposit from the New (+) icon.
    2. Choose the correct bank, then select the sales receipt under the Select the payments included in this deposit section.
    3. Scroll down to the Add funds to this deposit, then add the fees/expense in a negative amount.
    4. Tap Save and close.

     

    Once done, proceed with matching the deposits. Feel free to visit these articles which contain information about matching and customizing transactions in QuickBooks:

     

     

    Please know that the Community has your back if you need assistance. Feel free to post a question, get answers, share tips, ideas, and more. Wishing you and your business continued success.

    D
    doug107Author
    November 7, 2022

    Again, you've added unnecessary steps to what should be an automatic process. 

    Currently, there is no need to create a deposit manually to match later to the downloaded banking transactions. When a donor makes an online contribution using donorbox, I receive a notification of the donor and amount. I then create the sales receipt and save it to undeposited funds. They process the payment through Stripe, and the bank deposit/transfer is automatic. I never know how many contributions are being processed in a single deposit until when a contribution(s) is processed by Stripe. Stripe sends an email notifying me of the deposit amount, but rather than duplicate a matching process at that point, I wait until the deposit processes and downloads in the banking transactions. Once downloaded I match the contributions to the automatic deposit/transfer and deduct the fees charged by both donorbox and Stripe. This simplifies the process of dealing with variable processing fees charged by Stripe. 

    The problem occurs when the processing fees exceed the matching range used by QuickBooks to present the possible matches for consideration and is easily replicated when your deposit doesn't match your sales receipts within their tolerances. 

    My apologies if my comments seem harsh, but time is money and wasting it isn't a good thing. 

    G
    GlinetteC
    November 8, 2022

    I can see that having the user filter setting to match deposits can be beneficial to you and your business, doug107.

     

    While there isn't a way for you to do the task, I recommend sending your ideas to our product engineers. Customer feature requests and product suggestions are collected and reviewed so they may add them to feature product updates. Here's how:

     

    1. Go to the Gear icon and select Feedback.
    2. Type in your feedback and suggestions about the advertisements in QBO. 
    3. Click Next to submit them. 

     

    You can view all submitted requests on this site: https://feedback.qbo.intuit.com/.

     

    I've also added this article to ensure your books are updated and accounted for properly: Reconcile account in QuickBooks Online.

     

    I'll be right here to keep helping if you have more questions about managing your transactions.

    Terms & ConditionsAccessibility statement