Post Dated Transactions Affecting Reconciliations
Hi All
I've attempted a few times to explain this issue here without much success (either I'm being incredibly thick or I'm being told it shouldn't happen) so I've taken some screen caps which should hopefully illustrate my point.
I've been wanting to move our Payroll function over on the MYOB payroll module, however because the payroll module is linked to the bank account I was concerned that any transactions generated by the Payroll module and posted to the bank account would affect my bank reconciliations if the payroll transactions were dated after the period I was trying to reconcile (post dated). Say, for example, if I haven't had the opportunty to reconcile the bank account for January but I have processed payrolls for February, the transaction values for the February payroll affect the total of the bank even though I have selected a date range for January only in the reconcilation screen. Now, as I say perhaps I'm being really thick because I have been lead to believe this shouldn't happen, however it does.
Please note: the example here is actually for the petty cash account because all my other reconciliations were up to date and I haven't processed any payrolls yet on this system because of this issue, as such I had to engineer a scenerio to demostrate the issue. I have posted screengrabs to illustrate below.
Reconciliation with no post dated transactions, which balances
Addition of a post dated transaction (in this case for January 2019)
Attempt to reconcile the account with a post dated transaction posted to the bank account but not included in the date range to be reconciled.
I hope this illustrates the issue I have. I'm not sure how to explain any other way.
Thanks in advance for your help.
Welcome to the MYOB Community Forum, I hope you find plenty of useful information.
When you do the Reconciliation the First thing you have to enter is the ending Balance on the bank statement.
This get entered at Closing Statement Balance.
In the first screen shot the closing balance is $108.80 but in the second one where you say it is out of balance the closing balance is only $103.95.
Why have you not entered the same closing balance of $108.80?
If you had it would show out of balance zero.