PCard Pre-Reconciliation Report

Use this option to generate a report showing transactions that are not reconciled. The report includes card numbers, purchase dates, employee names and ID's, vendor names and numbers, and purchase and receipt amounts. You can select records based on PCard numbers, employee ID's, and purchase dates.

Menu Path: PCard Processing > Reports > PCard Reports > PCard Reconciliation Report

You can also access this report using the Pre-Reconciliation Report item on the Action Bar of the PCard Entry Reconciliation and PCard Bank Reconciliation pages.

Report Sections

The PCard Pre-Reconciliation report is divided into sections based on the status of the transactions in your reconciliation file:

Matched	Unreconciled transactions that have matching payment and receipt amounts and a status of Matched or Disputed, as set in the PCard Entry Reconciliation page. If you do not use receipt entry, the records shown were designated as Reviewed or Disputed in the PCard Bank Reconciliation page.
Discrepancies	Unreconciled transactions whose payment and receipt amounts do not match and that have a status of Matched or Disputed. This section only applies if you use receipt entry.
Received	Transactions that have not yet been processed. By default, the system designates these transactions as Received.

Generating the PCard Pre-Reconciliation report

Select PCard Processing > Reports > PCard Reports > PCard Reconciliation Report to display the PCard Pre-Reconciliation Report page.
In the Bank Layout field, select the format used by your reconciliation file.
In the Search Criteria section, identify the transactions to include. Note: Leave all fields blank to select all unreconciled transactions.
- PCard Number - Select a PCard number, or use the pipe symbol to specify multiple PCards, for example, 12345|12456|12567.
- PCard Holder - Select an employee ID, or use the pipe symbol to specify multiple employees, for example, 234567|345678|456789.
- Purchase Date - Select a specific date, or use the colon symbol to enter a range of dates, for example, 06/01/2018:06/30/2018. You can also use the (>) and (<) symbols, for example, >05/31/2018.
In the Transaction Status Field, select one of the following:
- All - Includes Matched and Disputed transactions. Note: If your PCard Profile is not set up for receipt entry, the system uses the status code Reviewed in place of the status Matched.
- Disputed - Limits the report to Disputed transactions. With this selection, the report does not include a Received section.
- Non-Disputed - Includes Matched transactions.
Select OK.
In the Print window, specify how to generate the report, and then select OK. The report's default file name is pcd_rptrec1.rpt.