Prior year info correction

SOLVED

AMy client’s former accountant said her Simply Accounting file was compromised, so all I had to go on for historical data was the balance sheet for the last year end, generated not long after the fiscal year end (May 31/22). Once I entered the historical info on hand, I closed the “enter history” option.

I'm almost finished entering the current fiscal year's data and stumbled on a copy of the GST return (annual) filed for last fiscal. I realized that the balance sheet entry to May 2022 for GST was incorrectly stated on the financials. I've looked back and the numbers remitted to CRA were correct. Odds are that the prior accountant made adjustments after that report but without her Simply file, I had nothing else to go initially when setting up the company file in Sage.

What can I do to fix this? I can't enter the correction as last year even though I know that's where the adjustment really belongs. For the moment, I did a journal entry to correct the starting balance to what the GST return was filed as to get that off the balance sheet, and I offset the difference to an expense account that I labeled as "GST historical correction". Is this the right process? This will impact the income statement instead of the balance sheet and I don't want that either because it’s incorrect regardless. I want to make it go away altogether.
Any suggestions are very welcome.

  • 0
    SUGGESTED

    Hi  ,

    Thank you for reaching out, I see that you're navigating a challenging situation with historical data in Sage.  Hopefully, you already received a workable answer to this. To give you specific guidance:

    1. Sage 50 Canada (formerly Simply Accounting*) only allows adjustments to be made in the current and prior fiscal years. Since the issue originates from last fiscal year, you're within guidelines to make an adjustment.

    2. You can use the 'Adjust a previously processed entry' option in the general journal to correct the GST account. Ensure the date for this is within the last fiscal year.

    3. If the "Do not allow transactions dated before" setting is enabled, temporarily disable it via Setup, Settings, Company, System.

    4. Confirm your final financials with an accountant before submitting them to the CRA.

    Your initial "GST historical correction" journal entry is a stopgap but will impact your income statement. It's better to use Sage's features to make a more accurate adjustment.

    Since your issue pertains to Sage 50 Canada, I'm moving your post to the Sage 50 Canada General Discussion Forum where other users can offer more targeted advice.

    Hope this helps and let me know if you have further questions.

    Warm Regards,

    Erzsi

  • +1 in reply to Erzsi_I
    verified answer

    I appreciate the reply, Erzi! 

    The adjustment I needed to make did impact the income statement, but honestly that's probably for the best.  I couldn't use the prior year because I created my file for the 2022/2023 fiscal year based on the financial statements of the prior bookkeeper.  I didn't have her data file at all so I had to start from scratch.  Naturally, I didn't discover the errors until I had closed the option to enter historical information. 

    I double checked with an accountant to make sure the entries I did were done correctly.  I also made notes for the incorrect reporting on the prior fiscal so I can address any issues that arise due to the adjustments.  

    Thank you again,

    Valerie

  • 0 in reply to Valerie G2

    Thank you for closing the loop here and sharing what you ended up doing! Slight smile