Using the Check Payment Register
The Check Payment Register lists all payments made from a bank account.
You can view or print payments made from a particular bank for a specified period and from a specified source application. You can specify criteria such as payment types and reconciliation statuses, sorted by Payment Number, Payment Date, or Vendor/Payee Code. You can print the payment details or a payment summary, as well as show missing check numbers.
If you have Print Payment Register security authorization, you can print the Check/Payment Register, even if you have no other rights to perform tasks in Bank Services. For example, if you are an Accounts Payable clerk, you could print the Check/Payment Register to trace missing checks. If you are an Accounts Receivable Clerk, you could print the Payment Register to follow up on customer refunds.
Print this report when you want to view payment activity for a bank account that originated in other applications.
Information on the report
If you are printing payment details, the report includes the following information:
- Payment Number (for example, a check number, or a transfer number)
- Payment/Reversal Date
- Source Application
- Reconciliation Status
- Reconciliation Posted
- Vendor/Payee Code
- Vendor/Payee Name
- Currency
- Payment Amount
- Bank Payment Amount
The report lists payments by payment type for each bank code, and it provides totals for each payment type.
To print the report
- From the Navigation Pane, select Reports > Payroll > Bank Reports > Check Payment Register.
- Specify the codes for the range of banks to include in the payment register.
- Specify the range of payment dates for the transactions to include on the report. (The To Payment Date field is set to the session date by default.)
- Use the From Application and To fields to specify a range of source ledgers (for example, CP for Canadian Payroll, UP for US Payroll) for the payments.
- Select the level of detail for the report from the list in the Print field.
- Choose whether to sort payments by payment number, payment date, or vendor/payee code.
If you sort by payment number and you are printing payment details (with or without a summary), you can select the Print Missing Check Number option in the next step.
- If the payment register will include checks and you want the report to include a note about any check numbers that are missing from a sequence, select the Print Missing Check Number option.
- Select the type of payments to include on the register. Type of payments include:
- Check
- EFT
- Cash
- Credit Card
- Transfer
- Service Charge
- Other
- Specify the reconciliation statuses of the transactions you want to include on the register. Reconciliation statuses include:
- Cleared
- Reversed
- Outstanding
- Non-negotiable
- Continuation
- Not Posted
- Printed
- Void
- Cleared with Write-Off
- Cleared with Bank Error
- Cleared with Exchange Rate Difference
- Click Print.
If you have Print Payment Register security authorization, you can print the payment register even if you have no other authorization to use Banks in Payroll.