Sage doesn't balance

Sage doesn't balance

Didn't find your answer?

A client has just sent us a sage back up file so that we can prepare the company's accounts.

The trial balance doesn't balance (and there is nothing in either of the automatic suspense accoounts - 9998 and 9999).

Any suggestions?
Patrick

Replies (13)

Please login or register to join the discussion.

avatar
By AnonymousUser
30th Jul 2008 11:00

Have you solved this yet.....?
Patrick

Have you solved this - what was the problem - it would be good to have some feedback!

Thanks (0)
By brucedenney
24th Jul 2008 18:51

Year End Procedure
The technique described works only where the bucket values are corrupted, in which case a transactional TB will correctly balance.

If the transactional TB does not balance then you need to use the data repair services of your local sage reseller or that of sage themselves.

Thanks (0)
avatar
By adandy
24th Jul 2008 09:40

Year end procedure
Had this on Monday myself, the answer as steven suggests is to change the year start date then change it back again, this will sort your data problem.

Take backup first just to be safe :-)

Thanks (1)
avatar
By superste1981
23rd Jul 2008 16:50

Year end proceedure
I have had this on a couple of clients, the problem is usually caused by running a year end proceedure, which then produces corrupt data. In my cases the period trial balance does not balance however a transactional trial balance did. If this is the case to resolve the problem you need to change the period start date in Sage, and then change it back to the correct start date. This will correct the data corruption and your TB should balance again.

Thanks (0)
avatar
By barrysnashall
23rd Jul 2008 16:03

Sage corruption
It would appear that your client has a corrupt Sage databse, it is possible to resolve, I am MD of Delandale Solutions Limited www.delandalesolutions.com an IT company specilising in Sage50 i would be happy to have a look at the Sage dtaa for you. Please contact me Barry

Thanks (0)
avatar
By AnonymousUser
23rd Jul 2008 09:16

non balancing journals
"About 17 years ago, a client had a non balancing tb when the computer was switched off half way through a journal.

Guess how we managed to post a non balancing journal to correct it!

I know - all you computer boffins tutting out there, but it worked. "


Hahahaha! Love it :)

Thanks (0)
By David2e
23rd Jul 2008 09:10

Also think Chart of Accounts for reporting
Hi Patrick

As suggested by Jane, check the Chart of Accounts Layout as the TB report uses this to identify what accounts to include.

A datacheck usually picks up the error, or you can see what the difference is and might identify which account (if only one) has been left out of the range included in the Chart of Accounts layout.

We've seen this error several times - and has so far the Chart of Accounts always been the reason.

David Toohey
The Accountants

Thanks (0)
avatar
By User deleted
22nd Jul 2008 19:59

I saw this once
About 17 years ago, a client had a non balancing tb when the computer was switched off half way through a journal.

Guess how we managed to post a non balancing journal to correct it!

I know - all you computer boffins tutting out there, but it worked.

Is it possible to post a non balancing journal via recurring entries though? I don't know if you can, but I have wondered what would happen if you set up just a debit and didn't set up the corresponding credit, as I think it has to be set up in two parts??

Thanks (0)
By brucedenney
22nd Jul 2008 16:08

Part transaction corruption
I think this is probably data corruption.

You will, I expect, be able to find half a journal with the other half missing.

This happens when the first part of the transaction is written to the database and then before the second part is written, network connectivity, or the pc are lost and the error is there.

File Maintenance would normally spot this sort of thing.

The trouble is you can't delete the half transaction, because you cant edit journals and so on.

I have "hacked" the files to remove such errant transactions in the past.

Sage should be able to offer a similar service with their data recovery charge.

Thanks (0)
avatar
By User deleted
22nd Jul 2008 15:26

Transactional Trial Balance
Patrick,

I have seen this as well. An alternative that sometimes works is to run a transactional Trial Balance.

Thanks (0)
avatar
By AnonymousUser
22nd Jul 2008 14:06

Check the chart of accounts layout
Get the client to check the chart of accounts layout - they may have added new nominal records and not updated the layout. It should give them a warning message when they print out the TB or P/L or Balance Sheet that there are errors but a lot of people ignore it!

They may have more than one chart of accounts layout - check they are printing out the correct one.

Thanks (0)
avatar
By User deleted
22nd Jul 2008 13:04

Seen this twice before...
First time the difference was in the 3XXX series using charity module. Second time was using foreign currency module where a journal balanced but was posted into differnet years

Thanks (0)
avatar
By fiobian
29th Oct 2012 14:13

I had the same problem.

 

I did as people suggested here, change the financial year start date and re change it to the correct one.

 

It worked.

 

Thank you!

Thanks (0)