The Book-keepers Forum (BKF)

Post Info TOPIC: SAGE - start of new financial year and nominal ledger still showing old year's figures.


Newbie

Status: Offline
Posts: 3
Date:
SAGE - start of new financial year and nominal ledger still showing old year's figures.
Permalink Closed


Is that correct or should the nominal ledger show zero balances at the start of the new financial year?

 

Thank you



__________________


Newbie

Status: Offline
Posts: 1
Date:
Permalink Closed

Hi

The profit and loss nominal codes clear down but the balance sheet ones carry on accumulating.  Hope this helps 



__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Silly question, but I'm assuming you've run the year end procedure?

Pauline



__________________

Pauline



Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

Stardoe wrote:

Silly question, but I'm assuming you've run the year end procedure?

Pauline


 

Not a silly question but yes I ran the year end procedures.

Gemmill - yes you are right the p & l nominal codes have zero'd. 

Can the balance sheet ones be reset so it is only the current year that is shown?



__________________


Expert

Status: Offline
Posts: 1609
Date:
Permalink Closed

Auds wrote:
Stardoe wrote:

Silly question, but I'm assuming you've run the year end procedure?

Pauline


 

Not a silly question but yes I ran the year end procedures.

Gemmill - yes you are right the p & l nominal codes have zero'd. 

Can the balance sheet ones be reset so it is only the current year that is shown?


 That's not the idea of the balance sheet, they show running balances, and are designed to be a snapshot of the companies standing at any particular time. There are reports  where you will be able to define date parameters, i'm not sure how much they will help though.



__________________
Steve


Newbie

Status: Offline
Posts: 3
Date:
Permalink Closed

I think what was concerning me as is that this is only me starting my second year of doing my accounts so had gotten used to seeing just one year's amounts.

 

Makes sense that there will be reports I can create, never thought of that so will go and investigate.

 

Many thanks



__________________


Expert

Status: Offline
Posts: 1811
Date:
Permalink Closed

If you wish to see just one year's amounts on the balance sheet, when you run the balance sheet report, select the first month of your financial year to run the report from, rather than "Brought forward". When you do this, the "Year to date" column will show the balance sheet at the end of the period, and the "Period" column will show the changes to the balance sheet in the period in question - and those changes are, by definition "one year's amounts"; the amount shown for "Cash at bank and in hand", for example, won't be the combined balances on your cash and bank accounts, but the sum total of all the transactions that have been recorded for those accounts.

I find that most people don't seem to understand this and, if anythng, get confused by what is shown in the "Period" column on the balance sheet compared with the same column on the profit and loss account. The reality is that in terms of the maths, they're both doing exactly the same thing.

When you run either of the standard P&L and balance sheet reports in Sage you are prompted to enter a period start and end, which goes from "Brought forward" through each month of your financial year, up to "Future".

Both reports present the results with a "Period" and a "Year to Date" column. "Period" shows you the total of all the transactions for each line/category running from the start of the period that was selected, to the end of the period - and therefore represents the *changes* in that period. "Year to date" shows the same total, but running from the brought forward balances, so is the running total up to the end of the period.

On the P&L (and in an ideal world where no mistakes have been made), the brought forward balances will be zero, so if you run from the first month of the year, "Period" and "Year to date" should be the same - and since they are changes from zero, that's how they can represent what the title of the report is: The profit and loss. Similarly, if you run it for just (say) the fifth month of the year, "Period" will contain the changes just in that month; the profit and loss for the month, while year to date will contain the changes for the year up to the fifth month; the profit and loss for the five months of the year so far.

On the balance sheet, however, the brought forward balances contain the closing balances at the end of last year. Therefore if you run it from the first month of the year, "Period" and "Year to date" will differ - the difference being the opening balances, which are included in the latter, but not the former. Therefore, "Year to date" is showing you your actual balance sheet at the end of the period, and "Period" is showing you the changes within that period. So, if you were to run the balance sheet report for the fifth month of the year and look at (say) your "Trade debtors", then the "Year to date" column is showing you how much money you were owed by your customers at the end of the fifth month, and "Period" is showing you how much that has increased or decreased since the end of the fourth month.


__________________

Vince M Hudd - Soft Rock Software

(I only came here looking for fellow apiarists...)

Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  
©2007-2024 The Book-keepers Forum (BKF). All Rights Reserved. The Book-keepers Forum (BKF) is a trading division of Bookcert Ltd. Registered in England Company Number 05782923. 2 Laurel House, 1 Station Rd, Worle, Weston-super-Mare, North Somerset, BS22 6AR, United Kingdom. The Book-keepers Forum and BKF are trademarks of Bookcert Ltd. This forum is a discussion forum only. There will usually be more than one opinion to any question and any posting should not be viewed as a definitive solution. No responsibility for loss occasioned to any person acting or refraining from action as a result of any posting on this site is accepted by the contributors or The Book-keepers Forum. In all cases, appropriate professional advice should be sought before making a decision. We reserve the right to remove any postings which are offensive, libellous, self-promoting or engaged in covert marketing. We will not notify users of removals. The views expressed in the forum posts are those of the individual and do not necessary reflect or agree with those of The Book-keepers Forum. Any offensive or unsuitable posts will be removed by the moderators. Any reader of this forum can request for a post to be looked into by sending an email to: bookcertltd@gmail.com.

Privacy & Cookie Policy  About