Audience: Accounting Manager, Read-Only Accounting Manager, Payment Authorizer
Summary: Use payment reports to reconcile payments, review payment history, and track how vendors are paid.
Overview
Payment reports provide visibility into payment activity, from reconciling transactions against the bank to tracking individual vendor card payments.
Most reports can be viewed in MineralTree and downloaded for additional review. Downloaded reports may contain more columns than the on-screen preview.
Available reports and columns may vary based on your enabled payment methods, ERP integration, and account settings.
Which payment report should I use?
| If you need to... | Use... |
|---|---|
| Review a complete payment ledger or reconcile payments against the bank | Payment Report |
| Review payment volume and value by month and payment method | Monthly Payment Totals |
| Review total SilverPay activity by day | Daily SilverPay Report |
| Check the status of an individual SilverPay payment | SilverPay Payments |
| Track American Express delivery, activity, and settlement events | Amex Card Payment Tracking |
| Compare payment activity over time | Payments Over Time |
| Investigate payments that failed to sync with your ERP | Payment Sync Failures |
| Confirm how or when a specific invoice was paid | Bill Payment Report |
| Connect a paid invoice’s line-level coding to its payment | Bill Payment Detail |
The Bill Payment Report and Bill Payment Detail reports are covered in the Invoice and Purchase Order Reports article.
Payment Report
The Payment Report provides a complete view of payments processed through MineralTree.
Use this report to:
- Reconcile payment activity
- Review payment history
- Answer vendor payment questions
- Research payment status
- Connect payments to invoices
Requires: Start and end date
Columns included
Identifiers
- External ID
- Vendor Name
- Subsidiary Name
- Name on Check
- Payment Number
- Batch Reference ID
- Reference Invoice
Dates and status
- Payment Date
- Payment Submitted
- Payment Status
- Card Status
Amounts
- Payment Amount
People and routing
- Paid From
- Submitted By
- Approved By
- Payment Channel
Monthly Payment Totals
The Monthly Payment Totals report summarizes payment volume and value by month and payment method.
Use this report to identify payment trends and understand how your organization pays vendors.
Columns included
Time
- Month
- Year
Totals
- Total Payment Count
- Total Payment Amount
Payment methods
- Check Count
- Check Amount
- ACH Count
- ACH Amount
- SilverPay Count
- SilverPay Amount
- Credit Card Count
- Credit Card Amount
- Wire Count
- Wire Amount
Daily SilverPay Report
The Daily SilverPay Report summarizes SilverPay activity by day. SilverPay is MineralTree’s virtual card payment method.
Use this report to review daily SilverPay payment volume and value.
Columns included
- Payment Date
- Payment Amount
- Number of Payments
SilverPay Payments
The SilverPay Payments report provides details for individual SilverPay payments.
Use this report to:
- Check payment status
- Monitor card activity
- Confirm whether a vendor used the payment
- Review expiration and card-use dates
- Check the most recent reminder email
Columns included
Identifiers
- ID
- Vendor Name
- Payment Number
Amounts
- Payment Amount
- Amount Swiped
Dates
- Payment Date
- Expiration Date
- Date Swiped
- Last Reminder Email
Status
- Status
Amex Card Payment Tracking
The Amex Card Payment Tracking report tracks key American Express payment events, including delivery, vendor activity, and settlement.
Dates and times are displayed in the user’s local time zone.
Requires: Start and end date
Columns included
Identifiers
- ID
- Vendor
- Sequence Number
Amounts
- Amount
- Settled Amount
Dates
- Payment Date
- Settled Date
Activity
- Card Information Sent to Vendor
- Most Recent Reminder Email
- Card Swiped by Vendor
Payments Over Time
The Payments Over Time report is a visual chart of payment activity across a selected period.
Use this report to identify trends and compare payment methods over time.
Note: This report is a chart only and does not provide downloadable data.
Cleared Transactions
The Cleared Transactions report shows transactions that have settled through the bank.
Use this report to confirm completed payments and support bank reconciliation.
Requires: An active Finicity bank connection. Finicity is MineralTree’s bank-connection service.
Results depend on the information received through the bank connection. If your account is not connected, the report will not return results.
Payment Sync Failures
The Payment Sync Failures report identifies payments that failed to sync with your ERP.
Use the error information in this report to investigate the failure and determine the appropriate next step.
Columns included
Identifiers
- Vendor Name
- Payment Number
- Invoice Number
Amounts
- Amount
Dates
- Payment Date
Status and error information
- Payment Type
- Sync Status
- Original Error Message
- Error Explanation