Forum Discussion

Eurofence's avatar
Eurofence
Contributing User
3 years ago

Transactons

Have an issue with recording transactions just did a spend money but its not visible in the selected account so i did it again 3 times to be exact same thing also after 3 hours the transactions all 3 of them are showinf in the correct account but not 1 is showing in reconcile acconts for that specicific account has any one had this before ?

10 Replies

Replies have been turned off for this discussion
  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi Eurofence 

     

    Welcome to the Community Forum, I hope you find it a valuable resource.

     

    First of all I'd suggest double checking that the date of the Spend Money transactions is correct and within the Reconcile Accounts statement date; also check that the Pay From account and the allocation accounts are correct. With that checked, please clear browser cache then try again. 

     

    If the problem persists, please provide a screenshot of the transaction details and the Reconcile Accounts window, we are happy to check it further.

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    Clearing cache did it on a different matter in reports reconciliation I have 5 bank accounts all reconciled but when i do a report for last reconcile date and amout 2 accounts are not showing any idea why ? The account numbers are in sequential order 

     

     
    1-1110
    1-1111  NOT SHOWING
    1-1112
    1-1113 NOT SHOWING
    1-1114
  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi Eurofence 

     

    Thank you for the update.

     

    Did you run the Bank Reconciliation report and find some accounts not appearing on the report? If so, first of all on the report screen, please click on the 'Accounts' button to check if all the desired accounts are ticked. After that please go to Banking > Reconcile accounts, select the account in question, does it show any last reconciled date under the account field? 

     

    If the correct last reconcile date is showing on the Reconcile Accounts window but not on the Bank Reconciliation report, please do provide a screenshot showing the reconcile account window, the report and the accounts selection window of report, so we can look into it further.

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    As you can clearly see the account was reconciled on the 16th Jan  account no 1-1111 screen shot attached

    Account number or account NOT visible in reconciliarion report also attached .

  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi Eurofence 

     

    Thank you very much for the screenshot. And just to double check, if you could please click on the 'Accounts' button within the bank reconciliation report, is account 1-1111 already ticked?

     

     

    If it's already ticked, could you please do a future dated (e.g. year 9999) bank reconcilition for account 1-1111, then undo this bank reconciliation, then check the report again? 

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    No difference did exactly what you said 

     

    reconciled the account futur date 2030 check reports the undid reconciliation check again still not visible

    did a report for all accounts then did a report just for that account 1-1111 

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    rewcon report just 1 account selected 1-1111 attached

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    If it just showed the amount here   instead of UNDO it would not be an issue

    Date last reconciled 16/01/2023
    Undo
    AMOUNT ?
     
  • CloverQ's avatar
    CloverQ
    Former Staff
    3 years ago

    Hi Eurofence 

     

    Thank you very much for the screenshots. 

     

    I noticed that the last reconciled date for 1-1111 is 23/1/2023, and the bank statement date selected on the Banking Reconciliation report is 31/1/2023. If there are no outstanding transactions to be reported as of the statement date, the account will not appear on the report.

     

    You'll need to change the bank statement date to the last reconciliation date to view the last reconciliation details. If you change the report statement date to before the last reconciled date but after the transaction date (e.g. a transaction entered on 1 Jan, last reconciled date 10 Jan, set report statement date to 3 Jan), this account will also display on the report. Just keep in mind that the reconciled/outstanding transaction details shown will be as of the selected reporting date. 

     

    So in short, in Reconcile Accounts, click 'Undo' will return the last reconciled date to 16/1/2023. Run the bank reconciliation report with the statement date set to 16/1/2023, 1-1111 should appear. Alternatively, when there are new unreconciled transactions entered on the account dated before 31/1/2023, running the bank reconciliation report on 31/1/2023 will also pick up 1-1111.

  • Eurofence's avatar
    Eurofence
    Contributing User
    3 years ago

    Thanks for the reply

     

    I did this 

    So in short, in Reconcile Accounts, click 'Undo' will return the last reconciled date to 16/1/2023. Run the bank reconciliation report with the statement date set to 16/1/2023, 1-1111 should appear. Alternatively, when there are new unreconciled transactions entered on the account dated before 31/1/2023, running the bank reconciliation report on 31/1/2023 will also pick up 1-1111.

     

    Report did not show up after i clicked undo and with statement date 16/1/23 the only way i can see the report is to enter a transaction prior to the 16/1/ 2023 as unreconciled if i enter a transaction  after the 16/1/23 it will not show in report which makes no sense 

     

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.