Forum Discussion

KathyH61's avatar
KathyH61
Experienced User
2 years ago

GST Return and BAS Lodgement don't match

I hope someone can assist.  I went to prepare and lodge my BAS Statement, but the statement "GST on purchases" amount does not match the GST Return and the GST Report amounts.  (Both the GST Return and GST Report agree).  Is anyone able to shed light on what could be wrong?  Thanks.

9 Replies

  • KathyH61's avatar
    KathyH61
    Experienced User
    2 years ago

    Thanks Earl, however BAS wasn't prepared earlier and both reports were generated one after the other.

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    2 months ago

    Hi LucyMik,

    Thanks for sharing the screenshot. It looks like the default CAP tax code has been renamed or replaced with a custom code (e.g., GCA), which is why it isn’t appearing. As for your second question, the GST Return report only includes default tax codes; consolidated and customised codes aren’t included. Because CAP was customised/renamed to GCA, it won’t show on the GST Return report. To have it appear on that report, please change the tax code name back to CAP. 

    Please see this help page GST codes then navigate to Edit a tax code for detailed guidance. 

    I hope this helps!

    Regards,
    Earl

  • LucyMik's avatar
    LucyMik
    Experienced Cover User
    2 months ago

    Hi Thank you for your reply.

    The GCA GST code it wasn't changed by me or anyone that's the way your system came up (there was no reason for me to do so anyway) I found this code in 2 of my clients.

    Anyway i went in the edit tax codes and change the name to CAP for those 2 clients, and that solve the problem. Now the GST is mapping into the G10 on the GST return report.

    and both reports now agreed. 

    that's solve the constant problem with BAS reports.

    Thank you so much for your help.

  • Earl_HD's avatar
    Earl_HD
    MYOB Moderator
    2 years ago

    Hi KathyH61 ,

    This can be quite challenging. If the BAS was prepared earlier, the report might not match because the date reflects when it was prepared. Additionally, when running the GST Return Summary report under Reporting > BAS Reporting, note that the report is static. It populates values at the time it is generated and won't change unless it is deleted and re-created. By design, it should be generated when lodging a BAS return for a period, as it tracks any changes made in that period. These changes will be included in the adjustments for the next period.

    Feel free to post again, we're happy to help!

    Regards,
    Earl

  • Penny_Phillips's avatar
    Penny_Phillips
    Experienced Cover User
    2 years ago

    Hi I am having the same problem - both reports prepared today.  The GST paid amount varies between the GST Report and GST Return Summary.

    The amount of the GST Report is the correct amount both in the Brower version and desktop version but changes in the GST Return Summary ???? 

    No Prior period adjustments

    Have checked the GST codes to be included.

    Any ideas??

  • Genreve_S's avatar
    Genreve_S
    MYOB Moderator
    2 years ago

    Hi Penny_Phillips,

     

    It's unusual for the GST report and the GST return to not match, so there could be many possible reasons for this. It might be best to run different filters for the report incrementally and compare them until you find what caused the discrepancy and start troubleshooting from there.ccc

     

    Feel free to let us know if you need any further help with this.

     

    Thanks,
    Genreve

     

  • LucyMik's avatar
    LucyMik
    Experienced Cover User
    2 months ago

    I have the same problem each time. the GST Return Report (the BAS one) doesnt take in the capital purchase GST, while in the GST report has the GST on Capital Acquisitions.

    I was speaking with Myob support just now and he didn't even understand the problem and he was keep telling me to contact with my accountant of what GST to use. Im the bookkeeper of the business and i was trying to explain to him that the capital purchase GST is in the GST report but not in the GST return report and that's MYOB problem and not the accountants (of course he will show the correct GST in BAS but the reports must agree). and the support guy he was keep telling me to contact my accountant!!!!!  I ask him many times to tell me which GST code is connected with capital Purchase G10 in the return report and he refuse to answer and insisted to call my accountant. 

  • Princess_R's avatar
    Princess_R
    MYOB Moderator
    2 months ago

    Hi LucyMik,

     

    Totally get how that felt off-track, you were asking about product mapping and kept getting pushed into tax advice. If you’re asking which tax code to use on a transaction, we’d point you to an accountant, but if you want to know what goes to G10 in the return report, I’m happy to fill you in. 

      

    Capital purchases are usually tagged with the CAP tax code, which is what pulls those amounts into the GST return. If a capital purchase is shown in the GST report but not in the GST return, it’s usually down to the transaction type (bill/invoice), your accounting method and dates, or BAS timing. To sort it out, make sure the transaction’s categorised and recorded with the right tax code and transaction type. Avoid editing or re-coding anything after you’ve started a BAS/GST return because changes won’t be picked up, and then cross‑check your GST Return Report against the GST Report.  

     

    Cheers,

    Princess

  • LucyMik's avatar
    LucyMik
    Experienced Cover User
    2 months ago

    Hi 

     

    Thank you for your reply.

    The point is that for a capital purchase i used the GCA gst code as per photo attached because there is no other (no CAP as per your message) 

    and this GCA Gst its not mapping in to G10 return report, thats why the 2 reports are not matching.

     

    So Question why there is not CAP Gst code in the dropdown list to choose in the first place?

    And why the GCA GST code on capital acquisitions does not mapping in the return report and only shows in the GST report