Forum Discussion

AXSHS's avatar
AXSHS
Experienced Cover User
6 years ago
Solved

Changing accounting Method

One of my clients has changed GST reporting from Accrual to Cash basis. I have changed this in the MYOB data file, however when running cash reports there is no information to display, but there is for accrual reports.

What am I missing?

 

TIA

 

Chris

  • Hi AXSHS 

     

    Our teams have been investigating this and have found that it is caused by General Journals without a tax code in the first line. This problem does appear to surface with the 2019.4 release and our teams are investigating a permanent solution.

     

    In the meantime you can resolve the issue by running the report for small date ranges until you narrow down the date(s) and locate the incorrect GJ. Once you have entered the missing tax code you should be able to run the GST (summary - cash) report. 

     

    We do apologise for the inconvenience caused. Please let me know if you have further issues.

8 Replies

Replies have been turned off for this discussion
  • AXSHS's avatar
    AXSHS
    Experienced Cover User
    6 years ago

    Hi Tracey,

     

    Thank you for that - hoping a solution is at hand as I have 20 data files I manage and 12 are on a Cash basis for their BAS.

     

    And yes - this wasn't an issue before the latest release.

     

    Many thanks

    Chris

  • Hi AXSHS 

     

    For the Cash reports to display data, you need to record the payments for transactions recorded in the software. 

    The Accrual reports would display all the transactions even if they are not closed. However, Cash reports would only recognize the transactions for which payments have been applied.

     

    I hope this helps. Please let me know if you have further questions. 

  • AXSHS's avatar
    AXSHS
    Experienced Cover User
    6 years ago

    Hi Komal,

     

    The transactions are there - they are not being reported in a cash report. 

     

    I found another post where this was an issue - this was my response :

    Hi Tracey,

     

    I also have the same issue. I can get a report for GST Summary accrual, but not Cash for 1/10/2019-31/12/2019. I can however get an Cash report for 1/1/2020-6/1/2020?

     

    This happens across data files

     

    I have taken one data file offline as was suggested in another post to run the reports, but this does not work.

     

    I have checked the build date

    I have unistalled and deleted 2019.4 and reinstalled

     

    All to no avail

     

    Where to now?

     

    TIA

    Chris

  • Robert_Mitchell's avatar
    Robert_Mitchell
    Valued User
    6 years ago

    I'm not sure if this applies in this case but I wonder whether the cash payments have been applied directly to the invoice as COD rather than as a separate receipt after the invoice is recorded. I have found this sometimes stuffs up the Cash GST reports.

     

    Cheers

    Robert

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    6 years ago

    Hi AXSHS 

     

    Thank you for the additional information.


    As Robert_Mitchell  mentioned, it would be worth checking how the payment has been recorded for the transactions. 

     

    In case it does not resolve the problem, we would have to identify if there is any issue with the specific transactions in your files which are causing a roadblock while running the report. Therefore, can you please try running the cash report for a single day instead of weeks or months, and check if it's  then displaying any data, as the report broken in a specific range date can sometimes run fine for a single date if the transactions on that date have been recorded accurately.

     

    Also, is the information not getting displayed just on "GST Summary Cash" report or all the other Cash reports as well?

     

    Please let us know how you go with that. 

  • AXSHS's avatar
    AXSHS
    Experienced Cover User
    6 years ago

    Hi Robert,

     

    Thank you for your reply. Payments are allocated via Receive Payment in Bank feeds.

     

    This is an issue in 2 of my data files that do cash reporting - I have not tried all 17.

     

    Thought there may have been an issue with the daa files under my subscription, however the 2 data files have different owners but I have administratow access on both.

     

    Cheers

    Chris

  • AXSHS's avatar
    AXSHS
    Experienced Cover User
    6 years ago

    Hi Komal,

     

    Other reports are fine as far as am aware.

     

    I will have to do a day by day report tonight or later this week once I have finished dealing with my clients daily needs.

    This is going to be time consuming and can you tell me what I should be looking for if there is a day/s that it won't report when there are transactions?

     

    Cheers

    Chris

  • Tracey_H's avatar
    Tracey_H
    Former Staff
    6 years ago

    Hi AXSHS 

     

    Our teams have been investigating this and have found that it is caused by General Journals without a tax code in the first line. This problem does appear to surface with the 2019.4 release and our teams are investigating a permanent solution.

     

    In the meantime you can resolve the issue by running the report for small date ranges until you narrow down the date(s) and locate the incorrect GJ. Once you have entered the missing tax code you should be able to run the GST (summary - cash) report. 

     

    We do apologise for the inconvenience caused. Please let me know if you have further issues.