Year end

Hi there,

Just a little backstory to my problem:
  • In Dec 2017 we did not manage to perform the year end properly and sage didn’t change the financial year to 2018. 
  • In Dec 2018, we tried the year end and once it was completed, it said your new financial year is 2018 (but we needed it to be 2019)
  • So we performed the year end again and it eventually said your new financial year is 2019.
  • Now, when we try to generate our last years P&L and balance sheet, it shows us 0.00 as values (as though no transactions occurred).
  • We cannot choose to view the years prior either. Under the nominals tab, when we click P&L, it gives us option of "brought forward" and "Jan-Dec 2019". 
I would appreciate if someone can help sort this out. 
Thank you.
  • 0

    Somji

    The opening (brought forward) balance sheet in your Sage now is the closing balance sheet at 31/12/18 which is half of what you want.  The other half is to get the profit and loss account for the year ended 31/12/18.  Do the following.

    1.  Do a backup (always a good idea).

    2.  Generate an opening (brought forward) trial balance (which the trial balance at 31/12/18) and export it as a cvs file.

    3.  Restore the Sage backup that hopefully you did as at 31/12/17.  

    4.  Do a Month 12 trial balance (i.e. as at 31/12/17) and export it also as a cvs file.

    5.  Restore the backup that did in Step 1 to get back to where you started.

    6.  Put the figures of the two csv files side-by-side and subtract one from the other, row by row and making sure that the account numbers line up.  The resulting income and expenses figures are the profit and loss account figures for the year ended 31/12/18.

    Richard

  • 0 in reply to Richard Lebus

    Thank you Richard! I will try this and let you know how it went. Cheers!