The receivables management reports provide information about finance charges assessed on overdue invoices and related debt collection activities.
The receivables management reports include:
Assign Finance Charges Report; provides information on customers and invoices assigned finance charges
Accrue Finance Charge Detail Report; provides information on debit memos and adjustment amounts for debit memos generated during the Accrue Finance Charges process
Receivables Activity Worksheet; provides information on an agency's receivables by entity code and receivable type. Receivable types include direct loans, defaulted guaranteed loans, and administrative receivables.
Identification of Federal Employees Report; provides information on federal employees indebted to the U.S. Government
Delinquent Invoices Eligible for Referral Report; provides information on all past due invoices that meet the criteria for being referred to Financial Management Service (FMS)
The output of this report assists in assigning a status of Debt Eligible for Referral to Treasury for Offset or Debt Eligible for Cross Servicing in the Invoice Status window.
Invoice Status Report; provides information on the date and nature of invoice status values that were added or changed for past due invoices
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:
1099-C Electronic Filing process; enables agencies to submit 250 or more 1099-C Cancellation of Debt reports to the IRS
1099-C Cancellation of Debt process; enables agencies to generate a paper copy of the 1099-C Cancellation of Debt report
1096 Annual Summary and Transmittal of U.S. Information Returns process; enables agencies to generate a paper copy of the 1096 Annual Summary and Transmittal of U.S. Information Returns report
The Delinquent Invoice Referral process lets you perform these tasks:
Select past due invoices identified for referral to Treasury in the Invoices Eligible for Referral Report
Update invoice status to Referral in the Invoice Status window
Format an electronic file containing the selected invoices to be submitted to Debt Management Services
Produce the Delinquent Invoice Referral report
The Delinquent Invoice Referral report lists invoices that are selected for referral to FMS.
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).
Receivables setup steps, including setting up Customer Classes, Customer Categories, Customer Types, Receivables Activities, and Federal Receivable Types, must be performed to run the Receivables Activity Worksheet and the Identification of Federal Employees Report.
Agency name and address must be entered in the Define Federal Options window.
Organization information must be defined in Receivables.
Customer information must be entered in Receivables.
Invoice information must be entered in Receivables.
Adjustment Status must be entered for all adjustment transactions.
Federal System Parameters must be defined.
Agency identifier and program codes must be defined to generate the Delinquent Invoice Referral process.
Receivable types must be defined to generate the Delinquent Invoice Referral process.
Invoices and the appropriate invoice statuses must be entered in the Invoice Status window to generate the Delinquent Invoice Referral process.
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
The Assign Finance Charges Report is generated automatically during the Assign Finance Charges procedure.
The following table describes the Assign Finance Charges report.
| 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 |
The Accrue Finance Charges Detail Report is generated automatically during the Accrue Finance Charges procedure.
The following table describes the Accrue Finance Charges Detail report.
| 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 |
To print the Receivables Activity Worksheet:
Navigate to the Submit Request window.
In the Name field, select Receivables Activity Worksheet.
In the Ledger field, select the ledger.
In the Reporting Entity Code field, enter a reporting entity code.
In the Fiscal Year field, select a fiscal year.
In the Quarter field, optionally select a quarter.
In the Reported By field, select the date option required.
In the Type of Receivable field, select a receivable type to be reported.
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.
In the Receivables Write Offs Activity 2 field, optionally select a receivables activity for write-offs.
In the Receivables Write Offs Activity 3 field, optionally select a receivables activity for write-offs.
In the Non-Federal Customer Class field, select a non-federal customer class.
In the Footnotes field, enter footnote text.
In the Name of Preparer field, enter the name of the person preparing the report.
In the Preparer's Phone field, enter a phone number.
In the Preparer's Fax Number field, enter a fax number.
In the Preparer's E-MAIL field, enter an e-mail address.
In the Supervisors's Name field, enter the supervisor's name.
In the Supervisor's Phone field, enter a phone number.
In the Supervisor's E-Mail field, enter an e-mail address.
In the Address Line 1 field, enter the agency street address.
In the Address Line 2 field, optionally enter the agency street address.
In the Address Line 3 field, optionally enter the agency street address.
In the City field, enter the agency city.
In the State field, enter the agency state.
In the Postal Code field, enter the agency postal code.
The following table describes the Receivables Activity worksheet.
| 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:
Lines 8 and 9, Rescheduled Debt and Interest & Late Charges, in Section A of Part I
Section B for Part II
Section D of Part II
Note: Receivables adjustments are populated from system provided values in the Adjustments Descriptive Flexfield.
To print the Identification of Federal Employees Report:
Navigate to the Submit Request window.
In the Name field, select Identify Federal Employees.
In the Operating Unit field, select an operating unit.
In the Customer Category field, select a category.
In the Customer Class field, select a class.
In the Customer Type field, select Internal or External.
The following table describes the Identification of Federal Employees report.
| 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 |
To run the 1099-C Electronic Filing procedure for an organization:
Navigate to the Submit Request window and select Single Request.
In the Name field, select 1099-C Electronic Filing.
In the Operating field, select an operating unit.
In the Tax Year field, enter the tax year using a two digit format.
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.
In the Media field, enter the two character magnetic tape or tape cartridge type.
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:
A - Creditor Records identify the creditor and transmitter of the magnetic media file and provide parameters for Debtor (type B) Records
B - Debtor Records contains debt information such as debtor ID, amount, and description
C - End of Creditor Records contain the total number of debts cancelled and the total amount of debt cancelled for each creditor
F - End of Transmission Record written after the last C record contain the total number of type A records
The following tables describe the 1099-C Electronic Filing format.
The following table describes the 1099-C Electronic Filing format, 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.
| 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.
| 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.
| 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. |
To print the 1099-C Cancellation of Debt for an organization:
Navigate to the Submit Request window.
In the Name field, select 1099-C Preprinted Form Report Procedure.
In the Operating Unit field, select an operating unit.
In the Ledger field, select a ledger.
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.
In the Reprint field, select either Yes or No.
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.
| 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. |
The following table describes the 1099-C Cancellation of Debt report.
| 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. |
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.
Navigate to the Submit Request window.
In the Name field, select 1096 Annual Summary and Transmittal of U.S. Information Returns.
In the Operating Unit field, select an operating unit.
In the Ledger field, select a ledger.
In the Name of Contact Person field, enter a contact name.
In the Phone of Contact Person field, enter a phone number.
In the Federal Income Tax Withheld field, enter the amount of federal income tax withheld.
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.
The following table describes the 1096 Annual Summary and Transmittal of U.S. Information Returns report.
| 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. |
To print the Delinquent Invoices Eligible for Referral Report:
Navigate to the Submit Request window.
In the Name field, select Delinquent Invoices Eligible for Referral Report.
In the Operating Unit field, select an operating unit.
In the As of Date field, optionally select a target date.
In the Customer Name Low and High fields, optionally select a customer name to begin the report generation.
In the Customer Number Low and High fields, optionally enter a customer number to begin the report generation.
In the Receivables Type field, optionally enter a receivables type.
The following table describes the Delinquent Invoices Eligible for Referral report.
| 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. |
To print the Invoice Status Report:
Navigate to the Submit Request window.
In the Name field, select Invoice Status Report.
In the Operating Unit field, select an operating unit.
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.
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.
In the Receivable Type field, select a Receivable Type.
In the Customer Name Low field, select a customer name to begin the report generation.
In the Customer Name High field, select a customer name to end the report generation.
In the Customer Number Low field, enter a customer number to begin the report generation.
In the Customer Number High field, enter a customer number to end the report generation.
In the Current/History field, select Current or History.
In the Invoice Status field, select an invoice status.
The following table describes the Invoice Status report.
| 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. |
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.
Navigate to the Submit Request window.
In the Name field, select Delinquent Invoice Referral Process.
In the Operating Unit field, select an operating unit.
In the Customer Name Low and High fields, optionally select a customer name to begin and end the report generation.
In the Customer Number Low and High fields, optionally enter a customer number to begin and end the report generation.
In the Referral Through Date field, optionally enter the referral through date to end the report generation.
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.
The following table describes the Delinquent Invoice Referral report.
| 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