A Way To Automatically Apply Payments To Invoices

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.

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.

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. 

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. 

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

One other thing you can do before our call is send me a sample file of what you receive from your customer(s). We can then review it to determine what will be required for any necessary templates

Yes I’ll send over a sample remittance. Can the applet apply invoices that already have been imported into QB to a payment? I’ve seen other tools that can apply a payment but only for new invoices not existing invoices. 

If I understand your question, our applet only applies payments to existing invoices, which sounds like your use need. So for our application, our customer may receive a large ACH or check, which covers hundreds of invoices. The end customer provides the payment information via some sort of file, and we use that file to apply the payments and discounts against the correct invoices.

Yes exactly, that’s how we receive our payments as well. The applet sounds very promising, I’m excited to see more on Monday. Thank you! 

Ashlee,

I have not been able to reach you, are you still interested in reviewing the product features?

Rick