Create a payment registry for MineralTree payments

You can create a payment registry report for a registry of ACH and virtual credit card payments made through Vendor Payments powered by MineralTree.

Open the Custom Report Writer (CRW)

• Do one of the following:

  • Go to Customization Services > All > Custom reports.

  • Go to Platform Services > All > Reports.

  • Go to Reports > All > Advanced > Custom reports.

Create a payment registry report for MineralTree payments

This section covers the only steps you need to create a payment registry report for MineralTree payments. CRW has more steps, but some have no relevance for this report. You can skip the extra steps, or use them to augment your report, as needed. For more information, see the Custom Report Wizard.

1. In the Select a primary data source step, select one of the following from the dropdown menu.

   • AP payment request to see payment requests.
   • AP payment to see posted payments.

2. In the Add columns step, add the following columns.

   Columns to add for custom report wizard sections

   Section	Columns to add
   AP payment request	Account Document/check no. Payment amount Payment date Payment method Vendor ID Vendor name

3. In the Select the column sequence step, drag and drop columns to the display order.

   1. Payment date
   2. Account
   3. Payment method
   4. Document/check no.
   5. Vendor ID
   6. Vendor name
   7. Payment amount
4. In the Add more column totals step, select Sum for the Payment amount column.

5. In the Sort Columns step, drag and drop columns by priority and sort the columns as follows:

   • Payment date: Ascending
   • Payment method: Ascending
   • Document/check no.: Ascending

6. In the Filter your report step, filter the report as follows:

   • Payment method equals ACH
   • Payment method equals VCARD
7. In the Refine filters step, enter 1 OR 2 for the Filter expression, then in the Enable grouping step, select Grouping.
8. In the Group data by column step, select Document/check no. and Payment method.

9. In the Set report date and title step, name the report.

   In this example, the report was named MineralTree ACH or VCARD daily withdrawal.
   

   You can specify a date range with a Reporting period, Start date, As of, or End date. We recommend using the Current month reporting period to filter for all payment requests for the month.

   Select All locations to Show for and Yes to Show details.

10. Select View on this page to see your report. If needed, edit the report by using the forward or backward buttons, or the dropdown menu of steps.
11. In the Save and add to menu step, save your report and add it to an application if needed.

Use the report

You can share Custom Report Writer (CRW) reports by adding them to:

• Dashboards, to make key performance indicators readily available to others. For more information, see Add a custom report to a dashboard.
• Applications, to make running the report accessible to other users. For more information, see Save and add your report to a menu.