Post year end adjustments - After running year end - Question on 'Ledger Year End' journal posting

Hi,

I'm trying to find an answer to my question, but somewhat struggling.

I need to post some year end adjustments to our accounts, normally the accountants advise us to post these on day 1 of the following accounting year, but this messes up my accounts for the current year meaning that I need to perform a load of adjustments off system to balance P1.

What I want to do is post the adjustments in the final day of the year, but since we have already posted the year end ledger cleardown, this will leave a b/f balance in all of the P&L nominals with adjustments in the.  I have read this post https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=200427112207652&guest=0 which suggests that I can post, but then I will have to journal out the balances of the P&L nominals to retained earnings.

My question is how would this report in the system, surely if I post say a debit to Payroll, then immediately credit it by journaling the balance to retained earnings, the movement will be NIL in the period?  How do I get the system to recognise that the journal transferring the balance to retained earnings is a Year End cleardown and not just a normal journal?  i.e. when i use an ODBC connection and look at the prior year movements in the P&L for P12, these movement specifically exclude the system generated cleardown journal.

I hope this makes sense.

Darren

Parents
  • 0

    Robert,

    Thanks for your response, your 1st thought is the correct one.

    My Query is looking at the 'NOMINAL LEDGER' table and then looking at 'PRIOR_YR_MTH1' 'PRIOR_YR_MTH2' ...etc.

    You say that late adjustments will not be reflected in these balances, why is this?  Is there any way that I can get the balances to reflect the post year end adjustment?

    Can I roll-back the Y/E, post my corrections, then re-run the year end process to clear the new balances down?

    I know its a shot in the dark!

    Thanks

Reply
  • 0

    Robert,

    Thanks for your response, your 1st thought is the correct one.

    My Query is looking at the 'NOMINAL LEDGER' table and then looking at 'PRIOR_YR_MTH1' 'PRIOR_YR_MTH2' ...etc.

    You say that late adjustments will not be reflected in these balances, why is this?  Is there any way that I can get the balances to reflect the post year end adjustment?

    Can I roll-back the Y/E, post my corrections, then re-run the year end process to clear the new balances down?

    I know its a shot in the dark!

    Thanks

Children
  • 0 in reply to DarrenF

    These figures stored in the nominal code for PRIOR_YR are, AFAIK, static in that they are just a stored record of the balance as it was when the year end procedure was run.  This is done for speed as it means that when using these figures in the future they will not have to be recalculated as they should not have changed as they are for the previous, closed year.  Whether they change if you add transactions prior to the year close date I cannot say - have a play with the demo data to see what happens (enter something into a nominal code, close the year, enter a prior year end adjustment, see what happens) - but I suspect not.

    I've no idea about rolling back the YE.

    This is now into the realms of Sage support.

    Sorry.