VI Update

USVI Public Records

A VI Update Project · Brian LoudenThe territory’s public record — kept public.

## SUMMARY RECON FORM

Collection
Government Financials
Sub-shelf
usvifinance.info (Internet Archive recovery)
Kind
Financial Report
Topics
Public Finance
Pages
2
Text
Native Text

## SUMMARY RECON FORM Government of the Virgin Islands CFDA XX.YYYY - Federal Program Name Reconciliation of ERP to Federal Reports As of September 30, 20XX Fiscal Year 20XX Expenditures Reconciliation Total Grant Federal Expenditures, per ERP 42.0 Per Federal SF269 Report(s): SF269 Q1 21.0 SF269 Q2 21.0 SF269 Q3 SF269 Q4 Total Grant Expenditures, per SF 269 Report 42.0 Expenditure Differences to be Reconciled ** 0.0 Unposted fringe benefit costs 0.0 Indirect costs not drawn from federal system 0.0 Reconciled Difference 0.0 Drawdown Reconciliation Grant Revenue Posted, per ERP 42.0 Grant Drawdowns, Federal Drawdown System 42.0 Differences to be Reconciled ** 0.0 Drawdown(s) In-Transit 0.0 0.0 0.0 Reconciled Difference 0.0 ** Differences and corrections to be explained, if necessary. ## DETAILED RECON FORM DETAILED RECONCILIATION OF FEDERAL AWARDS TO ERP SYSTEM GVI DEPARTMENT NAME: FEDERAL GRANTOR AGENCY: U.S. Department of Health and Human Services GRANT/SUB-GRANT TITLE: GRANT PROGRAM TITLE: GRANT AWARD NO: CFDA #: GRANT AWARD BUDGET PERIOD: TOTAL IND. COST RATE: 0.14 DEPT. IND. …

Download the original document · Plain text (TXT) · Browse the archive · How this archive works

Original source: https://web.archive.org/web/20110313193656id_/http://www.usvifinance.info:80/Forms/Form-DOF-Federal%20Grant%20Reconciliation.xls

SHA-256 d5903a973543654067596c3b391e00c1784450ebcf3b90b0d77a935f31247b6d

Re-using this document

Our description, tagging, arrangement, extracted text and machine transcripts are released under CC0 1.0. We assert nothing about the document itself.

Archive identifier LF-d5903a973543

Document text

## SUMMARY RECON FORM Government of the Virgin Islands CFDA XX.YYYY - Federal Program Name Reconciliation of ERP to Federal Reports As of September 30, 20XX Fiscal Year 20XX Expenditures Reconciliation Total Grant Federal Expenditures, per ERP 42.0 Per Federal SF269 Report(s): SF269 Q1 21.0 SF269 Q2 21.0 SF269 Q3 SF269 Q4 Total Grant Expenditures, per SF 269 Report 42.0 Expenditure Differences to be Reconciled ** 0.0 Unposted fringe benefit costs 0.0 Indirect costs not drawn from federal system 0.0 Reconciled Difference 0.0 Drawdown Reconciliation Grant Revenue Posted, per ERP 42.0 Grant Drawdowns, Federal Drawdown System 42.0 Differences to be Reconciled ** 0.0 Drawdown(s) In-Transit 0.0 0.0 0.0 Reconciled Difference 0.0 ** Differences and corrections to be explained, if necessary. ## DETAILED RECON FORM DETAILED RECONCILIATION OF FEDERAL AWARDS TO ERP SYSTEM GVI DEPARTMENT NAME: FEDERAL GRANTOR AGENCY: U.S. Department of Health and Human Services GRANT/SUB-GRANT TITLE: GRANT PROGRAM TITLE: GRANT AWARD NO: CFDA #: GRANT AWARD BUDGET PERIOD: TOTAL IND. COST RATE: 0.14 DEPT. IND. COST RATE: 0.12 CENTRAL SERVICE IND. COST RATE: 0.13 REVENUE BUDGET, PER SUBMISSION TO OMB REVENUE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" & FEDERAL DRAWDOWN SYSTEM REVENUE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" & FEDERAL DRAWDOWN SYSTEM REVENUE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" & FEDERAL DRAWDOWN SYSTEM REVENUE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" & FEDERAL DRAWDOWN SYSTEM EXPENDITURE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" 1ST QUARTER REVENUE RECONCILIATION ZONE 2ND QUARTER REVENUE RECONCILIATION ZONE 3RD QUARTER REVENUE RECONCILIATION ZONE 4TH QUARTER REVENUE RECONCILIATION ZONE YEAR-TO-DATE REVENUE RECONCILIATION ZONE OBJECT NO. OBJECT CLASS ORG PROJECT PERIOD 1 PERIOD 2 PERIOD 3 1ST QUARTER POSTED (ACTUALS, ERP) 1ST QUARTER POSTED (FED. SYSTEM) 1ST QUARTER (ACTUALS VS. FED. SYSTEM) 1ST QUARTER (AVAILABLE BUDGET, ERP) PERIOD 4 PERIOD 5 PERIOD 6 2ND QUARTER POSTED (ACTUALS, ERP) 2ND QUARTER POSTED (FED. SYSTEM) 2ND QUARTER (ACTUALS VS. FED. SYSTEM) 2ND QUARTER (AVAILABLE BUDGET, ERP) PERIOD 7 PERIOD 8 PERIOD 9 3RD QUARTER POSTED (ACTUALS, ERP) 3RD QUARTER POSTED (FED. SYSTEM) 3RD QUARTER (ACTUALS VS. FED. SYSTEM) 3RD QUARTER (AVAILABLE BUDGET, ERP) PERIOD 10 PERIOD 11 PERIOD 12 4TH QUARTER POSTED (ACTUALS, ERP) 4TH QUARTER POSTED (FED. SYSTEM) 4TH QUARTER (ACTUALS VS. FED. SYSTEM) 4TH QUARTER (AVAILABLE BUDGET, ERP) TOTAL ACTUAL REVENUES POSTED YTD AVAILABLE REVENUE BUDGET YTD FEDERAL SYSTEM DRAW DOWNS YTD TOTAL ACTUAL VS. FEDERAL SYSTEM YTD F4323 FEDERAL FEDERAL SHARE INCREASE (DECREASE) REVISED BUDGET 451250.0 XYZ Grant 21267004 100.0 50.0 150.0 6.0 6.0 4.0 16.0 18.0 -2.0 134.0 8.0 6.0 6.0 20.0 18.0 2.0 114.0 0.0 0.0 114.0 0.0 0.0 114.0 36.0 114.0 36.0 0.0 457200.0 INDIRECT COST 21267004 50.0 25.0 75.0 0.0 0.0 0.0 0.0 75.0 4.0 1.0 1.0 6.0 6.0 0.0 69.0 0.0 0.0 69.0 0.0 0.0 69.0 6.0 69.0 6.0 0.0 TOTAL REVENUES 150.0 75.0 225.0 6.0 6.0 4.0 16.0 18.0 -2.0 209.0 12.0 7.0 7.0 26.0 24.0 2.0 183.0 0.0 0.0 0.0 0.0 0.0 0.0 183.0 0.0 0.0 0.0 0.0 0.0 0.0 183.0 42.0 183.0 42.0 0.0 EXPENDITURE BUDGET, PER SUBMISSION TO OMB EXPENDITURE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" EXPENDITURE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" EXPENDITURE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" EXPENDITURE ACTUALS, PER ERP "FLEXIBLE PERIOD REPORT" 1ST QUARTER EXPENSE RECONCILIATION ZONE 2ND QUARTER EXPENSE RECONCILIATION ZONE 3RD QUARTER EXPENSE RECONCILIATION ZONE 4TH QUARTER EXPENSE RECONCILIATION ZONE YEAR-TO-DATE EXPENSE RECONCILIATION ZONE OBJECT NO. OBJECT CLASS ORG PROJECT PERIOD 1 PERIOD 2 PERIOD 3 1ST QUARTER (ACTUALS, ERP) 1ST QUARTER (AVAILABLE EXPENSE BUDGET) 1ST QUARTER (ENCUMBRANCES 1ST QUARTER (NET AVAILABLE EXPENSE BUDGET) PERIOD 4 PERIOD 5 PERIOD 6 2ND QUARTER (ACTUALS, ERP) 2ND QUARTER (AVAILABLE EXPENSE BUDGET) 2ND QUARTER (ENCUMBRANCES 2ND QUARTER (NET AVAILABLE EXPENSE BUDGET) PERIOD 7 PERIOD 8 PERIOD 9 3RD QUARTER (ACTUALS, ERP) 3RD QUARTER (AVAILABLE EXPENSE BUDGET) 3RD QUARTER (ENCUMBRANCES 3RD QUARTER (NET AVAILABLE EXPENSE BUDGET) PERIOD 10 PERIOD 11 PERIOD 12 4TH QUARTER (ACTUALS, ERP) 4TH QUARTER (AVAILABLE EXPENSE BUDGET) 4TH QUARTER (ENCUMBRANCES 4TH QUARTER (NET AVAILABLE EXPENSE BUDGET) TOTAL ACTUAL EXPENSES POSTED YTD AVAILABLE EXPENSE BUDGET YTD ENCUMBRANCES NET AVAILABLE EXPENSE BUDGET YTD F4323 FEDERAL FEDERAL SHARE INCREASE (DECREASE) REVISED BUDGET 510000.0 PERSONNEL SERVICES 21267105 10.0 50.0 60.0 1.0 1.0 1.0 3.0 57.0 57.0 1.0 1.0 1.0 3.0 54.0 54.0 0.0 54.0 54.0 0.0 54.0 54.0 6.0 54.0 54.0 520000.0 FRINGE BENEFITS 21267106 10.0 25.0 35.0 1.0 0.0 1.0 34.0 34.0 3.0 1.0 1.0 5.0 29.0 29.0 0.0 29.0 29.0 0.0 29.0 29.0 6.0 29.0 29.0 SUBTOTAL PERSONNEL 20.0 75.0 95.0 2.0 1.0 1.0 4.0 91.0 0.0 91.0 4.0 2.0 2.0 8.0 83.0 83.0 0.0 0.0 0.0 0.0 83.0 0.0 83.0 0.0 0.0 0.0 0.0 83.0 0.0 83.0 12.0 83.0 0.0 83.0 531000.0 UTILITIES 21267109 15.0 15.0 1.0 1.0 1.0 3.0 12.0 1.0 11.0 1.0 1.0 1.0 3.0 9.0 9.0 0.0 9.0 9.0 0.0 9.0 9.0 6.0 9.0 9.0 540000.0 SUPPLIES 21267109 15.0 15.0 1.0 1.0 1.0 3.0 12.0 1.0 11.0 1.0 1.0 1.0 3.0 9.0 9.0 0.0 9.0 9.0 0.0 9.0 9.0 6.0 9.0 9.0 564100.0 OTHER SERVICES 21267109 10.0 10.0 1.0 1.0 1.0 3.0 7.0 2.0 5.0 1.0 1.0 1.0 3.0 4.0 4.0 0.0 4.0 4.0 0.0 4.0 4.0 6.0 4.0 4.0 577000.0 CAPITAL OUTLAY 21267109 40.0 40.0 1.0 1.0 1.0 3.0 37.0 2.0 35.0 1.0 1.0 1.0 3.0 34.0 34.0 0.0 34.0 34.0 0.0 34.0 34.0 6.0 34.0 34.0 SUBTOTAL BUDGET 100.0 75.0 175.0 6.0 5.0 5.0 16.0 159.0 6.0 153.0 8.0 6.0 6.0 20.0 139.0 0.0 139.0 0.0 0.0 0.0 0.0 139.0 0.0 139.0 0.0 0.0 0.0 0.0 139.0 0.0 139.0 36.0 139.0 0.0 139.0 563300.0 INDIRECT COST 21267108 50.0 50.0 0.0 50.0 50.0 4.0 1.0 1.0 6.0 44.0 56.0 0.0 44.0 44.0 0.0 44.0 44.0 6.0 44.0 44.0 TOTAL EXPENDITURES 150.0 75.0 225.0 6.0 5.0 5.0 16.0 209.0 6.0 203.0 12.0 7.0 7.0 26.0 183.0 0.0 195.0 0.0 0.0 0.0 0.0 183.0 0.0 183.0 0.0 0.0 0.0 0.0 183.0 0.0 183.0 42.0 183.0 0.0 183.0 SIGNATURE PREPARED BY & DATE: ______________________________________________ SIGNATURE PROG. DIRECTOR & DATE: ___________________________________________ SIGNATURE DEPT. HEAD & DATE: ________________________________________________