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

  • Gerry WinterGerry Winter Accredited Partner Posts: 343 ✭✭

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

    Gerry 0418907140

    [email protected]

  • John WalkerJohn Walker Member Posts: 5

    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.

  • Gerry WinterGerry Winter Accredited Partner Posts: 343 ✭✭

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

    Gerry 0418907140

    [email protected]

  • John WalkerJohn Walker Member Posts: 5
    edited October 15

    User since 99. Quickbooks Premier 2017 Desktop 5 user

  • John WalkerJohn Walker Member Posts: 5

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

  • Robyn Kelly (Partner)Robyn Kelly (Partner) Accredited Partner Posts: 546 ✭✭
    edited October 17

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

  • John WalkerJohn Walker Member Posts: 5

    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.

Sign In or Register to comment.