hi DebWright
From the snip you are showing me I can see two pays for 23/3, 4 for 29/3 and 1 for 5/4.
So i don't know how your bank is reconciled for any of of those dates without those transactions in your bank account, unless the pays have been processed again paying from the bank account directly which means there is a double up of recording of wages.
I also don't understand why the other pays done 5/4 are not showing in prepare electronic payments.
I think you need someone to be able to access the file either on line or on site to look into it further.
Hi Julie_A_C ,
I appreciate your response but I checked the payroll report and to confirm that there's no double up of recording of wages. However, the locked transactions are the only ones that are not showing in the Prepare Electronic Payments.
Is there any other way on how I can able to show and reconcile those transactions to the bank account while clearing the balance from electronic clearing account to bank account without affecting other accounts?
Your response will be highly appreciated.
Many thanks.
Hi DebWright
The image in your opening post 'Something has gone wrong...' suggests a corruption in your file. I would start by getting that looked at. You could transfer the relevant amounts between the 2 accounts by way of a General Journal, however if there is a corruption, fixing the file might also fix this issue.
Regards
Gavin
Hi gavin12345
Thank you for your response. Could you please let me know how to fix the corrupt file if that's the case? Also, I would appreciate if you could please list down the steps by way of a General Journal as well? And since I'm reconciling my client's account on a monthly basis, with that way - will that also allow me to reconcile the missing amounts in the 'Reconcile Accounts' so I can reconcile all transactions from the bank statements for the month of April including those wages?
Looking forward to your reply.
Thank you so much!
Hi DebWright
To get a corruption in the file fixed, you would need either send the file to MYOB or to a MYOB specialist who can repair files. If your file is online, simply tag a moderator and wait for them to contact you. I have tagged Earl_HD and Celia_B. They might be able to repair the file with a script.
Normally if the payment method on the employee's card is cash or cheque, the payroll transaction is:
DR Wages
DR Super etc
CR Bank Account
CR PAYG
If the Payment method is Electronic the CR is to the Electronic Clearing account instead of the Bank Account. So for bank reconciliation purposes you would create a GJ with date same as the payroll transaction and
CR Bank Account (edited as per Julie_A_C comment below)
DR Electronic Clearing
This should adjust the account balances and allow you to see the transactions when doing the bank reconciliation. In theory same would apply if this has happened to previous pays. Use the previous payroll date as the date for the GJ - and always add a suitable explanation in the GJ memo for other users.
Regards
Gavin
