45.2 Report Descriptions

Current Payroll List

This report lists payroll vouchers that have been selected for payment. The vouchers are grouped by bank account and employee. Each group represents one computer check to be written. The bank account was taken from the payroll voucher.

Payroll Checks by Employee

This reports shows both computer and manually issued payroll checks by employee. After this report is selected, the following parameter screen is displayed to select the checks to be included on the report.

fjpman00000006.gif

Check date is the check was printed. Employee is the employee's code. Check is the check code. If you do not want to select one of the above parameters, just leave the Starting Value and Ending Value fields blank. For example, to print a report listing all checks printed in July 1983, type 07/01/83 and 07/31/83 in the Check Date fields. Leave the rest of the fields blank so that all the checks for all employees printed in July 1983 are displayed.

The report lists the checks by employee Id. For each employee Id the following information is shown:

employee name,

check number,

date,

amount for each check,

and total amount.

Issued Checks by Payee

This report shows all issued checks by the payee. This includes computer and manual checks from both the Account Payable System as well as the Payroll System. The parameter screen displayed to select the checks that are to be included on the report is similar to the one displayed by the Payroll checks by employee report except that instead of selecting by employee Id you select by payee. The payee of the check is either a vendor or an employee.

fjpman00000006.gif

The output of this report is similar to the previous one with the exception of the employee Id. Either the employee Id and employee name or the vendor code and vendor name are printed.

Check Register

This report shows all issued checks by check number. This includes checks from the Account Payable System as well as the ones from the Payroll System. The parameter screen displayed by this report is identical to the one displayed by the Issued checks by payee report.

The output lists issued checks in check number order. Checks which have not yet cleared the bank (not marked as cancelled) are marked with a flag ( * ) to indicate that the check is still outstanding. Voided checks are marked as (void).

Print Payroll Checks

This report is a combination of a report and a process. When this report is run, checks are created to pay all the vouchers in the payroll pay list. This process is discussed in detail in Chapter 39, Printing Checks. Before the checks are printed, the system displays the following parameter screen for user input.

fjpman00000006.gif

Each field on this parameter screen requires entry. The Bank Account is a general ledger account number that represents a bank account. This is the same bank account that has been used throughout the Payroll System. The First Check Number is used on the first check created and printed. The rest of the checks created after the first are numbered sequentially. The Check Date is the date that is recorded on each check and indicates the accounting period used to record the checks.

The information printed on each check includes the following:

your company's name and address,

the employee's name and address,

the remittance amount.

A check stub is also printed with each check. The deduction amounts along with the date are printed with the amount on the check stub.

Bank Statement Reconciliation

This report is used to help balance the computer bank account with the bank statement. This report is covered in greater detail in Chapter 44, Bank Statement Reconciliation.

Before this report is run, all the checks that have been returned should be marked as cancelled. After this report is selected, the following parameter screen is displayed to select the bank account and statement date.

fjpman00000006.gif

The Bank Account is a general ledger account number representing the bank account. The Bank Statement Date should be the same date used to mark the cancelled checks.

The report displays the current computer bank balance at the top of the report. It then lists by check number all the checks that have not yet cleared the bank. At the bottom of the list of checks, it shows the deposits that have not cleared. Each check is identified by date and vendor (or employee) as well as by check number. The total of the above checks and deposits should equal the bank statement ending balance. The bank statement beginning balance is also shown.