You can use the report templates provided by J.P. Morgan to create your own reports and share them with the rest of your organization.
Report templates are listed on the Report Setup screen and are enabled by default for program administrators only. As a result, only program administrators will see the templates in the Report List. Other user roles can be given access to the templates via the Report Setup screen, or you can create template-based reports and share them with other roles.
This topic provides information about the report templates in the following categories:
Note: Program administrators are not given access to the QuickBooks Template by default. If you want to use this template to upload PaymentNet data into QuickBooks, you must first enable the template for the Program Administrator role on the Report Setup screen. For more information, see QuickBooks File Option.
The following Account templates are available in PaymentNet:
Account Template — Provides the elements common to most account-based reports.
Account and Transaction Location Comparison Template — Provides a base report to determine how and where cardholders are transacting.
Account Audit Template — Provides account audit information, including all changes made in the last 30 days (default) and the ID of the person who made each change.
Accounts with Disputed Transactions Template — Provides information about dispute cases that are not in Closed status by Account Number.
For these templates, the Output Format is Excel. Additional characteristics of these templates are noted in the following table.
Report Template |
Report Columns |
Filter |
Sort |
Group By |
|---|---|---|---|---|
Account |
Account Number Account Given Name Account Family Name Credit Limit Amount Available Balance Amount Account Balance Amount Single Transaction Limit Base Amount Cycle Transaction Limit Amount Account Status Account Status Reason |
Account Status is equal to “Active” |
Account Family Name (Ascending) Account Given Name (Ascending) |
None |
Account and Transaction Location Comparison |
Account Number Cardholder Address City Name Cardholder Postal Code Transaction ID Post Date Transaction Amount Merchant Name Merchant Category Code Merchant City Name Merchant Postal Code |
Post Date is in last 30 days |
Merchant City Name (Ascending) |
Account Number (Ascending) and Merchant Postal Code (Ascending) |
Account Audit |
Account Number Account Given Name Account Family Name Account Audit Change Date Account Audit Change Time Account Audit Field Name Account Audit Field Previous Value Account Audit Field New Value Account Audit Changed By |
Account Audit Change Date is in last 30 days |
Account Number (Ascending) Account Audit Change Date (Descending) Account Audit Change Time (Descending) Account Audit Field Name (Ascending) |
None |
Accounts with Disputed Transactions |
Account Number Account Family Name Account Given Name Transaction ID Post Date Transaction Amount Settled Amount Dispute Status Dispute Created Date Dispute Code Merchant Name |
Post Date is in last 30 days and Dispute Status is not equal to “Resolved” |
Dispute Created Date (Ascending) |
Account Number (Ascending) and Dispute Code (Ascending) |
The Administration template provides the elements most common to administration-based reports. For this template, the Output Format is Excel. Additional characteristics of this template are noted in the following table.
Report Template |
Report Columns |
Filter |
Sort |
Group By |
|---|---|---|---|---|
Administration |
Employee Hierarchy Name Employee Hierarchy Description Given Name Family Name Login Name Last Login Date |
Last Login Date is in last 30 days |
Employee Hierarchy Name (Ascending) |
None |
The Merchant template provides the elements most common to merchant-based reports. For this template, the Output Format is Excel. Additional characteristics of this template are noted in the following table.
Report Template |
Report Columns |
Filter |
Sort |
Group By |
|---|---|---|---|---|
Merchant |
Merchant Name Merchant Category Code Merchant Address Merchant City Name Merchant State Code Merchant Postal Code Merchant Government Identification Number |
Merchant Category Code is not equal to ‘0000’ |
Merchant Name (Ascending) |
None |
The following Transaction templates are available in PaymentNet:
Transaction Template — Provides the elements common to most transaction-based reports.
Transaction and Account Limit Template — Combines transaction details with cardholder billing information in order to track activity against credit limits.
Transaction Audit Template — Provides transaction audit information, including all transaction changes made in the last 30 days (default) and the ID of the person who made each change.
For these templates, the Output Format is Excel. Additional characteristics of these templates are noted in the following table.
Report Template |
Report Columns |
Filter |
Sort |
Group By |
|---|---|---|---|---|
Transaction
|
Transaction Date Post Date Transaction Amount Transaction ID Merchant Name Merchant City Name Merchant State Code Merchant Category Code Account Number Account Given Name Account Family Name |
Post Date is in last 30 days |
Transaction Date (Ascending) |
None |
Transaction and Account Limit
|
Account Number Account Family Name Account Given Name Current Bill Date Credit Limit Amount Post Date Transaction ID Transaction Amount Merchant Name Merchant Category Code |
Post Date is in last 30 days |
Post Date (Ascending) |
Account Number (Ascending) |
Transaction Audit |
Transaction ID Post Date Account Number Transaction Audit Change Date Transaction Audit Change Time Transaction Audit Field Name Transaction Audit Field Previous Value Transaction Audit Field New Value Transaction Audit Changed By |
Post Date is in last 30 days |
Account Number (Ascending) Transaction Audit Change Date (Descending) Transaction Audit Change Time (Descending) Transaction Audit Field Name (Ascending) |
None |
The QuickBooks template provides the elements required for upload into a QuickBooks accounting system. For this template, the Output Format is QBO. Additional characteristics of this template are noted in the following table.
Report Template |
Report Columns |
Filter |
Sort |
Group By |
|---|---|---|---|---|
QuickBooks |
Account Number Post Date Transaction ID Transaction Amount Merchant Name Account Balance Amount |
Post Date is in last 30 days |
N/A |
N/A |