how do I clear the reported amounts off my GST report in sage 50

SUGGESTED

Hello, 

I have posted my GST remittances as follows:

Debit GST Charged on Sales      2310
Credit GST Paid on Purchases    2315

This is done as Supplier Invoice - Cash, as it is done through my bank

However, How do I Clear this off my GST Report for the next Qtr? 
I just did my GST report for the next qtr and the payment that I processed is showing up and changing my balance!!

Does that make sense? I have already done my bank rec's so I am not sure if i should go into the postings and make any changes 

  • 0
    SUGGESTED

    It should change your balance.  Every GST payment should reduce the amounts in those accounts as they are liability accounts.  If you don't let them reduce the amounts in those accounts you will end up overpaying on your next remit.

  • 0

    I use Sage 50 and once I have posted the GST as you did above, I do a backup, then I go to Maintenance, Clear Data, Clear Tax Report, choose the tax you want to clear, choose the end date of your quarter you just posted, click ok.  This will clear your tax report for the next quarter.  Hope this is what you were looking for as an answer.

  • 0 in reply to Marj@Swab

    I am posting just as I said and its not clearing the account. When I do the following remittance, I have just been removing the payment from the total. But it just hangs out there.

  • 0 in reply to Guylaine Thibault

    I will try this. Thank you

  • 0 in reply to Kim Mackenzie

    This will clear all entries posted - I am not sure thats what I want to do.

  • 0 in reply to Kim Mackenzie

    Usually you do not wish to clear the reporting.  However, some people do this so they can run the report and catch anything that was posted after the last remittance but posted to dates before the current remittance period.  I do not recommend clearing data.

    You have not provided any examples of what you are doing with your reports.

    For example, when I do a remittance for the period Oct 1 to Dec 31, 2021, I run the report for those dates in that year.

    When I do the next remittance, I use Jan 1 - Mar 31/22.  I don't go back to the previous period.

    How do you get the previous period's numbers on your report that is causing your problem?

    Why are your payments even showing up?  The only way a payment would show up on the tax report is if you used a tax code.  Maybe you could tell us or show us how it is showing up that is causing a problem. so we can try to replicate it. 

  • 0 in reply to Richard S. Ridings

    I run my report the same as you. Quarterly. I do not go back to a previous report or date. But the payment was made in the following Quarter - could it just be the date that i need to change? 
    For example - If i run Jan - Mar, they payment is made april 15 and thats the date I use to post. 
    Is that why its showing on the following report? I may have just figured this out. I was overthinking it.

  • 0 in reply to Kim Mackenzie

    I didn't see the report you said was following so I can't tell what you are seeing on it.

    I just did a quick test using Sage 50 2022.2 and I had to make some huge assumptions.  I ran the report as in the dialog below.

    I posted a GST remittance using the tax code E and it showed on the subsequent period when I posted it with a date in the next month.

    I then edited that entry and removed the E tax code from the GST Paid line.  The dollar value changed.

    I then removed all tax codes and it reversed out the entry completely.

    I posted an entry again completely from the beginning without any tax codes and it didn't show on the report.

    So as I said before

    The only way a payment would show up on the tax report is if you used a tax code. 

    So are you using a tax code?  If so this is likely the cause of your reporting problem.  I've never used a tax code on the remittance entry as there is no sales tax on sales tax payments.

    Disclaimer:  I actually don't use the tax report.  It only tracks entries that use tax codes and does not pick up any entry from a previous period because of the start and end dates of the report.  There is no balance forward.  It also does not include revenue that is posted without a tax code.  I only use the Balance Sheet, Income Statement and General Ledger reporting for validation.  I don't even go through the trouble of partially doing a GST eFile to get a properly completed GST34 form because I can't always get into single-user mode.  I just manually fill in the working copy I have.

  • 0
    SUGGESTED

    You need to use the GST report period end date as your payment date. This will give you an outstanding item on your bank rec however. Alternatively (and more correctly) you post using the GST end date and keep the Invoice as "Pay Later" and then pay it using the date you are actually paying it through your bank. The key is the GST period date.