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.

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

4. 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