Cash Flow Report Definitions

Cash Flow Report Definitions

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

What Is Cash Flow Report 

  1. Processing Reports   
    1. Cash Flow Report - Drill down report of approved sales and credits for each payment method

Making The Connection

Where Will I See This Within OLX?

Use the Cash Flow Report to show fiscal credits and debits by month or fiscal week. You can filter the report by: Client, Product Group, Processing Acct, Transaction Type or Order Type.  The data displayed in this report is: Number of Transactions for each type of credit card, Transaction amount for each type of credit card, Check, Telecheck and Money order Transactions and amounts and the total. Select "Show Inactive" boxes to view inactive information in filters.

What Imports/Exports Relate to Cash Flow Report?

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

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

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.
Date Range
The date range of the successful payment transaction
Report Layout
3 layer filter to display report data (see Grouping below)

example if set to BatchName/Date/DNIS:

Format
(only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
Expand
  1. None
    1. will not expand any of the selected groupings and only show the first layer of the Groupings set in Report Layout
  2. One
    1. will expand only the first Grouping to display the first and second layer of the Groupings set in Report Layout
  3. Two
    1. will expand all Groupings to display all layers of the Groupings set in Report Layout
Order Type
  1. Regular: An order that is not an autoship generated order and does not spawn any autoship orders.
  2. Enrollment: An order that is not an autoship generated order but DOES spawn an autoship order.
  3. Continuity: An order that IS an autoship generated order.
Client
The client of the product group of the item
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
Product Group
The product group of the item in the payment transaction
Team
The team of the employee who placed the order
Processing Acct
The payment account used to process the item
Item Type
Credit or debit



Grouping/Report Layout

Grouping
Definition
Batch Name
The name of the payment batch the item was in
Date
The date of the successful payment transaction
DNIS
The DNIS of the source of the order
Employee
The employee who took the order
Order Type
  1. Regular: An order that is not an autoship generated order and does not spawn any autoship orders.
  2. Enrollment: An order that is not an autoship generated order but DOES spawn an autoship order.
  3. Continuity: An order that IS an autoship generated order.
Processing Account
The payment account used to process the item
Product Group
The product group of the items on the payment transaction
Transaction Type
Credit or debit
*



 Column Definitions

Column
Definition
American Express # Trans
The number of successful American Express payment transactions
American Express Amount
Debit amount - credit amount for successful American Express payment transactions
Discover # Trans
The number of successful Discover payment transactions
Discover Amount
Debit amount - credit amount for successful Discover payment transactions
Mastercard # Trans
The number of successful Mastercard payment transactions
Mastercard Amount
Debit amount - credit amount for successful Mastercard payment transactions
Visa # Trans
The number of successful Visa payment transaction
Visa Amount
Debit amount - credit amount for successful Visa payment transactions
Check/Money Ord # Trans
The number of successful Check/Money Order payment transactions
Check/Money Ord Amount
Debit amount - credit amount for successful Check/Money Order payment transactions
Telecheck # Trans
The number of successful Telecheck payment transactions
Telecheck Amount
Debit amount - credit amount for successful Telecheck payment transactions
Other # Trans
The number of other successful payment transactions
Other Amount
Debit amount - credit amount for successful other payment transactions
Total # Trans
The number of total successful payment transactions
Total Amount
Debit amount - credit amount for total successful payment transactions
*




Copyright 2019
Revised 12.29.2025

    • Related Articles

    • 5.1.149 - Net Sales Report Fix

      Version: 5.1 Patch: 149 Title: Net Sales Report Fix Application Category: Other; Reports Patch Type: Bug Description: Fix to Net Sales Report results being blank with certain parameter settings.  Articles: Net Sales Report Definitions Net Sales ...

    • Warehouse Report Definitions

      This report displays all locations for all warehouses and the inventory items in them. Definitions Warehouse Report Column Definitions Warehouse The warehouse name Location The floor/aisle/section/shelf in the warehouse Is Multi? Whether or not the ...

    • Supplier Item Report Definitions

      This report display supplier item information. Definitions Supplier Item Report Column Definitions Supplier The supplier name Item The inventory item Sku Supplier Sku The supplier Sku for the inventory item Unit Of Measure The unit of measure for the ...

    • Client List Report Definitions

      This report lists clients entered in OLX. Client List Report Column Definitions Client ID The ID of the client Client Name The name of the client Contact Name The contact name for the client Address The address of the client Phone Number The phone ...

    • Return Analysis Report Definitions

      Module: Reports Path: Reports > Processing Reports > Return Analysis Report Topic: Returns Analysis Report Version(s): 5.1 and up Editions: All What Is Return Analysis Report Processing Reports Return Analysis - Analyze the return rate for previous ...