What is the Sales Journal Summary

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

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.   

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

Realized This Period -  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 this Period - 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