Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

How do I remove a payment that was applied to an invoice?

(0) ShareShare
ReportReport
Posted on by

I work in a medical office and receive payments from insurance companies for services provided to our clients. Sometimes the insurances will make a payment to us and then months down the road realize they made it in error and will recoup that money from the account. We don't actually write a check to them in most instances, usually they take it from our future payments instead.

So far, the only way I've found to deal with this on the client's end to reflect that the payment is no longer there is to create a debit memo. However, while this method will remove the payment from the account, it does not clear out the invoice the payment was originally applied to. So, a new payment cannot be reapplied to the invoice if one is made again, or simply to know which invoices are still outstanding even, at a later date.

Frequently we see this when a payment is made and then the insurance company finds out they weren't the primary insurer and shouldn't have paid anything because the actual primary will have covered the entire amount - we then rebill to the correct insurance and we receive a "second" payment that is the accurate one that we can't apply to the invoice it belongs to and it's just floating there unapplied instead and muddying up our AR aging. 

I can't use the application inquiry/reversal option like I would for a misapplied payment to the wrong client, because in this instance we're not reapplying the amount - it's essentially a refund. Unless I'm missing something, that would leave the payment still registering as in the bank account, when technically future payments are being offset until that amount reaches zero. Thus, our bank reconciliations would be off. 

Is there anything else we can do to clear these out of the account at all?

  • Mark E Profile Picture
    Mark E 6,431 on at
    RE: How do I remove a payment that was applied to an invoice?

    The NSF option reverses the payment from AR & GL (like if it were actually a deposited check that was returned to the bank for insufficient funds).  I'm not entirely sure how this my or may not work for your particular situation, but if you need the payment reversed from the Customer AR account, and the GL credited for the AR Payment that was not correctly applied and recorded, then it might just work.

  • RE: How do I remove a payment that was applied to an invoice?

    I was under the impression that doing that would leave the money still "floating", for lack of a better description, in the system some where. Like, it shows in the bank account, but it's not actually applied to anything. Yes, it would eventually correct itself in that scenario - in theory that is. Insurance companies do NOT make it an easy process though and often it will take months to fix the payment, if they ever do (case in point, one of my aging accounts I'm still trying to get corrected payments on is from February of 2018).

    We are a non-profit and get audited fairly regularly by surprise, as well as when we cross fiscal years, so we can't have a payment sitting unapplied on the account waiting to be whittled away by future offset payments. With the debit memo, it's hitting both the client account showing the payment reversal from their services, and it's hitting the cash account of our bank so the funds are earmarked as a recoupment (I will admit, I do not completely understand how that part all operates as I'm a medical biller and coder doing this payment entry job - I bring the understanding of the whys and hows we're getting paid what we are and how to attempt to appeal issues, but my bookkeeping/accounting experience has been an on-the-job learning situation and I'm still working on the nuances of what all is happening with the accounts behind the screen).

    So, am I just misunderstanding how this ultimately works, or will the NSF option indeed work for our situation? Or are we stuck with the debit memo situation we've been using all this time?

  • Suggested answer
    Mark E Profile Picture
    Mark E 6,431 on at
    RE: How do I remove a payment that was applied to an invoice?

    You can use the Application Inquiry/Reversal screen, and use the Void Selected Application (NSF Check) option to remove the payment from the account.  It will reverse the payment and re-open the Invoice(s) that were applied during the original payment application.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans