Reversals showing up as negative amounts in Prepare Electronic Payments Window

Question

Just having an issue with reversals showing up as negative amounts in the Prepare Electronic Payments Window. We originally paid a batch of suppliers through Electronic Payments. When it came time to do the bank rec, the amount had gone through the bank but had disappeared in MYOB. The first side of the payments was still showing against each supplier but the EP on the opposite side had gone. Even though our file has always had the transactions must be reversed checkbox unticked, it only gave us the option to reverse the first part of the payment in view of re applying it. Once we reversed the original payment it comes up with the above mentioned negative amounts in Prepare Payments window. If we apply all these negative balances as normal this will always come up with a negative amount that you cant tick off in the bank rec window.

Any ideas on how to overide system so we can actually fully delete the original payments in MYOB and start from scratch.

Matt

tracey_h · Answer

Hi&nbsp;MDavids&nbsp;
&nbsp;
Thanks for your post. To work through your issue I'll go through the electronic payment process first:
&nbsp;

record the Pay Bills transactions - these are posted to the electronic clearing account and appear in the Prepare electronic payments window
process the Prepare electronic payment - this creates the ABA and records the electronic payment transaction which moves the amounts from the electronic clearing account to the bank account for matching with the bank feed
if you reverse the Pay Bills transactions - the reversals will appear in the Prepare electronic payments window as you're recording negative transactions posted to the electronic clearing account
if you delete the electronic payment transaction - the original Pay Bills transactions are put back in the Prepare electronic payments window

One of your issues is that you had to reverse the Pay Bills transactions, this is because they were already included in an electronic payment transaction. You need to delete the electronic payment transaction before deleting the Pay Bills transactions.
&nbsp;
As the original Pay Bills transactions are not in the Prepare electronic payments and you had to reverse them, the electronic payment transaction has been recorded so you'll need to locate it to match with the bank feed.
&nbsp;
Then in the Prepare electronic payments window tick the reversals and the matching re-recorded Pay Bills transactions. The Total deposit amount should be $0, click on Bank file and Record. This will clear those transactions from that window.
&nbsp;
If you can't find an electronic payment transaction in the bank account, go to Find transactions&gt;&gt;Account&gt;&gt;search by electronic clearing account. Locate the electronic payment transaction, click on the zoom arrow to open and check the Pay from account and date.
&nbsp;
If you continue to have problems please let me know, screenshots would be great. Make sure you remove sensitive information from screenshots prior to posting on the Forum.
&nbsp;
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.

Forum Discussion

Reversals showing up as negative amounts in Prepare Electronic Payments Window

1 Reply

Looking for something else?

Related content

Reversing an Electronic Payment

Electronic Payment Reversal

Prepare Electronic Payments holds negative values

Accidently reversed a Electronic Payment

Reversing an electronic payment in AccountRight

Rejected electronic payment reversal

Electronic Payment and Reversal of Payment

Reversed electronic payment too many times