Hi Dawn,

Thanks for using Community Hub.

If you run the Transactional Trial Balance for the same date range as the nominal is it correct? You can access this in Nominal > Reports > Trial Balance > Transactional Trial Balance.

I'd also suggest recalculating the period values. To do this, first take a backup, then open File > Maintenance > Recovery tools > Recalculate Period values.

If the issue persists I would then suggest contacting Technical Support so they can look at it further for you: Sage Technical Support >

Regards,

Andy
Sage UK

Hi, 

Thank you for your response. 

The transactional TB for the date range is correct. 

I have actually year ended the client so am unable to run the recalculate period values now - the correct balances have come forward to the new year. If it happens again I will recalculate. 

Thanks 

Dawn 

If you've done the year end, if you can use the transaction number limit to stop the transactional TB report to just before the cleardown journal (there should be no further transactions for any previous year after the cleardown journal).

If you want to find out exactly what is going into each nominal of the TB you will need to edit the transactional TB report :

1. Edit the report
2. Using the "Report Explorer" select and change the "Properties" of the Details section: Behaviour>visible to True
3. Add extra variables for AUDIT_JOURNAL_Date, AUDIT_JOURNAL.INV_REF, AUDIT_JOURNAL.DETAILS (you may also like to add AUDIT_JOURNAL.HEADER_NUMBER to be able to quickly locate the transaction) tot he Details section
4. Save in My Nominal Reports (eg "TRANTB Details")

When you Export Data to Excel you will now get a list of the transactions that are being used to create the TB.

If you've done the year end, if you can use the transaction number limit to stop the transactional TB report to just before the cleardown journal (there should be no further transactions for any previous year after the cleardown journal).

If you want to find out exactly what is going into each nominal of the TB you will need to edit the transactional TB report :

1. Edit the report
2. Using the "Report Explorer" select and change the "Properties" of the Details section: Behaviour>visible to True
3. Add extra variables for AUDIT_JOURNAL_Date, AUDIT_JOURNAL.INV_REF, AUDIT_JOURNAL.DETAILS (you may also like to add AUDIT_JOURNAL.HEADER_NUMBER to be able to quickly locate the transaction) tot he Details section
4. Save in My Nominal Reports (eg "TRANTB Details")

When you Export Data to Excel you will now get a list of the transactions that are being used to create the TB.