In the Criteria, enter the first and last date of the month and do not select the Inc B/Fwd Tran check box.
Step 2 – Check the value in the nominal bucket
Nominal codes > double-click the relevant nominal code.Sage Accounts 2014 (v20) and below – Modules > Nominal Ledger > double-click the relevant nominal code.
Check the actual figure in the bucket for the required month.
For example, for nominal code 4000, if the Nominal Activity report shows a history balance of £100 in February, but the February bucket shows £50, there is bucket corruption.
Another way of testing for bucket corruption is to run the transactional management reports. These reports build their figures based on transactions instead of reading the nominal bucket values
To run the transactional reports
Nominal codes > Reports > Profit and loss / Balance sheet > Transactional Profit & Loss / Transactional Balance Sheet.Sage Accounts 2014 (v20) and below – Modules > Financials > Reports > Profit and loss / Balance sheet > Transactional Profit & Loss / Transactional Balance Sheet.
In the Criteria, enter the first and last date of the month.
For example, run the Profit and Loss report for the month of January 2017 run the Transactional Profit and Loss report entering the date range from 01/01/2017 to 31/01/2017. If the values are different, this indicates bucket corruption.
If running these reports indicates bucket corruption, to resolve this please refer to article 13921.
If there is no difference in these reports click Next.
Run Check Data to check for errors or a warning relating to the purchase aged balance (5)
To run Check Data, File > Maintenance > Check Data.
Errors
Any errors reported may be causing the problem and must be corrected before continuing. For further information about correcting errors, please contact us on 051-395900 or [email protected]
Warnings
The only warning which indicates problems with aged creditors is:
‘Purchase Aged Balance disagrees with Creditors Control by (amount)’
The two reasons for this warning are:
Journals posted to the Creditors Control Account – Step 4 will identify these.
Link removed transactions – Step 5 will identify these. For further information about link removed transactions, please refer to Ask Sage article 14578. If this warning does not appear, go to step 6.
Download and run the Aged Reconciliation reports (4)
If the previous steps have not highlighted the discrepancy, it is likely that it is caused by the allocation dates on some transactions.
For example, a PI dated after the report date, has been allocated to a PC with an allocation date prior to the report date. The Aged Reconciliation reports highlight any transactions with allocation problems or links removed.
For a more detailed explanation of link removed transactions, please refer to article 14578.
Check for journals posted to the Creditors Control Account nominal code (3)
1. Run the following report:
Nominal codes > Reports > Day books > Day Books: Nominal Ledger.
Sage Accounts 2014 (v20) and below – Modules > Nominal Ledger > Reports > Day books > Day Books: Nominal Ledger.
2. Enter the following criteria:
Transaction Date: Between (inclusive) – 01/01/1980 and the last day of the month being reconciled.
Nominal Code: Is 2100.
2100 is the default code for Creditors Control. You can check this in Settings > Control Accounts.
3. Check the totals for the Debit and Credit columns. If the values are the same, then journals are not the reason for the difference. If the values are different, subtract one from the other to give the difference.
If a journal is posted to the Creditors Control Account, it changes the value on the nominal code. However, the same value is not reflected anywhere in the supplier’s record, and as a result does not affect the aged creditors reports, resulting in the discrepancy.
Under normal circumstances, you should not post journals to the Creditors Control Account. The only time this should happen is when entering and reversing opening balances.
Difference
If there is a difference, you must determine if the journals are correct or not.
If they are correct, no further action is needed and there will always be a difference between the Aged Creditors and the Creditors Control Account because of the journal.
If they are incorrect, the journal could be reversed or a further journal can be posted to move the discrepancy to a different nominal account.
If you are not sure if the journals are correct or not, please refer to your accountant.
No difference
If there is no difference, it means that the journals posted to the control accounts are not causing the discrepancy.
If there are any suppliers with an underscore, or other non-alphanumeric characters, in their account reference, for example, Z_01, the aged creditors report may exclude some suppliers.
Criteria
Supplier Ref – Leave as default.
Report Date – Enter the last day of the month being reconciled.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional
Always active
The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences
The technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics
The technical storage or access that is used exclusively for statistical purposes.The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing
The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.