P-Card Download, Card Holder(CH)Statement, and Show Users By Default Code Reports
For each of the reports below, click Reports on the P-Card Admin menu. Then click the name of the report.
This report shows every transaction in the P-Card application for the date range specified. It reports transactions back to approximately 06/01/2008. Agencies would use this to get their transactions in one report.
1. Select a date range.
2. Click TXT or CSV. In MS Excel, the ACQ REF cells format needs to be changed to Number.
Figure 1 - PCard Download example in CSV
The card holder statement shows all of the transaction information from the point of sale, e.g., reference number, description of the vendor, and MCC coding. This is useful for reconciling your transactions to the bank statements. A cardholder or the cardholder’s proxy can run the report. However, the P-Card administrator will have selections to run statements for all cardholders in the agency. To generate a CH Statement report:
1. Select All Cards, Your Card(s), or Card(s)&Type.
2. If you select Card(s)&Type, enter up to five credit card numbers by last ten digits of the card number in the first field and then either WFMC for MasterCard or BOAV for VISA in the second field.
3. Select a date range, and then click the desired file format.
Figure 2 - Criteria
1. Enter up to five credit card numbers by the last ten digits of the card number in the first field and then either WFMC for MasterCard or BOAV for VISA in the second field.
2. Select a date range, and then click the desired file format.
1. Select a date range, and then click the desired file format.
Figure 3 - CH Statement Report example
The Show Users By Default/Assigned Code report will display your agency’s users that are assigned a particular default or approval PCA or Index (depending on your agency’s structure). This is the same information as found in the “view Users” options in the Maintain PCA/Index of the Admin screen.
1. Select either Default PCA or Index or Assigned Approval PCA or Index.
Figure 4 - Criteria
2. Enter the PCA or Index code.
3. Click the desired file format.
Figure 5 - Report example