Payment Batch Report Definitions

Payment Batch Report Definitions


Info
Module: Reports
Path: Reports > Processing Reports > Payment Batch Report 
Topic: Payment Batch Report
Version(s):  5.1 and up
Editions: All

What Is Payment Batch Report

  1. Processing Reports                  
    1. Payment Batch Report - Sales payments breakdown.

Making The Connection

Where Will I See This Within OLX?

This report is for payment batches created in OLX.

What Imports/Exports Relate to Payment Batch Report?

  1. At this time there are no imports/exports related to the report

Trouble Shooting

  1. Navigating to the end of report will display all transactions with an Unknown Result or Debit Other
    1. These orders should be reviewed manually, starting with Unknown Results as you may have transactions that were approved on the gateway, but the response did not make it back to OrderLogix.

Setup


Preview




You'll notice control buttons displayed just above the results. Review Report Tools (orderlogix.com) article for more information on how to utilize each control button. :
  1. View Report  - Displays results
    1. Displays the toolbar 
  2. Hide Controls - Hides report filters
    1. Show Controls - Displays report filters
  3. Show Schedules  - Displays schedule editor
    1. Format filter will display at top of screen
    2. Delivery and Encryption tabs will display on bottom left of screen
  4. Show Instances - Displays list of previously ran and pending reports. Click on the status to review the job log.
  5. Close  - Close out of the report popup.

Report Definitions

Using Calendar Icon to Set Date(s) is a good article to review when running reports manually or scheduling for automation.

Filters

Filter
Definition
Date Type
  1. User Selected
    1. Allows the user to select any calendar day for start and end range.
  2. Last Week (S)
    1. The previous week starting with Sunday will automatically be set in the Date Range
  3. Last Week (M) 
    1. The previous week starting with Monday will automatically be set in the Date Range
  4. This Quarter
    1. Date Range will set to the current quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  5. Last Year
    1. Jan 01 of previous year to Dec 31 of previous year
  6. Last Month
    1. Day one of previous month to the last day of the previous month
  7. This Week (S) - Sunday
    1. Current week from Sunday to the following Saturday
  8. This Week (M) - Monday
    1. Current week from Monday to the following Sunday
  9. This Month
    1. First day of current month to last day of current month
  10. This Week to Date (S) - Sunday
    1. Sunday of current week to current date
  11. This Week to Date (M) - Monday
    1. Monday of current week to current date
  12. This Month to Date
    1. First day of current month to current day
  13. Tomorrow
    1. Current day plus one
  14. Now to End of Week (S) - Sunday
    1. Current day the next Sunday
  15. Now to End of Week (M) - Monday
    1. Current day to the next Monday
  16. Now to End of Month
    1. Current date to last day of the current month
  17. Now to End of Year
    1. Current date to Dec 31 (current year)
  18. Last Quarter
    1. Date Range will set to the previous quarter based off the current date and which quarter it falls in:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  19. This Quarter To Date
    1. Date Range will set to the current quarter based off the current date up to the current dates data:
      1. First quarter, Q1: 1 January – 31 March (90 days or 91 days in leap years)
      2. Second quarter, Q2: 1 April – 30 June (91 days)
      3. Third quarter, Q3: 1 July – 30 September (92 days)
      4. Fourth quarter, Q4: 1 October – 31 December (92 days)
  20. Year to Date
    1. Jan 01 (current year) to current date
Fiscal Week
(only shows during manual run when utilizing User Selected Date Type above)
This will set the below Date Range to the Monday - Sunday date range selected from this drop down.
The date ranges the batch was created
Format
This is the format that the report will export in:
PDF
Excel
CSV
Client
The client of the source of the order in the batch
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
Report Type
Whether to show only credit card details, customer details or both
Show Max Number of Declines
Trans Type
  1. All
    1. will display approved, declined, unknown, and unprocessed transaction results
  2. Approved Only
    1. only transaction results that show as approved will display
  3. Declined Only
    1. only transaction results that show as declined will display
  4. Unknown Only
    1. only transaction results that show as unknown will display
  5. Unprocessed Only
    1. only transaction results that show as unprocessed will display
A specific payment batch



 Column Definitions

Payment Batch Credit Card Details Column
Definition
Total Attempted
Total amount of items that were attempted to be processed for all payment methods broken down by debit, credit and net (debit - credit)
Total Approved
Total amount of items that were approved for all payment methods broken down by debit, credit and net
Visa Attempted
Total amount of Visa items that were attempted to be processed broken down by debit, credit and net
Visa Approved
Total amount of Visa items that were approved broken down by debit, credit and net
MasterCard Attempted
Total amount of Mastercard items that were attempted to be processed broken down by debit, credit and net
MasterCard Approved
Total amount of Mastercard items that were approved broken down by debit, credit and net
Discover Attempted
Total amount of Discover items that were attempted to be processed broken down by debit, credit and net
Discover Approved
Total amount of Discover items that were approved broken down by debit, credit and net
American Express Attempted
Total amount of American Express items that were attempted to be processed broken down by debit, credit and net
American Express Approved
Total amount of American Express items that were approved broken down by debit, credit and net



Payment Batch Customer Details Column
Definition
Order Date
The date the order was placed
Customer Name
Customer first and last name
City
The billing city at the time of the transaction
State
The billing state at the time of the transaction
Zip
The billing zip at the time of the transaction
Payment Details
The payment information at the time of the transaction including payment method, cc number/routing number, cc exp date/account number
Amount
The amount attempted to be processed
Result
The result of the transaction if available (approved, declined, unknown, etc)
Order #
The order ID



Copyright 2019
Revised 2.05.2026