PowerObjects Blog 

for Microsoft Business Applications

Reversing an NSF Payment from a Previous Period in D365 Business Central

Post Author: Joe D365 |

The reversal feature in Dynamics 365 Business Central is a handy tool. It gives the user all types of ways to cleanly reverse out transactions, including NSF customer checks. The problem is, to reverse them, those checks must bounce in the same period they are received, and as anyone who has done a bank reconciliation will tell you, that is rarely the case. For starters, let us see what happens in D365 Business Central when we try to reverse an entry that has already been cleared in the bank reconciliation. Below is the entry we will use for our example. As you can see, it is green, which means it has been marked as cleared.

1. Let’s assume that in the subsequent bank statement, this payment has been marked as NSF by the bank, so we need to reverse it out. Let’s go to the customer card for Alpine Ski House, access the customer ledger entries, and try to reverse out the customer payment. First you will need to unapply the payment (Process > Unapply).

2. The next step would normally be to reverse the entry (Process > Reverse Transaction). However, when the payment has already been cleared in the bank reconciliation, this is where we get into trouble. The error you will receive is below. How do we get around this? Well, if the NSF is in the same period the payment was received, it’s easy. Unclear the entry in the bank reconciliation and run the reversal again. All set.

3. But what if the payment was received in June but the NSF is in July? If you unclear the bank reconciliation entry, you will be out of balance for June. The fix must happen in July. Luckily, the fix is an easy one. Here are the steps:

  • First, create a new “cash receipt journal.”
  • Your document type will be “Refund.”
  • Your account type will be “Customer.” Select the customer account with the NSF payment.
  • The amount is a refund so it will be a positive. In this case, it is $2,000.00.
  • The balance account will be “Bank Account.” Select the same bank account that the payment went into.
  • The applies-to doc type will be “Payment.”
  • For the applies-to Document No., select the payment that you just unapplied via the customer ledger entries.

4. Here is a screenshot of our entry:

5. If you would like, preview the posting. If it looks good, go ahead and post. You should be all set now. You will see a new bank account ledger entry in your bank reconciliation.

We realize this method is not as easy as simply marking a payment as NSF and having the offsetting cash entries automatically made for you. However, once you get the hang of it, this should be a relatively quick and painless workaround.

Happy D365’ing!

By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

Leave a Reply

Your email address will not be published. Required fields are marked *

PowerObjects Recommends