KB Category: Sage 50 Accounts

Sage 50 Accounts

Check for currency corruption (7)

Check for currency corruption (7)

If the currency information in your data is corrupt, this may cause the aged creditors reports to show an incorrect balance.

To check for currency corruption, remove the currency code and currency symbol from the aged report.

1. Suppliers > Reports.

2. Select the Aged Creditors Analysis (Summary) report > Edit.

3. Select the Currency Symbol variable > press Delete.

 

 

4. Select the Currency Code variable > press Delete.

 

5. File > Save As > ensure Save in is My Supplier Reports > Save.

6. Close Report Designer and the Report Browser.

7. Reports > My Supplier Reports > select the Aged Creditors Analysis (Summary) report > Preview.

8. Enter the criteria > OK.

 

Check for bucket corruption (6)

Check for bucket corruption (6)

Bucket corruption occurs when the nominal code bucket values disagree with the total of the activity for the same period.

Sage Instant Accounts, Sage Instant Accounts Plus and Sage 50 Accounts

Run the Nominal Activity report for each month in the current financial year and compare each history balance to the buckets.

Step 1 – Run the Nominal Activity report

  1. Nominal codes > Reports > Nominal activity > Nominal Activity.Sage Accounts 2014 (v20) and below – Modules > Nominal Ledger > Reports > Nominal activity > Nominal Activity.
  2. 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

  1. Nominal codes > double-click the relevant nominal code.Sage Accounts 2014 (v20) and below – Modules > Nominal Ledger > double-click the relevant nominal code.
  2. 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.

 

Sage 50 Accounts Plus and above

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

  1. 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.
  2. 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.

 

Click here Continue to (7) or  here to go back to Summary

Run Check Data to check for errors or a warning relating to the purchase aged balance (5)

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.
  • If this warning appears, to go to Step 3 click Next.

 

Click here Continue to (6) or  here to go back to Summary

Download and run the Aged Reconciliation reports (4)

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.

To download the Aged Reconciliation reports

Sage Accounts v21 and above – Download and restore the Sage Accounts v21 and above – Additional Reports Backup.

Sage 50 Accounts 2014 (v20) and below – Download and restore the Sage 50 Accounts 2014 (v20) and below- Additional Reports Backup.

Sage Instant Accounts 2014 (v20) and below – Download and restore the Sage Instant Accounts 2014 (v20) and below- Additional Reports Backup.

For further information about how to download and restore these, please refer to article 28447.

 

Click here Continue to (5) or  here to go back to Summary

Check for journals posted to the Creditors Control Account nominal code (3)

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.

 

Click here Continue to (4) or  here to go back to Summary

Ensure that you run the correct trial balance report with the correct criteria (2)

Ensure that you run the correct trial balance report with the correct criteria

You must use the following:

Report
  • Nominal codes > Reports > Trial balance > Period Trial Balance. Criteria
  • Sage Accounts 2014 (v20) and below – Modules > Financials > Reports > Trial balance > Period Trial Balance.
Criteria
  • Period – Choose the month being reconciled.
Figure

The total for the Creditors Control Account.

 

Click here Continue to (3) or  here to go back to Summary

Ensure that you run the correct aged creditors report with the correct criteria (1)

Ensure that you run the correct aged creditors report with the correct criteria

Before running the aged creditors report, ensure there is no search applied to the Suppliers list and that no suppliers are selected.

You must run the following report:

Report

  • Suppliers > Reports > Aged creditors > Aged Creditors Analysis (Summary). Criteria

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.
  • Inc Future Tran – Clear.
  • Exc Later Payments – Select.

Figure

Click here Continue to (2) or  here to go back to Summary

Check for updates – There are no new updates (Sage 50 V24.2)

Error

If you are prompted to check for updates in Sage Accounts v24.2 but no updates are found, you can manually download these updates instead.

 

Solution:

1. Log onto your computer as an administrator and close all software.

2. You can log into our website to download Sage 50 Accounts v24.2, then click Save link as or Save target as.

3. Make a note of the file name, browse to the Windows desktop, then click Save.

4. On the Windows desktop, double-click the downloaded file, then follow the on-screen prompts.