GST posting troubleshooting

SOLVED

I just noticed that GST is not posting correctly for 1 of the companies I have set up.

If I pull up the All Journal Entries report, the transactions do not show the tax.  If I recall the transaction, the tax is showing in the purchase journal screen.

Example:

All Journal Entries Report

Dr: Fuel $105.00
Cr: Cheq Acct $105.00

Transaction in Purchases Journal

GST $5.00     Fuel $100.00    Total $105.00

I must be missing a setting, but not sure which one.  It seems to only be the 1 company of 5.

Any suggestions would be very appreciated.  Thank you in advance!!

  • 0
    SUGGESTED

    Press control-J to look at the journal entry from within the Purchase Journal screen.

    If that's not right, try forcing in an amount of GST that would be enough to notice in the journal entry and repeat.

    If it still isn't apparent where the GST is going, then check the linking under setup | settings | Company | Sales Taxes.

    And check whether that vendor has been set as 'Tax Exempt = Yes', in the Taxes tab under the vendor record.

    I hope that helps, please post back.

  • 0 in reply to RandyW
    verified answer

    GRCochrane,

    If what Randy has suggested is not the answer, then in the tax code setup under Setup, Settings, Company, Sales Taxes, Tax Codes, double-click the same code in one company that works and one that doesn't.

    I would assume the "Is Refundable" column beside the GST tax is set to No in the company that does not send the GST to the liability account for GST Paid.  But in the companies that entry is correct, it is set to Yes.

    Change it to Yes but you will have to manually go back and adjust the tax amounts.  The easiest way to correct the amounts from the past is to calculate the amount for each expense account for each month and post one general journal entry per month to move the amount from the expense to GST Paid.  You will not be able to go back and hit the Adjust button to correct the GST calculation on each entry.

  • 0 in reply to RandyW

    Thank you Randy!

    When I do a new transaction it shows the GST in the journal entry.

    It does not show for the majority of 800 previous entries for multiple vendors though.   I tried amending and resaving the entry and it still does not show the GST in the journal entry.  It is currently adding the GST into the expense account - ie: $105.00 fuel instead of $5.00 gst and $100 fuel.  

    I am hoping there is a way to correct the previous entries without reposting all.

    Thanks for your help!

  • 0 in reply to Richard S. Ridings

    I had compared the settings prior to posting here.  The one was sent to No under "is refundable".  They are all the same now.   Thank you for the lump sum posting, that will be much easier.

    Thank you for your assistance.  :)