Skip to main content
Sign in Resources

Payments Report Overview (Finix)

Megan Rosenbohm
  • Updated

Payments Reports and Export Information

Primary Audience: Admins

The Payments report provides detailed information about customer payments processed through the Platform and can help your team reconcile transactions with your ERP.

The Payments page in the Team Hub provides a high-level overview of payment activity, while exported reports include additional transaction details such as customer contact information, processing fees, settlement information, and payment failure reasons.

Download Payment Reports

To download payment-related reports:

  1. Navigate to Team Hub > Admin
  2. Select the Payments sub-tab
  3. Choose one of the following report types:
  • Payments – Displays all customer payments processed through the Platform
  • Payouts – Displays payout settlements and included transactions
  • Processing Fees – Displays fee settlements and associated processing fees
  1. Click the Download button in the upper-right corner of the selected page
  2. The report will download as an .xlsx file

Filter Payment Reports

Each report type can be filtered using the filter options at the top of the page.

Filtering allows you to narrow results based on specific payment criteria before reviewing or exporting the report.

Understanding Payment Export Information

Exporting the Payments report provides additional transaction-level details that may be useful for:

  • ERP reconciliation
  • Reviewing customer payment activity
  • Researching failed payments
  • Reviewing processing fees and settlements

The export includes additional fields not visible directly within the Team Hub interface.

Payment Export Column Definitions

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 Email 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 Resources

Additional details and walkthroughs related to payment exports and ERP sync behavior are available in the:

Overview of Online Payments & ERP Sync Logic  lesson 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.