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.
Receipt origin information must be assigned for the cash receipt.
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 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 ”.
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:
Past Due Criteria (if applicable) - If the column has a value, only data meeting the criteria will be reported.
Transaction Invoice Status - Only includes receivables with the specified Invoice Status(es) on the FV Invoice Status window.
Adjustment Status - Only includes receivables adjustments with the specified Adjustment Status (DFF value) assigned on the Adjustment window detail section of the Receivable Transaction window.
Receipt Oorigin- Only includes receipts activity with the specified Receipt Origin assigned on the FV Cash Receipts form.
Customer Category- Only includes receivables activity with the specified Customer Category assigned on the Customer Page Profile Tab.
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.
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.
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