The Book-keepers Forum (BKF)

Post Info TOPIC: trial balance


Veteran Member

Status: Offline
Posts: 62
Date:
trial balance
Permalink Closed


Hi

I am having trouble with a trial balance that does not match, after spending hours looking at this I have found that the amount it is out by is the amount connected with nominal 0060 for company purchase, has anyone come across this before?  and does anyone know the best way to correct this?



__________________


Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi Keely,

Is this a real life situation we're talking about here or a study situation?  I assume this is a Sage Trial Balance?  If a Trial Balance in Sage doesn't balance it strongly suggests data corruption.  Have you done a Data check?  Does it throw up any errors?



__________________

Pauline



Veteran Member

Status: Offline
Posts: 62
Date:
Permalink Closed

hi pauline

this is a real life situation not training.  it is in sage i did read somewhere about this with data corruption and to correct it is change year end date by one month then change back?  have you come across this and do you know of a better way around it?  i have done check data and no errors or comments arise and there are no errors in the coa.  any ideas?



__________________


Guru

Status: Offline
Posts: 513
Date:
Permalink Closed

Hi Keely,

You have three options (that i can think of):

1, send it Sage to get it fixed, i think there may be a charge

2, if you know which entry is missing, causing the TB not to balance, you can just make a manual adjustment when preparing the accounts (not ideal)

3, When you come to the year end start another business in Sage and transfer accross the opening balances.

hope this helps

Nick



__________________

Nick 

Nick Craggs FMAAT ACA  AAT Distance Learning Manager

@nickcraggs 

BKN Tutor of the Year 2013 & 2015


footer_logo.png



Veteran Member

Status: Offline
Posts: 62
Date:
Permalink Closed

hi nick

it is the whole of code 0060 which was set up for company purchase, the four items in this nominal total the whole amount that the tb is out by, very strange.

__________________


Guru

Status: Offline
Posts: 513
Date:
Permalink Closed

have you checked your Chart of Accounts?  It could be outside of this?

You could just journal the amounts to another code if it a case of this account not being shown in the TB.



__________________

Nick 

Nick Craggs FMAAT ACA  AAT Distance Learning Manager

@nickcraggs 

BKN Tutor of the Year 2013 & 2015


footer_logo.png



Guru

Status: Offline
Posts: 1470
Date:
Permalink Closed

Hi Keely,

You could send the data to Sage to get it fixed, but it would probably cost an arm and a leg, although over on the Sage forum there is someone who could do it for a fraction of the cost. Strange that data check didn't bring up any errors. The TB shouldn't be affected by the COA so not sure this is the answer. What version of Sage are you using, is it Instant or Line 50? Could you send me a pdf of the TB?

__________________

Pauline



Member

Status: Offline
Posts: 9
Date:
Permalink Closed

Hi Keely,

I'd personally be checking the nominal structure within your COA. Is the bs out by the same value? As this will help rule out nominal report errors.



-- Edited by Paddylad on Tuesday 1st of January 2013 06:31:43 PM

__________________


Senior Member

Status: Offline
Posts: 133
Date:
Permalink Closed

Where does sage report the difference? On the balance sheet or file maintenance/check data?

__________________
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