Skip Headers

Oracle U.S. Federal Financials User Guide
Release 12.1
Part Number E13551-04
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Receivables Management Report Procedures

Receivables Management Report Procedures

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.

Receivables Activity Worksheet Description

The following table describes the Receivables Activity worksheet.

Receivables Activity Worksheet Description
Line Description
Part I: Status of Receivables  
Section A: Receivables and Collections  
1. Beginning FY Balance Number and dollar amount of all receivables outstanding at beginning of fiscal year; figures must agree with ending balance reported at end of prior fiscal year.
2. New Receivables (+) Number and dollar amount of all receivables generated in current fiscal year.
3. Accruals (+) Dollar amount of earned interest and late charges accrued during current fiscal year.
4. Collections on Receivables (-) Dollar amount of collections on all debts, including delinquent and non-delinquent debt, during the fiscal year; non cash collections, for example, personal property or services rendered must be footnoted; total dollar amount equals the sum of lines 4A, 4B, 4C, and 4D of this section.
(A) At Agency Dollar amount for both delinquent and non-delinquent debt worked and collected at agency.
(B) At Third-Party Dollar amount for both delinquent and non-delinquent debt collected by a third party other than the Department of Justice or private collection agency, such as a guaranty agency.
(C) Asset Sales Dollar amount of proceeds realized from sale of a loan or debt asset.
(D) Other - must footnote Dollar amount of all other collections both delinquent and non-delinquent not recorded in lines 4A, 4B, or 4C above; amounts reported on this line must be footnoted to identify the collection tools or techniques used.
5. Adjustments Number and dollar amount of changes to receivables during the fiscal year due to reclassifications or adjustments; adjustments dollar amount reclassified or adjusted and transferred into or out of receivables balance in current fiscal year; corrections to previously reported receivables, refunds of amounts previously reported as collections, and adjustments made in prior periods; total dollar amount equals the sum of lines 5A, 5B, and 5C of this section; lines may be either positive or negative.

Note: Per Treasury, waived transactions are treated as Adjustments and are reported on line 5A in Part I, Section A. Waived transactions are not written-off. However, at this time the Waive Finance Charges window is not designed for this purpose.

(A) Reclassified/Adjusted Amounts (+ or -) Dollar amount reclassified or adjusted and transferred into or out of receivables balances during fiscal year; all amounts reported on this line must be footnoted with reason for adjustment.
(B) Adjustments Due to the Sale of Assets (+ or -) Dollar amount of difference between gross book value of an asset and proceeds from sale of asset, as recorded as a collection in line 4C.
(C) Consolidations (+ or -) Dollar amount of proceeds received through loan consolidations.
6. Amounts Written Off (-) Dollar amounts written off during current fiscal year.

Note: Only invoice and principal amounts are reported on this line.

(A) Currently Not Collectible Number and dollar amount of debts greater than two years old where collection continues and debt not closed out.
(B) Written-off and Closed Out Number and dollar amount of debts resulting in termination of all collection activity and elimination of accounts from further servicing.
7. Ending Balance Number and dollar amount of receivables outstanding at end of reporting period; number and dollar amounts of lines 7A and 7B of this section do not always equal line 7.
(A) Foreign/Sovereign Number and dollar amount of receivables owed to Government by Sovereign nations; debts owed by foreign corporations or foreign individuals are not included; this line is for informational purposes only; number and dollar amount are included in line 7.
(B) State and Local Government Number and dollar amount of receivables owed to Government by state governments, local governments, public colleges, and universities; this line is for informational purposes only; the number and dollar amount are included in line 7.
8. Rescheduled Debt Rescheduled debt for which new or modified payment terms have been agreed to.
(A) Delinquent  
(B) Non-Delinquent  
9. Interest & Late Charges Dollar amount of interest or late charges associated with the total outstanding receivables due from public at the end of the reporting period.
Section B
Delinquent Debt by Age
 
1. Total Delinquencies
(A) 1-90 Days
(B) 91-180 Days
(C) 181-365 Days
(D) 1-2 Years
(E) 2-6 Years
(F) 6-10 Years
(G) Over 10 Years
Number and dollar amount of receivables reported on line 7, Outstanding Receivables, Ending Balance in Part I, Section A that are delinquent at end of quarterly reporting period; debts with portions in different aging categories, such as may occur when a debtor becomes delinquent on multiple installment payments, should be reported in most delinquent (oldest) category; total dollar amount equals sum of lines A through G of this section; total dollar amount also equals sum of lines 2 and 3 of this section; lines A through G show dollar amounts of receivables that are delinquent for the respective time periods: 1-90 days, 91-180 days, 181-365 days, 1-2 years, 2-6 years, 6-10 years, and over 10 years.
2. Commercial Number and dollar amount of delinquent commercial accounts.
3. Consumer Number and dollar amount of delinquent consumer accounts.
4. Foreign/Sovereign Debt Number and dollar amount of debt owed to the Government by sovereign nations; debts owed by foreign corporations or foreign individuals are not included as they are considered non-government, domestic debts.
Part II: Debt Management Tool and Technique Performance Data  
Section A: Delinquent Debt 180 Days or Less  
1. Total Delinquencies (1-180 days) Cumulative dollar amount of delinquent debt outstanding 180 days or less as of the end of the quarterly reporting period.
(A) In Bankruptcy Number and dollar amount of delinquent collateralized or uncollateralized debt in bankruptcy.
(B) In Forbearance or In Formal Appeals Process Number and dollar amount of delinquent debt in a formal appeals process or forbearance program; results of the appeal affect whether a debt is considered valid and legally enforceable and/or the dollar amount is collected; debts in a formal appeals program represent debts that are still in negotiation.
(C) In Foreclosure Number and dollar amount of delinquent debt, which is in foreclosure; to be "in foreclosure", a notice of default must be filed.
(D) At Private Collection Agencies Number and dollar amount of delinquent debt outstanding at private collection agencies.
(E) In Litigation Number and dollar amount of delinquent debt outstanding that is in litigation either at the Department of Justice or at agencies with the statutory authority to litigate.
(F) Eligible for Internal Offset Number and dollar amount of delinquent debts that will be collected by internal agency offset; internal offset occurs when an agency collects a delinquent debt by offsetting payments made or due to the delinquent debtor by that agency.
(G) In Wage Garnishment Number and dollar amount of delinquent debt for which the agency is pursuing administrative wage garnishment; garnishment actions being pursued by the Department of Justice or Debt Management Services are not included; these actions are reported as in litigation on line E of this section.
(H) At Treasury for Cross-Servicing Number and dollar amount of debt outstanding at Treasury for cross-servicing.
(I) At Treasury for Offset Number and dollar amount of debt outstanding at Treasury for offset; the Treasury Offset Program combines administrative and salary offsets; amount includes delinquent accounts referred for Tax Refund Offset.
(J) At Agency Number and dollar amount of delinquent debt being worked at the agency; debt being worked at the agency includes, but is not limited to, in counsel, Federal salary offset initiated by the agency, or pending referral to the Department of Justice for litigation.
(K) Other - must footnote Number and dollar amount of delinquent debts outstanding that is being worked by management tools or techniques not represented in lines 1A through 1J of this section; other tools and techniques include, but are not limited to, debts at third parties, such as a guaranty agency or financial institution, and debts at a designated debt collection center; all amounts reported on this line are to be footnoted to identify the tool or technique being used.
Section B: Debt Eligible for Referral to Treasury for Offset and Cross-Servicing  
1. Debt Eligible for Referral to Treasury for Offset Delinquent debt over 180 days but not over 10 years that is eligible for referral to Department of Treasury for offset.
(A) Delinquent Debt Over 180 Days to 10 Years Dollar amount of debt that is over 180 days delinquent but not over 10 years delinquent.
(B) In Bankruptcy (-) Number and dollar amount of delinquent collateralized or uncollateralized debt in bankruptcy; enter number and dollar amounts with a minus (-) sign before the figures.
(C) Foreign/Sovereign Debt (-) Number and dollar amount of delinquent debt owed to the Government by sovereign nations; do not include delinquent debts owed by foreign corporations or foreign individuals; those debts are considered to be non-government, domestic debt; enter number and dollar amounts with a minus (-) sign before the figures.
(D) In Forbearance or Formal Appeals Process (-) Number and dollar amount of the debt that is deferred because of a formal forbearance program or appeals process; debts that are subject to forbearance or that are under appeal generally are not legally enforceable; the results of an appeal determine whether a debt is considered valid and legally enforceable and/or the dollar amount to be collected; enter number and dollar amounts with a minus (-) sign before the figures.
(E) In Foreclosure (-) Number and dollar amount of delinquent collateralized debt in foreclosure; to be "in foreclosure" a notice of default must have been filed; enter number and dollar amounts with a minus (-) sign before the figures.
(F) Other - must footnote (+ or -) Number and dollar amount of delinquent debt that is exempt from, or adjusted to, referral to Treasury for reasons other than those listed in lines A through E above; amounts entered on this line must be footnoted with the reason for exempting or adjusting the debt referral; number and dollar amounts may be positive or negative; enter negative amounts with a minus (-) sign before the figures.
(G) Debt Eligible for Referral to Treasury for Offset This line is system generated; number and dollar amount of delinquent debt over 180 days but not over 10 years that is eligible for referral to Treasury for Offset; dollar amount of this line equals the sum of lines 1A through 1F.
Debt Eligible for Referral to Treasury for Offset  
2. Debt Eligible for Referral to Treasury or a Designated Debt Collection Center for Cross-Servicing Delinquent debt over 180 days but not over 10 years that is eligible for referral to Department of Treasury or a designated debt collection center for cross-servicing.
(A) Debt Eligible for Referral to Treasury for Offset Dollar amount of delinquent debt over 180 days that is eligible for referral to Treasury for offset.
(B) At PCAs (-) Number and dollar amount of delinquent debt outstanding at private collection agencies.
(C) In Litigation (-) Number and dollar amount of delinquent debt outstanding that is in litigation either at the Department of Justice or at agencies with the statutory authority to litigate; do not include amounts referred to Justice for concurrence in compromise, suspension or termination action; these debts are not to be reported because they are not being pursued; enter number and dollar amounts with a minus (-) sign before the figures.
(D) Eligible for Internal Offset (-) The agency is enforcing collection of the debt through an internal offset; delinquent debts are eligible for internal offset, if such offset is sufficient to collect the claim within 3 years after the date the debt or claim is first delinquent; enter number and dollar amounts with a minus (-) sign before the figures.
(E) Other - must footnote (+ or -) Number and dollar amount of delinquent debt that is exempt from, or adjusted to, referral to Treasury for reasons other than those listed in lines 2B through 2D; delinquent debts that are over 10 years old and are not exempt from referral for cross-servicing are included; other exempt categories include, but are not limited to, debts at third parties’ such as a guaranty agency or financial institution which is servicing the delinquency on behalf of the agency, debts at a designated debt collection center, debts scheduled for sale, debts in a non-judicial garnishment of private sector wages process, or debts referred to Treasury but returned to the agency; amounts entered on this line must be footnoted with the reason for exempting or adjusting the debt referral; number and dollar amounts may be positive or negative; enter negative amounts with a minus (-) sign before the figures.
(F) Debt Eligible for Referral to Treasury or a Designated Debt Collection Center for Cross-Servicing Number and dollar amount of delinquent debt over 180 days that is eligible for referral to Treasury or a Designated Debt Collection Center for cross-servicing; this line equals the sum of lines 2A through 2E of this section.
Section C: Collections  
1. Collections on Delinquent Debt Dollar amount of collections on delinquent debts; collections of delinquent debt that were written off and subsequently restored during the fiscal year are included; non-cash collections, for example, personal property or services rendered are to be footnoted; the dollar amount for this line equals the sum of lines 1A through 1J of this section.
(A) By Private Collection Agencies Number and dollar amount of delinquent debt collected by private sector collection agencies under contract with the agency or Treasury; collections realized by other services, for example, a designated debt collection center are not included.
(B) By Litigation Number and dollar amount of delinquent debt collected by the Department of Justice through litigation or by agencies with the statutory authority to litigate.
(C) By Internal Offset Number and dollar amount of delinquent debt collected through an internal offset; an internal offset occurs when an agency collects by offsetting payments made or due to the delinquent debtor by another program within that agency.
(D) By Third Party Number or dollar amount of delinquent debt collected by a third party other than the Department of Justice or private collection agency, such as a guaranty agency.
(E) By Asset Sales Number and dollar amount of proceeds realized from the sale of a delinquent loan or debt asset.
(F) By Wage Garnishment Number and dollar amount of collections received as the result of non-judicial (administrative) garnishment of private sector wages; federal employee salary offset is not included; federal employee salary offsets are collected through the Treasury Offset Program.
(G) By Treasury or a Designated Debt Collection Center Cross Servicing Number and dollar amount of delinquent debt collected by Treasury through its cross-servicing program.
(H) By Treasury Offset Number and dollar amount of delinquent debt collections realized by Treasury or by a non-Treasury disbursing officer through the offset of a Federal payment; federal payments of benefits, tax refunds, salary, or vendors are subject to offset.
(I) By Agency Number and dollar amount of delinquent debt worked and collected at the agency.
(J) Other - must footnote Number and dollar amount of delinquent debt collected by management tools or techniques not represented in lines 1A through 1I; all amounts reported on this line are to be footnoted to identify the collection method used.
Section D: Debt Disposition  
1. Written Off and Not Closed Out currently unavailable
(A) At Private Collection Agencies currently unavailable
(B) At Treasury or a Designated Debt Collection Center for Cross Servicing currently unavailable
(C) At Treasury for Offset currently unavailable
(D) Other - must footnote currently unavailable
2. Reported to IRS on Form 1099-C currently unavailable
Part III: Footnotes  

Note: Dollar amounts are not currently provided by Oracle U.S. Federal Financials for these:

Note: Receivables adjustments are populated from system provided values in the Adjustments Descriptive Flexfield.

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.

Note: 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