Processing Closeout Adjustments Date: Tue, 16 Sep 1997 11:50:20 -0400 To: "AO - All Administrative Officers" From: "Alice A. Sabatini, Division Administrative Officer" Subject: Processing Closeout Adjustments Mime-Version: 1.0 Content-Type: text/enriched; charset="us-ascii" In Reply Refer To: Mail Stop 442 August 18, 1997 MEMORANDUM In Reply Refer To: Mail Stop 442 September 15, 1997
MEMORANDUM
To: Administrative Officers From: Alice A. Sabatini Division Administrative Officer, Water Resources Division Subject: Processing Closeout Adjustments
REPLY REQUIRED BY OCTOBER 11, 1997
All offices received specific division policy and procedural guidance on closeout in the memorandum, subject: Fiscal Year 1997 Closeout Instructions, dated August 18, 1997. This memorandum provides additional instructions on processing closing adjustments. Because all offices are using remote data entry into the Federal Financial System (FFS) to record payments, accruals and obligations, we will also use this method to process closeout adjustments. Offices are also required to enter adjustment data into the Administrative Information System (AIS) in order to produce the Adjustment Drawdown Report. This should not require much additional work because we do not anticipate that cost centers will have many adjustments this fiscal year. Payroll data for pay period 21 will be entered as actual; pay period 22 data will be automatically entered into FFS as a projection for basic salary costs and related benefits for Sunday, Monday, and Tuesday, September 28 through 30, 1997. This projection is 20% of the actual salary costs recorded in the basic salary object classes for pay period 21. (Refer to the OFM closeout memorandum for specific instructions on which object classes must be manually accrued because they will not be projected.) Adjustments to projected payroll costs for Sunday, September 28, 1997, Monday, September 29, 1997, and Tuesday, September 30, 1997, must be processed as accrued expenditures. You are reminded that the deadline for the electronic submission of closeout adjustments is tentatively scheduled for close of business Friday, October 10, 1997. Copies of documentation to support all adjustments should be sent via express mail to be received by the Headquarters office no later than noon, Saturday, October 11, 1997. Please make sure to indicate that Saturday delivery is required on your air bill and list Kelly Bradley at 703-648-5040 as the contact person. All adjustments must be entered into the Federal Financial System (FFS) using Remote Data Entry (RDE) and processed with a "H" in the action field. All documents must also be entered into the AIS and transferred electronically to Headquarters. A hard copy of the AIS Adjustment Drawdown Report and supporting documentation must also be mailed. Transactions that are not entered in both FFS and the AIS will not be processed. It is recommended that adjustments be transferred to Headquarters daily from the time that cost centers begin to populate entries in the AIS. Only the last file sent will be used. Remember that the FFS balances are the official numbers--adjustments MUST be made to correct FFS to agree with your local records (AIS). The following are detailed instructions for entering and transferring closeout adjustments to Headquarters. A. Entering Documents in the FFS Offices should be identifying items that require adjustment and entering adjustments into the Federal Financial System via Remote Data Entry. After October 6, 1997, the 4P, 4V, 4I, and 4N documents will no longer be available for use in fiscal year 1997. All transactions previously recorded using these document types should now be recorded using one of the accrual documents (4A, 4C, 4U, 4B, 4D). All documents recorded in FFS after October 6, 1997, can be processed only with an "H" in the action field. The "H" applies a hold in the FFS and will require further approval and processing by the Financial Operations and Reporting Section before it is posted. These document types include 4M, 4O, 4A, 4C, 4U, 4B, 4D, 4S, and 4J. >From October 7, 1997 through October 24, 1997, FY 1998 Remote Data Entry (RDE) payment and obligation transactions (4P, 4V, 4R, 4B, 4D, 4M, 4O, 4T, and 4I) can be entered into FFS. (Please note: when entering FY 1998 transactions, the receipt date field for Bankcard accruals (4B) must have an October date and the draft date field for Third part draft must have an October date, otherwise FFS will post it to FY 1997.) From October 25, 1997 through October 28, 1997, offices will not be able to process documents. Starting October 29, 1997, documents can be entered and processed in FFS. For further information, please refer to Attachment 6 in the Fiscal Year 1997 Close-Out Procedures, from Tim Calkins, OFM, dated July 23, 1997. B. Entering Documents in the AIS The preliminary and adjusted balance frame can be accessed via the main window frame by selecting Preliminary Balance from the function list field, by typing Preliminary Balance in the execute entry field or by using the cascading menu bar in the following sequence: expense->closeout->closeout adjustments->preliminary balance. The preliminary and adjusted balance frame should be used to enter account number balances as shown in the net balance available column on the Federal Financial System (FFS) Report 286A (Net Monthly Summary of Project and Customer [FPCA]) for the month ending September. This balance file needs only to be populated at the account level, since we do not fund at the subaccount level in the FFS. For example, if a cost center's preliminary Report 286A shows an ending balance of -2,000.00 for the 00100 account, that is the amount that the user would add to the preliminary balance file. ONLY THE NET BALANCE AVAILABLE SHOULD BE ENTERED. The burden earned will be recomputed after adjustments are processed. These preliminary balances will be used on the Adjustment Drawdown Report and by AIS frames in calculating the adjusted account balance. To enter preliminary balances in AIS: Change mode to insert by using the pull down menu bar, clicking on edit and then clicking on edit/insert or by using the accelerator command Alt-i. After changing the mode, the balances for each account number should be entered. Key in fiscal year, account number and preliminary balance (which is the net ending balance as shown on the September FFS Report 286A). The adjustment balance is a system calculated value. If the auto-save is on, the data will be saved when the user tabs or enters past the last data entry field. If auto-save is not on, the data should be saved after each account number balance entry is completed. After preliminary balances are entered for all accounts, review the data in the table field for accuracy. The preliminary balances should be compared to the FFS Report 286A net available balance. Change the mode to edit, query the account numbers that are inaccurate, make changes, and save the data. After ensuring accurate entry, close the frame or iconify it for later use. ***If the net amount authorized on the Report 286A does not agree with the AIS assessment report, a funding adjustment must be processed. Most cost centers reported that it is easier to recalculate the net balance available prior to populating the preliminary balance file. This is done by subtracting the total encumbrances shown on the report 286A from the correct net amount authorized (taken from the AIS assessment report) to yield a corrected net balance available. Enter the corrected total in the preliminary balance file and report the funding adjustment as shown below. If a corrected preliminary balance is calculated, please highlight or asterisk the balance on the hard copy Adjustment Drawdown Report submitted to Headquarters and submit the adjustment in the format provided in the August 18, 1997 memorandum. Be sure to note the change in format and include the supporting AIS reports with your funding adjustment.*** For example: AIS shows your net amount authorized for the 00100 account as $100,000, but FFS shows the net amount authorized as $90,000. Take the net amount authorized from AIS ($100,000) and subtract the total encumbrances from the Report 286A ($99,800) to yield the corrected net balance available ($120). Enter this corrected amount in the preliminary balance file. The Account Balance Report is a summarized Adjustment Drawdown Report without the adjusted transactions. It shows the account and cost center preliminary and ending balances. Both reports can be run at any time during the adjustment process. Transferring the Adjustments to Headquarters After all adjustments have been entered into FFS and AIS (not later than close of business Friday, October 10, 1997), the AIS entries should be transferred to Headquarters. To transfer records, click on the TRANSFER TO HQ button or use the pull down menu bar under Special and click on TRANSFER TO HQ. After clicking on the button, a pop-up window will appear asking the user if it is ok to transfer adjustments for cost center XXXX and fiscal year 1997 (XXXX equals your cost center). Click on OK. In order to transfer, data must be shown in the header entry fields on the frame. After clicking on OK, the records are queued for transfer and the system message will read, "Records sent". For ease of data entry, we have left the descriptions used for the nature of adjustment last year unchanged. This will allow offices to use the AIS pull down to populate the data in this field. Offices may choose to key in the descriptions and not use the pull down examples at their discretion, but data entry must follow the examples shown below (two character code followed by a space, -, space, narrative explanation). Sample of adjustment descriptions: AE - an accrual adjustment or forgotten accrual; enter document number MO - purchase order, contract or other obligating document was not processed MO - purchase order needs to be deobligated TO - relocation travel authorization or amendment was not obligated SV - SV adjustment within the same cost center SV2 - SV adjustment involving another cost center within WRD SV3 - SV adjustment involving other Survey Division, (i.e., Geologic Division, National Mapping Division, etc.) OF - adjustments between funds PY - SV adjustment involving more than one fiscal year (i.e., a standard voucher that is correcting OFM error causing an expenditure to be charged to FY 1997 instead of the correct fiscal year) All SV (4S and 4J) adjustments must have an offsetting entry, i.e., for every debit, there must also be a credit. You should make every effort to contact the affected cost center or division to alert them to the fact that you are processing an adjustment that will affect their cost center and consequently their closing balance. It is the responsibility of the cost center receiving the credit to coordinate the adjustment with the cost center receiving the debit. Please ensure all accrual documents which do not require back up documentation have the FFS document number recorded in the description field on the AIS Drawdown Report. If you need additional information regarding the processing of closeout adjustments, please contact your Regional Administrative Officer, or Kelly Bradley (703-648-5040). ****************************************************************** * Alice A. Sabatini, Division Administrative Officer * * Water Resources Division, U.S. Geological Survey * * 442 National Center, 12201 Sunrise Valley Drive * * Reston, VA 20192 703-648-5027; fax 703-648-5295 * ******************************************************************