Forum Discussion

MyAccountsHat's avatar
MyAccountsHat
Experienced Cover User
6 years ago

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. 

 

 

 

  • MyAccountsHat

     

    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.

     

  • GDay53's avatar
    GDay53
    Ultimate Cover User

    MyAccountsHat

     

    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.

     

    • MyAccountsHat's avatar
      MyAccountsHat
      Experienced Cover User

      Hi Graeme 

       

      Apologies for the delay in my response. Yes, I see what you mean now.  TBH I've never done it that way because I generally just enter all the transactions and then make sure the figures balance rather than manually entering the statement figure. 

       

      Logically to me it would make sense that the software just takes a 'snapshot' of the balance at the date you want to reconcile to and then ignores all post dated transactions so you can see right away if you have an issue or if the transactions balance but as that's not the case this was very helpful. 

       

      Thank you.