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
The general journal will actually be a credit to bank account and a debit to the electronic clearing account.
Doing this will not put a negative amount into the electronic payment account so these entries can be cleared and they will always keep appearing even though the balance of the account will be zero.
This needs to be sorted by the corruption being sorted or a more experienced bookkeeper looking at the file.
