The Book-keepers Forum (BKF)
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> Sage Line 50 - Balance Sheet
Post Info TOPIC: Sage Line 50 - Balance Sheet
dovid40


Member

Status: Offline
Posts: 9
Date:
Sage Line 50 - Balance Sheet
Permalink Closed

I need assistance in trying to solve an issue with the balance sheet reporting. On the Tb there are balance sheet items but when you prepare a balance sheet they do not appear.We have checked postings and dates etc but when we run the report the figures do not appear. Appreciate help on this one.



__________________
j hamilton
Peasie


Expert

Status: Offline
Posts: 1707
Date:
Permalink Closed

Have you checked the "Chart of accounts" ?



__________________

Never buy black socks from a normal shop. They shaft you every time.

http://www.smbps.co.uk/
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi There, thanks for your help but we have checked the chart of accounts and the Nml accounts fall into the correct categories.

__________________
j hamilton
Wella


Expert

Status: Offline
Posts: 2256
Date:
Permalink Closed

Probably already done this but just to be sure, have you run the check C0A button at the bottom of the screen? This will show any nominal accounts not included in the selected C0A.

Also, are you using the default CoA, or a custom one?. If you are using a custom one, is it set to default? If not Sage will use the standard set up, which may not include your new nominals.

HTH

Bill



__________________

 

 
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi There, checked this and no errors were found

__________________
j hamilton
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

We are using Sage's default setting



__________________
j hamilton
ADAS


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Can you tell us what the accounts and nominal codes are?

No offense meant but can you confirm the accounts have a closing balance and the codes you're looking for aren't included in another figure in the balance sheet

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi there

Nom Codes are 2300/2301/2302 & 2330

All have a closing balance and I confirm that these codes are not included in any other fig. in the balance sheet.



__________________
j hamilton
ADAS


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Hi J'

It's interesting that the accounts you've listed normally appear added together under "Long Term Liabilities" - does that line appear on the Balance sheet report, even if there's no figure next to it?

I'm thinking, that if the Chart of Accounts is correct then maybe the Balance Sheet Report itself has been edited

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi there
The Long Term Liabilities line does appear on the report but the value shows as '0.00'. I am not aware that anyone has edited the balance sheet report so I will look into this.




__________________
j hamilton
ADAS


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

When you look at the Chart of Accounts, check which category includes the range 2300 - 2399? By default they should be in the range mentioned above.

Can you tell us where they actually appear bud?

Edit:

Dont think you've been asked this but does your Balance Sheet balance and the problem is you can't see some items that appear on the TB?



-- Edited by ADAS on Monday 24th of October 2011 02:35:35 PM

__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

In The Chart of accounts, the category the range 2300-2399 appears in long term liabilities.
The balance sheet does balance and the items appear on the TB but the issue is they do not appear on the balance sheet report in financials

__________________
j hamilton
ADAS


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

Assuming the three financial reports are all run to cover the same period - then I"m stumped how this can happen given all the checks you've been asked to do.

Sorry.



__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

We have 20 Companies on sage and this was put on recently, so there are only 5 transactions, so what we ere thinking of doing was deleting the transactions and then rentering them to see if this corrects the issue. We feel that there has been a conflict somewhere so we are tryig all solutions to remedy this.
Anyway thanks for your time and effort.

__________________
j hamilton
gbm


Guru

Status: Offline
Posts: 896
Date:
Permalink Closed

A couple of thoughts:

If the transactions are all in one range, do they all net out as zero?

Also, the transaction dates are within the year you're reporting on?

__________________

 

Regards,
Nick

Website: www.gbmaccounts.co.uk
Twitter

Factsheet | Starting a Business

 
ADAS


Guru

Status: Offline
Posts: 827
Date:
Permalink Closed

gbm wrote:



If the transactions are all in one range, do they all net out as zero?


 Good call Nick, never thought of that one..



__________________
Tony

Responses are intended as outline only. Formal advice should be sort from your Institutes Technical Department or a suitably qualified Accountant.
.
dovid40


Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi There, you were absolutely correct. We had added new nominal codes and it has now come clear as to why the balances were being masked. Thanks for this help and also I thank the help from the guys at ADAS



__________________
j hamilton
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.
The Book-keepers Forum (UK) -> General Book-keeping & Accounting -> Sage Line 50 - Balance Sheet
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