GST Problem

Joanne Sedgman
Joanne Sedgman Member Posts: 24
edited July 2020 in Accounts Hosted
I am having a problem with Reckon today when preparing GST reports. All three reports that I am running give me a different GST to be reclaimed amount. I have run a Tax Liability Report, a Tax Detail Report and also the Simplified BAS/IAS and all three give me a completely different number. Who can this be?

Comments

  • GerryWinter
    GerryWinter Accredited Partner Posts: 1,204 Personal Range Expert Personal Range Expert
    edited July 2020
    It may be a date range issue

    Gerry id 6376

    Gerhard Winter

    Ph. 0418907140

    Reckon Store Next Door

    "Always at your Service"

    Email: gwinter0808@gmail.com

  • Joanne Sedgman
    Joanne Sedgman Member Posts: 24
    edited November 2019
    I wish it was that simple but unfortunately it isn't. I have picked the same date range for all reports and the GST received amount is exactly the same in each report whereas the GST Paid is different. But thank you for your suggestion. 

  • Kris_Williams
    Kris_Williams Member Posts: 3,272 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited November 2019
    Have you tried a tax summary report?
  • John Graetz
    John Graetz Member Posts: 1,651 ✭✭✭
    edited November 2019
    Are you running the reports under the same accounting method i.e. Cash Basis or Accrual Basis?
    John L G
  • Joanne Sedgman
    Joanne Sedgman Member Posts: 24
    edited November 2019
    Thank you all so far. I have checked that I am running cash in all three options and the date period is the same in all. The Tax Summary report gives me the same information as the Tax Liability Summary but neither are the same as the Tax Liability or Simplified Bas/IAS for. I do notice though when I run the tax summary report there is an amount under Net GST-P. What is that? And it is not the difference between the reports.
  • GerryWinter
    GerryWinter Accredited Partner Posts: 1,204 Personal Range Expert Personal Range Expert
    edited November 2019
    Check the codes in the Simplified BAS, drill down on the different amounts and compare

    Gerry id 6376

    Gerhard Winter

    Ph. 0418907140

    Reckon Store Next Door

    "Always at your Service"

    Email: gwinter0808@gmail.com

  • Jacqui Allen
    Jacqui Allen Member Posts: 238 ✭✭
    edited November 2019
    Historically I've found that if the Tax Summary (TS) & The tax Liability (TL) reports don't match, there is a data integrity issue, so resort all lists and rebuild the data file, if necessary create a portable backup and restore.
    If the TS & TL match but differ from the Balance Sheet (BS) then this is generally data entry error ie ATO BAS Payment allocated incorrectly.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited November 2019

    On a cash basis, the Tax Detail reports are sometimes incorrect if there are discounts or part payments involved as the system tries to calculate the GST at 10% still.  Therefore I will sometimes run them but never rely on them alone.

    I always use the Tax Summary report – This one will always calculate correctly even in the above cases.  The GST sections of the Simplified BAS should match with this summary, provided the basis (cash v accrual) & date range are the same.

     

    NB - Check whether you are reporting the Tax Summary & Tax Liability reports in net or gross

    The Tax Detail is only/always generated in net so if your TS/TL are set to gross, that could be the problem!

     

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    Reckon Accredited Professional Partner Bookkeeper / Registered BAS Agent (No: 92314 015)

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    0422 886 003

    shazinoz2@bigpond.com

    www.accounted4bs.com


    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)