Sage Payroll

Customise your payroll desktop and employee list

You can customise your employee list in Sage 50 Payroll to make it easier to find what you want.

Sort a column

To sort a column

1. Click the column heading. Click the column heading a second time to sort the list in revers order.  Click a third time to revert the list to default order.
2. Right-click the relevant column heading, Sort Column or Reverse Sort Column. To remove a sort on a column, right-click the column heading, and click Sort Off.

Tip: If a sort has been applied to a column, it will have an arrow indicating the order of the sort.

Re-order columns

You can re-order the columns to show the employee list in any order you prefer, for example you may want employees surnames to appear on the list first, followed by their forenames, then employee reference numbers.

To re-order columns, drag the column headings to the desired position.

Tip: Although you can not hide columns, you can move unwanted columns to the far right of the window.

Change column widths

You can also change the width of a column, to make it wider or narrower.

To change the width of a column, click and drag the vertical bar to the right of the relevant column heading.

To reset column widths, you can either:

• View menu then Reset Column Widths.
• Right-click on the desktop then Reset Column Widths.

TIP: Resetting the column widths also reverts the column order back to the default settings.

If you would like help with sorting columns or re-ordering columns or altering the column widths etc or need any other help or advice with your payroll, please contact us

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

How to filter lists

Using the Filter options in Sage 50 Accounts can help to locate records quickly and easily or hide unused ones.  For example, filter customers to only show those with a balance.  This is available in all modules except Transactions, filtered results apply to reports you run.

Create a Filter

1. Open the required module, for example, Customers, then click Filter.
2. If required, to clear a previously created filter, click Discard.
3. Complete the filter window as follows:

TIP: For further help with creating your filter, use the Wizard option.

Join                 Click Where.

Field                Click the field you want to filter on, for example, Balance.

Condition         Click the required condition, for example, Is Not Equal To.

Value               Enter the value to apply to the condition. 0.00

4. To apply the filter without adding a further line, Click Apply.
5. To add another line to the filter, click the space below then select And or Or as required.
6. Complete the Field, Condition and Value
7. To save the filter for later use, click Save As, enter a file name, then click Save.
8. To apply the filter, click Apply, then click Close.

Your filter applies and the software shows how many records match the filter criteria.

To reverse the display, click the filter icon or spy glass on the module banner.

You can also use filter options to restrict the records that appear and help with reporting.  If you would like help with filters etc, or if you need any other help with your Sage 50 Accounts, please contact us

Sage Payroll

Search for Employees

If you are looking for a specific employee or employee(s), the Find option can be especially useful.  You can search using all or part of the data shown in the employee list.  E.g. All or part of the employee’s name, their payment period or payment method etc.

Search for an employee

1. Click View (next to File on top menu), then click
2. Enter the information you want to search for in the Find
3. Use the Within drop-down list to search all data in the employee list or data from a specific column.
4. Use the Where option to search for data that contains part of the text entered, or that exactly matches it.
5. To perform your search, click Find then click OK.

The matched records are then highlighted on your employees list.

TIP If you need to find an employee who has left, check that the current year historical leavers are showing.  To do this click Criteria above your employee list and clear the Current Year Leavers and the Historical Leavers field, then click OK.

If you would like help with search your employee list or need any other help or advice with your payroll, please contact us

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

Search – Quickly find a transaction

The ability to find a transaction quickly and easily within a list can save a lot of time and effort, thus saving you scrolling though hundreds of transactions to find the transaction you want.  The more transactions you have the, the more useful this option becomes.

Find a transaction

To access the find option click Transactions, then Find.

The find option is then split into the following areas:

Find                 Enter the text you want to search for

EXAMPLE: Account reference, transaction number, date, amount,  details etc.

Search in         Choose the field you want to search in.

EXAMPLE: If you are looking for an account reference, choose the Account Reference field from the drop-down list.

Match               Choose the type of match you are looking for from the following.

Any finds all transactions that contain the details you have entered, anywhere in the field you are searching on.

EXAMPLE: Searching for an Account Reference containing the text JON, matching the Any option, finds JON, JONES, JOHNSTON, PJONES.

Whole finds the transaction that contains the exact details you have entered.

EXAMPLE: Searching for an Account Reference using the whole option only finds JON, not JONES, or JOHNSTON or PJONES.

Start finds all the transactions that contains the details you have entered at the beginning of the box you have searched on.

EXAMPLE: Searching for an Account Reference JON at the start of the box finds JON, JONES, and JOHNSTON not PJONES.

Case                 Select this check box if you want your search to pick up capital and Sensitive      lower-case letters, exactly as specified in the Find What box.

You can also use the search and filter options to restrict the records that appear, we will go through filters next month.  If you would like help with searches or correcting transactions etc or if you need any other help with your Sage 50 Accounts, please contact us

Sage Payroll

Set up and use Custom Absence Types

How to create customised absence types that are not covered by the default absence reasons.  For example, unpaid leave, leave for exam revision and exams etc.

Setting up a custom absence type

1. Click Company, then click Settings.
2. Click the Absence tab then, under Custom Absence Reasons, click one of the Description boxes.
3. Enter a description, for example, Exam Revision.
4. Repeat steps 2 and 3 for each custom absence you want to set up.
5. Click OK.

Enter a custom absence using Diary Entry

1. Double-click the required employee, then click the Absence
2. Click Diary Entry then, from the Absence Type drop down list, choose Custom Absences.
3. From the second Absence Type drop down list, choose the required absence type.
4. From the From drop-down list, choose AM or PM then, in the From date box, enter the required date.
5. From the To drop-down list, choose AM or PM then, in the To date box, enter the required date.
6. If required, enter absence details in the Comment box, then click OK.
7. Click Save, then click Close.

Enter a custom absence using click and drag

1. Double-click the require employee(s), then click the Absence tab.
2. Click and drag to select the required dates, then right-click the selected dates.
3. Choose Custom Absence Types, then choose the required absence type.
4. Choose the absence length then, if required enter absence details in the Comments
5. Click OK, then click Save.
6. Click Save.

If you would like help with creating and or entering custom absences or need any other help or advice with your payroll, please contact us

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

Refund a Supplier

There are times when you might receive a refund from a supplier such as when you have over paid or if you have been issued with a credit note etc after you have paid.  You can record a refund from a supplier and using the supplier refund option.

Post a Refund

1. Select Bank accounts.
2. Select the bank account you are receiving the money into.
3. On the tool bar, click Supplier refund.
4. Complete the boxes as required.

• Ensure the correct Bank A/C is selected.
• Select the correct Account in the Supplier Details section.
• Enter the date of the refund on the Refund Details section.
• Enter the refund amount. Enter this in the Amount field or Amount column next to the credit note.

5. Once the boxes are complete, click Save.
6. If you don’t allocate the refund to a purchase credit, you will see this message: ‘There is an unallocated refund of (insert amount) do you want to post an unallocated refund? click Yes. .
7. This refund now appears as a PR on your supplier activity.

If you would like help entering a supplier refund or if you need any other help with your Sage 50 Accounts, please contact us