GST not Calculating correctly on invoice line

Have created a new company and imported lists and chart of accounts from another. When invoicing enter item, quantity = 7.5, rate = 100, tax rate = E = 0%, total = $750.00 (Correct) When tax rate = S = 15%, total = $975.00.(Wrong) In summary Total Tax = $112.50 (Correct) and get error " transaction not in balance". Premier Desktop 2017. Any help would be appreciated. Cheers John

Comments

  • GerryWinter
    GerryWinter Accredited Partner Posts: 1,204 Personal Range Expert Personal Range Expert

    Check your tax code list and tax item list to make sure the amounts are correct for each tax code

    Gerry id 6376

    Gerhard Winter

    Ph. 0418907140

    Reckon Store Next Door

    "Always at your Service"

    Email: gwinter0808@gmail.com

  • John Walker
    John Walker Member Posts: 10

    Thanks for that. Checked and double checked all that. Added tax amount column. Tax amount showing correct, extended total still showing double gst. Have now setup another new company and manually adding lists, c of a etc. So far all working ok. Probably glitch in first setup.

  • GerryWinter
    GerryWinter Accredited Partner Posts: 1,204 Personal Range Expert Personal Range Expert

    What version and flavor of Reckon are you using, call me and i can have a look at whats happening.

    Gerry id 6376

    Gerhard Winter

    Ph. 0418907140

    Reckon Store Next Door

    "Always at your Service"

    Email: gwinter0808@gmail.com

  • John Walker
    John Walker Member Posts: 10
    edited October 2020

    User since 99. Quickbooks Premier 2017 Desktop 5 user

  • John Walker
    John Walker Member Posts: 10

    Set up new company, invoice now working fine. Now having same issue when entering bills.

  • Robyn Kelly (Partner)
    Robyn Kelly (Partner) Accredited Partner Posts: 473 Accredited Partner Accredited Partner
    edited October 2020

    Have you done a verify & rebuild of the data file? Backup your current data file first. File Utilities Verify and then Rebuild.

  • John Walker
    John Walker Member Posts: 10

    Hi, thanks for the quick reply. looks like I've sorted it. Did verify data etc. Problem appears to be when .IIF files were imported our Tax Agency (IRD) supplier, different from Reckon default, was not showing as Tax Agency. Changed IRD to Agency and seems sorted.