Duplicated pay in bank recon
Hi there, hope someone can help me. I am trying to do a bank reconciliation but have found that on one pay run I have the total paid for wages, as well as an individual transaction for one of the em...
Forum Discussion
Hi
The first thing I would do is to unreconcile the single joe bloggs transaction ( remove tick)
Then go into the transaction ( blue arrow)
See if you can edit the trancation ( top ribbon on left hand side) and see if delete payment comes up. Delete the payment which will delete the myob transaction to the bank not the pay itself
You need to check that there are infact two pays entered for JB - your report suggests not
Do a find transaction for the amount and see what comes up . Are there two payroll transactions or has someone just entered a random entry just a spend money.
If indeed there are two pays for JB you do need to reverse one as the ytd figures sent to ATO will be wrong in any case. The second pay and the reversal will cancel out the additional figures.
It looks like a rogue entry really especially as the payroll activity only shows the one amount.
Look at the entries and see whats what
Hope this helps
Lisa
Hi LRBooks61
Thank you for your response. Delete payment does come up, but as explained it will not let me delete it, but tells me to do a reversal. I have no idea where the individual transaction comes from as I am the only one working on the payroll and I have not done a "spend money" transaction - I work from the bank feed and there was no single payment made to this person from our bank account, only the bulk "pay employees" amount, that is why I am not balancing :(
Message screenshot attached
I would still check first to see if there is two transactions
one is payroll but there may be another one
do a find transaction query. I think this is best as all transactions for the amount will come up. or go into the bank register and see what is there
as I understand your problem your bank rec is out by an additional payment so you need to find the transactions that may be the same and identify those that are incorrect
would you do a find on the amount and send a screenshot!
L isa
Hi LRBooks61
Thank you for helping. I'm attaching a screen shot of my bank register for the day, also of my bank statement - comparing this shows that there is a MYOB entry for this amount but no such payment from the bank has been made. There is also one of my payroll reporting centre that shows that only the bulk amount has been reported. (I don't know which tab to use in the "find transactions" that you want me to screen shot). The fact that it has not been reported to the ATO should mean I can delete that transaction but it wants me to reverse it as it says that it has been reported to the ATO (which it hasn't). In order to delete it I have to change the preferences (as explained under "learn more" on the pop-up message). I can try that but it worries me that the message says it has been reported. I am so confused ... sorry for sounding stupid.
Just go into the blue arrow of the Joe Bloggs payment
That will bring up the transaction - screenshot it for me please
To find a transaction
In the banking screen on the bottom ribbon, second along is find transaction
From there it opens into the accounts tab, select advanced filters
Change accounts to all accounts , change the date perameters, enter the amount you are looking for and save - all the transactions will come up
Tanks
Lisa
