web
You’re offline. This is a read only version of the page.
close
Skip to main content
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?

I have the same question (0)
  • Mark E Profile Picture
    6,451 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.

  • Community Member Profile Picture
    on at
    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
    6,451 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 789 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 607 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 497 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans