Bad Debt Write Off

Introduction

Purpose of Report

The Bad Debt Write Off report is designed to provide local billing units with the information needed to manage receivables and the related General Ledger accounting.

Intended Audience

The intended audience includes anyone with responsibility for tracking, analyzing, and managing AR invoices.

Parameters Screen

Note:

Enter single values or a limited number of values to fields on the Parameters screen to improve system performance and obtain results more quickly.

In This Field

Enter

Report Description

Description of this report

Note: This description is included in the View Requests screen.

Tub

Tub value(s) using dashes and/or commas for continuous and noncontinuous ranges, respectively

Note: System defaults to all tubs.
Org

Org value(s) using dashes and/or commas for continuous and noncontinuous ranges, respectively

Note: System defaults to all orgs.
Type Low / High You can pick a transaction type associated with invoices / credits that you want included in the results, or enter part of the invoice type to get a reduced list of values

Customer Name Low / High

You can pick a customer name from the list of values. The default is "All"

Customer Number Low / High

You can pick a customer number from the list of values. The default is "All"

Invoice Number Low / High

A range, by invoice number, that you want included in the results

Note: Use the list of values to view all invoices.

Invoice Date Low / High

You can enter the date parameters of the original invoices
Site

Site is a unique name given to a bill-to-site. You can type in part of the name to get a reduced list of sites

Date of Bad Debt Write Off Low / High

You can enter the date range for the Bad Debt Credit Memos. If no range is selected, the reports will default to "all"
Primary Sort

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Type, Customer Name, Customer Number, Invoice Number, Invoice Date, Date of Bad Debt Credit Memo.
Subtotal on Primary Sort? Select Yes or No. If you select No, then you cannot select Yes in a subsequent sort/subtotal option
Page Break on Primary Sort / Subtotal Select Yes or No. If you select No, then you cannot select Yes in a subsequent sort / subtotal option
Secondary Sort

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Type, Customer Name, Customer Number, Invoice Number, Invoice Date, Date of Bad Debt Credit Memo.
Page Break on Secondary Sort / Subtotal Select Yes or No. If you select No, then you cannot select Yes in a subsequent sort / subtotal option

Subtotal on Secondary Sort?

Select Yes or No
Tertiary Sort

Variable by which you want the report sorted and subtotaled

Note: Select from the following list: Tub, Org, Type, Customer Name, Customer Number, Invoice Number, Invoice Date, Date of Bad Debt Credit Memo.
Page Break on Tertiary Sort / Subtotal Select Yes or No. If you select No, then you cannot select Yes in a subsequent sort / subtotal option
Subtotal on Tertiary Sort? Select Yes or No

Interpret Report Output

Column Content

Column Name

Contains

Tub

The tub value is displayed here

Org

The org value is displayed here

Type

Invoice Type descriptions, which are generally equivalent to org names

Customer Name / Number

The customer name and number are displayed

Site

The customer site, if selected, is displayed

Invoice Number Invoice numbers are listed in this column in ascending order (requested sorts taking precedent)
Invoice Amount The original invoice amount, which is the summary amount of the entire invoice
Credit Memo Number The credit memo number that was applied to the invoice to charge it to Bad Debt is displayed
Date of Credit Memo The date of the Bad Debt credit memo is displayed
Amount Written Off The amount of the Bad Debt credit memo is displayed