What is the Sales Journal Summary with Period Information Report?

Purpose

Contains all sales and adjustment information within a specified date range.  The report is compiled by journal numbers with any transaction date within the date range criteria entered for the report.

Access and Report Parameters

Reports>Billing>Journal Summaries>Sales Journal Summary with Period Information.

Report Parameters

Date Range -  From and Thru

Program - User can choose All, select a single program or select multiple programs

Group by - Program or Category

When Grouped by Category:  Report is Compiled by the Criteria Below

Transaction Category (TrxCategories)

Program

Transaction Type (TrxType)

Transaction Subcategory (TrxSubCategories)

 When Grouped by Program -  Report is compiled by the Criteria Below

       Program

Transaction Category (TrxCategories)

Transaction Type (TrxType)

Transaction Subcategory (TrxSubCategories)

Report Columns

Carrier – Carrier description or when the transaction is not associated to any carrier

Transaction Date – Sales and credit transactions entered within the specified date range of the report

Service Dates

          Start

          End

Journal Number

Realized This Period: Transactions prior to the date range of the report period and the service range is within the report period.   

Prior Period - Transactions within the date range of the report that have service dates prior to the start date of the report.  Can be either the entire service date range or part of the service date range (will be prorated as noted below) is before the date range of the report

Prior Period 1 – 1 Period Criteria - All prior sales as defined above  

Prior Period 2  Column will only show when Period 2 is selected.

1 Period Criteria - This column would include all transactions for an equivalent time as the report date range.

          2 Period Criteria – This column will in all transactions prior to the start date of Period 1

Deferred this Period is Defined as sales with a start date and/or end date that is after the specified date range.  Only invoices are deferred.

Calculations are based on the individual transactions on the each of the journals listed. 

Can be either the entire service date range or part of the service date range (will be prorated as noted below) is before the date range of the report. The full amount of the journal should be reflected between all of these calculations to the penny.

Current Sales:  Both the transaction date and the service dates are within the date range of the report.  When the date range extends beyond the date range, the current amount is calculated

Calculate number of days between service start date and service end date

Divide the amount of the transaction by the number of days to determine the per day

Current – number of days  that the service date range is within the date range of the report multiply by the per day calculation

Prior Period 1  - Transaction date is within the report date range and the service dates are prior to the From Date

Calculate number of days between service start date and service end date

Divide the amount of the transaction by the number of days to determine the per day calculation.

Prior period 1 – number of days  that the service date range is prior to the date range of the report multiply by the per day calculation

Prior Period 2  - Transaction date is within the report date range and the service dates are prior to the first date of Prior Period 1

Calculate number of days between service start date and service end date

Divide the amount of the transaction by the number of days to determine the per day calculation.

Prior period 1 – number of days  in the prior month multiplied by the per day calculation

Prior period 2 – number of days  that the service date range is prior to month before  the  range of the report multiply by the per day calculation

Realized:  Transaction date is before the date range of the report and part of the service date range is within the of the report.

Calculate number of days between service start date and service end date

Divide the amount of the transaction by the number of days to determine the per day calculation.

Realized – number of days  that the service date range is within the date range of the report multiply by the per day calculation

Deferred:  Transaction date is before the thru date of the report and part of the service date range is after the date range of the report.

Calculate number of days between service start date and service end date

Divide the Amount of the transaction by the number of days to determine the per day calculation.

Deferred – amount is determined by number of days  that the service date range is after the thru date multiply by the per day calculation