Prepare Electronic Payments window
Hey there- wondering if anyone can help me I recently made a mistake with pays where I completed the pay run on MYOB but then realised I had overpaid a staff member. I then corrected this with th...
Forum Discussion
Thanks so much for the reply so this is what's happened:
The electronic payment transaction that was originally created as a result of doing the pay run was for approx $19k
I have a $20k daily limit which meant I dropped one of the pays from the ABA file & paid that employee the following day.
So in my bank feeds, there are 2x unallocated transactions, 1x $17K & the other $2k which = the total pay run. If I allocate these via a spend money, it ends up being a duplicate due to the auto transaction that is created, but if I delete the auto transaction, it puts it back into the prepare electronic payments window so I seem to be stuck with duplicate transactions either way.
Hi niqueyk1
Thanks for the detailed information. Recording a Spend money will create a duplicate transaction so you're right that it's not the correct way to handle this. You've got two options though:
- Delete the electronic payment transaction - this will put the pay transactions back into the Prepare electronic payments window but as you've deleted the original transaction it won't create a duplicate. When you reprocess the electronic payment only tick the pay transactions included in the ABA file. So you'd process two separate electronic payments, one for $17 and one for $2. You can then match the two bank feeds with the two electronic payments. You don't need to upload the ABA file to your bank as payment has already been made.
- In the Bank feeds window right click on the bank feed transactions and select Hide transaction. In the Reconcile accounts window manually reconcile the electronic payment by ticking that transaction.
But, one thing I do want to check with you is that you mentioned you dropped one employee from the ABA file. As the ABA file is created when you record the electronic payment, the ABA and EP transaction would be exactly the same so you should have two electronic payment transactions to match with the bank feeds.
Please feel free to send me screenshots so that I can assist further if you still have problems with this. Make sure sensitive information is removed from screenshots prior to posting on the public Forum.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
Thanks so much Tracey, that helped 90% but a strange thing happened-
So yes most of the pays ended up back in the prepare electronic payments window, apart from the 1 employee I paid separately. So I was able to reprocess those into an ABA to get the correct figure on my bank feeds. However the person I paid separately, their payment did not end up back in the prepare electronic payment window....? This means it is sitting unallocated in my bank feeds with no transaction. It was definitely paid as I checked the bank & it's even in the transaction journal when I search for it.
If I were to just allocate this using a spend money transaction, would that work or is there a better solution? If spend money works best, what account do I use? Electronic Clearing account (asset)? Or payroll liabilities? Or is it a cost of sales account it should be allocated to?
Hi niqueyk1
Great to hear you've resolved most of your issue.
You should never record a Spend Money transaction to match with wage payments in the Bank feeds window, that will create a duplicate transaction and issues with your account balances.
In the situation where you've got a bank feed transaction and an AccountRight transaction but the AccountRight transaction doesn't appear to be matched with the bank feed, the first step is to trace where the AccountRight transaction was posted. For your payroll transaction, go to Transaction Journal>>Payroll tab>>locate the pay transaction and click on the zoom arrow to open. Check the Pay from Account.
When the Pay from Account is the electronic clearing account the transaction will appear in the Prepare electronic payments window for processing. When it's the bank account the transaction will appear as a withdrawal in the bank account. If it's a payroll clearing account or different bank account you'd need to record a Transfer money transaction to move it to the bank account.
In the Find transactions window>>Account tab you can enter that Pay from account in the search field and trace that transaction to see if was moved to another account. For example, if you searched the electronic clearing account you'd see the payroll transactions as credits. The electronic payment transactions appear as debits and clear out the credits so that account should reconcile back to zero.
Let me know how you go with tracing that payroll transaction.
If my response has answered your enquiry please click "Accept as Solution" to assist other users find this information.
thanks so much for your help Tracey, sorry to say Im only half understanding what to do though.
I'm working from home today too so my access is only via Accountright web browser version.
So I've found the transaction & it is listed as the electronic clearing account (see photo 5622) but unfortunately it is not in the prepare electronic transaction window. It also says in this transaction window that an electronic payment was recorded & when I click on this, I can see that the cheque account is listed (see pic 5623)
So in that instance, I'm unsure what to do ? Do I just delete the EP000289 payment (pic 5623) linked to that transaction and that will pop the pay back into the prepare electronic payments window for me to try again? is it as simple as that?
