3.17.221 Enterprise Computing Center Data Controls 3.17.221.1 Program Scope and Objectives 3.17.221.1.1 Background 3.17.221.1.2 Responsibilities 3.17.221.1.3 Related Resources 3.17.221.2 ECC Data Controls Run Numbers and Reports 3.17.221.2.1 Processing Validation Section (PVS) System Sources and Tool Kit 3.17.221.3 Administrative Rules 3.17.221.3.1 Federal Government Accounting Requirements 3.17.221.3.2 Security 3.17.221.4 Functional Responsibilities 3.17.221.4.1 Enterprise Computing Center (ECC) 3.17.221.4.2 IBM/Service Center Input Processing Automation System (SCIPAS) Scheduling 3.17.221.4.3 IBM Computer System Analyst (CSA) Section 3.17.221.4.4 Processing Validation Section (PVS) 3.17.221.4.5 Submission Processing Campus 3.17.221.5 Receipt of Submission Processing Campus Data Release 3.17.221.5.1 Tape Edit Processing (TEP) Controls 3.17.221.5.2 Receipt of Non-TEP Releases 3.17.221.6 Daily and Weekly Cycle Balancing 3.17.221.6.1 ECC Input Runs (Joint Processing Data (JPD) and Master File Sections) 3.17.221.6.2 Media Reel Replacement (Scheduling) 3.17.221.6.3 Input, Sort, and Merge Processing 3.17.221.6.4 Input Balancing 3.17.221.6.5 Sort Balancing 3.17.221.6.6 Merge Balancing 3.17.221.6.7 Error Resolution 3.17.221.7 ECC Control Adjustments 3.17.221.7.1 Data Adjustment Voucher 3.17.221.7.2 Error and Reject Adjustment 3.17.221.7.3 Data Adjustment Voucher (DAV) Numbering System 3.17.221.8 Maintenance of Reciprocal Accounting Control Record (RACR) 3.17.221.8.1 Explanation of RACR 3.17.221.8.2 RACR Procedures 3.17.221.8.2.1 RACR Ending Balance 3.17.221.9 Reconciliation of Master File Balance 3.17.221.9.1 General 3.17.221.9.2 Manual Creation of Master File IMF REC 3.17.221.9.3 Form 5198A, Reconciliation of Master File Balance (REC) and Reciprocal Accounting Control Record (RACR) Validation 3.17.221.10 Refund Validation and Certification 3.17.221.10.1 General 3.17.221.10.1.1 PVS Validation Responsibilities - IMF 3.17.221.10.1.2 PVS Validation Responsibilities - BMF 3.17.221.10.1.3 Refund Schedules 3.17.221.10.1.4 Avoidance of Late Transfers 3.17.221.10.2 Regular, Electronic Funds Transfer (EFT), and Accelerated Refunds 3.17.221.10.2.1 On-line Voucher Preparation 3.17.221.10.3 Error File Refunds 3.17.221.10.4 Notification of Refund Data 3.17.221.10.5 Dropped File 3.17.221.10.6 Authorization of Certifying Officers, and Other Secure Payment System (SPS) Personnel 3.17.221.10.7 Trusted Registration Agent (TRA) Instructions 3.17.221.11 Revenue Receipts 3.17.221.11.1 General Information 3.17.221.11.2 Balancing Revenue Receipts 3.17.221.11.3 Problem Reporting 3.17.221.11.4 Revenue Receipt Adjustments 3.17.221.12 General Ledger Reconciliation With Form 6168 3.17.221.12.1 Verification Procedures 3.17.221.12.2 Reporting Requirements 3.17.221.13 Deletion Operations 3.17.221.13.1 General 3.17.221.13.2 Generalized Mainline Framework (GMF) Deletions 3.17.221.13.3 Resequence File Deletions 3.17.221.14 Release and Certification of Magnetic Tape Files 3.17.221.14.1 General 3.17.221.14.2 Releasing Procedures 3.17.221.15 Tax Return Database (TRDB) 3.17.221.15.1 TRDB Processing 3.17.221.15.2 Daily Processing Exhibit 3.17.221-1 SC Trans Release Summary (Other) GMF1545 Exhibit 3.17.221-2 SC Trans Release Summary (ELF Total Summary) GMF1545 Exhibit 3.17.221-3 SC Revenue Receipts Control Sheet SCF1340 Exhibit 3.17.221-4 Revenue Receipts Control Sheet Nullified Unpostables GUF5342 Exhibit 3.17.221-5 Form F9607-A, Controls Register (IMF) Exhibit 3.17.221-6 Form F9607, Controls Register (BMF) Exhibit 3.17.221-7 Run 460-02 Total Output Transactions Control Exhibit 3.17.221-8 Form M4496, Data Adjustment Voucher Exhibit 3.17.221-9 Revenue Receipt Report Exhibit 3.17.221-10 Document Locator Number Format Exhibit 3.17.221-11 ECC Trans Release File Acceptance Voucher Summaries (793-01) Exhibit 3.17.221-12 Run 02 Primary SC Revenue Receipt Controls Exhibit 3.17.221-13 Run 02 Reclassified SC Revenue Receipt Controls Exhibit 3.17.221-14 Run 02 Nullified SC Revenue Receipt Controls Exhibit 3.17.221-15 Accounting and Operating Report Exhibit 3.17.221-16 PVS BMF Revenue Receipts Report Exhibit 3.17.221-17 Reciprocal Accounting Control Record Exhibit 3.17.221-18 Reconciliation of Master File Balance, Computer Form 5198A Exhibit 3.17.221-19 Reconciliation of Master File Balance, Form 5198A Exhibit 3.17.221-20 Run 63 Resequence Controls Exhibit 3.17.221-21 Run 43 Recap of Assessments, Abatements, and Other Post-Journalized Transactions Exhibit 3.17.221-22 Run 15 Controls Exhibit 3.17.221-23 General Ledger Reconciliation with ECC RACR, Form 6168 Exhibit 3.17.221-24 Secure Payment System Schedule Exhibit 3.17.221-25 Form 9633, File Search Request Exhibit 3.17.221-26 BPW and IPW Refund Report Exhibit 3.17.221-27 ECC Trans Release File Acceptance Voucher Summaries Exhibit 3.17.221-28 EFTPS Revenue Receipts Control Sheet Exhibit 3.17.221-29 EFTPS Revenue Receipts Control Sheet Exhibit 3.17.221-30 Designation for Certifying Officer Form Exhibit 3.17.221-31 PKI Certificate Action Request Exhibit 3.17.221-32 PKI Certificate Action Request Exhibit 3.17.221-33 Delegation of Authority Form Exhibit 3.17.221-34 Designation for SPS Data Entry Operator Form Exhibit 3.17.221-35 ECC TRANS RELEASE ACCEPTANCE VOUCHER SUMMARIES (793–04) Exhibit 3.17.221-36 GRAND TOTAL SUMMARY Exhibit 3.17.221-37 IMF MAINLINE SUMMARY Part 3. Submission Processing Chapter 17. Accounting and Data Control Section 221. Enterprise Computing Center Data Controls 3.17.221 Enterprise Computing Center Data Controls Manual Transmittal December 08, 2023 Purpose (1) This transmits revised IRM 3.17.221, Accounting and Data Control - Enterprise Computing Center Data Controls. Material Changes (1) IRM 3.17.221.2(10) Updated reports used by ECC Processing Validation Section (PVS), report list. IPU 23U0109 issued 01-17-2023. (2) Updated hyperlinks and other editorial changes as needed. Effect on Other Documents IRM 3.17.221, Accounting and Data Control, dated November 2, 2017 (effective January 1, 2018) is superseded. The following IRM Procedural Update (IPU) is incorporated: IPU 23U0109 issued January 17, 2023. Audience This IRM provides instructions for use by the Enterprise Computing Center (ECC) Data Controls function. Effective Date (01-01-2024) James L. Fish Director, Submission Processing Wage and Investment Division 3.17.221.1 (04-07-2017) Program Scope and Objectives Purpose: These instructions are provided for use by the Enterprise Computing Center (ECC) Unisys and IBM Master File in the Operations Services, Scheduling and Validation Branch (OSSVB) for the purpose of balancing, reconciliation, and control of accounting data. Note: IRM deviations must be submitted in writing following instructions from IRM 1.11.2.2, Internal Management Documents System - Internal Revenue Manual (IRM) Process, IRM Standards, and elevated through appropriate channels for executive approval. Audience: ECC Unisys and IBM Master File in the Operations Services, Scheduling and Validation Branch. Policy Owner: The Director of Enterprise Computing Center. Program Owner: Enterprise Automated Deployment, Systems Control Point Section. 3.17.221.1.1 (04-07-2017) Background This IRM includes instructions for: Balancing of ECC weekly Master File processing Balancing of ECC daily and weekly and Individual Master File (IMF) processing Balancing of files received from the Submission Processing Campuses, Bureau of Fiscal Services, Regional Financial Centers and internal processing Preparing and balancing the Reciprocal Accounting Control Report (RACR) if manual intervention is necessary Reconciliation of the Master File - prepare Data Adjustment Vouchers if necessary Balancing of Revenue Receipts received from the Submission Processing Campuses Control of refund data released to Bureau of Fiscal Services (BFS) 3.17.221.1.2 (04-07-2017) Responsibilities Enterprise Computing Center (ECC) control and accountability begins with the acceptance of ECC-Memphis (ECC-MEM) and ECC-Martinsburg (ECC-MTB) Master File data. Such data includes Service Center Control File (SCCF) and Generalized Unpostable Framework (GUF), which are input to the Weekly Submission Processing Campus Reports processing (IMF Weekly receipts and Business Master File (BMF) Weekly Receipts); General Mainline Framework (GMF), End of Day (EOD), and Electronic Federal Tax Payment System (EFTPS), which are input to Joint Processing Data (JPD) processing. (List is not all inclusive.) The initial acceptance of Reports data is acknowledged within 160-02 and 460-02. Acceptance of JPD is acknowledged with Accountability Acceptance Vouchers (AAV) 793-01, 793-02 and 793-04. (The acronym 'AAV' is used to reference any of the following: 793-01, 793-02, and 793-04, MCC SC Trans Release Acceptance Voucher, 793-02, Abridged Acceptance Voucher; 160-02 and 260-02, MCC Automated Balancing Report Abridged Acceptance Voucher.) (See Exhibit 3.17.221-11 and Exhibit 3.17.221-35) In January 2012, IMF generates daily and weekly AAV summaries for the 793-01-11 files. The AAV summaries will reflect data on the input file sent for processing at the Master Files. IMF will generate daily AAVs in the Customer Account Data Engine (CADE) 2 daily processing environment. JPD Router Runs verifies that the data on the media file is acceptable for further ECC Processing. If a service center file is not acceptable, Master File Scheduling at ECC will request a replacement file from the ECC-MEM/ECC-MTB via the Internal Revenue Workflow, Optimization, Requests, and Knowledge System (IRWorks). The JPD Router Run separates the ECC-MEM/ECC-MTB data into the following files: Individual Master File (IMF) Business Master File (BMF) Employee Plans Master File (EPMF) Information Returns Program (IRP) Combined Annual Wage Reporting (CAWR) Each Master file is then processed under separate project programs, IPD (IMF daily processing) - project 460 IPW (IMF weekly processing) - project 460 BPW (BMF weekly processing) - project 160 PPW (EPMF weekly processing) - project 130 and 260 CAWR (BMF weekly processing) - project 402 The Master File Support (MFS) function Computer System Analysts (CSAs) and Resident Programmer Analysts (RPAs) is responsible for ensuring that the totals of records and/or prejournalized debits and credits are balanced inputs to outputs before the initiation of succeeding runs (run-to-run, abends, aborts due to imbalances, programming issues). Also, required balancing of data must be complete and correct before the release of files to the Submission Processing Campuses or Kansas City Financial Center Reconciliation using Data Adjustment Vouchers (DAV) to request adjustments to the reciprocal controls between ECC and the various campuses is the responsibility of the Processing Validation function. MFS will open a IRWorks ticket to document all processing discrepancies. 3.17.221.1.3 (04-07-2017) Related Resources References of Submission Processing Campus procedures are found in the following IRMs: IRM 3.17.30, Accounting and Data Control, SC Data Controls IRM 3.17.63, Redesigned Revenue Accounting Control System IRM 3.17.79, Accounting Refund Transactions IRM 21.4.1, Refund Research IRM 3.17.277, Electronic Payments IRM 3.17.64, Accounting Control General Ledger Policies and Procedures References of Operations Services, Scheduling & Validation Branch procedures are found in the following IRMs: IRM 2.7.6, Systems Scheduling IRM 2.7.9, Enterprise Computing Center - Martinsburg (ECC-MTB) Processing Timeliness 3.17.221.2 (01-17-2023) ECC Data Controls Run Numbers and Reports Output Transaction Controls, data files 793-01-011 IMF Data 793-01-012 BMF Data 793-01-013 EPMF Data 793-01-015 IRP Data 793-01-016 CAWR Data 793-01-017 Drop File (Deletions) 793-01-019 Formatted VSAM Reports 793-02-011 IMF Data Acceptance Vouchers 793-1A, 2A, 4A Acceptance Vouchers 793-01-018 Acceptance Vouchers 793-02-018 Acceptance Vouchers 793-04-018 EFTPS Acceptance Vouchers 160-02-022 Acceptance Vouchers Input Transaction Controls, 02 Run 160-02 BMF Transactions 130-02 EPMF Transactions 460–02 IMF Transactions Input Transactions Sorts 160-03 BMF Transactions 460-03 IMF Transactions 130-08 EPMF Transactions Analysis Run, 12/15 Run 160-15 BMF Analysis - weekly 130-12 EPMF Analysis - weekly 460-15 IMF Analysis - weekly SC Report Records, 35 Run 180-35-013 BMF Receipts Control Sheet 480-35-016 IMF Receipts Control Sheet Submission Processing Campus Recap of Assessments, Abatements, and Other Post Journalized Transactions 160-43-022 BMF Submission Processing Campus Recap (Accounts Register) 260-43-060 PPW Submission Processing Campus Recap (Accounts Register) 460-43-022 IMF Submission Processing Campus Recap (Accounts Register) Monthly US Internal Revenue Receipts 180-40-011 Reports of U.S. Internal Revenue Receipts SC Trans Report (BMF) 480-55-011 IMF Report of U.S. Internal Revenue Receipts Unpostable Controls 460-60-032 IMF Control Data 160-60-032 BMF Control Data 260-60-032 EPMF Control Data Reports used by ECC Processing Validation Section (PVS) BMFRRB - BMF Revenue Receipts report IMFRRB - BMF RACR for cycle 03-52/53 BMFREC - BMF Reconciliation for cycle 03-52/53 BMFREC01 - BMF Conversion Reconciliation for cycle 01 B16002M - BMF 16002 Summary Report for cycles 03-52/53 IMFBALCM - IMFBAL Report IMF02CTM - IMF02SUM Report IRACRCTM - IMF RACR for cycles 04-52/53 IMFREC - IMF Reconciliation for cycles 04-52/53 IMFREC01 - IMF Conversion Reconciliation for cycle 01 RCAUTRFB - Refund Report for BMF RCAUTRFI - Refund Report for IMF PVSREFCB - BMF Refund Counter Report PVSREFCI - IMF Refund Counter Report B18035M - Weekly BMF Accounting and operating Report (B18035 CUM) *Produced by BMF, and not IBM Automation section B18035M - Monthly BMF Accounting and Operating Report (B18035CUM) *Produced by BMF, and not IBM Automation section Note: These reports aid PVS in the balancing and control of the Master File systems. If an imbalance or error occurs, a IRWorks ticket must be opened by the help desk and assigned to section: EOPS-ECC-MOB-ISS; with share assign to OS:CIO:EO:IT:ES:IB. 3.17.221.2.1 (04-07-2017) Processing Validation Section (PVS) System Sources and Tool Kit Automated Data Processing (ADP) Output Controls - Automated balancing routines containing equations to compile data from various locations, including Log Analysis and Reporting System (LARS) controls to summarize an output control for quick reference by PVS; replaces manual compilation of output controls in IBM production. CADE 2 - Scheduled Schematic to Processing Time Frames Mapping - This spreadsheet is saved on the Service operation Command Center (SOCC) SharePoint and lists all critical jobs that are processed daily and weekly. This report shows the IMF run schematic time frame, where we are in processing, and if any tickets are opened on the jobs, etc. PVS uses this tool to show if IMF cycle has good completion, what jobs are still waiting to process, what jobs are bad and any tickets that are open. This information is utilized to identify current status and to determine if any downstream processes are impacted. Each IBM Master File group has access to update their part of the spreadsheet; PVS updates refund certification, turning it green for all good, red to indicate issue resulting in refunds being suspended. C - List - Created under an option in LARS. Contains the audit trail of LARS run-to-run balancing of processing in IBM production environment. Control D - Secured web-based on-line report viewing system. Control D Web can be accessed by using the following link. CONTROL-D/WebAccess Server - LOGIN (irs.gov) Request Type = Login Window DOC IT - Secured web-based application that stores computer operator handbooks and schematics, database is updated by national office programmers. PVS uses this tool to validate that the jobs are being processed timely and in the correct flow, and no files have been left out of the job stream. ENDEVOR - Automated Configuration Management Tool - IBM. Use of the ENDEVOR tool ensures that controlled production libraries contain the official version and level, of all existing IRS IBM application source code. ENDEVOR facilitates easy access to the official level of source code as a starting point for development activity, significantly reduces the effort required to transmit software to production sites after development and testing, and ensures that modified source elements do not move into production libraries until the appropriate time. Intershift Report - Report created by IBM Automation Section and maintained by Master File Scheduling. This report resides on the IBM mainframe. This report provides a synopsis of Master File processing activities. It provides a status of all jobs out on the active job list, what jobs have ran, what conditions the jobs are waiting for to run, and if any IRWorks tickets opened, the number associated with that run. Report is updated at the end of each scheduling shift daily. Processing Notes - Updated and maintained by IBM Scheduling Section based on information and directions provided by the programmers for establishing the daily/weekly processing schedules. This information is located on the ECC website under system support. PVS uses these notes to verify jobs listed in the Production Log (PLOG) on the mainframe were input accurately for that cycle. Information in the processing notes will indicate if there are any ENDEVOR memos for the cycle that may have transmitted a new Job Control Language (JCL) for processing the job; PVS verifies the correct JCL was used based on the memo. Resource Access Control Facility (RACF) / IBM Mainframe - A Software Security Package leased from IBM and is installed on the IBM-compatible Master File computers. 3.17.221.3 (01-01-2010) Administrative Rules This section relates to administrative rules. 3.17.221.3.1 (01-01-2010) Federal Government Accounting Requirements The Budget and Accounting Procedures Act of 1950, and amendments thereto, places the responsibility for establishing and maintaining adequate systems of accounting and internal control upon the head of each executive agency. These systems must conform to the accounting principles, standards, and related requirements prescribed by the Comptroller General of the United States. These are reflected in the "General Accountability Office Policy and Procedures Manual for Guidance of Federal Agencies." Section 113 of that act states that the head of each executive agency shall establish and maintain systems of accounting and internal control to provide: Full disclosure of the financial activities of the agency Adequate financial information needed for management purposes of the agency Effective control over and accountability for all funds, property, and other assets for which the agency is responsible, including appropriate internal audit Reliable accounting results to serve as the basis for preparation and support of budget requests for controlling the execution of its budget, and for providing financial information required by the Office of Management and Budget Suitable integration of the accounting of the agency with the accounting of the Treasury Department in connection with the central accounting and reporting responsibilities imposed by the Secretary of the Treasury The accounting system of an executive agency or any of its component parts is subject to review and approval by the Comptroller General. The continuing efforts to improve, modernize, and simplify accounting systems in the Federal Government are exercised under a "Joint Program" sponsored by the Comptroller General, the Secretary of the Treasury, and the Director of the Bureau of the Budget. This program contemplates the full development of sound accounting within each executive agency, as a working arm of management, and in terms of financial information and control. It envisions an integrated pattern of accounting and financial reporting, for the Government as a whole, that will be responsive to executive and legislative needs. The established accounting and reporting principles, standards, and basic procedures will take into consideration the various areas of responsibility involved, the elimination of overlapping operations and paper work, and the fuller application of efficient methods and techniques in accounting operations throughout the Government. Integration of revenue accounting data with central accounts maintained by the Treasury, Bureau of Fiscal Services is accomplished primarily by the submission of monthly SF 224, Statement of Transactions, reporting deposits, classified collections, and disbursements. 3.17.221.3.2 (01-01-2011) Security Service officials and managers must communicate security standards contained in IRM 10.2.11, Basic Security Concepts, to subordinate employees and establish methods to enforce them. Employees are responsible for taking required precautions in providing security for the documents, information, and property which they handle in performing official duties. Security safeguards, adequate security equipment containers, and facilities must be provided for the safeguarding of all protectable items per procedures in IRM 10.2.11, Basic Security Concepts . 3.17.221.4 (01-01-2012) Functional Responsibilities This section outlines the responsibilities of the Unisys and IBM Master File in the Operations Services, Scheduling and Validation Branch and the Submission Processing Campus. 3.17.221.4.1 (01-01-2012) Enterprise Computing Center (ECC) The Enterprise Computing Center (ECC) is primarily responsible for maintenance of the Master File Record for each taxpayer and for the electronic processing of inputs and outputs related to the Master File records. ECC will maintain accounting and control data for BMF and IMF, records through systemically posted Master File control records. The manual creation of Control Registers is optional (not required) as the count from the Auto Control Records will be the systemic point of validation for run-to-run balancing. There are no Master File processes dependent upon the manual preparation or balancing of the control register. All financial data for Master Files will be maintained in the Redesigned Revenue Accounting Control System (RRACS). RRACS balancing will be performed by the Submission Processing Campuses. Note: Control Registers may be prepared if deemed necessary by Information Technology EOPS PVS management in support of unique processing periods such as start up or special circumstances such as conversion or transition processing. ECC will maintain a Reciprocal Accounting Control Records (RACR) for each Submission Processing Campus. An IMF RACR will be created daily as well as weekly in the CADE 2 environment. (See Exhibit 3.17.221-17) During Master File posting operations at ECC, various files of accounting transactions, adjustments, refund data, and abstracts of revenue receipts will be generated. These output files are transmitted to the appropriate Submission Processing Campuses for printing and for post-journalization through RRACS. PVS will electronically certify refund schedules, for IMF and BMF, for each Submission Processing Campus. The schedules cover the total count and amount of overpayment, principal, and interest for IMF and BMF refund data. An Authorized Certifying Officer of ECC will certify each voucher for the account of the applicable Submission Processing Campus Director. The electronically certified vouchers and the refund media will be transmitted to the Kansas City Financial Center for issuance of the refund checks and direct deposit. (See IRM 3.17.79.6.4, Bureau of Fiscal Services Secure Payment System) 3.17.221.4.2 (01-01-2012) IBM/Service Center Input Processing Automation System (SCIPAS) Scheduling IBM Service Center Input Processing Automation System (SCIPAS) Scheduling is responsible for the following: Building schedule for IBM Master File processing Compiling processing notes using COHs, transmittal notes when changes are made, and e-mail from programmers, and post to the shared drive Build reject files based on transmittals received from program areas Resolving flags issued by SCIPAS Release refund files for transmission to BFS 3.17.221.4.3 (01-01-2012) IBM Computer System Analyst (CSA) Section The IBM CSA Section is responsible for the following: Monitoring IBM Master File processing using COHs, programming notes Resolving LARS Out of Balances (LOOBs) - coordination with IBM Scheduling and programmers Resolving abends and aborts – coordination with programmers Initiating and updating IRWorks Referring unresolved issues to RPAs and programmers Validating RECAP/REC are in balance (Initiate actions to research and resolve any out of balances as they occur) Communicating release of refund files to IBM Scheduling 3.17.221.4.4 (01-01-2016) Processing Validation Section (PVS) The Processing Validation Section (PVS) coordinates with Submission Processing Campuses regarding reciprocal Master File accounts and balances, advises on adjustments, balances and certifies refunds, applies control systems to assess the validity and propriety of operational processes and to detect data or systemic irregularities, initiates investigative and diagnostic action to resolve problems, reports on accountability impact and maintains audit trails when it is necessary to manually create the audit trail, coordinates analysis of error-file data, provides adjustments (DAV's) to the Submission Processing Campuses and validates quantitative and monetary controls for all Master File production processing when manual processes are required. PVS is responsible for the following: Refund validation and certification (Interface – IBM Master File and BFS) Priority Data Adjustment Voucher (DAV) preparation and distribution (IBM Master File and Submission Processing Campus Accounting) Documentation of all activities in the remarks section of the Reconciliation to explain out of balances and actions taken to resolve Validation of all Master File output (Interface – IBM Scheduling, CSA Staff, Programmers) Note: “v” to validate jobs – looking for indication of an unresolved error on the control list (out of balance indicated to the right of each job) Validate daily Revenue Receipt output controls (Interface - IBM Master File and Submission Processing Campus Accounting and Unisys Mainline) Verification of RACR summary report submitted by Submission Processing Campus Accounting Supporting Tasks Review and analysis of CLIST Validation of errors within Master File output controls Confirmation all out of balance Joblog Validation listings are resolved and require no further action by PVS. PVS is responsible for monitoring any out-of-balance datasets. Bring up the daily listing of Joblog Validation at Control D If LOOB exists in the listing, check for a IRWorks Ticket If LOOB is detected, verify the COH and schematic If LOOB notate IRWorks ticket number Contact Lead and Manager for their approval. Lead should check the validation list to see if JRF is present. When completed, the lead will check off the lead portion of the validation listing. 3.17.221.4.5 (01-01-2012) Submission Processing Campus Each Submission Processing Campus is a separate accounting station and is assigned an identifying numerical "Agency Location Code." The Submission Processing Campus Director is accountable for revenue receipts and repayments deposited for application to BMF and IMF accounts, and disbursements made from these accounts. Each Submission Processing Campus will: Maintain a general ledger and such subsidiary records as are required herein. Reconcile the general ledger accounts and subsidiary records or files daily, weekly, and monthly (RRACS) Control all accounting documents within the Submission Processing Campus area for entry to the BMF and IMF accounts, and for journalizing and posting to the General Ledger Receive or initiate, control, and process all BMF and IMF accounting transactions involving other Submission Processing campuses Receive and control BMF and IMF accounting outputs, and accomplish required journalization and general ledger postings Reconcile the RACR from ECC to the Submission Processing Campus general ledger 3.17.221.5 (01-01-2012) Receipt of Submission Processing Campus Data Release This section outlines procedures for receipt of Submission Processing Campus Data release. 3.17.221.5.1 (01-01-2012) Tape Edit Processing (TEP) Controls IBM Mainframe (SCIPAS) receives the Tape Edit Processing (TEP) Controls from ECC Unisys once the Submission Processing Campus releases the TEP for transmission via Sterling Commerce Connect: Direct MVS, referred to as Network Data Mover (NDM). GMF1545, SC Trans Release Summaries. Other Total Summary (See Exhibit 3.17.221-1) Grand Total Summary (See Exhibit 3.17.221-36) Summaries for each file containing data (See Exhibit 3.17.221-37) GMF2545 ELF SC Trans Release Summaries SCF1340, Revenue Receipts Control Sheets (RRCS), daily and weekly. (See Exhibit 3.17.221-3) GUF5342, Revenue Receipt Control Sheets—Nullified Unpostables, weekly (Tuesday) (See Exhibit 3.17.221-4) EFT1545, EFTPS Daily Trans Release Summary (OSPC only) Other EFTPS reports may be received online. CMS22 - Weekly Trans Release Summary CMS23 - Daily Revenue Receipts Control Sheet (See Exhibit 3.17.221-28 and Exhibit 3.17.221-29) CMS23 - Weekly Revenue Receipts Control Sheet (See Exhibit 3.17.221-28 and Exhibit 3.17.221-29) Note: The EFTPS Daily Trans Release Summary and Revenue Receipts Control Sheet provide cumulative data should more than one TEP be run for the same date. Reports for the final TEP must be balanced to the sum of the TEP records received for the date. Tape file GMF1545MCCPR with print capability is retained by the Submission Processing Campus for 30 days and printed upon request or when needed to resolve discrepancies. The print tape is no longer sent to ECC. All data and control files (i.e., GUF, SCF1340, GMF, EOD, EFTPS, etc.) transmitted via Connect:Direct and magnetic media transmitted daily for the current cycle should be received at ECC no later than 5:00 PM Eastern time each workday. If SCIPAS does not receive a file per the defined schedule, SCIPAS will contact Unisys. Unisys will contact the Submission Processing Campus if data is not received within its expected arrival time. Data received early should be controlled and held for processing in the correct cycle. The Submission Processing Campus should be notified if data for the next cycle (day) was processed early by mistake or if data is regularly received early from the same center, indicating that the center is closing the cycle too early. Following the end of the fiscal year, Submission Processing Campuses will include additional controls called 13th Month Supplementals with the regular TEP controls. The 13th Month Supplementals are run the first two Submission Processing Campus cycles in October. These controls will include daily and weekly mainline RRCS and weekly unpostable processing. When transmitted the supplementals will be identified by an "s" in the first position of the two digit workgroup. The control dates will be those of the previous fiscal year. The 13th Month Supplemental allows revenue received, but not processed by the end of the fiscal year, to be accumulated for the appropriate year for reports purposes. Unisys will verify receipt of all TEP controls. If necessary, contact the Submission Processing Campus to retransmit the controls file if the initial transmission is bad. A retransmission controls file can be rerun after the initial transmission is uncataloged. 3.17.221.5.2 (01-01-2012) Receipt of Non-TEP Releases Every media shipment received by ECC - Unisys should contain summary count and amount information, even for transactions that are not processed by the TEP. A list of Non-TEP transaction media shipped by the Submission Processing Campus to ECC can be found in IRM 3.30.123, Processing Timeliness: Cycles, Criteria, and Critical Dates. These media controls will be used for balancing purposes by the Processing Validation Section, when manual balancing is necessary and directed by management. 3.17.221.6 (01-01-2012) Daily and Weekly Cycle Balancing This section provides a description of the weekly cycle and IMF daily and weekly balancing. 3.17.221.6.1 (01-01-2012) ECC Input Runs (Joint Processing Data (JPD) and Master File Sections) The JPD Router Runs perform the initial processing and acceptance of Submission Processing Campus data by ECC. Each program sorts Submission Processing Campus data creating separate media files. GMF data is processed in JPD run 793-01. Processing of EFTPS data is done in JPD run 793-04. Deletions can be processed in both the 793-01 and 793-04 runs. IMF EOD data and EFT1601 for IMF are processed in JPD run 793-02. BMF and EPMF EOD data bypass the router runs and are processed directly to run 160-02. The JPD and 02 run programs balance input to output control records. A Trans Release Acceptance Voucher (AAV) is generated when the JPD has successfully processed. (The acronym "AAV" is used interchangeably to reference any of the following: 793-01, MCC SC Trans Release Acceptance Voucher; 793-04, MCC Trans Release File Acceptance Voucher; 793-02, Abridged Acceptance Voucher; and 160-02, MCC Automated Balancing Report Abridged Acceptance Voucher.) A generated AAV is indicative of correct data; no further balancing of the input data is required by PVS. An AAV will not generate if an out of balance condition occurs. When the AAV fails to generate, a Priority 1 work stoppage ticket will be issued by Master File Scheduling and assigned to the Master File Section (MFS) with a share to System Automations Branch (SAB). Contact may be needed with Submission Processing Headquarters to reconfirm counts and amounts submitted for transfer in comparison to the JPD report summaries. After all ECC-MEM/ECC-MTB data is processed for the cycle (daily for IMF), AAV Summaries for each center are generated by cycle (daily IMF) from the JPD 793-1A (793-01 and 793-04), PA and PB (793-02). Processing Validation Section will verify the input of the ECC-MEM/ECC-MTB data transmitted VIA CONNECT:Direct using the AAV Summaries. Input of shipped reels will be verified using the ECC-MEM/ECC-MTB TEP and the LARS validation summary screen. Each input reel should also produce an AAV with the exception of file EPM-02-01 input to 260-02. The IMF daily and weekly and the BMF and EPMF AAV Summaries reside on Control D for Submission Processing Campus viewing and verification of input. ECC suspends copies of the weekly AAV Summaries by Submission Processing Campus and by Master File pending verification and balancing of the monthly reports. The 793-01-17 Drop File is a print (error listing) and is sent to the Submission Processing Campus with the AAV for all honored deletions. 3.17.221.6.2 (01-01-2012) Media Reel Replacement (Scheduling) If a file cannot be processed, it will be flagged by SCIPAS. The SCIPAS Team in Master File Scheduling will investigate. If SCIPAS does not receive a file per the defined schedule, SCIPAS will contact Unisys. The Scheduler in Master File Scheduling may request assistance from the Master Files Automation Section (MFAS) if a replacement is necessary. If a replacement file is needed, Master File Scheduling will prepare a Info Notes. The Info Notes should include the workgroup, file ID, batch and cycle, a precise detailed description of the reason the file was flagged, and the IRWorks ticket number. Master File Scheduling will contact the Centralized Help Desk to initiate a request for a retransmission and furnish the necessary information from the Info Notes. The IRWorks tickets will notify the appropriate site. The Computer Center Journalization System (Info Notes) will be updated with the IRWorks ticket number. 3.17.221.6.3 (01-01-2012) Input, Sort, and Merge Processing Input, sort, and merge processing reformats, sorts and merges Submission Processing Campus data, Agency and regional financial center data with other ECC files such as the cross-reference file and the resequence file. This process prepares data for posting to the Master File. The projects for each Master File are: 160 for BMF (BPW) 460 for IMF (IPD, IPW) 130 and 260 for EPMF (PPW) As these runs are processed, Master File programs contain internal balancing features resulting in the generation of controls and LARS counters are generated for balancing purposes. The controls and LARS counters are systemically compared with the input record totals in order to verify the operational validity of the output. LARS counters are the recognized General Accountability Office (GAO) audit trail used to validate run-to-run balancing. This audit information includes all input and output records and prejournalized debits and credits. If manual balancing is necessary and directed by management, the Processing Validation computer assistant should refer to the project Computer Operator Handbook (COH) for specific balancing requirements. If IT management determines Controls Registers are necessary for audit trail purposes, error or reject records and money amounts will need to be posted on the Controls Register for complete and correct balancing of the processing run. 3.17.221.6.4 (01-01-2012) Input Balancing The beginning program for Master File projects is the 02 run. This run reformats data for Submission Processing Campus, ECC, and other files in preparation for subsequent processing. Master File will systemically balance the 02 runs and ensure the total input transactions equal the "Total Output Transactions Controls." When the input processing run has been balanced, the transaction output will be systemically input to the sort run. The remaining paragraphs in this section only apply if manual intervention is necessary and directed by management. To balance the 02 run, list on the Controls Register all input files to the run. (See Exhibit 3.17.221-5 and Exhibit 3.17.221-6) Inputs will include 793-01, 793-04, 793-02, resequence file, undelivered/cancelled refunds, cross-reference file and other files depending on need and availability. CAWR (when available) is included on BMF. Undelivered/cancelled refund Data is input to run 160-08 for BMF processing. Carefully review the Log Analysis and Reporting System (LARS) validation summary to determine the files input. Because of computer scheduling and constraints, there are several passes of the 02 run which will need to be summarized through the Statistical Analysis System (SAS) controls and manual postings to determine the total input records and prejournalized debits and credits. (See Exhibit 3.17.221-7) Record the total input records and prejournalized money amounts on the Controls Register. Record any reject or error records and money on the Controls Register to ensure accountability. Initiate IRWorks, listing the reject and route to the Master File Scheduling (MFS) staff for disposition. 3.17.221.6.5 (01-01-2012) Sort Balancing The next step of 02 processing sorts the records to various categories for posting to the Master File. The sort data will contain the input from the 02 run, zip code transactions, and other miscellaneous data. The sort control consists of total records, including prejournalized debits and credits that will be reflected in the output controls. Output control totals will be verified with the total of the transactions input. When the sort processing run has been balanced by internal Master File balancing, the transaction output is input to the merge run. If manual intervention is necessary and directed by management, continue using the Controls Register for the processing cycle. (See Exhibit 3.17.221-5 and Exhibit 3.17.221-6) 3.17.221.6.6 (01-01-2012) Merge Balancing The next step of 02 processing is merging all files for the cycle. IMF will perform this activity daily in daily processing. BMF and EPMF will perform this weekly. If manual intervention is necessary and directed by management, continue using the Controls Register for the processing cycle. Post and summarize all input files records. Balance using the input from the sort runs, plus additional input files, to verify the total output records, debits, and credits. Discrepancies should be reported by opening a IRWorks ticket. Annotate the ticket number on the Controls Register. 3.17.221.6.7 (01-01-2012) Error Resolution PVS serves as a liaison between Master File Section and the Submission Processing Campuses to assist in resolving imbalance conditions. PVS is responsible for issuing Data Adjustment Vouchers as necessary when transactional records have to be deleted from Master File processing. See IRM 3.17.221.7, ECC Control Adjustments. The IRWorks ticket is initiated by PVS Computer Assistant via e-mail to Lead Computer Assistant to record, control, resolve errors, and to provide an audit trail for all unexplained discrepancies. After consulting with the Lead Computer Assistant or management, the Computer Assistant opens the IRWorks ticket for all error records, run imbalances, dropped input reels, and controls irregularities. Identify the cycle and run designation and provide a brief but inclusive description of the problem. For run imbalances, provide the record counts and money amounts; error record information can be reviewed on-line by accessing Control D. Based upon the Lead Computer Assistant's direction, the ECC Help Desk will forward the IRWorks ticket to the appropriate area for resolution and response. When the IRWorks response is returned with an acceptable resolution, determine whether an adjustment action or additional data should be provided. Record follow-up action taken on the completed IRWorks. Annotate the Control Register report page with the IRWorks ticket number for an audit trail of the discrepancy to resolution. 3.17.221.7 (01-01-2012) ECC Control Adjustments The following section outlines the ECC Control Adjustments process. 3.17.221.7.1 (01-01-2012) Data Adjustment Voucher After resolution of certain processing discrepancies by response to IRWorks from the MFS staff, the PVS lead will access an online menu screen to prepare the Data Adjustment Voucher (DAV), Form M-4496A. The DAV is used to record reciprocal accounting control balance between ECC and the Submission Processing Campuses. The DAV is prepared as deletions are reported by the Master File program area and should be issued within one workday of identification. (See Exhibit 3.17.221-8) Note: The DAV User Guide is located on DOCIT. The DAV is used to control the required adjustments, to notify the affected Submission Processing Campus of the problem, and to provide the information needed to correct the out of balance condition. The DAV should provide all information available and necessary for the Submission Processing Campus to make the appropriate adjustment on a timely basis. This information is available on the 460-02-16. The minimum information provided on the DAV should include the following when applicable: Taxpayer Identification Number (TIN) Document Location Number (DLN) Amount (Debit or Credit) Processing Cycle Reason for the adjustment Copy of Error/Reject List, run 460-02-16, should be sent to the campus electronically via secure e-mail, if too large to input on Form M-4496A Any other pertinent documentation Line Code if related to the SC Recap of Assessments, Abatements, and other Post Journalized Transactions Explanation including what the amount should have been and the amount that actually posted on the SC Recap Action taken by ECC Recommended action to be taken by SPC The DAV will be loaded to Control D upon completion for each SPC. Notify campuses via e-mail when a DAV has been created. Any necessary clarification of the DAV should be resolved through telephone contact with the Submission Processing Campus, followed up by an amended DAV if appropriate. 3.17.221.7.2 (01-01-2012) Error and Reject Adjustment During production processing, transactions may not be processed because of a processing discrepancy or a control irregularity. These error or reject transactions are dropped from processing and will create an Error or Reject file listing. Whenever a record opens the error or reject file, the record count and money amount, if applicable, will be displayed in a LARS counter for that run and/or indicated on the Controls Listing when manual intervention is necessary and directed by management. When manual intervention is necessary and directed by management, the Error or Reject record will need to be listed on the Controls Register to reconcile the input/output totals. The MFS staff will initiate a IRWorks to the programmer with an explanation of the problem. Processing Validation will: Prepare DAV if the error or reject necessitates an adjustment action or if the record is to be returned to the Submission Processing Campus for corrective action. If the DAV contains money, the DAV should be processed in the next running of the RACR for input into the Reconciliation in the subsequent cycle. Document DAV information in the remarks section of the RACR. The DAV will be loaded on Control-D for the appropriate Submission Processing Campus. 3.17.221.7.3 (01-01-2011) Data Adjustment Voucher (DAV) Numbering System The IMF DAV is numbered to control, classify, and provide an audit trail if research is needed. These numbers are automatically assigned VIA the on—line DAV program. Position 1 -Type of adjustment transactions, rejected (R), error (E), and blank for all other transactions. Position 2 - File source I-IMF, B-BMF, E-EPMF Positions 3 - 9 - Processing cycle (YYYYJJJ) Positions 10 - 11 - Submission Processing Campus code Positions 12 - 13 - Voucher serial number (sequenced from January 1 to December 31 by Submission Processing Campus, type, and file) 3.17.221.8 (01-01-2012) Maintenance of Reciprocal Accounting Control Record (RACR) This section explains and outlines procedures for the maintenance of the RACR. 3.17.221.8.1 (01-01-2012) Explanation of RACR The automated RACR is the cumulative accounting record maintained by ECC for each Submission Processing Campus. (See Exhibit 3.17.221-17) The RACR reflects the monetary value of data input and generated to each Master File (IMF and BMF). The RACR is prepared daily by ECC for each Submission Processing Campus for IMF. The RACR is also prepared weekly by ECC for each SPC for BMF. The RACR should be prepared as soon as all related processing is completed (i.e., unpostables, accounts register, AAV summaries, resequence, cancelled/undeliverable refunds, etc.). At the close of the cycle (may be other than Wednesday if a holiday is involved), there will be one Recap and RACR, which will be tagged with a "H" , indicating the last daily which includes the weekly transactions. The monthly closing of the RACR is made at the end of the last posting cycle for that month. RACRs are programmed to print "Last entry for the Month of" message on the last cycle of the month. This is the last weekly posting cycle of the month for BMF processing. For IMF, this would be the final daily RACR, which will also contain the activity for the weekly transactions. The monthly RACR is used by the Submission Processing Campuses to reconcile their general ledger control accounts. Items posted to the RACR are the same items that have been journalized to the Submission Processing Campus general ledger accounts. ECC has developed ADP programs which assist in preparation of the RACR. Refer to local Statistical Analysis System (SAS) procedures in using these programs. A copy of each daily and weekly RACR is available to the SPCs via Control D. PVS will no longer forward copies of these reports to the SPCs. Copies of the RACR are filed separately for each Submission Processing Campus in chronological sequence along with the associated AAVs for those cycles. 3.17.221.8.2 (01-01-2012) RACR Procedures The Form 5199A, Reciprocal Accounting Control Record, is automatically generated after the related runs have processed. The automated Statistical Analysis System (SAS) program supplies the following data extracted from the appropriate controls. The prior ending RACR balance for each Submission Processing Campus and Master File (IMF daily - BMF weekly) The total debits and credits for the cycle from the Accountability Acceptance Voucher Summary, 793-01 and 793-04 The total debits and credits for Unpostable transactions from the 60 run (reverse) The total run 43 Accounts Register Non-Prejournalized (NPJ) debits and credits For 160-43 (BMF) the Non-Prejournalized (NPJ) amount is posted less refunds generated. For 460-43 (IMF) the NPJ amount is posted less refunds generated and DMF. The total refund amounts from 160/460-43 (IMF and BMF only) The Criminal Investigation Division (CID) cancelled EFT refund amounts from the 460-38 run (IMF only) DMF Offsets and DMF Reversal transaction amounts from the 460-43 runs (IMF only) Accounts To and From Other Submission Processing Centers amounts from the 43 runs Credits To and From Other Submission Processing Centers amounts from the 43 runs The total credit amount of cancelled/undelivered refunds from the following schedules: SF 1098, Schedule of cancelled Checks SF 1185, Schedule of Unavailable Check Cancellation Credits EFT 145, Schedule of cancelled EFT items (IMF only) Limited Payability Reclamation Credits Unavailable Check Cancellations (Paper SF 1184) DAV figures are extracted from the automated DAV program. The total debit amount for Payment over Cancellation 3.17.221.8.2.1 (01-01-2010) RACR Ending Balance After reconciling the Master File balance at the close of the cycle, the ending balance will be automatically carried forward via Statistical Analysis System (SAS) to begin the next week. 3.17.221.9 (01-01-2012) Reconciliation of Master File Balance This section outlines the Master File balance reconciliation procedures. 3.17.221.9.1 (01-01-2012) General Form 5198A, Reconciliation of Master File Balance, commonly called the "REC" is generated after the related processing runs completed and the RACRs have automatically processed. This is completely automated and processes immediately after the needed runs have processed. Reconciliation of IMF is daily, BMF is weekly. (See Exhibit 3.17.221-18) In the event of reruns or other factors that would require a rerun of the RACRs and REC, PVS must first balance the related runs and open a IRWorks to the ECC/MFS requesting a rerun of the RACRs and REC for that cycle. PVS is no longer able to manually submit reruns of RACRs and REC. The "REC" is used to reconcile the updated Master File balances to the current cumulative net balance on the RACR. During IMF and BMF conversion processing, Form 5198A, is systemically generated, to reconcile these Master Files separately. (See Exhibit 3.17.221-19) 3.17.221.9.2 (01-01-2010) Manual Creation of Master File IMF REC When a manual creation of the REC is needed, enter the following information: Enter the net balance from the RACRs for each Submission Processing Campus. Enter the cancelled refund amount of CID Transaction Code 841(s) In Records from the 460-37-14 controls to the Transactions Pending Column (IMF only). Account for any adjustments reflected in the "Adjustments in Process" column which are imbalances between the Net RACR amounts and the sum of Transactions Pending (IMF only), Resequenced Pre-Journalized (PJ)Transactions, and the Accounts Register OMB data by Submission Processing Campus. Enter the resequenced PJ Amounts from the Merge Master File Accounts Control, 63 run. (See Exhibit 3.17.221-20) Enter the Accounts Register, SC Recap (43 run) Outstanding Module Balances (OMB) net credits and debits balances. (See Exhibit 3.17.221-21) The Master File Balance of the "REC" is a summation of the processing segments and the "Resequenced Tax Modules" , which must balance with accounts register, OMB Data, net balance. Enter for each segment, from the run 15 controls, the ending entity and ending total tax module balance. (See Exhibit 3.17.221-22) BMF will include segments 1 through 4. IMF will include segments 1 through 6. Enter the net "resequenced tax module" amount from the "Recap of all segments" 15 run processing controls data. (See Exhibit 3.17.221-22) Complete the preparation of the "REC" by totaling all parts. 3.17.221.9.3 (01-01-2012) Form 5198A, Reconciliation of Master File Balance (REC) and Reciprocal Accounting Control Record (RACR) Validation The REC is reviewed by the CSA Section immediately following generation of the report controls which are output following successful completion of IMF and BMF determined at the time the RECAP is output. The total of the column labeled “adjustments in progress” should be zero and is verified by the CSA area. There may be counts present in this column by site which indicates a transactional amount is being transferred from one Submission processing Campus to another (TOS and FOS). The CSA notifies IBM Scheduling via IRWorks and Scheduling releases the refund files to BFS to generate control numbers for pre-edit. ECS38 and 39 files for IMF and an ECS41 file for BMF are created after the processing has completed and refund data files have been sent to BFS by scheduling section. There is an agreement that BFS will not issue refunds on the files until the certification files have been received. Automation creates the ECS certification files to transmit to BFS from the following pre-edit files: PDIPW.CFMSPE.F001* (for the 460-39-22 control – paper refunds - IMF) PDIPW.CFMSPE.F002* (for the 460-38-15 control – EFT refunds - IMF) PDBPW.CFMSPE.F001* (for the 160-41-017 control – paper refunds - BMF) PDBPW.CFMSPE.F002* (for the 160-41-017 control – EFT refunds - BMF) The REC is used to reconcile the updated Master File balance to the current cumulative net balances on the RACRs'. The Accounts Register OMB (160-43, 460-43) total should equal the Master File Balance total. (Net tax module ending balance plus the net resequenced tax module 160-15 or 460-15.) The Reciprocal Accounting Control Column should equal the sum of Transactions Pending (IMF only), Resequenced PJ Transactions, and Accounts Register OMB Data. Any imbalance should be listed under adjustment column. If an imbalance occurs, the CSA will verify source data, transcription amounts and computation of totals. Report any imbalance for error resolution to PVS for preparation of the Data Adjustment Voucher (DAV). In the Remarks section explain all items listed under Adjustment in Process Column and comment on actions being taken to resolve imbalances. Include original cycle ID of first occurrence. If the imbalance cannot be resolved, a Priority 1 ticket will be issued by the Master File Section (CSA/RPA) to the programmer. IRWorks ticket priorities are listed below: Priorities Priority 1 - Immediate nationwide work stoppage Assigned within 30 minutes Updated hourly Priority 2 - Potential Work Stoppage - Could have impact on service to taxpayers Assigned within 1 hour Updated every 2 hours Priority 3 - Work Stoppage for 1 customer with no work-around Assigned within 1 hour Updated every 4 hours Priority 4 - Non-critical - No work stoppage and has a work-around Assigned within 2 hours Updated no later than 3 working days Priority 5 - Requests for non-production related services Assigned within 2 hours Updated no later than 5 working days 3.17.221.10 (01-01-2016) Refund Validation and Certification This section outlines refund processing procedures. 3.17.221.10.1 (01-01-2012) General An important and sensitive area of Master File processing concerns the issuance of BMF and IMF tax refunds, and should be considered a priority. Delays or errors in the issuance of refunds could result in large interest payments as well as significant taxpayer relations problems. It is important that problems in the issuance of refunds be identified and resolved at the earliest possible time. If a file cannot be processed, it will be flagged by Service Center Input Processing Automation System (SCIPAS). The SCIPAS Team in Master File Scheduling will investigate. The Scheduler in Master File Scheduling may request assistance from the Master Files Automation Section (MFAS) if a replacement is necessary. If a replacement file is needed, Master File Scheduling will prepare a Info Notes. The Info Notes should include the workgroup, file ID, batch and cycle, a precise detailed description of the reason the file was flagged, and the IRWorks ticket number. Master File Scheduling will contact the Centralized Help Desk to initiate a request for a retransmission and furnish the necessary information from the Info Notes. The IRWorks tickets will notify the appropriate site. The Computer Center Journalization System (Info Notes) will be updated with the IRWorks ticket number. All refunds are paid by check or by electronic fund transfer by BFS. Refunds generated at ECC by weekly Master File and daily IMF processing are transmitted electronically via CONNECT:Direct to BFS. IMF/BMF regular refunds are transmitted via CONNECT:Direct upon completion of refund cycle processing. Notify Chief, OSSVB by e-mail. IMF/BMF EFT refund data is transmitted via CONNECT:Direct upon completion of EFT refund cycle processing. 3.17.221.10.1.1 (01-01-2012) PVS Validation Responsibilities - IMF The following additional IMF validation tasks must be performed daily by PVS following successful completion of IBM Master File Processing and all differences and/or error counts must be identified as acceptable reconciliation amounts prior to certifying refunds for release to BFS. Certifying refunds must be the first priority of work performed each day. Review CLIST - check for out of balance conditions and ensure they were addressed and corrections are noted. Ensure all Log Analysis Reporting Service (LARS) out of balances have been corrected prior to certification of refunds. I = “in balance” O = “out of balance” Pay special attention to jobs for IMF 460 (02, 03, 07, 08, 10, 11, 12, and 15). If CLIST shows an out of balance, check for a rerun that shows it in balance. If no rerun is found, the PVS technician notifies the Lead. The Lead will conduct additional research such as reviewing ENDEVOR transmittals, IRWorks, and Processing notes. If no explanation is found, the Lead will issue a IRWorks to the programmer requesting clarification and validation of activity. Confirm all refund files were successfully transferred to BFS. Check the record counts and total amounts Verify the date and control number(s) to make sure there are no control numbers listed as “Z99999”. Confirm receipt of confirmation from CSA/RPA area (via e-mail) that they have completed the QR (Quality Review) for 460-38 and 460-39. This is to ensure that the files are format compliant for BFS. Review IMFBAL (PVS automation tool) to ensure there are zeroes in the "difference column" . If any value other than zero is displayed, contact ADP programmer. Ensure all differences have been identified and are reconcilable prior to certification of refunds. Review and validate the following output controls by looking for counts in the error fields: 460-17 460-64 460-35 *(see additional information under EOD0167 for 460-35-12) IRM 3.17.221.10.1.1(7) 460-37 460-38-15 460-39-22 460-72 If error counts are found, the PVS Technician will report their findings to the PVS Lead for issuance of a IRWorks alert to the programmer to determine next action and to confirm whether or not refunds should be held based on the findings and explanations from the responsible programmer. EOD0167 Validation of input to 460-35-12 - this validation needs to be performed daily. Review amount field listed as “Diff of Debit Totals and Credit Totals” in 460-43. The dollar amount should be zero. If not zero, the PVS technician notifies the PVS Lead to determine if a IRWorks assigned to the program area is warranted to reconcile the difference. Ensure all differences have been identified and are reconcilable prior to certification of refunds. The following tasks must be performed, but certifying refunds is not dependent upon completion of these tasks: Review and validate the following output controls by looking for counts in the error fields: 460-3A 460-3E 460-96 Ensure all existing errors have been identified and are reconcilable. If error counts are found, the PVS Technician will report their findings to the PVS Lead for issuance of a IRWorks alert to the programmer to determine next reconciliation action based on the findings and explanations from the responsible programmer. Ensure no schedules were omitted in transfer to BFS. Confirm all refund schedule numbers are in sequential order with no gaps between cycles. This must be a point of validation during the process. If this is validation point is not performed by IBM Scheduling, it should be performed by PVS. 3.17.221.10.1.2 (01-01-2012) PVS Validation Responsibilities - BMF The following additional BMF validation tasks must be performed on Friday by PVS following successful completion of IBM Master File Processing and all differences and/or error counts must be identified as acceptable reconciliation amounts prior to certifying refunds for release to BFS. Certifying refunds must be the first priority of work on Friday for BMF validation. Review CLIST - check for out of balance conditions and ensure they were addressed and corrections are noted. Ensure all Log Analysis Reporting Service (LARS) out of balances have been corrected prior to certification of refunds. I = “in balance” O = “out of balance” Pay special attention to jobs for BMF 160 (02, 03, 07, 08, 10, 11, 12, and 15). If CLIST shows an out of balance, check for a rerun that shows it in balance. If no rerun is found, the PVS technician notifies the Lead. The Lead will conduct additional research such as reviewing ENDEVOR transmittals, IRWorks, and Processing notes. If no explanation is found, the Lead will issue a IRWorks to the programmer requesting clarification and validation of activity. Check BMF02SUM for counts listed in the 160-02-15/16 files. Check for stale CAWR records. If counts are listed in either the 160-02 15 or 16 files report to PVS Lead. PVS Lead will then initiate a IRWorks ticket to the programmer for acceptance. Note: Even though this warrants a IRWorks ticket, this does not hold up refunds from being submitted. These counts are expected and the programmer needs to know to review the records. Confirm all refund files were successfully transferred to BFS. Check the record counts and total amounts Verify the date and control number(s) to make sure there are no control numbers listed as “Z99999”. Confirm receipt of confirmation from CSA/RPA area (via e-mail) that they have completed the QR (Quality Review) for BPW 16041. This is to ensure that the files are format compliant for BFS. Review BMF Revenue Receipts Report (PVS automation tool) to ensure there are zeroes in the "difference column" . If any value other than zero is displayed, contact ADP programmer. Ensure all differences have been identified and are reconcilable prior to certification of refunds. Review and validate the following output controls by looking for counts in the error fields: 160-17 160-41-017 If error counts are found, the PVS Technician will report their findings to the PVS Lead for issuance of a IRWorks alert to the programmer to determine next action and to confirm whether or not refunds should be held based on the findings and explanations from the responsible programmer. Review Recap and check for errors. Also check amount field listed as "Diff of Debit Totals and Credit Totals" in 160-43. The dollar amount should be zero. If not zero, the PVS technician notifies the PVS Lead to determine if a IRWorks ticket to the program area is needed to reconcile the difference. Ensure all differences have been identified and are reconcilable prior to certification of refunds. 3.17.221.10.1.3 (01-01-2012) Refund Schedules The refund files will be transmitted to Bureau of Fiscal Service (BFS) as follows: IMF EFT and paper refunds are processed daily and should be completed by 3:00 PM Eastern Time each workday; but may be no later than 5:00 Eastern Time the following workday if needed. BMF EFT and paper refunds are processed weekly and should be completed by 3:00 PM Eastern Time on Friday after BMF weekly processing; but may be no later than 5:00 PM Eastern Time the following Friday if needed. 3.17.221.10.1.4 (01-01-2011) Avoidance of Late Transfers In the event ECC is unable to electronically transmit refund data, ECC management will make necessary arrangements to avoid late shipment. 3.17.221.10.2 (01-01-2012) Regular, Electronic Funds Transfer (EFT), and Accelerated Refunds All refund documents and controls must be reviewed and balanced for completeness and correctness before submitting to Secure Payment System. Balance the refund data to the Master File (460-15 IMF and 160-15 BMF) and to the "Refund Generated" amount on the SC Recap of Assessments, Abatements, and Other Post-Journalized Transactions (460-43 or 160-43). 3.17.221.10.2.1 (01-01-2016) On-line Voucher Preparation Submit on–line Refund Vouchers. The online refund vouchers are available for the campuses to view through Control D. Inform the Data Entry Operator (DEO) who will perform the following: Download refund data from the mainframe to The C drive. See IRM 3.17.221.10.2.1 (3) below for instructions if you are not able download refunds from ECS. Upload data from the C drive to Secure Payment System (SPS). Correct or delete incorrect schedules rejected back to the edit queue. DEO verifies printed schedule record and money amounts of the IMF and BMF refund controls. Manual download instructions: Access C drive as normal, select first file and hold shift key to select all other files. Once all files have been highlighted, right click and click copy. Open a new e-mail and paste files in the e-mail, not in an attachment or subject line. Paste by right clicking and pasting. Files will be automatically placed in the attachment line. Forward e-mail to DEO. DEO will open e-mail. Copy files as in step 2. Then paste to desktop. Only step that will change is when you upload files to SPS you will not select the C drive. You will need to select desktop and highlight all your files, then submit and continue as usual. The Certifying Officer (CO) will do the following: Certify all correct schedules. Reject incorrect schedules back to the Edit Queue for correction or deletions. Transmit the Certification Payment Schedule to the SPS host at BFS. Note: A User Manual is available for SPS. When logged into SPS, click the question mark in the upper right hand corner. This will display the SPS User Manual. The Campus will validate the integrity of the ECS Form received from ECC via a file transfer through Control D. To ensure there are no inconsistencies between the ALC Payment Details listing, verify the following: Place the original copy of the Secure Payment System Schedule in the refund suspense file. (See Exhibit 3.17.221-24) Schedule number on the ECS form must match the schedule number on ECS run on Control D. Requested payment dates must match confirmed date. Record counts balance to the check/bond range; to ensure the correctness of the check bond range; subtract the ranges (highest figure subtracted from the lowest figure add on), the difference between the two check/bond ranges will match the record counts that are listed on the ECS form. Monetary disbursements with net amount. Note: The information should be verified by an Accounting Technician daily for IMF and once a week for BMF to ensure any inconsistencies can be cleared before payments are disbursed. If all information from the ECS form corresponds with the ALC Payment Details listing, then no further action is needed. If there are inconsistencies between the two forms, contact ECC Processing Validation Section to investigate the inconsistencies. 3.17.221.10.3 (01-01-2012) Error File Refunds Some refund cases may be directed to the Error File during processing and will require research to determine validity for further processing. Initiate a File Search Request, Form 9633. (See Exhibit 3.17.221-25) Prepare a PRIORITY IRWorks for MFS staff review. The MFS staff will review and analyze the documentation to determine validity of the refund. Refunds determined to be valid will be processed as manual refunds by ECC. Prepare a separate Secure Payment System Schedule and route to the assigned Submission Processing Campus. Prepare a DAV advising appropriate Submission Processing Campus of any necessary RRACS journalization or adjustments to the Net Tax Refund Report. A follow-up telephone contact will be made in twenty-four hours to insure the processing of the manual refunds by BFS. If the refund is invalid, prepare a DAV requesting that the responsible Submission Processing Campus correct the transaction and complete the necessary journalization. 3.17.221.10.4 (01-01-2012) Notification of Refund Data Department of Treasury requires separate reporting of IMF and BMF refund data, daily for IMF and weekly for BMF. Exceptions would be holidays and elongated processing. This reporting to the Federal Reserve Bank is to insure that funds are deposited into the account for issuance to the taxpayer. The Processing Validation section will transmit the estimated IMF and BMF Refund Reports, Form MCC-388 to the Department of the Treasury, Secretary Office of Cash and Debt, via e-mail to: Receipts@do.treas.gov, include the Leads and manager on the e-mail. If unable to e-mail, fax to (202) 622-1822. The contact's telephone number is (202) 622-1817. (See Exhibit 3.17.221-26) BMF Refund Report is e-mailed weekly on Tuesday, by 11:00 AM. The estimated IMF Refund Report is to be e-mailed daily by 8:30 AM. If during the cycle a rerun occurs, Treasury will be notified by 8:30 AM that the estimated Refund Report will be transmitted when the rerun has been completed. The Secretary Office of Cash and Debt will in turn acknowledge receipt of the Refund Report by signing, dating, and faxing acknowledgment back to ECC. The Refund Report consists of the following data: Count and amount of IMF/BMF refunds by principal, interest and total. Date refunds are to be paid. The count, principal, interest, and total of civil penalties. (IMF only) Cumulative count, principal, interest, and total for IMF refunds and civil penalties. The Debtor Master File (DMF) offsets and reversals by items and amounts. Items, principal, interest, total, and to be paid date for EFT refunds. During BMF accelerated cycles, amounts will be posted for items, principal, interest, totals and "to be paid" date. 3.17.221.10.5 (01-01-2010) Dropped File ECC Master File Scheduling help desk will contact Kansas City Financial Center (KCFC) when a refund cancellation file is flagged (dropped). The following information will be provided to KCFC or BFS for replacement media. File ID Batch Cycle Workgroup 3.17.221.10.6 (04-20-2017) Authorization of Certifying Officers, and Other Secure Payment System (SPS) Personnel Security over disbursement of federal funds is a responsibility shared by Federal agencies and the Treasury Department, primarily through the Financial Center to which payment documents are submitted. Upon receipt of a payment document by a financial center, the first and primary process in examination is the matching and comparison of the electronic signature of the certifying officer to the signature on the Bureau of Fiscal Services (BFS) Form 210, Designation of Certifying Officer. Kansas City Financial Center requires the following forms to be prepared for the following Secure Payment System (SPS) personnel: (See Exhibit 3.17.221-30 to Exhibit 3.17.221-34) Head of Agency (self-appointed) — Delegation of Authority, BFS Form 2958 Certifying Officer — Designation For Certifying Officer, BFS Form 210 A Local Service PKI Certificate Action Request is needed for both the COs and DEOs Data Entry Operator — Designation For SPS Data Entry Operator, BFS Form 210 Note: Form 210 for Data Entry Operators and Certifying Officers must reference a 310 RFC for Kansas City certification files. Forward the completed forms to the Enterprise Computer Center (ECC) Staff Assistants Office for the Director's signature. (The Director of ECC has delegation of Authority) This office will send the completed forms to: Kansas City Financial Center 4241 NE 34th St. Kansas City, MO 64117 Note: In order to speed up the processing of the forms, it is an option to fax the forms to BFS. A tracking number must be obtained from the mail room and noted on the Fax Cover Sheet, clearly label UPS tracking number. Without the tracking number, BFS will not process the forms until the originals are received. Expiration periods will be calculated based on effective date and will be effective for a full expiration period (as applicable). Delegation of Authority - 2 years Certifying Officer - 2 years SPS Data Entry Operator - 2 years Confirmation of acceptance of all delegations and designations will be sent from BFS. Delegators/designators will receive automatic written notifications two months prior to the expiration of all delegations/designations, as well as automatic written notification of the expiration of delegations/designations not renewed. When the completed forms are returned, copies of all signed forms are filed in the Internet Trusted Registration Agent (ITRA) folder maintained in PVS. 3.17.221.10.7 (01-01-2012) Trusted Registration Agent (TRA) Instructions Requesting a new TRA: Complete Public Key Infrastructure (PKI) Support Nomination form, which is available at https://www.fiscal.treasury.gov This form must be completed by the Head of Agency (HOA) or Fiscal Sponsoring Authority (FSA) at the agency. See IRM 3.17.221.10.7 (5) for instructions on completing this form. Complete the PKI Certificate Action Request (CAR) form, which is available at https://www.fiscal.treasury.gov. Select “New Subscriber” in Block 1. This form must be completed by the HOA or FSA at the agency. See IRM 3.17.221.10.7 (6) for instructions on completing this form. Submit paperwork to servicing RFC. Servicing RFC submits paperwork to BFS Headquarters After paperwork has been processed, Existing TRA will receive authorization codes via pinmailer, original CAR, Non-Disclosure agreement and Help Desk Registration Form from BFS; User will receive reference number via e-mail. Existing TRA will complete the In Person Proofing Process which includes: 1. completing the PKI in Person Proofing Form, which is available at https://www.fiscal.treasury.gov See IRM 3.17.221.10.7 (7) for instructions on completing this form. 2. having user read the PKI subscriber agreement, which is available at https://www.fiscal.treasury.gov 3. getting a copy of the users id 4. having user complete the Nondisclosure Agreement 5. having user complete the Help Desk registration form Existing TRA will "Create Credential" in ITRA. Existing TRA will submit all paperwork (support nomination form, original certification action request, in person proofing form, non-disclosure agreement, help desk registration form, and copy of id) back to servicing RFC. Requesting a new SPS User: Complete the PKI Certificate Action Request (CAR) form, which is available at https://www.fiscal.treasury.gov Select "New Subscriber" in Block 1. This form must be completed by the HOA or FSA at the agency. See IRM 3.17.221.10.7 (6) for instructions on completing this form. Submit paperwork to servicing RFC. Servicing RFC submits paperwork to BFS Headquarters. After paperwork has been processed, Existing TRA will receive authorization codes via pinmailer, original CAR, Non-Disclosure agreement and Help Desk Registration Form from BFS; User will receive reference number via e-mail. Existing TRA will complete the In Person Proofing Process which includes: 1. completing the PKI In Person Proofing form, which is available at https://www.fiscal.treasury.gov See IRM 3.17.221.10.7 (7) for instructions on completing this form. 2. having user read the PKI subscriber agreement 3. having user read and sign the SPS Rules of Behavior Form, which is available at https://www.fiscal.treasury.gov 4. getting a copy of the users id 5. having user complete the Non-Disclosure Agreement 6. having user complete the Help Desk Registration form Existing TRA will "Create Credential" in ITRA. Existing TRA will submit all paperwork (support nomination form, original certification action request, in person proofing form, non-disclosure agreement, help desk registration form, SPS Rules of Behavior, and copy of id) back to servicing RFC. Requesting a Key Recovery: Contact your servicing RFC to advise them that you have a user who has lost their IKey, forgotten their password, changed their name, etc. Note: for a user who has changed their name, a new Form 210 will be required with their new signature. Complete the PKI Certificate Action Request form, which is available athttps://www.fiscal.treasury.gov. Select “Recover PKI Certificate” in Block 1 and select the appropriate reason. If reason is not listed, please select “other” and provide a description. This form can be completed by the TRA for key recoveries. See IRM 3.17.221.10.7 (6) for instructions on completing this form. Fax paperwork to servicing RFC. Servicing RFC submits paperwork to BFS Headquarters. After paperwork has been processed, Existing TRA will receive authorization codes via pinmailer , e-mail, or phone call - depending on the urgency. User will receive reference number via e-mail. Existing TRA will complete the In Person Proofing Process which includes: 1. completing the PKI In Person Proofing form, which is available athttps://www.fiscal.treasury.gov See IRM 3.17.221.10.7 (7) for instructions on completing this form. 2. having user read the PKI subscriber agreement 3. getting a copy of the users id Note: User should not have to complete another Non-Disclosure Agreement or Help Desk form because the original should already be on file; however, if they choose to complete one, it will replace the one on file. Existing TRA will "Recover Credential" in ITRA. Existing TRA will submit all paperwork (original certification action request, in person proofing form, non-disclosure agreement, help desk registration form, and copy of id) back to servicing RFC. Requesting to Revoke SPS Users: Contact your servicing RFC to advise them that you have a user who has retired, gotten another job or will no longer be using SPS. Complete the PKI Certificate Action Request form, which is available at https://www.fiscal.treasury.gov select “Revoke PKI Certificate” in Block 1. This form can be completed by the TRA for revokes. See IRM 3.17.221.10.7 (6) for instructions on completing this form. Submit paperwork to servicing RFC. Complete appropriate Form 210 (210 or 210 DEO) to revoke user and submit it to Kansas City Financial Center (KCFC). Servicing RFC will notify the TRA when the Revocation has been completed. Instructions for completing Fiscal Service PKI Nomination Form: You will need a Fiscal Service PKI Support Nomination form for each TRA and FSA. They must be accurate and all boxes completed except Block 4. Block 1: Check the FSA box for FSAs and the TRA box for TRAs. Block 2: Enter the FSA or the TRA's information in Block 2. The Business Systems Requiring Nomination: SPS FPA ID = CPS1 The Nominee must sign and date the form in this block. Block 3: The Nominating Official must complete this block and sign and date it. The Nominating Official will be a HOA or a FSA. The HOA nominates the FSA and/or the TRAs. If you have a FSA, the FSA can nominate the TRAs, COs, and DEOs. Block 4: Leave blank. Instructions for completing PKI Certificate Action Request Forms: For the nominations, you must have a PKI Certificate Action Request (CAR) for each DEO, CO and TRA. Block 1: Check 'New Subscriber'; check 'Enterprise Certificate' and 'Medium' as the Level of Assurance. The Business System Requiring Certificate: SPS Other Information: FPA ID = (YOUR FPA ID) and Role of User (CO, DEO or TRA) Block 2: Enter the DEO's, CO's, or TRA's full name, the organization name and address, the correct e-mail address, phone and fax number of the person. Block 3: The FSA or HOA nominates the DEOs, COs, and TRAs. His/her data is to be entered in Block 3. Block 4: Enter the information of the TRA that will be receiving the Authorization Code. First time should be the TRA at the RFC. After the SPS site visit, the agency’s TRA information will be entered on any subsequent forms submitted. Instructions for completing PKI Certificate In-Person Proofing Forms: You must complete a PKI Certificate In-Person Proofing Form (IPP) for each DEO and each CO and each TRA that is created OR recovered. Block 5: Enter the DEO's, CO's, or TRA's full name, the organization name and address, the correct e-mail address. Block 6: Enter the DEO's, CO's, or TRA's Government-issued photo ID for identity authentication in the space provided. Acceptable forms of identification are: State Driver’s License, Military ID, U.S. Passport or U.S. Government Work ID. If the request is approved, check the “approved” box. If the user provides ID that is not in agreement with the PKI form (name changed) or has expired, check the “rejected” box and provide the reason. If request is rejected contact your servicing RFC for further instructions. Indicate whether the User is an Employee or Contractor by checking the appropriate box. Note: Remember to make a copy of the ID (front and back) for the servicing RFCs files. Block 7: Subscriber (DEO, CO, or TRA) must sign, date and put the time in this block. Block 8: Enter the information of the TRA that performed the IPP. Please remember to indicate whether the User is an Employee or Contractor by checking the appropriate box. 3.17.221.11 (01-01-2012) Revenue Receipts The following section defines procedures for processing revenue receipts. 3.17.221.11.1 (11-02-2017) General Information The Master File Report of U.S. Internal Revenue Receipts generated monthly is balanced to a worksheet with cumulative revenue receipts data. The data for the area offices is furnished to each Submission Processing Campus via Control D. (180-40-011 for BMF and 480-55-011 for IMF) Revenue receipts are defined as any current prejournalized input amounts with a valid document code except 45, 48, 51, 58 or 34 and with a current fiscal year DLN control date. (See Exhibit 3.17.221-10) The report period begins October 1 each fiscal year and is cumulative through September 30. Revenue receipts reported are selected by DLN control date, which is the date of deposit or reclassification. Revenue receipt Document Locator Numbers (DLN) with control dates before the report period (October 1) are not accumulated for report purposes. Revenue with control dates from October 1 to the end of the current Report month are accumulated as "current." Revenues with control dates following the end of the current month report are accumulated as "future." During special 13th Month Supplemental processing (first two cycles in fiscal year for Submission Processing Campuses), revenue receipts will accumulate as current for the previous fiscal year for report purposes. Submission Processing Campuses will furnish special 13th Month RRCS in addition to the regular paperwork. The report month cutoff is determined by the S107 Date. In the 460-02, the S107 date determines whether a receipt is to be classified as current or future money. The S107 date is the Julian Date of the last day of the month. The S107 cycle is the campus production cycle that contains the last campus production date of the month in accordance with the cutoff cycles listed in IRM 3.17.30.14.1.1, Accounting and Data Control, SC Data Controls, Reports Cycle Cutoff Dates. The report month cutoff (see cycle cutoff chart in IRM 3.17.30.14.1.1) is determined by the last day of the month as it falls in the last campus production cycle of the month. Beginning in processing year 2012, the GMF campus production cycle starts on a Thursday and ends on a Wednesday with the final transfer of Tape Edit Processor (TEP) data to Master File on Thursday. If a holiday falls on a Thursday during the last cycle, the final transfer day will be Wednesday. Exception: If the last campus production day of the month falls on a Thursday, the cutoff cycle will be set to the prior cycle. For example: in May 2012, May 31 fell on a Thursday which started campus production cycle 2012/24. Therefore, the cycle cut-off for the month of May was set to the preceding cycle 2012/23. For Supplemental processing at the end of the fiscal year, two cycles of inputs to the 460-02 are run manually with the S107 card and the Computer Paragraph (CP) 23 card reflecting the last reports cycle of the year. This is done in order to pick up money for the report and place in the correct category, current or future. See Reports Cycle Cutoff Date Chart in IRM 3.17.30.14.1.1, Reports Cycle Cutoff Chart. Revenue receipts controls received on-line from the Submission Processing campuses include: Revenue Receipts Control Sheet, (RRCS) (SCF1340) Nullified Unpostables RRCS (GUF5342) EFTPS (CMS2340) - Ogden Only 3.17.221.11.2 (01-01-2015) Balancing Revenue Receipts To ensure that revenue receipts retain the balances accepted from the Submission Processing Campuses, ECC will monitor the flow of revenue data through the Automated Data Processing (ADP) system from receipt of Submission Processing Campus TEP transactions through the Revenue Receipts Control Sheet, 180-35 (BMF), 480-35 (IMF), for each cycle. Any imbalance or processing discrepancy will be reported using IRWorks. Note: This balancing routine is performed weekly for BMF and daily for IMF. Automated Data Processing (ADP) system performs a balancing routine that identifies if there are any out of balances between the SCF1340 RRCS submitted by the SP Campuses and the 480-35 and 180-35 generated at Master File. The SCF1340 is a control report that categorizes pre-journalized money transactions submitted by the Campuses for posting at Master File accounts. The categories include current revenue receipts, future revenue receipts and non-revenue receipt monies based on the Julian Date of the DLN in consideration with the month ending date of the fiscal year reporting period. The 480-35 and 180-35 categorizes these transactions by tax class based on the MFT of the account they are actually posted to at Master File. This balance must be performed to validate the transactions posted to the MFT (tax class) in conjunction with SCCF and described as a PVS responsibility under IRM 3.17.221.11.2 (5). The 480-35 and 180-35 are input to the monthly which is generated at the close of the reporting period in accordance with the report cycle cut-off chart in the IRM 3.17.30.1341.1, Reports Cycle Cutoff Chart. Note: The IMF September Supplemental processing is balanced to the 48A-35. The following are accessed to create the automated weekly Revenue Receipt Report: (See Exhibit 3.17.221-9) Revenue Receipts Control Sheet (RRCS), weekly SCF1340 BMF and Daily SCF1340 IMF. RRCS - Nullified Unpostable, GUF5342 EFTPS data, weekly control file, CMS2340 - Ogden Only Submission Processing Campus Revenue Receipt Controls (BMF only), 160-02 (See Exhibit 3.17.221-12, Exhibit 3.17.221-13 and Exhibit 3.17.221-14) Note: If a revenue receipt item is deleted by the service center it will be reported as an extra SCF1340 daily attached to the weekly SCF1340. Do not count this item when balancing as it was already deleted out of the total amount. At the beginning of the calendar and fiscal year and whenever an out of balance condition occurs, the following comparisons need to be performed: Each week print all Submission Processing campuses RRCS Grand Totals and compare these to the SC Total Summary amount on the 793-01 AAV Summary. (See Exhibit 3.17.221-11) The SC Revenue Receipt Controls, Nullified, (160-02), totals should equal the Nullified Unpostable RRCS, GUF5342, current totals. For the first cycle of the fiscal year the 160-02 will reflect a zero balance for the first cycle and for the first cycle of the calendar year, verify by tax class the totals between the Nullified 160-02 and the Nullified Unpostable RRCS, GUF5342, current tax class totals. The SC Revenue Receipt Controls, Reclassified, (160-02), totals must be offset balance between debits and credits. If not, initiate a IRWorks ticket, noting form number and tax classification the imbalance occurs in. Verify in the monthly processing of IMF and BMF 480/180-37 that the required adjustment has been made. The automated revenue receipt report performs the following steps when balancing the 35 run (180/480) summaries for each Submission Processing Campus. Summarize the current amounts from the RRCS, SCF1340, plus the nullified current amounts (reversed) from the GUF5342, RRCS - Nullified, plus the CMS2340 amounts (Ogden only). For BMF balancing, the total should equal the "Weekly Receipts Control Sheet for 160-02," (from run 180-35) total for each Submission Processing Campus. For IMF balancing, the total should equal the "Daily Receipts Control Sheet for 480-35" (from run 480-35) total for each Submission Processing Campus. For BMF balancing, the "Reclassification Control Sheet for run 160-02" totals (from run 180-35) should equal the reclassified totals from the 160-02. Also, the reclassified amounts on the 160-02 run control should always equal. The "Reclassification Control Sheet for run 160-15" (from run 180-35) should equal the reclassification amounts from the 160-15 Recap, minus the 1040 amounts. For IMF balancing, the total of 1040 amounts from the run 160-15 Recap should equal the "FUTA/IP DEBIT" from the Receipts Control Sheet for 480-35. For any imbalance, research the RRCS SCF from and to control dates and reported Revenue Receipts money amounts, deletions reflected on the MCC 793-01 AAV Summary, mathematical errors made in totals or adjustments, and error records from the 180/480 processing. If a balance is not attained, verify the items noted above in (5) a through (5) f. Annotate the RRCS totals to reflect any ECC deletion honored during the initial processing runs. Verify that document codes are revenue receipt doc codes. Attempt clarification with the Submission Processing Campus. If balance is not attained, prepare a IRWorks ticket to report the imbalance. To balance the Monthly Revenue Receipts, prepare weekly, the on-line Accounting and Operating Report for each Submission Processing Campus for identification by tax class and net total. This report is automated and captures the following data: (See Exhibit 3.17.221-15) By tax class (net) the ending balance from the prior month. (October 1 begins with zero.) By tax class (net) the Receipts Control Sheet amounts from the 35 run. By tax class any future monies from the 35 run. By tax class (net) the Reclassification Control Sheet from run 160-02 amounts from the 35 run. By tax class (net) (reversed) the Reclassification Control Sheet from run 160-15 from the 35 run. Enter any data adjustments for the month that affect the revenue receipt totals. Cycles for the month are cumulated by the program when responding to a program prompt. Note: IMF Adjustments are entered weekly by direction from SPC. Weekly, review the on-line Revenue Receipt Report to monitor the reclassification or adjustments by tax class between runs 160-55-15, 180-35-13, and 160-43-25. (See Exhibit 3.17.221-16) Any difference should be reported by opening a IRWorks ticket. 3.17.221.11.3 (11-02-2017) Problem Reporting Imbalance conditions that affect all Submission Processing Campuses due to program or system trouble and complex situations unique to a Submission Processing Campus should be reported to the SP Headquarters Policy Analyst, as well as the Enterprise Service Desk (ESD) at 1-866-743-5748, option 2. ESD will assign the ticket to the appropriate IT Service Provider for resolution. The Headquarters RACS Team should be contacted at os.cfo.fm.a.s.revenue.systems.raec.section@irs.govfor all situations related to RRACS processing of assessments and refunds. 3.17.221.11.4 (01-01-2012) Revenue Receipt Adjustments Any adjustment to revenue receipts that changes what was sent to ECC or that will affect balancing for the current or subsequent month should be reported to the affected Submission Processing Campus. 3.17.221.12 (01-01-2012) General Ledger Reconciliation With Form 6168 This section outlines verification procedures and the reporting requirements of Form 6168, General Ledger Reconciliation. 3.17.221.12.1 (01-01-2012) Verification Procedures At the close of each month, the Submission Processing Campus will prepare Form 6168, General Ledger Reconciliation with ECC RACR. This form should be completed and forwarded to ECC by the 15th of the month following the report month. An original and copy of the BMF and the /IMF RACR will be sent on a weekly and monthly basis by the SPCs to ECC. ECC will verify the correctness of the debit and credit amounts for each reconciling item shown. (See Exhibit 3.17.221-23 ) Verify the entries listed under "Entries posted to RACR." These amounts will normally refer to the last Submission Processing Campus Recap, or Accounts Register, which the Submission Processing Campus had not processed at the time the Form 6168 was prepared. These items are checked to insure correct reference to the applicable RACR and to preclude duplication of previously reported data. The Submission Processing Campus will identify entries under "Entries Posted to General Ledger" as items processed and journalized by the Submission Processing Campus but not posted to the RACR. Questionable or problem entries will be identified by an asterisk (*) in the Action column. Aged reconciled entries from the previous month should be identified by an asterisk (*). Processing Validation will verify receipt of the media transactions identified by the Submission Processing Campus to insure the media is received and processed by ECC. Differences noted will be identified by an asterisk. ECC will annotate the cycles in which the data was processed. Contact the Submission Processing Campus for any item with an asterisk and coordinate to resolve the differences for entries reported the second time. Annotate on the reverse side of the Form 6168, the date, name and phone number of Submission Processing Campus contact, and caller's initials. Annotate for follow-up action required on unresolved differences. 3.17.221.12.2 (01-01-2010) Reporting Requirements Within ten (10) workdays after receipt of and balancing the last Form 6168, General Ledger Reconciliation with ECC RACR, PVS will fax or e-mail any problem identified and not resolved to the RACS Team at Headquarters. The Form 6168 should be balanced by PVS within five workdays for the weekly IMF RACR and within 10 days for the monthly/IMF and BMF RACR. The file of original copies received from the Submission Processing Campuses will be maintained at ECC. 3.17.221.13 (01-01-2010) Deletion Operations This section outlines deletion procedures. 3.17.221.13.1 (01-01-2010) General Requests for deletions are normally received in the Master File Scheduling from a Submission Processing Campus, Headquarter's Office, or ECC IBM Support Branch. Two types of deletion requests are: Generalized Mainline Framework (GMF) deletion Resequence file deletion request (reject) Requests for deletion may also be initiated by Master File Branch (MFB), to correct stoppage problems in production runs. 3.17.221.13.2 (01-01-2010) Generalized Mainline Framework (GMF) Deletions Requests for deletes from the Submission Processing Campuses will not be honored. 3.17.221.13.3 (01-01-2010) Resequence File Deletions Resequence file deletions (Rejects) are requested by Headquarters or ECC Mainframe Operations Branch via telephone, memorandum, or facsimile. These are rejected during processing of BPW/IPW 02 runs. These reject requests will be verified by the on-line Computing Center Journaling System (Info Notes). When the run controls indicate a Block Out of Balance (BOB) or rejected record, prepare a IRWorks to identify the rejected data. Rejected items will be used in balancing the BPW/IPW 02 run. Prepare DAV to notify the Submission Processing Campus of the reject. Explain action to be taken by the Submission Processing Campus. Attach a copy of the reject transaction to the DAV. Rejected records that contain money amounts must also be reported on the RACR. 3.17.221.14 (01-01-2010) Release and Certification of Magnetic Tape Files This section defines and outlines procedures for the release and certification of magnetic tape files. 3.17.221.14.1 (01-01-2010) General Computer production runs at ECC are audited by the Processing Validation Section for correctness and completeness of the data produced by the run. 3.17.221.14.2 (01-01-2010) Releasing Procedures Whenever a control file is converted to electronic transmission via Network Data Mover (NDM) or Control D, ECC will no longer provide a paper document. Each Submission Processing Center upon receipt of the electronic transmission will be responsible for the distribution of the control data. 3.17.221.15 (01-01-2010) Tax Return Database (TRDB) This section provides information pertaining to the Tax Return Database (TRDB). The TRDB is the official repository of record for all electronically filed returns. TRDB jobs are systemically validated via LARS counters in run-to-run. No manual balancing is required. 3.17.221.15.1 (01-01-2010) TRDB Processing ECC control and accountability for the TRDB begins with the acceptance of Submission Processing Campus data. Input files to TRDB processing are: ELF-10-004 MGT-15-007 EFS-55-003 ERS-01-005 ERS-05-007 ELF-15-003 ETD-68-003 ETD-69-004 EFS-33-002 AMS-03-014 793-01-021 GUF-51-108 ERS-08-001 EFS-55-003 EFS-10-017 ELF-61-020 ELF-61-018 The files are electronically transmitted (EDT'd) to ECC daily and should be transmitted by 6:00 p.m. EST Monday through Saturday. The exception is the AMS-03-014 file, which is received weekly. The initial acceptance of submission processing data is acknowledged with AAV's from the following runs: 793-0A 793-3A 793-4A 793-5A 793-6A 793-7A 793-8A 793-9A 793-1B 793-2B 793-AA 793-BA 793-CA 793-DA 793-EA The following is a breakdown of acceptance voucher runs by Submission Processing Campus input to the initial ECC input runs: 793-0A, ETD-68-003, RDB-GC 943-A, ELF-10-004, RDB-E0 793-4A, MGT-11-007, RDB-XX 793-5A, EFS-55-003, RDB-X1 793-6A, ERS-01-005, RDB-K0 793-7A, ERS-05-007, RDB-K1 793-8A, ELF-15-003, RDB-G9 793-9A, ETD-69-004, RDB-GA 793-1B, EFS-33-002, RDB-W1 793-2B, AMS-03-014, RDB-60 793-AA, EFS-10-017, RDB-XM 793-BA, ERS-08-001, RDB-C3 793-CA, GUF-51-018, RDB-CA 793-DA, ELF-61-020, RDB-A0 793-EA, ELF-61-018, RDB-A1 3.17.221.15.2 (01-01-2010) Daily Processing PVS will verify the input of the Submission Processing Center data to Control D. Any discrepancies identified will be addressed via a IRWorks ticket. Output data files from the input runs listed above are reformatted and subsequently loaded to the TRDB. Exhibit 3.17.221-1 SC Trans Release Summary (Other) GMF1545 Shown is the SC Trans Release Summary, Other Total Summary page. The report is comprised of two rows. The first row lists from left to right the following: RECORD COUNTDOCUMENT COUNTPJ CREDITSPJ DEBITSNET PJ AMOUNTThe second row lists the following under the BLOCKS TO BE DELETED AT MCC heading: BLOCK-DLNPRIOR DOC STATUS CODEDOCUMENT COUNTRECORD COUNTPJ CREDIT/DEBITTRANS-TAPE SEQ-NUMPAGE-OF LIST Please click here for the text description of the image. Exhibit 3.17.221-2 SC Trans Release Summary (ELF Total Summary) GMF1545 Shown is the report identified in the text. The following information is listed on the report:The heading lists from the top left Data Set, Date, Time, Page, Report Name and Number.The body of the report lists from left to right:RECORD COUNTDOCUMENT COUNTPJ CREDITSPJ DEBITSNET PJ AMOUNT Please click here for the text description of the image. Exhibit 3.17.221-3 SC Revenue Receipts Control Sheet SCF1340 This exhibit shows the report cited in the text. The report has a common header for each of the Master Files listed (i.e., IMF, BMF, NMF), the following information is listed from left to right: DATA SETDATETIMEPAGEREPORT NUMBERTitle of the report and SPC identifiedCycle date and WeeklyFrom and To Julian datesThe body of the report lists the following information from left to right: Tax ClassCurrent Debit and Credit columnsFuture Debit and Credit columnsOther Prejournalized Debit and Credit columnsThe bottom of the report body has summary information listed from left to right: Total Recordshigh and low DLN DatesGrand Total DebitsGrand Total Credits Please click here for the text description of the image. Exhibit 3.17.221-4 Revenue Receipts Control Sheet Nullified Unpostables GUF5342 This exhibit shows the report cited in the text. The report has a common header for each of the Master Files listed (i.e., IMF, BMF, NMF), the following information is listed from left to right: DATA SETDATETIMEPAGEREPORT NUMBERTitle of the report and SPC identifiedCycle date and WeeklyFrom and To Julian datesThe body of the report lists the following information from left to right: Tax ClassCurrent Debit and Credit columnsFuture Debit and Credit columnsOther Prejournalized Debit and Credit columnsThe bottom of the report body has summary information listed from left to right: Total Recordshigh and low DLN DatesGrand Total DebitsGrand Total Credits Please click here for the text description of the image. Exhibit 3.17.221-5 Form F9607-A, Controls Register (IMF) Shown is the report cited in the text. This is the first page of a four page report. It contains the following column headings from left to right with information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the second page of a four page report. It contains the following column headings from left to right with information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the third page of a four page report. It contains the following column headings from left to right with information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the fourth page of a four page report. It contains the following column headings from left to right with information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is a remarks page of the Controls Register Report, it lists processing or balancing remarks in paragraph format for various computer runs. Please click here for the text description of the image. Exhibit 3.17.221-6 Form F9607, Controls Register (BMF) Shown is the report cited in the text. This is the first page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the second page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the third page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the fourth page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the fifth page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Shown is the report cited in the text. This is the sixth page of a six page report. It contains the following column headings from left to right with the information listed in rows: POSTED BYPOSTED DATEJOB RUN FILE NUMBERBATCH AND CYCLECREATION DATEFIRST REEL NUMBERSEQ TOTFILE DESCRIPTIONITEM COUNTS - RRCS IN, INSERT, DELETE, RRCS OUTDEBIT AMOUNTCREDIT AMOUNTREMARKS Please click here for the text description of the image. Exhibit 3.17.221-7 Run 460-02 Total Output Transactions Control Shown is the report cited in the text. The head portion of the report lists the Title and run number, Cycle, Runs, and Date. The body of the report has the following columns populated with data in rows: OUTPUT FILERECORD COUNTPRE-JOURNALIZED DEBITSPRE-JOURNALIZED CREDITSThe total of the above is followed on the next row with BALANCE TOTALS TO RUN 460-43, with the same columns populated and the feeding runs listed under the OUTPUT FILE column. Please click here for the text description of the image. Exhibit 3.17.221-8 Form M4496, Data Adjustment Voucher Shown is a Data Adjustment Voucher. The top portion of the voucher has the Cycle , date, SPC address, From line and Subject line. This is followed by four more boxes listed below: DESCRIPTION (type of DAV)EXPLANATION (TYPE OF PROBLEM)RECOMMENDED ACTIONEffective date of posting to RACR, Signature box, and telephone number Please click here for the text description of the image. Exhibit 3.17.221-9 Revenue Receipt Report Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. There are 3 rows identifying the following: Total Reclassified Debit and Credit amountTotal Reclassified Debit and Credit amountBalance Debit and Credit amount Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. The note indicates that the figures are not represented on the final page of the report. There are three rows identifying the following: Total Current + Future FTD Debits and CreditsTotal PJ/FTD Debits and CreditsBalance Debits and Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report with the cycle and report title at the top of the report. From left to right the following header categories are listed: Data Set NameService CenterFuture DebitsFuture Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report with the cycle and report title at the top of the report. From left to right the following header categories are listed: Data Set NameService CenterCurrent DebitsCurrent Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. The note indicates that the figures are not represented on the final page of the report. There are four categories listed from left to right: Data Set NameService CenterReclass DebitsReclass Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. The note indicates that the figures are not represented on the final page of the report. There are four categories listed from left to right: Data Set NameService CenterReclass DebitsReclass Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. The note indicates that the figures are not represented on the final page of the report. There are four categories listed from left to right: Data Set NameService CenterReclass DebitsReclass Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report with a note below the title. The note indicates that the figures are not represented on the final page of the report. There are four categories listed from left to right: Data Set NameService CenterReclass DebitsReclass Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are four categories listed from left to right: Future FTDService CenterFuture DebitsFuture Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are four categories listed from left to right: Future FTDService CenterFuture DebitsFuture Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are four categories listed from left to right: Current FTDService CenterCurrent DebitsCurrent Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are four categories listed from left to right: Data Set NameService CenterCurrent DebitsCurrent Credits Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are three categories listed from left to right: Submission Processing CentersFuture BMF Debit BalanceFuture BMF Credit Balance Please click here for the text description of the image. Shown is a Revenue Receipt Report. The report has the cycle and a title at the top of the report. There are three categories listed from left to right: Submission Processing CentersCurrent BMF Debit BalanceCurrent BMF Credit Balance Please click here for the text description of the image. Exhibit 3.17.221-10 Document Locator Number Format Shown is a DLN with each part of the number identified as follows: FLC - first two numbersTax Class - third numberDoc. Code - fourth and fifth numberJulian Date - Sixth through eighth numberBlock Series - ninth through eleventh numberSerial Number - Twelfth and thirteenth numberList Year - fourteenth number Please click here for the text description of the image. Exhibit 3.17.221-11 ECC Trans Release File Acceptance Voucher Summaries (793-01) Shown is an Acceptance Voucher. The top of the voucher from left to right is the Service Center, Title of the voucher, Cycle, and date. Six columns are listed from left to right as follows: WRK GRP and Run ControlsRECORD COUNTSDOCUMENT COUNTSTOTAL PJ CREDITSTOTAL PJ DEBITSNET PJ AMOUNTS Please click here for the text description of the image. Exhibit 3.17.221-12 Run 02 Primary SC Revenue Receipt Controls Shown is a Run 02 Revenue Receipt Control. The top of the report identifies the Submission Processing Center, title, cycle, and date. Listed in the report are five columns listing the following data: Primary - Form numberCurrent - DRCurrent - CRFuture - DRFuture - CR Please click here for the text description of the image. Exhibit 3.17.221-13 Run 02 Reclassified SC Revenue Receipt Controls Shown is a Reclassified Revenue Receipt Control. Across the top of the report the Submission Processing Center, report title, cycle, and date are listed. The report has three columns listing from left to right, the following: Form type, by form numberMoney columnMoney column Please click here for the text description of the image. Exhibit 3.17.221-14 Run 02 Nullified SC Revenue Receipt Controls Shown is a Nullified Revenue Receipt Control. Across the top of the report the Submission Processing Center, report title, cycle, and date are listed. The report has three columns listing from left to right, the following: Form type, by form numberMoney columnMoney column Please click here for the text description of the image. Exhibit 3.17.221-15 Accounting and Operating Report Shown is the Accounting and Operating Report identified in the text. The top of the report lists from left to right, Recap, title, and cycle. Listed by Submission Processing Center are money amounts in the following categories: CUM FORWARDFUT FORWARDCYCLE - current cycleADJUSTMENTSMANUAL TOTALS Please click here for the text description of the image. Exhibit 3.17.221-16 PVS BMF Revenue Receipts Report Shown is a Revenue Receipts Report as identified in the text. Across the top of the report, listed from left to right is the cycle, report title, Submission Processing Center, and date. There are five columns listing money in rows by tax class: TAX CLASSThree different runs listed in three columnsDIFFERENCES Please click here for the text description of the image. Exhibit 3.17.221-17 Reciprocal Accounting Control Record Shown is the RACR with the rows listed in the same order as the text describing what goes in the report. Not identified in the text, the top of the report has this information listed from left to right as follows: DATE OF ENTRYFILE NUMBERCYCLEDATEREEL NUMBERDEBITSCREDITSNET BALANCE (CREDITS)DESCRIPTION Please click here for the text description of the image. Shown is the second page of the RACR. The top of the report identifies the following from left to right: Master FileReport titleSubmission Processing CenterThe report identifies the following in rows from top to bottom: 1098's1185UCC'SREC'SPOC'SLP'S Please click here for the text description of the image. Exhibit 3.17.221-18 Reconciliation of Master File Balance, Computer Form 5198A Shown is the Reconciliation Of Master File Balance as identified in the text. The top of the report has the following information from left to right, Master File, title of the report, Cycle Number and Week Ending date. The next row down has the following columns from left to right: Service Center - Code and SymbolsRACR - Net Balance DR/CRAdjustments in Process - Net Balance DR/CRResequenced Please click here for the text description of the image. Exhibit 3.17.221-19 Reconciliation of Master File Balance, Form 5198A Shown is the Reconciliation Of Master File Balance as identified in the text. The top of the report has the following information from left to right, Master File, title of the report, Cycle Number and Week Ending date. The next row down has the following columns from left to right: Service Center - CodeTC 388 and 389 - Net Balance DR/CRTransactions Pending - Net Balance DR/CRAdjustments in Process - Net Balance DR/CRResequenced PJ Transactions - Net Balance DR/CRAccounts Register OMB Data Please click here for the text description of the image. Exhibit 3.17.221-20 Run 63 Resequence Controls Shown is a Resequence Control. The top of the report lists from left to right the name of the report, run and project numbers, cycle, and date. The body of the report lists from left to right, the Submission Processing Center, record count, debit and credit amounts and total amount. Please click here for the text description of the image. Exhibit 3.17.221-21 Run 43 Recap of Assessments, Abatements, and Other Post-Journalized Transactions Shown is a Recap report identified in the text. The top of the report lists from left to right, the Submission Processing Center, run number, report title, cycle, and date. The following columns are populated with data for the following categories, OIC Write off, Outstanding Module Balances, and Schedule H Adjustments. The column headers are: Tax ClassItem CountAmountJournalization Requirements Please click here for the text description of the image. Exhibit 3.17.221-22 Run 15 Controls Shown is the Run 15 Control report. It has two sections of data reported. The top section has columns listing the following: Active Opening BalanceRecord CountDebitsCreditsTotalsThe following data is listed under the columns: PJ and Post Journalized ItemsUnpostable PJ, Resequence PJ, and Resequenced ModulesActive, Inactive, and Total BalanceThe second section of the report are the Entity Controls. This section reports beginning balances and additions and deletes which provide the ending balance. The counts are only record counts Please click here for the text description of the image. Shown is a continuation of Exhibit 22. See exhibit 27 for explanation of report. Please click here for the text description of the image. Exhibit 3.17.221-23 General Ledger Reconciliation with ECC RACR, Form 6168 Shown is a F6168 as described in the text. The report has an upper and lower section. The upper section from left to right has the following headers: Entries Posted to the RACR, (Not posted to the General Ledger)ActionGeneral Ledger Balance - DebitGeneral Ledger Balance - CreditCredits VerifiedECC VerificationThe next section is for Age Reconciled with the following headers listed left to right:Age ReconciledActionDebitsCreditsECC VerificationThe lower section of the report from left to right has the following headers: Entries Posted to the General Ledger (Not posted to the RACR)ActionDebitsCreditsECC VerificationThe next section is for Age Reconciled with the following headers listed left to right:Age ReconciledActionDebitsCreditsECC VerificationThe following lines are total lines and listed vertically as follows:Total Reconciled Adjustment to Subsidiary RACRAged Reconciled Adjustment to SubsidiaryNet Reconciling Amounts reconciled and aged reconciled - Total adjustments to RRACS and SubsidiaryUnreconciled items TotalEnding RACR Balance TotalEnding balance from the RACRDifference between Ending RACR balance and Ending balance from the RACR - DifferenceThe last line is prepared by digital signature and verified by digital signature. Please click here for the text description of the image. Exhibit 3.17.221-24 Secure Payment System Schedule Shown is a SPS Schedule print as identified in the text. This schedule has four sections. The top section lists the following information: TitleUser nameTime and date of the printThe second section has the following information: ALCNumber of PaymentsDEST RFCSchedule number and money totalAgency Information (address and telephone number)The third section lists the following information: Last DEO action detailsActionNameTime and dateLast DEO action detailsActionNameTime and dateThe fourth section has the following information: Requested payment dateSummary Type CodeControl numberSub-type CodeAccount Symbols and Account Symbol amountRemarks sectionCO comment section Please click here for the text description of the image. Exhibit 3.17.221-25 Form 9633, File Search Request Shown is a File Search Request as identified in the text. This form shows a request from the Chief, PVS to a System point of contact at ECC requesting taxpayer information. There are boxed to check off indicating the Master File and type of request (transcript, Regular Print). Below this area are boxes to check off showing SSN or EIN and Reason for request. The bottom of the report has an area for the authorizing official to sign and date the request. Please click here for the text description of the image. Exhibit 3.17.221-26 BPW and IPW Refund Report Shown is a BPW Refund Report as identified in the text. It lists Regular, Accelerated, and BMF EFT refunds with the following information listed in each of these categories: TO BE PAIDPRINCIPALINTERESTTOTALITEMS Please click here for the text description of the image. Shown is the IPW Refund Report as identified in the text. This report lists refunds this cycle, refunds this year, refundable credits, reversals, and EFT to be paid. Under these categories the following information is listed: COUNTPRINCIPALINTERESTTOTAL Please click here for the text description of the image. Exhibit 3.17.221-27 ECC Trans Release File Acceptance Voucher Summaries Shown is an Auto Acceptance Voucher as identified in the text. The following are columns filled with data from left to right: Reel number and work groupRecord CountsDocument CountsTotal PJ CreditsTotal PJ DebitsNet AmountUnder each work group column are the revenue receipt actions that occur in processing. Please click here for the text description of the image. Exhibit 3.17.221-28 EFTPS Revenue Receipts Control Sheet Shown is a Revenue Receipt Control Sheet described in the text. The sheet lists the cycle and julian dates of the data. The data is listed by tax class in row format listing the following data : Current - Debit, CreditFuture - Debit, CreditPrior - Debit, CreditAt the bottom of the sheet Total Records, Debit and Credit Grand Totals are listed. Please click here for the text description of the image. Exhibit 3.17.221-29 EFTPS Revenue Receipts Control Sheet Shown is a BMF Revenue Receipt Control Sheet as identified in the text. The layout of this report is the same as Exhibit 29. Please click here for the text description of the image. Shown is an IMF Revenue Receipt Report as identified in the text. This report lists the Cycle and Julian Date Range of The data. There are three columns listed with no data listed under them. The headers are: CURRENTFUTUREPRIOR Please click here for the text description of the image. Exhibit 3.17.221-30 Designation for Certifying Officer Form Shown is the Designation for Certifying Officer Form as identified in the text. The form has seven sections. The first section has areas to fill out listing the ALC, new or renewal designation, and certification functions authorized. The second section lists the name, address, phone number, and effective date of the Designee. The third section has four blocks for the Designee to sign their signature in each of the blocks. The fourth section is for the Designator to sign their signature and list their title and organization. The fifth section has a box for the Designator to check revoking the Designee's authorization. The sixth section lists the Designator's return address and phone number. The seventh section lists the regional Financial Centers (RFC) with a box next to each to be checked off indicating the RFC the Certifying Officer will certify to. Please click here for the text description of the image. Exhibit 3.17.221-31 PKI Certificate Action Request Shown is the first page of the PKI Certificate Action Request identified in the text. Three boxes are listed. The first box has boxes to check off indicating access to SPS. The second box has boxes to check off indicating what had occurred that requires the subscriber to request recovery of their PKI Certificate. The third box has check off boxes for reasons to revoke the PKI Certificate. Please click here for the text description of the image. Exhibit 3.17.221-32 PKI Certificate Action Request Shown is the second page of the PKI Certificate Action Request identified in the text. There are three sections on this page. The first section is for Subscriber/ Certificate Holder information. The individual lists their name, organization, E-mail address, and phone numbers. The second section is to be filled out by the Nominating Official/ Requestor. The individual lists their name, title, organization, address, and phone numbers. The third section is for the RA/LRA/TRA to list their name, organization, E-mail, and phone number. Please click here for the text description of the image. Exhibit 3.17.221-33 Delegation of Authority Form Shown is a Delegation of Authority Form as identified in the text. The form has seven sections. Section one has boxes to check Delegating or Re-delegating various positions of authorization. Section two is to be populated with the individual's name, title, organization, phone number, and effective date. Section three is for the Designee to sign their signature four times. Section four is for the Delegator's signature, name, title, and organization. Section five has a box to check for revoking a Designee's authorization. Section six is for the return address of the Delegator. Section seven is to be completed by BFS. Please click here for the text description of the image. Exhibit 3.17.221-34 Designation for SPS Data Entry Operator Form Shown is the Designation for Data Entry Operator Form. The form has seven sections. The first section is to filled in indicating this is a designation or re-designation and the ALC. The second section is to be filled with the designee's name, title, organization, phone number, and effective date. The third section has four boxes for the designee's signature. The fourth section has a box for the designator's signature, name, title, and organization. The fifth section has a box to check if the designee's authority is revoked. The sixth section is to be filled with the designator's return address. The seventh section has RFCs listed with accompanying boxes to check off indicating where the disbursing office will be. Please click here for the text description of the image. Exhibit 3.17.221-35 ECC TRANS RELEASE ACCEPTANCE VOUCHER SUMMARIES (793–04) Shown is an ECC Trans Release Acceptance Voucher. The top of the voucher has the following listed from left to right: Submission Processing Centervoucher titleMaster FileCycleDateThe voucher has six columns populated with the data. The columns are: REEL NUMBER AND WORK GROUPRECORD COUNTSDOCUMENT COUNTSTOTAL PJ CREDITSTOTAL PJ DEBITSNET PJ AMOUNTSListed in the first column are five workgroups with the following inventory status, listed: SUMMARYDELETESNULLIFIEDTOTALSCORRECTEDPURGEDRECLASSR R TOTAL Please click here for the text description of the image. Exhibit 3.17.221-36 GRAND TOTAL SUMMARY Shown is a Grand Total Summary as identifies in the text. The top of the Summary has the following across the top of the report: Run numberTitleDateThere are columns in the report with data entered in rows, the columns are: RECORD COUNTDOCUMENT COUNTPJ CREDITSPJ DEBITSNET PJ AMOUNTThe rows have the following computer runs listed: SCCF RELEASEDELF TEP RELEASEDOTHER TEP RELEASEDRELEASED ADJUSTMENTSNULLIFIED UNPOSTABLESCORRECTED UNPOSTABLESRECLASSIFIED UNPOSTABLESPURGED UNPOSTABLES Please click here for the text description of the image. Exhibit 3.17.221-37 IMF MAINLINE SUMMARY Shown is the IMF Mainline Summary as identified in the text. The Summary is identical to the Exhibit number 42. Please click here for the text description of the image. More Internal Revenue Manual