Nominal Account balances are shown in the record as at the current period of the open year, and the way these are calculated differs between Balance Sheet (Bal) and Profit and Loss (P&L) records.
Balance Sheet accounts hold the running total of transactions from the beginning of processing and so in theory, running a Transaction Enquiry up to and including the current open period will show the same total as the record.
However, if transactions have been purged at year-end then the balances will have been retained and so will no longer correspond to the sum of transactions. This is common in long standing datasets as transactions may have been removed historically to deal with disc space issues etc.
Profil & Loss accounts are cleared down at year-end and so will only show the total of transactions up to, and including, the open period for the current year. There should be no reason why balances and transactions do not match.
If you require further assistance Support will need to run some scripts on the database. Therefore please raise a new case online and reference the title of this article and please include details of the Nominal Accounts affected.
Nominal account balance does not match the sum of transactions
Updated over a week ago