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 employees for some reason, so I am out of balance with his amount. (No indivicual transactions were made from the bank). This has never happened to me. I can't delete that individual transaction because it tells me it has been reported to the ATO and that it has to be reversed instead. Just wondering how to go about it and how it could have happened. Will everything at the ATO still be correct once I attempt a reversal? I am attaching my payroll activity report and the bank reconciliation - (all personal information deleted). Thanks in advance ...

Sorry I forgot to upload the screen shots

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 :(

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

Duplicated pay in bank recon

15 Replies

Replies have been turned off for this discussion

Mathilda
Trusted User
3 years ago
Sorry I forgot to upload the screen shots
LRBooks61
Ultimate Cover User
3 years ago
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
- Mathilda
  Trusted User
  3 years ago
  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 :(
  - Mathilda
    Trusted User
    3 years ago
    Message screenshot attached

Forum Discussion

Duplicated pay in bank recon

15 Replies

Related content

Duplicated Bank feeds

Payroll Liabilities Recon

Duplicate bank transactions

Duplicate payments in bank feed and bank reconciliation

ACCOUNT RIGHT STP RECON

STP Recon Errors

duplicated pay

Bank Recon