Payroll Register

Payroll Register is an Employees and Payroll Ready-to-Use Report for Sage 50 US. It shows payroll register detail for the date range entered on the Instructions worksheet.

Prerequisites

1. Microsoft Windows 10 Pro, Windows 11 Pro, or Windows terminal server (2012 and above)
2. Microsoft Office 365
3. Sage 50 US edition (2021 and above)
4. Internet connection

What the Report Does

The Instructions worksheet provides start and end date fields in C8 and C9. The Report worksheet shows the company name, the selected period, transaction dates, payroll details, and a Grand Total row. The hidden Data worksheet includes payroll fields such as TransactionDate, EmployeeID, Employee Name, Reference, GLAcntNumber, Amount, Pay Hour, RowDescription, PayType, and derived income, deduction, and amount categories.

How to Use the Report

1) Enter the start date in C8 and the end date in C9 on the Instructions worksheet, then click Refresh on the XLGL ribbon.

2) Click Go to Report... on the Instructions worksheet.

3) Review the Report worksheet for payroll register detail by transaction date and payroll category.

4) Use the Grand Total row to review the total payroll amount shown for the selected period.

Customization Options

Change the start and end dates on Instructions to review a different payroll period. You can use standard Excel sorting, filtering, and formatting on a copy of the workbook. For additional payroll fields, different grouping, changed calculations, or layout changes, use the customization link on Instructions or request a Custom Report from Logicim.

Common Use Cases

1. Review payroll register activity for a selected period.
2. Compare payroll amounts by employee, pay type, row description, or account detail when those fields are present in the output.
3. Review income, deduction, and net amount categories from the workbook's payroll data.
4. Support payroll-period validation by checking the Grand Total row.

Troubleshooting

1. If the period shown on Report is not what you expected, check C8 and C9 on Instructions and refresh the workbook.
2. If values appear stale or unexpected, confirm that Excel is connected to the correct Sage 50 US company through Logicim XLGL, then refresh again.
3. If payroll activity is missing, confirm that the selected dates include the transactions you expect to review.
4. If you need a different payroll layout or additional fields, request a Custom Report instead of editing hidden worksheets or formulas.

FAQs

1. Q: Which dates control the Report? A: The start date in C8 and end date in C9 on Instructions control the selected period.
2. Q: Where do I review the output? A: Click Go to Report... and review the Report worksheet.
3. Q: Does the workbook include payroll totals? A: Yes. The Report worksheet includes a Grand Total row.
4. Q: Can this Report be customized? A: Yes. Use the customization link on Instructions or request a Custom Report from Logicim.

Best Practices

1. Confirm the Sage 50 US company before refreshing the workbook.
2. Review the start and end dates before using the Report for payroll review.
3. Refresh the workbook after changing the date range.
4. Use a copy of the workbook before applying Excel sorting, filtering, or formatting changes.
5. Compare the Grand Total row with the payroll total you expect for the selected period.

Related Articles

Logicim XLGL installation and activation

Logicim Reports