Reporting
There are a number of different types of reporting available with One Click Payments. There is one for Payments and another for Deposits. We will cover, in detail, each of these options in the sections below.
Each of the available report options are available from the global “Finance” Tab on the Web App (screenshot below).
Payments Report
The payment report component displays payins and refunds (collectively, payments). Each payment can be opened to display additional details and actions associated with the payment, such as refunding a payin.
The payment report can be utilized for a variety of reports based on your use case. The report can be filtered by various fields, such as status, date, payment type, etc. Clicking on any payment generates a payment detail view.
Payment Listing
Below is an example of the Payment listing report.
The following options are available:
- For each of the columns, you can click to filter by the list of available options.
- You can switch between pages of available records.
- There is an export button in the top right corner which will allow you to export a list of payments for a defined period of time.
By default, the following columns will be included in the report:
- Created: The datetime the payment activity was created at.
- Type: The type of payment activity (ACH Return, Chargeback, Payin, or Refund)
- Status: The status of the payment activity.
- Amount: The amount of this activity.
- Customer: The name of the Customer from this activity.
- Method: The payment method for this activity which includes the last 4 digits of the card or bank account.
When selected, you can filter by each of the columns by hovering over the column and clicking the filter option.
Once selected, the list of available options for filtering that column will be displayed. You can choose one (or more) of the available options and click Apply to filter the results.
Payment Report Export
There is an option to export the list of payments to a CSV file. This is helpful when you want to run additional reporting or data filtering options outside of the built-in reporting component.
When generating reports, there are options for supplying different date ranges, which include:
- Previous Month
- Current Month
- Custom (define a period of time which is 31 days or less)
Once exported, the CSV file can be opened in the CSV editor of your choice for additional reporting operations.
Payment Details
Each of the payments listed in the Payments Report can be clicked on to get additional detailed information.
- The total amount of the Payin / Transaction
- The status of the transaction
- The ID of the transaction
- The name of the Customer
- The payment method (last 4 digits and expiration date for credit card)
- The date and time of the transaction
- The address of the customer
- The related info (included the amount paid in fees as well as other related information)
- Additional metadata stored on the payment including the associated job and organization information from One Click.
Deposits Report
The deposit report component displays deposits for a given Merchant. Each deposit can be opened to display additional details and actions associated with the deposit, such as the deposit amount and the payments that were included in the deposit.
The deposit report component can be utilized for a variety of reports based on your use case. The report can be filtered by various fields, such as status or date. Clicking on any deposit generates a deposit detail view.
The deposit report can be accessed by clicking the “Finance” tab in the header. On the right side of the screen you’ll see a toggle where you can toggle between the “Payments” and “Deposits” view.
Deposit Listing
Below is an example of the Deposit listing report.
The following options are available:
- For each of the columns, you can click to filter by the list of available options.
- You can switch between pages of available records.
- There is an export button in the top right corner which will allow you to export a list of deposits for a defined period of time.
By default, the following columns will be included in the report:
- Created: The datetime the payment activity was created at.
- Status: The status of the deposit. (the following is a flowchart of the changes to a deposit’s status).
- Processing: Deposit is processing and funds have been initiated.
- In Review: Deposit has been flagged for risk review.
- Succeeded: Deposit has completed processing and the funds were deposited to the merchant.
- Failed: Deposit unsuccessfully attempted to process.
- Amount: The amount of the deposit.
- Method: The payment method for the deposit.
- ID: The unique identifier for the deposit.
When selected, you can filter by each of the columns by hovering over the column and clicking the filter option.
Once selected, the list of available options for filtering that column will be displayed. You can choose one (or more) of the available options and click Apply to filter the results.
Deposit Report Export (Date Range)
There is an option to export the deposits to a CSV file. This is helpful when you want to run additional reporting or data filtering options outside of the built-in reporting component.
Choosing the export at the global deposits tab level will allow you to export multiple deposit reports in a single file.
When generating reports, there are options for supplying different date ranges, which include:
- Previous Month
- Current Month
- Custom (define a period of time which is 31 days or less)
Once exported, the CSV file can be opened in the CSV editor of your choice for additional reporting operations.
Deposit Details
Each of the deposits listed in the Deposits Report can be clicked on to get additional detailed information.
- The net amount of the deposit
- The ID of the deposit
- The status of the deposit
- The method of the deposit
- The date/time of the deposit
- Rows for each of the individual payments included on the deposit.
- Note: This includes information on the fees for each individual payment as well.
- The subtotal of the deposit (net of all per payment fees)
- The amount of fees charged for the deposit
- The total amount deposited into the account (net of all fees)
- Button to export this specific deposit record and associated payment details
Chargeback Report
The chargeback report component displays chargebacks for a given Merchant. Each chargeback can be opened to display additional details and actions associated with the chargeback, such as the name, date, payment method, etc.
The chargeback report component has the ability to filter the list of Chargebacks based upon status (All, Action Required, Processing, Won, or Lost) as well as filtering based on the other available columns. Clicking on any chargeback generates a chargeback detail view.
The chargeback report can be accessed by clicking the “Finance” tab in the header. On the right side of the screen you’ll see a toggle where you can toggle between the “Payments”, “Deposits”, and “Chargebacks” depending on your permissions.
Chargeback Listing
Below is an example of the Chargeback listing report.
The following options are available:
- For each of the columns, you can click to filter by the list of available options.
- You can switch between pages of available records.
- There is an export button in the top right corner which will allow you to export a list of deposits for a defined period of time.
By default, the following columns will be included in the report:
- Created: The datetime the chargeback was created at.
- Status: The status of the chargeback.
- Amount: The amount of the chargeback.
- Customer: The name of the Customer from this activity.
- Method: The payment method for this activity which includes the last 4 digits of the card or bank account.
- Due Date: The date your response and evidence is due.
- ARN: The acquirer’s reference number
When selected, you can filter by each of the columns by hovering over the column and clicking the filter option.
Once selected, the list of available options for filtering that column will be displayed. You can choose one (or more) of the available options and click Apply to filter the results.
Chargeback Report Export
There is an option to export the list of chargebacks to a CSV file. This is helpful when you want to run additional reporting or data filtering options outside of the built-in reporting component.
When generating reports, there are options for supplying different date ranges, which include:
- Previous Month
- Current Month
- Custom (define a period of time which is 31 days or less)
Once exported, the CSV file can be opened in the CSV editor of your choice for additional reporting operations.
Chargeback Details
Each of the chargebacks listed in the Charegback Report can be clicked on to get additional detailed information.
- The amount of the chargeback
- The status of the chargeback
- The ID of the the chargeback
- The name of the customer associated with the chargeback
- The method of the initial payment
- The date/time of the chargeback request
- The address of the customer associated with the chargeback
- A link to the payin associated with the chargeback.
- The billing fee of the chargeback
- The date evidence is due for the chargeback
- The ARN or acquirer reference number for the chargeback
- Internal metadata associated with the payin / chargeback
- Button to provide a response to the to the dispute
