Receivables Management Report Procedures

Overview

The receivables management reports provide information about finance charges assessed on overdue invoices and related debt collection activities.

Receivables Management Reports

The receivables management reports include:

1099-C Cancellation of Debt

Government agencies are required to file the IRS 1099-C Cancellation of Debt for each debtor for whom a debt of $600.00 or more is cancelled during the calendar year. In addition, the 1099-C Cancellation of Debt must be produced on electronic media when 250 or more forms are submitted. 1096 Annual Summary and Transmittal of U.S. Information Returns must be produced for submission with Copy A of all paper 1099-C Cancellation of Debt reports.

Oracle U.S. Federal Financials provides these features:

Delinquent Invoice Referral

The Delinquent Invoice Referral process lets you perform these tasks:

Requirements

Federal agencies are required to comply with the requirements of the Debt Collection Act regarding collection of finance charges on overdue invoices and the reporting of those charges.

The Assign Finance Charges Report and the Apply Cash Receipts Execution Report are intended for internal use to verify processing in Oracle U.S. Federal Financials.

Oracle U.S. Federal Financials provides the Receivables Activity Worksheet to comply with reporting requirements of the Department of Treasury's Financial Management Service (FMS). For agencies with total receivables, inclusive of principal, interest, and late charges, greater than or equal to fifty million dollars, the report must be submitted quarterly, by the end of the thirtieth day of the month following the close of each of the first three quarters. Annual reports are due on November 15 from all agencies, regardless of the amount of total receivables for the fiscal year. Annual reports must be certified as accurate by the chief financial officer or agency head; certification must be submitted separately from the report. Verifications are due by March 31 of each year for the preceding fiscal year.

Federal Financials provides the 1099-C Electronic Filing, 1099-C Cancellation of Debt, and 1096 Annual Summary and Transmittal of U.S. Information Returns to comply with Internal Revenue Service requirements that agencies file 1099-C reports for each debtor for whom a debt of $600 or more is cancelled during the calendar year.

Additional information regarding reporting requirements is available in the Treasury Financial Manual (TFM).

Prerequisites

Entering Customer Contacts, Oracle Receivables User Guide

Organizations, Oracle Receivables User Guide

Federal Options Setup,Oracle U.S. Federal Financials Implementation Guide

Transactions Window Field Reference, Oracle Receivables User Guide, Oracle Receivables User Guide

Crediting Transactions,Oracle Receivables User Guide

Federal System Parameters Setup,Oracle U.S. Federal Financials Implementation Guide

Delinquent Invoice Referral Setup,Oracle U.S. Federal Financials Implementation Guide

Receivable Types Setup,Oracle U.S. Federal Financials Implementation Guide

Receivables Management Procedures

Assigning Finance Charges Report Procedure

The Assign Finance Charges Report is generated automatically during the Assign Finance Charges procedure.

Assign Finance Charges Report Description

The following table describes the Assign Finance Charges report.

Assign Finance Charges Report Description
Column Description
Header Section Operating Unit, Ledger, currency, and report date
Assigned Finance Charges to Customers Customers assigned finance charges
Customer Name Customer name
Customer Number Customer identifier
Charge Type Finance charge type assigned to customer
Assigned Finance Charges to Invoices Invoices assigned finance charges
Customer Name Customer name
Customer Number Customer identifier
Invoice Number Invoice identifier
Charge Type Finance charge type assigned to invoice
Waived Indicates if charge is waived on invoice

Generating the Accrue Finance Charges Detail Report Procedure

The Accrue Finance Charges Detail Report is generated automatically during the Accrue Finance Charges procedure.

Accrue Finance Charges Detail Report Description

The following table describes the Accrue Finance Charges Detail report.

Accrue Finance Charges Detail Report Description
Column Description
Header Section Operating Unit, Organization, Ledger, currency, report date, and page
Finance Charge Debit Memos Created in AutoInvoice Interface Tables Region  
Transaction Number Debit memo transaction number
Line Number Line number
Finance Charge Type Charge type name defined in the Define Finance Charges window
Amount Debit memo amount
Existing Finance Charge Debit Memos Adjusted Region  
Transaction Number Adjusted debit memo transaction number
Finance Charge Type Charge type name defined in the Define Finance Charges window
Amount Debit memo adjusted amount

Generating the Receivables Activity Worksheet Procedure

To print the Receivables Activity Worksheet:

  1. Navigate to the Submit Request window.

  2. In the Name field, select Receivables Activity Worksheet.

  3. In the Ledger field, select the ledger.

  4. In the Reporting Entity Code field, enter a reporting entity code.

  5. In the Fiscal Year field, select a fiscal year.

  6. In the Quarter field, optionally select a quarter.

  7. In the Reported By field, select the date option required.

  8. In the Type of Receivable field, select a receivable type to be reported.

  9. In the Receivables Write Offs Activity 1 field, select a receivables activity for write-offs.

    Note: Up to three Receivables Write-Off Activities can be selected per report.

  10. In the Receivables Write Offs Activity 2 field, optionally select a receivables activity for write-offs.

  11. In the Receivables Write Offs Activity 3 field, optionally select a receivables activity for write-offs.

  12. In the Non-Federal Customer Class field, select a non-federal customer class.

  13. In the Footnotes field, enter footnote text.

  14. In the Name of Preparer field, enter the name of the person preparing the report.

  15. In the Preparer's Phone field, enter a phone number.

  16. In the Preparer's Fax Number field, enter a fax number.

  17. In the Preparer's E-MAIL field, enter an e-mail address.

  18. In the Supervisors's Name field, enter the supervisor's name.

  19. In the Supervisor's Phone field, enter a phone number.

  20. In the Supervisor's E-Mail field, enter an e-mail address.

  21. In the Address Line 1 field, enter the agency street address.

  22. In the Address Line 2 field, optionally enter the agency street address.

  23. In the Address Line 3 field, optionally enter the agency street address.

  24. In the City field, enter the agency city.

  25. In the State field, enter the agency state.

  26. In the Postal Code field, enter the agency postal code.

The Receivable Activity Worksheet selection criteria only select AR Transactions, AR adjustments, and Standard Receipts for customers with a customer classification other than a Federal or Non-Federal Code “G:Genral Fund” or “F:Federal ”.

Receivables Activity Worksheet Description

The Receivable Activity Worksheet has been reformatted to be consistent with Treasury Report on Receivables and Debt Collection Activities version posted to Treasury website on 8/21/2015 located at https://www.fiscal.treasury.gov/fsservices/gov/debtColl/pdf/tror/TROR_Form_yr2016_with_formulas.xlsx

The columns for the Selection Criteria for Worksheet Reporting represent the following:

Generating the Identification of Federal Employees Report

To print the Identification of Federal Employees Report:

  1. Navigate to the Submit Request window.

  2. In the Name field, select Identify Federal Employees.

  3. In the Operating Unit field, select an operating unit.

  4. In the Customer Category field, select a category.

  5. In the Customer Class field, select a class.

  6. In the Customer Type field, select Internal or External.

Identification of Federal Employees Report Description

The following table describes the Identification of Federal Employees report.

Identification of Federal Employees Report Description
Column Description
Header Section Operating Unit, Ledger, currency, and report date
Customer Name Customer name
Customer Number Customer identifier
SSN Social Security Number
Bill To Address Customer address
Category Receivables Customer Category
Name Federal employee name

Generating the 1099-C Electronic Filing

To run the 1099-C Electronic Filing procedure for an organization:

  1. Navigate to the Submit Request window and select Single Request.

  2. In the Name field, select 1099-C Electronic Filing.

  3. In the Operating field, select an operating unit.

  4. In the Tax Year field, enter the tax year using a two digit format.

  5. In the Invoice Minimum field, enter an invoice amount or use the default value of $600.00.

    Note: The process only selects records greater than or equal to the Invoice Minimum value.

  6. In the Media field, enter the two character magnetic tape or tape cartridge type.

1099-C Electronic Filing Format Description

If an organization submits 250 or more 1099-C forms to the IRS, the forms must be sent by electronic media.

The 1099-C Setup process must be run prior to producing the electronic filing data file. The file contains these record types:

The following tables describe the 1099-C Electronic Filing format.

The following table describes the 1099-C Electronic Filing format, Creditor/Transmitter A record.

1099-C Electronic Filing Format Description, Creditor/Transmitter A Record
Field Position Field Title Length Description
1 Record Type 1 Required. Record type is A.
2-3 Payment Year 2 Required; from the tax year parameter.
4-6 Reel Sequence No. 3 Optional. The reel sequence number is incremented by 1 for each tape or diskette on the file starting with 001.
7-15 Creditor's TIN 9 Required. The nine-digit Taxpayer Identification Number assigned to the payor.
16-19 Creditor Name Control 4 Optional.
20 Last Filing Indicator 1 Optional.
21 Combined Federal/State Filer 1 Optional.
22 Type of Return 1 Required; return code type.
23-31 Amount Codes 9 Required; amounts on return type.
32 Test Indicator 1 T if test file; otherwise blank.
33 Service Bureau Indicator 1 Indicator is 1 if a service is used to develop or transmit files.
34-41 Blank 8 Enter blanks.
42-43 Magnetic Tape Filer Indicator 2 Required for magnetic table/tape cartridge files from the media parameter.
44-48 Transmitter Control Code 5 Required. Enter the five character Transmitter Control Code assigned by IRS/MCC from the transmitter control code parameter.
49 Foreign Entity Indicator 1 Indicator is 1 if the creditor is a foreign entity and income is paid.
50-89 First Creditor Name 40 Required; creditor name.
90-129 Second Creditor 40 Optional.
130 Transfer Agent Indicator 1 Optional.
131-170 Creditor Shipping Address 40 Creditor address; fill unused positions with blanks.
171-210 Creditor City, State, and Zip Code 40 Required; city, town, or post office, state, and zip code.
211-290 Transmitter Name 80 Required if creditor and transmitter are not the same.
291-330 Transmitter Mailing Address 40 Required if creditor and transmitter are not the same.
331-370 Transmitter City, State, and Zip Code 40 Transmitter's city, town, or post office; state; and zip code.
371 Blank 50 Enter blanks.

The following table describes the 1099-C Electronic Filing format, Debtor B records.

1099-C Electronic Filing Format Description, Debtor B Records
Field Position Field Title Length Description
1 Record Type 1 Required. Record type is B.
2-3 Payment Year 2 Required; from the tax year parameter.
4-13 Blank 10 Enter blanks.
14 Type of TIN 1 If the Taxpayer Identification Number is Employer Identification Number, enter 1; for Social Security Number, enter 2; if cannot determine, enter 3.
15-23 Tax Identification Number 9 Required; the nine-digit Taxpayer Identification Number assigned to the debtor.
24-43 Creditor's Account Number for Debtor 20 Optional. Enter any number assigned by the creditor to the debtor.
44-50 Blank 7 Enter blanks.
51-60 Payment Amount 1 10 Enter zero.
61-70 Payment Amount 2 10 Enter amount of cancelled debt; right-justified and zero filled
71-80 Payment Amount 3 10 Enter interest cancelled right justified and zero filled.
81-90 Payment Amount 4 10 Enter zero.
91-100 Payment Amount 5 10 Enter zero.
101-110 Payment Amount 6 10 Enter zero.
111-120 Payment Amount 7 10 Enter zero.
121-130 Payment Amount 8 10 Enter zero.
131-140 Payment Amount 9 10 Enter zero.
141-160 blank 20 Enter blanks.
161 Foreign Country Indicator 1 Enter 1 if debtor is in foreign country; otherwise, enter blank.
162-201 Debtor Name 40 Required. Enter the name of the debtor.
202-241 2nd Debtor Name Line 40 Optional.
242-281 Debtor Mailing Address 40 Required. Enter mailing address of debtor.
282-310 Debtor City 29 Required. Enter city of debtor.
311-312 Debtor State 2 Required. Enter the valid U.S. Postal Service state abbreviations for states on the appropriate postal identifier.
313-321 Debtor ZIP Code 9 Required. Enter the debtor ZIP code.
322-370 Blank 49 Enter blanks.
371-376 Date Cancelled 6 Enter the date the debt was cancelled as MMDDYY.
377 Bankruptcy Indicator 1 Enter blank if FV_1099C.bankruptcy_code is blank; otherwise enter 1.
378-416 Debt Description 39 original debt description
417-420 Blanks 4 Enter blanks.

The following table describes the 1099-C Electronic Filing format, End of Creditor C records.

1099-C Electronic Filing Format Description, End of Creditor C Records
Field Position Field Title Length Description
1 Record Type 1 Required. Record type is C.
2-7 Number of Payees 2 Required. Enter the total number of B records; right justify information and fill unused positions with zeroes.
8-10 Blank 3 Enter blanks.
11-25 Control Total 1 15 Enter zero.
26-40 Control Total 2 15 Enter zero.
41-55 Control Total 3 15 Enter zero.
56-70 Control Total 4 15 Enter zero.
71-85 Control Total 5 15 Enter zero.
86-100 Control Total 6 15 Enter zero.
101-115 Control Total 7 15 Enter zero.
116-130 Control Total 8 15 Enter zero.
131-145 Control Total 9 15 Enter zero.
146-420 Blank 275 Enter blanks.

The following table describes the 1099-C Electronic Filing format, End of Transmission F records.

1099-C Electronic Filing Format Description, End of Transmission F Records
Field Position Field Title Length Description
1 Record Type 1 Required. Record type is F.
2-5 Number of A Records 4 Required. Enter the total number of type A records.
6-30 Zero 25 Enter zeroes.
31-420 Blank 390 Enter blanks.

1099-C Preprinted Form Report

To print the 1099-C Cancellation of Debt for an organization:

  1. Navigate to the Submit Request window.

  2. In the Name field, select 1099-C Preprinted Form Report Procedure.

  3. In the Operating Unit field, select an operating unit.

  4. In the Ledger field, select a ledger.

  5. In the Invoice Minimum field, enter an invoice amount or use the default value of $600.00.

    Note: The report only selects records greater than or equal to the Invoice Minimum value.

  6. In the Reprint field, select either Yes or No.

  7. In the Reprint Type field, select All, Corrected, or Void.

    Note: Select Reprint Type only if Reprint is set to Yes.

Note: The IRS 1099-C Cancellation of Debt report is a preprinted form that is produced by the IRS annually. Oracle U.S. Federal Financials enables agencies to print financial information from written-off receivables onto these preprinted forms.

Additional Information: The table below describes the 1099-C Cancellation of Debt selection criteria.

The following table describes 1099-C Cancellation of Debt Selection Criteria report.

1099-C Cancellation of Debt Selection Criteria
Reprint Reprint Type Description
No   All invoices that are checked reportable and are not checked reprint are selected for the 1099-C Cancellation of Debt report.
Yes Void Only invoices checked as reportable, reprint, and void are selected for the 1099-C Cancellation of Debt report.
Yes Corrected Only invoices checked as reportable, reprint, and corrected are selected for the 1099-C Cancellation of Debt report.
Yes All All invoices checked reportable and reprint, and either void or corrected, are selected for the 1099-C Cancellation of Debt report.

1099-C Cancellation of Debt Report Description

The following table describes the 1099-C Cancellation of Debt report.

1099-C Cancellation of Debt Report Description
Field Description
Creditor's name, street address, city, state, and ZIP code Name, address, city, state, and ZIP code for creditor
Creditor's Federal identification number Federal identification number for creditor
Debtor's identification number Federal identification number for debtor
Date cancelled Date the debt cancelled
Amount of debt cancelled Amount of debt cancelled
Debtor's name Debtor name
Interest if included in box 2 Amount of interest if included as part of amount of debt cancelled
Street address (including apt. no.) Street address of debtor
City, state, and ZIP code City, state, and ZIP code of debtor
Debt description Description of debt
Account number (optional) Optional field, account number assigned by agency
Check for bankruptcy If box is selected, the creditor indicated that debt was cancelled in a bankruptcy proceeding.
Fair market value of property The fair market value of property is shown, or the debtor receives a separate Form 1099-A Acquisition or Abandonment of Secured Property.

Generating the 1096 Annual Summary and Transmittal of U.S. Information Returns

To print the 1096 Annual Summary and Transmittal of U.S. Information Returns for an organization:

Note: Run this data after the 1099-C Cancellation of Debt reports are processed.

  1. Navigate to the Submit Request window.

  2. In the Name field, select 1096 Annual Summary and Transmittal of U.S. Information Returns.

  3. In the Operating Unit field, select an operating unit.

  4. In the Ledger field, select a ledger.

  5. In the Name of Contact Person field, enter a contact name.

  6. In the Phone of Contact Person field, enter a phone number.

  7. In the Federal Income Tax Withheld field, enter the amount of federal income tax withheld.

  8. In the Invoice Minimum field, enter an invoice amount or use the default value of $600.00.

    Note: The report only selects records greater than or equal to the Invoice Minimum value.

Note: The IRS 1096 Annual Summary and Transmittal of U.S. Information Returns is a preprinted form that is produced by the IRS annually. Oracle U.S. Federal Financials enables agencies to print financial information from written-off receivables onto these preprinted forms using the 1096 Annual Summary and Transmittal of U.S. Information Returns report.

1096 Annual Summary and Transmittal of U.S. Information Returns Report Description

The following table describes the 1096 Annual Summary and Transmittal of U.S. Information Returns report.

1096 Annual Summary and Transmittal of U.S. Information Returns Report Description
Field Description
Filer's name, street address, city, state, and ZIP code Name, address, city, state, and ZIP code for filer.
Name of person to contact if the IRS needs more information; Telephone number Name and telephone number of person to contact.
1. Employer identification number Federal identification number of employer.
2. Social security number Social security number of filer.
3. Total number of forms Total number of forms sent to IRS.
4. Federal income tax withheld Amount of federal income tax withheld.
5. Total amount reported with this Form 1096 Total amount reported with the Form 1096.
Enter an 'X' in only one box below to indicate the type of form being filed. Indicates the type of form being filed.
If this is the FINAL return, enter an 'X' here Indicates if the form is the final return.

Generating the Delinquent Invoices Eligible for Referral Report

To print the Delinquent Invoices Eligible for Referral Report:

  1. Navigate to the Submit Request window.

  2. In the Name field, select Delinquent Invoices Eligible for Referral Report.

  3. In the Operating Unit field, select an operating unit.

  4. In the As of Date field, optionally select a target date.

  5. In the Customer Name Low and High fields, optionally select a customer name to begin the report generation.

  6. In the Customer Number Low and High fields, optionally enter a customer number to begin the report generation.

  7. In the Receivables Type field, optionally enter a receivables type.

Delinquent Invoices Eligible for Referral Report Description

The following table describes the Delinquent Invoices Eligible for Referral report.

Delinquent Invoices Eligible for Referral Report Description
Field Description
Header Section Ledger, operating unit, report date, and page.
Invoice Number Invoice transaction number.
Receivable Type Receivable type; includes Administrative Receivables, Defaulted Guaranteed Loans, or Direct Loans.
Due Date Original invoice due date.
Days Past Due Calculated by subtracting Due Date from the As of Date parameter.
Original Amount Due Original amount due.
Amount Outstanding Amount due; includes invoice and debit memo transactions.

Generating the Invoice Status Report

To print the Invoice Status Report:

  1. Navigate to the Submit Request window.

  2. In the Name field, select Invoice Status Report.

  3. In the Operating Unit field, select an operating unit.

  4. In the Invoice Number Low field, select an invoice number that is past due by at least one day to begin invoice status report generation.

  5. In the Invoice Number High field, select an invoice number that is past due by at least one day to end invoice status report generation.

  6. In the Receivable Type field, select a Receivable Type.

  7. In the Customer Name Low field, select a customer name to begin the report generation.

  8. In the Customer Name High field, select a customer name to end the report generation.

  9. In the Customer Number Low field, enter a customer number to begin the report generation.

  10. In the Customer Number High field, enter a customer number to end the report generation.

  11. In the Current/History field, select Current or History.

  12. In the Invoice Status field, select an invoice status.

Invoice Status Report Description

The following table describes the Invoice Status report.

Invoice Status Report Description
Field Description
Header Section Ledger, operating unit, report date, and page.
Customer Name Customer name.
Customer Number Customer number.
Location Customer location.
Invoice Nbr Invoice transaction number.
Due Date Original invoice due date.
Days Past Due Calculated by subtracting Due Date from the As of Date parameter.
Receivable Type Receivable type.
Amount Due Amount due.
Status Invoice status.
Start Date Invoice start date.
End Date Invoice end date.
Comments User comments.

Generating the Delinquent Invoice Referral

To generate the delinquent invoice electronic file and to print the Delinquent Invoice Referral Report:

Note: Debt Eligible for Referral to Treasury for Offset of Debt Eligible for Referral to Treasury for Cross-referencing must be assigned in the Invoice Status window before running this process.

  1. Navigate to the Submit Request window.

  2. In the Name field, select Delinquent Invoice Referral Process.

  3. In the Operating Unit field, select an operating unit.

  4. In the Customer Name Low and High fields, optionally select a customer name to begin and end the report generation.

  5. In the Customer Number Low and High fields, optionally enter a customer number to begin and end the report generation.

  6. In the Referral Through Date field, optionally enter the referral through date to end the report generation.

  7. In the Output field, select Report Only or Report and Electronic File.

Note: When the Report and Electronic File parameter is selected, two requests are submitted to the concurrent manager. The output of the first request contains the Delinquent Invoice Referral Report. The second request produces the output file to be submitted to Debt Management Service (DMS).

Note: To submit an electronic file to DMS, save the output of the Delinquent Invoice Referral Process as a text file (.txt). The file can then be uploaded to DMS through their approved procedures.

Delinquent Invoice Referral Report Description

The following table describes the Delinquent Invoice Referral report.

Delinquent Invoice Referral Report Description
Field Description
Header Section Ledger, operating unit, report date, and page.
Customer Name Customer name.
Customer Number Customer number.
Invoice Number Invoice transaction number.
Due Date Original invoice due date.
Days Past Due Calculated by subtracting Due Date from the Referral Through Date parameter.
Principal Amount due remaining.
Interest Sum of debit memos whose finance charge category is Interest.
Administrative Costs Sum of debit memos whose finance charge category is Administrative.
.Penalties Sum of debit memos whose finance charge category is Penalties.
Total Amt Referred Calculated by adding Referred Principal, Referred Interest, and Referred Administrative, and Penalties.

Related Topics

Receivables Management Procedures

Receivables Management Process

1099-C Cancellation of Debt Selection Criteria