Hi TGS,

As you mentioned I'd recommend following this article: Sales / Purchase aged balance disagrees with control account

The message about  the journals not balancing means that the value in the Debit column does not equal the value in the Credit column. If it does balance, I'd suggest clearing the journal entry and entering again in case there is a blank line causing an issue.

If the problems persist, you can contact Sage Technical Support here.

Andy,
Sage UKI

Hi Andy

Please see my other reply about journals being posted to the control account. The help file ("How do I record late entries for an earlier period?") needs to be updated as it will cause exactly this issue.

Anita

Morning Andy 

Thank you for the reply. 

But that's the point, i am following these instructions and then it comes up with the error message "Journal do not balance, Ensure the Debits total is the same as the Credits total". 

My question is how do I get past this? As stated above 

TGS said:

I can not delete nor edit the transaction and if I try to rectify the balance sage says that I can not post to nominal code 1100

I don't know what else to do to clear this warning message. 

So I get this far in the process and can not get any further. 

Morning,

When you run the Daybooks: Nominal Ledger report  as per the article, is there a difference in the totals at the bottom of the report?

Andy

No. Same in both columns. 

When I run it by nominal code 1100 there is around £6k in the debit column but nothing in the credit column. 

Either there has been some corruption in the data, or someone has posted a journal to the control account. Back up first and add "error" to the backup name.

Go to the Nominal Ledger, Debtors Control Account (usually 1100), Activity screen.  If you know it's a recent error you can filter for just the last few months, otherwise let it display all transactions.  Export it to Excel.  In Excel, sort it into transaction type order. 

You are looking for transaction types other than S*, so it could be a BP or JD for example. If it's a journal, make a note of the details then delete it.  Depending on why the journal was posted in the first place, you may need to recreate it using a different N/L code.

You mention that Sage says you can't post to nominal code 1100.  You can, but it comes with a message warning you that it won't be reflected in the ledger. It can be overridden but only do so in exceptional circumstances.

It may be corrupted, sage wont even let me change or delete it that way either. 

We have no idea what it even goes to or why it was posted. 

There are not details of associated transactions, no account reference or any information like that.