Accounting Return Analysis Report

Accounting Return Analysis Report

Info
Module: Reports
Path: Reports > Processing Reports > Accounting Return Analysis Report
Topic: Accounting Return Analysis Report
Version(s):  5.1 and up
Editions: All

What Is Accounting Return Analysis Report

  1. Processing Reports
    1. Accounting Return Analysis Report - View accounting return data.

Making The Connection

Where Will I See This Within OLX?

This report will show items that have had a successful completed refund and item status is Item Refund Accepted

What Imports/Exports Relate to Accounting Return Analysis 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)
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.
Calendar date selection based off above Date Type or can be manually set if using User Selected
  1. items shipped in the date range.
    1. example if you run a report for month of Feb
      1. you could have an order that creates on the last day of the month after morning processing and therefore does not process until the first of the following month.
      2. the items that ship in March will not show up on this report
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
Format
(only shows when setting up a schedule)
This is the format that the report will export in:
  1. PDF
  2. Excel
  3. CSV
The client of the source of the order
Show Inactive (Client)
Show in the report:
  1. Checked - show active and inactive Clients
  2. Unchecked - only show active Clients
The campaign of the source of the order
Show Inactive (Campaign)
Show in the report:
  1. Checked - show active and inactive Campaigns
  2. Unchecked - only show active Campaigns
The payment account used to process the item



 Column Definitions

Column
Definition
Month
The month of the successful payment transaction
Credits by Month of Issue
(Quantity * UnitPrice) + Shipping + Tax for successfully processed credit items in that month
Credit Before Shipment
(Quantity * UnitPrice) + Shipping + Tax for successfully processed credit items in that month
Month of Sale
Successfully processed credit items attached to successfully processed debit items that were processed in the same month (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 1
Successfully processed credit items attached to successfully processed debit items that were processed a month after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 2
Successfully processed credit items attached to successfully processed debit items that were processed two months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 3
Successfully processed credit items attached to successfully processed debit items that were processed three months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 4
Successfully processed credit items attached to successfully processed debit items that were processed four months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 5
Successfully processed credit items attached to successfully processed debit items that were processed five months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 6
Successfully processed credit items attached to successfully processed debit items that were processed six months after the debit item (Quantity * UnitPrice) + Shipping + Tax
Month of Sale + 7
Successfully processed credit items attached to successfully processed debit items that were processed seven months after the debit item (Quantity * UnitPrice) + Shipping + Tax     
Total
Sum of column(s)



Copyright 2025
Revised 3.23.2026