Split Funding Report

 
Use Split Funding Report to search Split transactions.
 
Step1: Choose the Split Funding Report item in the Reports menu.


Step2:
 Choose the appropriate Transaction Filters. The choices are as follows: 
 
1. Status the results of a transaction: 
» All
» Successful
» Flagged For Review
» Transaction Failed
» Declined
» Internal Error
» Not Processed
» Wait For Response
» Rejected By Policy
» Rejected By User
» Dispute

2. Payment Type the type of payment used in the transaction(s): 
» ACH
» Credit Card
» eCheck
» Star Card
» Cash
» eWallet
 
3. Transaction Type the kind of operation performed: 
» Auth
» Sale
» Credit
 
4. Transaction ID the identification number of a particular transaction.
Users may also search for multiple Transaction ID numbers at once. Separate different ID numbers by comma to pull up multiple transactions. 
 
5. Operation Source the source of the transaction:
» Undefined – Transaction source could not be traced. This normally should not happen.
» Batch API – From Batch Upload.
» Virtual Terminal – Transaction processed in the payment gateway itself.
» Service API – Transaction has been created as a result of external call to Services API.
» MIMS Service – Transaction has been created as a result of external call to MIMS emulator.  (Merchant Information Management System)
» Billing – Transaction is billed.
» Callback Service.
» Payment – Transaction processed in the secure redirect payment page.
» Test – Transaction billed is being tested.
» Email Payment – Transaction has been created as a result of parsing email orders and will appear only for merchants using this functionality.
» Mobile – Transaction comes from mobile device.
» POS – Transaction comes from POS application.
» Data Vault Payment – Tokenized transactions and planed transactions processed by Data Vault clients.
» Checkout – Transaction has been created as a result of a checkout processing.
» ARC File – Transaction has been created as a result of parsing ARC File.
» Wallet API – Transactions processed by Wallet API.
» Gateway UI – Transactions processed in Gateway UI.
» Invoice – Transaction has been created as a result of paying invoice.
» Windows Service.
» Split Funding – Transactions processed using Split Funding.
» 3D Secure – Transactions processed using 3D Secure.
 
6. Email the email of the customer.
 
7. Processor the processor through wich the transaction was processed.
 
8. Order ID the Order Identification Number.
 
9. Account Number any consecutive digits from an account number, usually the first six or last four.
 
10. Card Issuer the issuer of the credit card used for the transaction.
 
11. Last Name the last name of the customer.
 
12. Customer ID
 
13. Company Name the company of the customer
 
14. Split Group ID the split group using for the split transaction
 
13. Date From and Date To used to refine the date range of the transaction result set.
 
14. Speed Dates feature is used to quickly choose a commonly used range. Speed Dates are as follows:
» Today
» This Week
» This Month
» This Quarter
» This Year
» Yesterday
» Last Week
» Last Month
» Last Quarter
» Last Year
» Past 3 Days
» Past 7 Days
» Past 30 Days
» Past 60 Days
» Past 90 Days
» Past 180 Days
» Past 365 Days
 
15. Report Type Determines how the data will be presented in the grid.  Detail produces a list.  Summary includes summaries and totals with drill down capabilities. 
» Detail
» Summary
 
16. Group By works only with Summary Reports to determine how the result set will be grouped for display:
» Day
» Month
» Year
» Payment Type
» Processor
» Merchant Account
» Transaction Source
» Batch ID
» Card Type
» User Department
» Operation Status
 
Step 3: Click the Submit.
 
Tip: Click on Clear button at any time to reset and clear all the search criteria. 
 
Additional features allowed by the Search pages are:
» Saved Reports – The Save icon will save this report for later viewing.  See Saved Reports for details.  
» Set Email Schedule - The Email Schedule icon opens the dialog where user is able to set the schedule for sending emails with report to specified email adresses. This report will appear in Saved Reports.
» Export to Excel – Use the Export to Excel button to transfer data to Microsoft Excel.
» Show Additional Fields – To expand the data view for the transaction, use Show Additional Fields. When doing so, a small popup window will display a list of fields that can be added to the existing grid columns. Additional fields are as follows: 
        » Address 
        » Batch ID 
        » Card Issuer 
        » City 
        » Code Description
        » Currency
        » Customer ID
        » Email
        » eWallet Type
        » IP Address
        » Merchant Account
        » Message
        » Order Description
        » Order ID
        » Passenger Name
        » Payment Type
        » Phone
        » Postal Code
        » Source Transaction ID
        » Source Type
        » User Department
        » Xref

Transactions that meet the criteria in the search fields will be displayed in a list/ grid format with following information: 
1. Transaction ID – the system generated identification number of a transaction.
2. Transaction Type - the operation used to create transaction (Sale, Auth, Credit). 
3. Status – the current status of the transaction(s). The Status may change in the event of a subsequent operation such as Capture or Refund.
4. Split Status – the current status of the split operation.
5. Module – the type of module that was utilized for the processing of the transaction.
6. Customer – customer name.
7. Account Number – the number of the account of the certain transaction.
7. Split Group ID - the ID of the split group using for splitting the transaction
8. Date – the date the transaction took place. 
9. Amount – the amount of the transaction. 
10. Auth Code – the authentication code of the transaction. 
11. Company Name - the company name of the customer
12. Username – username of the user who has processed the transaction
13. Operation ID -  the operation code of the transaction
 
Tip: Depending on the number of transactions displayed, a number of page options will appear below the grid. Use the Previous and Next buttons to move through the pages. Click the page numbers to navigate to a specific page.
Results Grid
The grid is a powerful way to display results.  When working with a Detail list (selected in the Report Type list box), you may perform several data manipulations directly in the grid. Operations you may perform on the grid are:
 
1. Sort - any column can be sorted in ascending or descending order by clicking its heading, to sort in the opposite direction, click the heading again
2. Filter - column headings with a blank field below them will act as filters when you enter data
3. Reorder - columns can be dragged and dropped anywhere left or right on the grid
4. Remove a Field from the grid - simply activate the Field Chooser window (below) and drag the offending field on to it and release the mouse button. The field will disappear from the grid.
5. Field Chooser - additional fields can be added to the grid by clicking the Show Additional Fields button.
 
Export Report Option
Any result set can be exported to Excel by clicking the Export to Excel button.


There are three cases how export works:

1. export of the report less than 10 000
2. export of the report that exceed 10 000 but less than 300 000
3. export of the report that exceed 300 000

I. Export of the report less than 10 000
If the list of transaction less than 10 000 rows then the file is exported immediately.


II. Export of the report that exceed 10 000 but less than 300 000
If the list of transactions exceeded 10 000 rows then a popup message will appear: "Your search has exceeded the 10 000 row limit. The system will email you when it is ready to download. Continue?"


If user selects "Yes", the report generation will be put in queue and the report will appear on the Download Reports page in Not Processed state. As soon as the report processing is finished, state will change and will reflect the result of the export operation: Processed or Export Failed. If "No" - the popup will close and the report will not be put in queue. 


If the file state is Processed, to download the report the user should click on the Download.


III. Export of the report that exceed 300 000
If the list of transactions exceeded 300 000 rows then a popup message will appear: " Your search has exceeded the 300 000 row limit. The system can not generate such report. Please update filters to narrow the report."


In this case the report will not be unloaded.

Save Report Option
Any set of search criteria can be saved by entering the Report Name and pressing the Save icon. After that user can view this report on the Saved Reports page.

 
Set Email Schedule
User is able to set Email Schedule for any report by entering the Report Name and pressing the Email Schedule icon. 

The dialog with the following sections appears:
  • Frequency - the frequency of emails with report;
  • Duration - until what date emails with report will be sent to specified email addresses;
  • Email - email addresses to what report will be sent (user can specify several emails separated by comma).


After all data is entered and the Save/Exit button is pressed the report appears (or becomes updated) in Saved Reports grid.
Pending Transactions

Use Split Funding - Pending Transaction to process split payments.

The page shows the following data: Transaction ID with link to the receipt, Transaction Status, Split Status, Amount, name of Merchant Account, Creation Time, ID of Split Group.


Process Split

Step 1: Select checkboxes next to the transactions to be processed.
Step 2: Click Process.

If transaction is not settled, it can not be split. These transactions can not be selected and are marked with a yellow triangle.


If an error occurred during processing of a split payment
, this transaction will be marked with a red round icon and will have Internal Error for Transaction Status.

 
 
 
 
 
 
 
 
Have more questions? Submit a request

Comments

Powered by Zendesk