The Payments report holds additional information about customer payments made through the Platform.
Primary Audience: Admins
The additional information within the Payments Report export is a great asset to use when reconciling your ERP. The information displayed in the Payments tab within the Team Hub offers a high level view of payment transactions that have taken place on the Platform.
Downloading Reports
To download the payment information reports, follow the steps below:
- Navigate to the Team Hub > Admin tab
- Click on the Payments sub tab on the horizontal bar
- From here, you can select between Payments, Payouts, and Processing Fees sub tabs
- Payments - shows a list of all payments made through the Platform
- Payouts - shows all Settlements, from which you can view all transactions included in each Settlement
- Processing Fees - shows the fees associated with transactions in each Fee Settlement
- Choose the relevant sub tab report
- Click the download button in the upper right corner of the selected report to download the .xlsx file
Filtering Reports
Each report (Payments, Payouts, and Processing Fees) can be filtered via the filter buttons at the top of each corresponding page. This allows you to narrow down the payments displayed based on specific criteria.
Export Information
The Payments export will give you access to more detailed information for each individual transaction in an .xlsx file. Using the export will allow visibility into fields such as client contact information, fees, and the reason for payment failure if a payment fails. View the chart below for a full breakdown of the information that is available in the Platform Payment page and export.
| Export Column | Column Name | Access | Definition |
| A | Payment Date | Web & export versions | The date payment was submitted. |
| B | Status | Web & export versions | Status of payment processing through Finix. |
| C | Record Type | Web & export versions | What the customer was paying, i.e. invoice, budget payment, statement. |
| D | Record ID | Web & export versions | ID number of the record paid. |
| E | Client | Web & export versions | Client name. This will match the name on the client profile. |
| F | Phone | Export only | Client's phone number. |
| G | Export only | Client's email address. | |
| H | Account | Web & export versions | Name of the account linked to this client. This will match the name in your ERP. |
| I | Account ID | Export only | The ID number of the client's account. This will be their ID in your ERP and on the Clients tab. |
| J | Record Total | Export only | The total amount due on the invoice, statement, etc. This will match the amount in your ERP. |
| K | Record Amount Paid | Export only | How much of the record amount the customer submitted payment for. |
| L | Payment Amount | Web & export versions | The total amount the customer paid. Includes processing fees. |
| M | Net Received | Export only | The Payment Amount less any processing fees Finix charges. (Calculated value for reference) |
| N | Payment Method | Web & export versions | ACH, Credit Card |
| - | Made by | Web only | Who submitted the payment. This may be a seller on behalf of the customer or the customer themselves. |
| O | Credit Card Convenience Fee | Export only | This is the fee your organization charges customers to cover processing fees. This is configurable and will be included in the Payment Amount. |
| P | Payment Processing Fee | Web & export versions | This is the fee that Finix charges your organization for processing payments. This is the amount removed from Payment Amount to get Net Received. |
| Q | Invoice Discount Applied | Export only | If a discount was applied to the invoice, the amount will show here. |
| R | ERP Payment ID | Export only | If the payment posted to your ERP automatically, this will show the ID of the payment there. |
| S | Payment ID | Web & export versions | Unique transaction ID. You can use this to locate a payment in Finix or within a settlement. Copy into the search bar. |
| T | Payment Processor ID | Export only | |
| U | Payout Settlement ID | Web & export versions | The ID of the Payout that will include the payment. |
| V | Payout Settlement Date | Web & export versions | The date of that payout |
| W | Payout Settlement Amount | Web & export versions | The total amount of the payout this payment is in. |
| X | Fees Settlement ID | Export only | The fee settlement that this payment's fees are debited from your organization in. |
| Y | Fees Settlement Date | Export only | The date that the fee settlement occurred. |
| Z | Fees Settlement Amount | Export only | The total amount of the fee settlement that includes this payment's fees. |
| AA | Reason for Failure | Export only | If the payment failed, this will show why. |
Additional information and a walkthrough of the information above is available in the Overview of Online Payments & ERP Sync Logic lesson found in the Partner Resource Center.
If you have any questions related to this article or anything else, please reach out to our Partner Enablement Team at help@agvend.com or at 512-812-9399.