Payroll

Correcting Employees wages once you have updated the wages

You might find that after you have updated the wages for the payroll run, new information comes to light and you need to re-run the payroll for that employee – examples could be a change to an Attachment of Earnings etc, missing overtime etc.

Solution

1. Back up your data.
2. On the Employee List, select the required employee(s).
3. Click Tasks, then click Rollback.
4. Click Next.
5. Check the employee(s) on the list is the one(s) you want to rollback, then click Next.
6. Select the earliest pay period that you want to remove.
7. If you select the employee’s first pay period, the following message appears ‘You have selected the oldest update. Do you also want to clear the following information?’ with a list of information.
8. Click No on the message. Only click Yes if you are certain you need to clear the values listed.
9. Click Next then click Finish.
10. Click OK.

You can now process your payroll again for the employee(s) that you have rolled back, including any statutory payments you have previously processed.

If you re-run pre-update reports these will only include the employee(s), you have rolled back.

Pension Details

If you have already submitted your pension data and the figures have changes, you will need to let your pension provider know.  You will need to contact your provider on how to make this amendment.

If you need help with rolling an employee(s) wage back or need any other help or advice with your payroll, please contact us on

We can also provide a remote access service where we can link into your computer to help you resolve your Sage Accounts or Payroll problems.

Sage 50 Accounts

Automatic contra entries

Sometimes you might have a customer who is also a supplier, and you want to offset customer and supplier invoices.  This is a contra entry.

You can not use Automatic Contra Entries if:

• If you operate a VAT Cash Accounting scheme.
• You need to offset customer or supplier transactions other than invoices. For example, customer credit notes (SC) with supplier credit notes (PC)
• CIS transactions – you can post manual contra entries for the full value of CIS transactions only.
• Non-base currency transaction.

Post manual contra entries – covered in next month’s newsletter.

Create a contra entry bank account.

1. Go to Bank accounts, then select New.
2. Enter the relevant details for the new bank account:

A/C Ref * The nominal code you want to use for the new bank account.

Note: If you are using Sage’s default nominal ledger structure, use a number within the range of 1200 to 1239.  These numbers are in the existing bank account range in the Chart of Accounts.  This ensures that the bank balances appear correctly on your Management reports.

Nominal Name Enter a description for the new bank account, for example, Contra Entries bank account.

A/C Type Select Cheque Account from the drop-down list.

No Bank Reconciliation If you do not want to run a bank reconciliation for this bank account, select this.

3. Click Save then click

How to post the contra entry

1. Go to Customers or Suppliers, and then select Contra Entries.
2. Select the contra entry Bank A/C, then select the relevant A/C Ref for both the Sales Ledger and the Purchase Ledger.
3. Select the invoices to offset against each other from both windows, then click OK.

If there is a mismatch in values, you are prompted to part contra the lowest account.

For example, a £120.00 contra entry offsets a £120 sales invoice, leaving £30 outstanding on a £150 purchase invoice.

4. To confirm this, click Yes.

The contra entry posts an SR and a PP to the contra entry bank account.  The accounts are the value of the invoices, or the lessor value if applicable.

Reserve a contra entry

To reverse a contra entry, delete or reverse the transaction posted due to the contra entry.  To do this, identify the transaction and delete or reverse them as usual.

If you would like any help with creating a contra bank account and or doing contras or if you need any other help with your Sage 50 Accounts, please contact us