Tips

Generating reports in Sage 50 Payroll

Summary

There are several different ways you can generate reports in Sage 50 Payroll. Each way is quick and easy.

Preview a report
1. Select the required report you want, for example Form P32 – Employer Payment Record.
2. To preview the document on-screen. Click Preview.

Print a report

1. Select the required report you want, for example Form P32 – Employer Payment Record.
2. Once you have checked the report or layout, click Print.

Email a Report

1. Select the required report.
2. To preview the report on-screen, click Email.

Save a report as a PDF

1. Select the required report you want.
2. To preview the report on-screen, click Export.
3. Save your report to the required directory, selecting a file name and type.

Send your report to Microsoft Excel

1. Select the required report you want.
2. To preview the report on-screen, click either Report to Excel, or Data to Excel.

If you have problems generating a report from your Sage 50 Payroll program 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

Bank Reconciliation

It is always a good idea to reconcile your bank accounts on a regular basis, mainly every time you receive a statement from your bank, and especially before you submit your VAT return to ensure that your have entered the correct figures, not missed anything or duplicated anything.

  1. Bank Accounts >
  2. Statement Reference: – Enter a statement reference e.g. the sheet number and the date you are going up to 151 30-06-26
  3. Statement Date: Enter the date you are reconciling up to eg the month end date 30/06/26.
  4. Click
  5. In the Un-matched transactions pane: select the first transaction that appears on your bank statement.
  6. Either click Match or double click the transaction

The transaction moves from the Un-matched transactions pane to the Matched transactions pane.

  1. Repeat steps 5 and 6 until all transactions on your bank statements are matched.

TIP – if you are using Sage selection style you can select multiple records by just clicking on them or if you are not just hold down Ctrl Key.

TIP – If you find you haven’t entered a transaction into Sage that shows on your bank statement, you can click at the top of the screen to enter a bank receipt, payment, customer receipt or refund, supplier payment or refund and transfers, these will automatically then appear in the Matched transactions pane.

If you require, you can save the reconciliation at any point and complete it later, click Save progress  Next time you open the Reconciliation window, to open the saved reconciliation, click Use Saved.

Reconcile your bank statement

Once you match all the relevant transactions:

  1. Check the Matched Balance and the Statement Balance are the same.

The Difference should be zero.  If the difference:

Is zero  Click Reconcile

A progress bar appears while flagging your transactions and creates a                                         PDF file of your reconciliation.

Isn’t      You must find out why the difference isn’t zero.

Zero      If required, click Save progress.  You might need to go to Transactions

to correct a transaction or delete a transaction. Next time you open the Reconcile window, open the saved reconciliation, click Use Saved.

View reconciliation report

If you want to view what has been reconciled:-

  1. Click Bank accounts then click the relevant bank account.
  2. Click Reconcile then click OK.
  3. Click View history.

A PDF file appears for each reconciliation, with the file name showing you entered.

  1. Double-click the required pdf file.

If you have problems with your bank reconciliation or if you need any other help with your Sage 50 Accounts, please contact us

Sole traders and landlords with income over £50,000 will need to submit MTD returns for income tax for the quarter ended 30th June 2026.  You will need to make sure you have downloaded and installed the latest version of Sage 50 Accounts to enable you to submit your quarterly returns.

To check you are on the correct version of go to Help > About and check you are using V33.1 if not you will need to download the latest version

Important Dates

  • 7th August – deadline for 1st submission under MTD for income tax
  • 7th August – deadline for submitting VAT return for the quarter ended 30th June 2026.

If you would like any more information on MTD or Sage 50 Accounts V33.1, need help with downloading the update or need any other help with your Sage 50 Accounts, please contact us

Sage 50 Accounts

It is a good idea to keep your Sage 50 Accounts program up to date to take advantage of the latest features and fixes for any bugs.

Memo – Job Costing or Sage Manufacturing V28.1 and above are no longer compatible with these programs, and it is recommended not to install Sage 50 Accounts V28.1 or V29.

Check for updates

Install available updates from within your Sage 50 Accounts software:

  1. On the menu bar go to Help, then click check for Updates.
  2. Follow the on-screen prompts.

You can choose to install the updates manually. To do this, follow the steps below.

Check your current version

  1. Open Sage 50 Accounts.
  2. On the menu bar go to Help, then select
  3. In the Program Details section, check the version number.

Once you know the version number of your software, you can go Sage’s website and download the relevant update required.

Manually install an update

Note – To install the latest version, go to Sage’s website and use their software hub.

Select the software version you want to install eg V33.1, the latest version is 33.1.359.0

  1. Log on to your computer as an administrator and close all software.
  2. Go to Sage’s website and click the link for the relevant download eg ‘Download Sage 50 Accounts v33.1 64-bit’.
  3. Click Save if prompted by your browser.
  4. Locate and right-click the downloaded file, then select Run as Administrator.
  5. Follow the instructions in the installer application.
  6. Once installation is complete, Open Sage 50 Accounts.
  7. On the menu bar go to Help, then select About.
  8. Under program Details, check this shows the latest version.

If you have Sage 50 Accounts installed on multiple computers, repeat these steps on each, including the computer that holds your data, check they are all showing the same version number when you have finished.

If you would like help installing an update etc or installing sage on a new computer etc or if you need any other help with your Sage 50 Accounts, please contact us

Sage Payroll

Errors when emailing documents from program

ERROR: ’Outlook doesn’t recognize one or more names’ in event viewer

Since a recent Microsoft Outlook update on 21st April 2026, some users are unable to send emails with various messages including:

  • Error with address: Unknown Error
  • Generic Com Error
  • Unable to communicate with Microsoft Outlook

Resolution

This error only occurs when you send emails immediately from outlook.

To check if the Microsoft update caused your error

  1. Type Event Viewer in the search box of your taskbar.
  2. Click the Event Viewer app, then maximise the window app.
  3. Click Windows Logs in the list on the left, then select Application.
  4. Check the section heading Application for any errors where the Source is Sage Report Designer.
  5. Select and error to view its details in the General tab below.
  6. Check for the message ‘Outlook doesn’t recognize one or more names.’

Workaround

If you are unable to do the above, change your settings to save emails to your mailbox and send from there.

  1. Go to Settings, then click Email Defaults.
  2. In the Email Program dropdown, click Microsoft Outlook.
  3. Select the tab for the items you send via email.
  4. In the send Options, choose Save to Mailbox.
  5. Click Apply and select the checkbox for each layout to apply the email settings to.
  6. Select OK then OK.

If you have problems emailing documents from your Sage 50 Payroll program 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.

Not all accountants are grey.

Call us now for your FREE consultation on 01691 654545 or click here...