cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
cloud2049
Level 1

A Way To Automatically Apply Payments To Invoices

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?

10 Comments 10
JamesM
QuickBooks Team

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.

Rochelley
Level 8

A Way To Automatically Apply Payments To Invoices

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.

rickrudolph
Level 2

A Way To Automatically Apply Payments To Invoices

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. 

Ashleemerae
Level 1

A Way To Automatically Apply Payments To Invoices

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. 

rickrudolph
Level 2

A Way To Automatically Apply Payments To Invoices

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

 

rickrudolph
Level 2

A Way To Automatically Apply Payments To Invoices

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

Ashleemerae
Level 1

A Way To Automatically Apply Payments To Invoices

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. 

rickrudolph
Level 2

A Way To Automatically Apply Payments To 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.

Ashleemerae
Level 1

A Way To Automatically Apply Payments To 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! 

rickrudolph
Level 2

A Way To Automatically Apply Payments To Invoices

Ashlee,

 

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

 

Rick

Need to get in touch?

Contact us