PCard Reconciliation Report

Use this option to generate a report showing transactions that have been designated as Reconciled. As an option, you can also include Disputed transactions. However, unreconciled transactions designated as Matched or Reviewed do not appear in the report.

The PCard Reconciliation report's data includes PCard numbers, purchase dates, employee names and ID numbers, vendor names and numbers, purchase and receipt amounts, and status designations. The totals at the end compare the report's total charges with its total receipts.

You can select transaction records based on PCard numbers, employee ID's, purchase dates, and vendor numbers. You can also organize the report by one of these categories, as determined by your Sort Order selection.

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

You can also generate this report using the Reconciliation Report item on the Action Bar in the PCard Entry Reconciliation and PCard Bank Reconciliation pages.

Generating the PCard Reconciliation report

1. Select PCard Processing > Reports > PCard Reports > PCard Reconciliation Report to display the PCard Reconciliation Report page.

2. In the Bank Layout field, select the format used by your reconciliation file.

3. In the Search Criteria section, use the following fields to identify the transactions to include. To select all reconciled transactions, leave all fields blank.

4. In the Search Criteria section, use the following fields to identify the transactions to include. To select all reconciled transactions, leave all fields blank.

   • PCard Number - Select a PCard, or use the pipe symbol to specify multiple cards, for example, 101011|202022|505055.

   • PCard Holder - Select a cardholder, or use the pipe symbol to specify multiple cardholders, for example, 123456|234567|345678.

   • Post Date - Select a date, or use the colon symbol to specify a range of dates. For example, 06/01/2018:06/30/2018 matches all dates in the month of June 2018.

   • Purchase Date - Select a date, or use the colon symbol to specify a range of dates. For example, 06/01/2018:06/30/2018 matches all dates in the month of June 2018.

   • Vendor Number - Select a vendor, or use the pipe symbol to specify multiple vendors, for example, 32109|43210|54321.

5. To include disputed records in the report, select the Include Disputed Records checkbox.

6. In the Sort Order field, select one of the following to determine how the report will be organized:

   • PCard Number

   • Vendor Number

   • Employee Number

   • Post Date

7. Click OK.

8. In the Print window, specify how to generate the report, and then click OK. The report's default file name is pcd_rptrec2.rpt.