Skip to main content
C
cloud2049
March 12, 2019
Question

A Way To Automatically Apply Payments To Invoices

  • March 12, 2019
  • 3 replies
  • 0 views

So we are using Intuit Quickbooks Desktop Enterprise Solutions, and we have monthly invoices. We use a third party program to charge credit cards automatically. When that's done, we need to upload the payment info to QuickBooks - right now, applying the payment to an invoice is manual. Is there a way to automatically do this so when uploading the payment info is just applies it to the most recent invoice?

3 replies

J
JamesM
March 12, 2019

Hi there, 

 

Thanks for contacting us! 

 

I'd be happy to help answer your question. At this time, there isn't a way to automatically apply a payment to the invoice. I recommend reaching out to the third-party to see if there's a way to integrate this process into your QuickBooks account. Should you need further assistance about features available in QuickBooks, let me know by leaving a comment below. I'm around if you need help.

    R
    Rochelley
    March 15, 2019

    Hello @cloud2049 ,

     

    You will still have to manually apply the payments, but this might make it a little easier.  I created a custom report I call Unapplied Payments Report.  I may have started with a custom transaction detail report, but in any case, I set up the following filters:

    Account:  All Accounts Receivable; Amount: <=0.00; Paid Status:  Open; Transaction Type:  Payment.

    I then total by Payee.  All payments that have not been applied show up in the report.  Then you drill down on each transaction and apply the payment.  It actually goes pretty fast.  Hope that helps somewhat.

    R
    rickrudolph
    April 12, 2022

    We recently created an Applet for automatically applying QB Enterprise Payments against invoices. Currently, the Applet is designed to take the data in a 7-Eleven or a CVS detailed remittance and then automatically apply the payments in Quickbooks. I would imagine that we could also do the same for transferring your credit card information in the same manner. 

    A
    Ashleemerae
    April 23, 2022

    Hi, I’d like to know more about the applet you’ve created. Could you send me some info on how it works? We are a unique business that gets paid in bulk payments that apply to hundreds or thousands of invoices. We’ve yet to find a tool that works seamlessly for this. 

    R
    rickrudolph
    April 23, 2022

    Ashleemerae,

    Thank you for your interest.

     

    Please reach out to me on Monday. I can explain it to you, and perhaps do a screen share showing you exactly how it works. In your instance, we would probably have to create a front end template to match how you receive your remittance information. We currently have templates for CVS Drug Stores and 7-Eleven convenience stores. Adding a new template should be a relatively modest endeavor. My contact information is below, and we are in Virginia on EDT. You can schedule a call here:  https://calendly.com/rick_rudolph/phone-call-with-rick

     

     

    Rick Rudolph

    [email address removed]

    Solve Ltd.

    12110 Sunset Hills Rd

    Suite 600

    Reston, VA  20190

    571-601-4531

     

      Terms & ConditionsAccessibility statement