Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Back-Up Documents
CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: Erica Paschal, Director DATE: September 30, 2022 Finance Department Bertine Louissaint FROM: Bertine Louissaint, Finance Manager Finance Department SUBJECT: Unreimbursed Grant Expenditures for quarter ending 06/30/2022 REFERENCES: ENCLOSURES: In accordance with the City's Financial Integrity Principles, the Finance Department shall make a quarterly determination of the amount of expenses incurred which may not be reimbursable under certain grant programs. A quarterly report of expenses incurred but not reimbursable shall be presented to the City Commission. The Finance Department has determined, and is reporting, for the quarter ended June 30, 2022, the following non -reimbursable expenditures: Item #1: a. Department: Human Services b. Project: 2020-21 HMIS Staffing and Identification Assistance Program c. Amount: $ 2,055.50 d. Funding Source: Miami Dade County Homeless Trust e. Reason for non -reimbursement: The Homeless Trust does not allow those expenditures for reimbursement. Item #2: a. Department: Human Services b. Project: Outreach Salary Match/Supplemental Staffing Costs Program and Coordination- PC2021-STAFF-3 c. Amount: $ 11,250.00 d. Funding Source: Miami Dade County Homeless Trust e. Reason for non -reimbursement: The Homeless Trust does not allow those expenditures for reimbursement. Item #3 a. Department: Police b. Project: FY21 Speed/Aggressive Driving Enforcement Saturation Patrol Project c. Amount: $25,543.69 d. Funding Source: Florida Department of Transportation e. Reason for non -reimbursement: Expenditures did not qualify for reimbursement Item #4 a. Department: Department of Real Estate Asset Management ("DREAM") b. Project: Brickell Ave Park Land Acquisition - B30685 c. Amount: $751.70 d. Funding Source: Miami Dade County e. Reason for non -reimbursement: non -reimbursable expenditure posted in the account will be covered by Impact Fees. Item #5 a. Department: Office of Capital Improvements ("OCI") b. Project: Englewood Sewer c. Amount: $48,510.86 d. Funding Source: GOB -Miami Dade County e. Reason for non -reimbursement: In 2021, unused balances of GOB contracts were reallocated in a new GOB agreement to fund Citywide storm sewers. By mistake, the $48,510.86 was not included in the amount of the new agreement and the modification would have implied delays in the execution of the new contract. Non -Reimbursable Expenditures Quarter Ending 06-30-2022 CITY OF MIAM1, FLORIDA INTER -OFFICE MEMORANDUM To • Ms. Erica T Paschal, Finance Director DATE : August 12, 2022 FILE : Finance Department F SUBJECT - Transfer Cost Allocation(Sep-2021)- FY2021 Fund 14800 to Fund 00001 FROM - Sergio Torres, Homeless Program Administrat Dept. Human Services- Homeless Program REFERENCES: ENCLOSURES: JE Reference N. HS&HP-2122/063 Expenditures not covered by grants General Ledger Form #: HS&HP-2122/063 The following journal entry is required to transfer expenditures not caverd by grants from Special Revenues(14800) to General Fund (00001), FY2020-2021 LENS p GENERAL LEDGER AMOUNT DEBIT AMOUNT CREDIT DESCRIPTION SUB -FUND ORG. GLACCOUNT NUMBER FUTURE 14J FUTURE i5J 1 00001 450001 891101 0000 00000 4,833.37 2 00001 450001 891101 0000 00000 4,916.63 Reciasification of expeneses 3 00001 450001 891101 0000 00000 250.00 not covered by grant from 4 00001 450001 891101 0000 00000 580.59 PnG (Project: 45-21019, 5 00001 450001 891101 0000 00000 44.41 Award: 2757) to General Fund 6 00001 450001 891101 0000 00000 580.59 7 00001 450001 891101 0000 00000 44.41 8 00001 450001 891101 0000 00000 954.71 Reclasification of expeneses 9 00001 450001 891101 0000 00000 73.04 not covered by grant from 10 00001 450001 891101 0000 00000 954.71 PnG (Project: 45-21018, Award: 2754) to General 11 00001 450001 891101 0000 00000 73.04 Fund 12 14800 450001 481101 0000 00000 11,250.00 Reclasification of expeneses 13 14800 450001 481101 0000 00000 2,055,50 from PnG to General Fund TOTAL 13,305.50 13,305.50 If you have any questions regarding this request, please contact Sergio Torres at Extension 4988. C: Bertine Louissaint Aniska Elliott CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO : Ms. Erica T Paschal, Finance Director Finance Department FROM _ Sergio Torres, Homeless Program Administrator Dept. Human Services- Homeless Program DATE: SUBJECT; REFERENCES: ENCLOSURES: August 12, 2022 FILE Expenditures not covered by Grants September 2021 OSM and HMJS - FY 2020-21 JE Reference if: 1-IS-HP 2122/063A PnG Fortn H; IIS-iir 2122/063A The following journal entry is required to remove from PnG side the expenditures not covered by grants (Salaries + Fica and Benefits - Sep 2021) LINE # PROJECT AMOUNT TO (IN) AMOUNT FROM (OUT) Trans ID Number & Description PR01ECT AWARD TASK EXPENDITURE ORG. SUB FUND Expenditures riot covered by 1 45-21019 2757 01 Transfer In -Prior Year 450001 14800 4,833.37 grants Trans Ida 4407409 Expenditures not covered by 2 45-21019 2757 01 Transfer In -Prior Year 450001 14800 4,916.53 grants Trans Ida 4407410 Expenditures not covered by 3 45-21019 2757 01 Transfer In -Prior Year 450001 14800 250.00 grants Trans Ida 4407411 Expenditures not covered by 4 45_-21019 2757 02 Transfer In -Prior Year 450001 14800 580.59 grants Trans Id# 4418403 Expenditures not covered by 5 45-21019 2757 02 Transfer In -Prior Year 450001 14800 44.41 grants Trans Id# 4418404 Expenditures not covered by 6 ' 45-21019 2757 02 Transfer In -Prior Year 450001 14800 580.59 grants Trans Id# 4387512 Expenditur es not covered by 7 45-21019 2757 02 Transfer In -Prior Year 450001 14800 44.41 grants Trans Id# 4387513 -- ----------- — - — -- Expenditures not covered by 8 45-21018 2754 01 Transfer In -Prior Year 450001 14800 954.71 grants Trans ida 4337510 Expenditures not covered by 9 45-21018 2754 01 Transfer In -Prior Year 450001 14800 73.04 grants Trans Ida 4387511 Expenditures not covered by 10 45-21018 2.754_ 01 Transfer In Prior Year 450001 14800 954.71 grants Trans Ida 4418401 Expenditures not covered by 11 45-21018 2754 01 Transfer In -Prior Year 450001 14800 73.04 grants Trans Ida 4418402 - 13,305.50 If you have any questions regarding this request, please contact Sergio Torres at Extension 4988 or Alberto Gonzalez at Extension 4997. C: Bertlne Louissaint PROJECT: 45-21019 AWARD: 2757 - jOracle Applications - %MiAMi Production File Edit yiew Folder To Window Delp N• } 'E,G;in..,.i L3 Trans Id Project Task ward Expnd Type Item Date Employ Quantity UOM Proj Func t Project Bur( Accr Bill F Comment 4387512 45-21019 02 2757 RegularSalane 30-SEP-2021 4387513 45-21019 02 2757 Flea Taxes 30-SEP-2021 4407409 45-21019 01 2757 ,Retirement Conl 30-SEP-2021 4407410 45-21019 01 2757 Life and Health 30-SEP-2021 4407411 45-21019 01 2757 Workers Comp 30-SEP-2021 4418403 45-21019 02 2757 Regular Salaries 30-SEP-2021 4418404 45-21019 02 2757 Fica Taxes 30-SEP-2021 PROJECT: 45-21018 AWARD: 2754 Oracle Applications - 1MFAMi Production Fde Edit View Folder Tools Window Help Itt+ f9 C!7 41 4 kir x: j9 580 59 Currenr 580.59 550.59 Expnd Org Non -Labor R FY21CP09302021-To post Payroll Expenditures coverer 450001 Human Serve 44 41 Currenc 44.41 44 41 'FY21CP09302021-To post Payroll Expenditures coverer 450001 - Human Servi 4833.37 Currenc 4,833.37 4,833 37 FY21CP100821-To post Benefits covered by Outreach*. 450001 - Human Serve 4916.63 Currenc 4.916.63 4,915.63 FY21CP100821-To post Benefits covered by Outreach .'„ 450001 - Human Servi 250 Curren 250 00 250 00 FY21CP100821-To post Benefits covered by Outreach ; 450001 - Human Senn 580 59 Curren( 580 59 580 59 FY21CP101221-Tr post Payroll covered by HMIS. PPE 450001 - Human Servi 44 41 Curren( 44 41 44 41 Y21 CP 101221-To ost Payroll covered b HMIS. PPE 450001 - Human Servi $11,250.00 e E10 a Trans Id Project Task Award Expnd Type Item Date Employ Quantity UOM Proj Func t Project Burl Accr Bill f Comment MIMI 45-21018 01 2754 Regular Saltine: 30-SEP-2021 954.71 Currenc 954.71 954.71 FY21CP09302021-To post Payroll Expenditures coverer 450001 - Human Servi 4387511 45-21018 01 2754 Fica Taxes 30-SEP-2021 73 04 Curren( 73 04 73 04 FY21CP09302021-To post Payroll Expenditures coverer 450001 - Human Semi 4418401 45-21018 01 2754 Regular Selarle! 30-SEP-2021 954 71 Curren( 954 71 954 71 FY21CP101221-To post Payroll covered by HMIS, PPE 450001 - Human Serve 1111.11 45-21018 01 2754 Fica Taxes 30-SEP-2021 73 04 Currenc 73 04 73.04 FY21CP101221-To post Payroll covered by HMIS, PPE 450001 - Human Senn $2,055.50 Expnd Org Non -Labor R BENEFITS _ p x ©Journals (City of Miami Set of Books) - 141300.450001 522080.0000 00000,OCT• "n Er Batch Balance Type Actual Journal Entry Source Entered Currency 30-SEP-2021 Miso Projects USD Reverses "30 Reverses "30-SEP- Projects USD Projects A 13 24-SEP--2021 Misc Projects USD Reverses "24- Reverses "24-SEP- Projects USD EL101521-09 EL101521-09 PnG Spreadshe USD Line 2 2 2 2 3 Currency Type Total Journals (City of Mimi Set of Books) - 14800 450001 000 0000 00000.00T-2020->SEP-202 I Balance Type Actual Batch Journal Entry Source Entered Currency 30-SEP-2021 Misc Projects USD Reverses "30 Reverses "30-SEP- Projects USD EL101521-09 EL101521--09 PnG Spreadshe USD Line 3 3 4 Entered Debit Entered Credit 58, 000, 00 180,000.00 58,000 00 180, 000.00 238.000 00 Currency Type Total Journals , Try of MTan Set of Books) - 14800.450001.524000.0000.00000,OCT-2020->SEP. Balance Type Actual Ta Batch Journal Entry Source Entered Currency Line MEE 30-SEP-2021 Misc Project USD 4 Reverses '30 Reverses "30-SEP- Projects USD 4 EL101521-09 EL101521--09 PnG Spreadshe USD 5 Entered Debit Entered Credit NI Currency Type Total Entered Debit 3,000 00 3,000 00 MI Entered Credit 3,000.00 COSTING DETAIL FUND 14800 ORG. 450001 Consolidation Set Name Payroll Name ORE Last Name First Name Middle Name Effective date Element Name Input Value UOM Cast A11OCation Segments Deb fl Amount Accrual Type Fund Organkzatl on Object LOe#tion Name Employee Number City of Miami CMIA Bi-Weekly Miami Morales Karla P 17Sep-21 Retro VaCTaken pay Value Money 14800.450001.512000.0000,00000 - 6.37 14800 450001 512000 Services -Homeless 40105 City of Miami CMIA Bi Weekly Miami Morales Karla P 17-Sep-21 Retro CIA lARegular Pay Value Money 14800.450001.512000.0000.00000 - 637 14800 450001 512000 Services - Homeless 40105 City of Miami CMIA Bi-Weekly Miami' Morales Karla P 17Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000.0000,00000 - 6.37 14800 450001 512000 Services - Homeless 40105 City of Miami CMIA Bi Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001.512000.0000.00000 - 5,37 14800 450001 512000 Services -Homeless 40105 City of Miami CMIA 81-Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000.500500000 - 637 14800 450001 512000 Services - Homeless 40105 eft/ Of Miami CMIA Bi-Weekly Miami Morales Karla P 17Sep-21 Retro CMIA Regular 'Pay Value Money 14800.450001512000,0000,00000 - 637 14800 450001 512000 5ervlces-Homeless 40103 City of Miami CMIABI-Weekly Miami Morales Karla P 17Sep-21 Retro CM IA Regular Pay Value Money 14800.450001512000.0000,00000 - 6.04 14800 450001 512000 Services - Homeless 40105 City of Miami CMfA51-Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value 'Money 14800,450001512000,0000,00000 - 6.68 14500 450001 512000 Services - Homeless 40105 Cfty of Miami CMIA Bi-Weekly Miami Morales !Carla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000.0000.00000 - 11.14 14800 450001 512000 _ Services -Homeless - 40105 City of Miami CMIA 31-Weekly Miami Morales Karla P 17Sep-21 Retro CM1A Regular Pay Value Money 14800.450001512000.0000.00000 - 1.59 14800 450001 512000 Sari/lees -Homeless 40105 City of Miami CM[ABi-Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000.0000.00000 - 6.37 14800. 450001 512000 Services -Homeless 40105 City of Miami CMfA Bi-Weekly Miami Morales Karla P 17-Sep-21.Retro CMIA Regular Pay Value Money 14800.450001512000.0005.00000 - S.37 14800 450001 512000 Services - Homeless 40103 City of Miami CMCA 81-Weekly Miami Morales Karla P 17-5ep-21 Retro CMIA Regular Pay Value Money 14800.450001512000,0000,00000 - 637 14800 450001 512000 Services -Homeless 40105 City of Miami CMIA. 81-Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000.0000,00000 - 537 14800 450001 512000 Services- Homeless 40105 City of Miami CMfA 61-Weekly Miami Morales Karla P 17-Sep-21 Retro CMIA Regular Pay Value Money 14800.450001512000,0005,00000 - 5,37 14800 450001 512000 Servlces- Homeless 40105 City of Miami CMCA Bi-Weekly Miami Morales Karla P 17-Sep-21 illness Pay Value Money 14800.450001.512000.0000.00000 - 133.70 14800 450001 5120E10 Services -Homeless 40105 City of Miami CMIA El -Weekly Miami Morales Karla P 17Sep-21 Holiday Pay Pay Value Money 14800.450901512000.0000.00000 - 133.70 14800 450001 512010 Services - Homeless 40105 City of Miami CMIABI-Weekly Miami Morales Karla P 17-Sep-21 Regular Overtime Pay Value Money 14800.450001514000.0000.00000 - 20055 14800 450001 514000 Servfees -Homeless 40105 City of Miami CMIA Bi-Weekly Mlaml Morales Karla P 17-5ep-21 Regular Overtime Pay Value Money 14200450001514000.0000.00000 - 200.55 14800 450001. 514000, Services -Homeless 40105 City of Miami CMIA Bi-Weekly Miami Morales Ka Ha P 17-5ep-21 55 ER Pay Value Money 14800.450001.521000.0000.00000 - 107.14 14800 450001 521000 Services - Homeless 40105 City of Miami CMIA Bi-Weekly Miami Morales Karla P 17-Sep-21 Medicare ER Pay Value Money 14800450001521000.0000.00000 - 25.05 14800 450001 521000 Services -Homeless 40105 City of MlamI CMIA Bi-Weekly Miami Morales Karla P 17-Sep-21 Retro CMfA Ovrtm Pay Value Money 14300.450001514000.0000.00000 - 4,78 14300 450001 514000 Services - Homeless 40105 City of Miami CMIA Bk-Weekly Miami Morales Ka Ha P 17-5ep-21 Retro CMIA Ovrtm Pay Value Money 14800.450001514000.0000.00000 - 4,78 14800 450001 514000 Services - Homeless 40105 CRy of Miami. CMIASFWeekfy Miami Morales Karla P 17-Sep-21 Retro CMfA Ovrtrn Pay Value Money 14800A5o501.514000.0000.00000 - 7,15 14800 450001 514000 Services - Homeless 40105 City of Miami CMIA BF -Weekly Miami Morales Karla P 17Sep-21 Retro CM[A ❑vrtm Pay Value Money 14300.450001.514000.0000.00000 - 6.68 14300 450001 514000 Services - Homeless 40105 City of Miami CMIA Br -Weekly Miami Morales Karla P 17Sep-21. Rstrn CMIA Ovrtm Fay Value Money 14800A50001314000.0000.00000 - 7.16 14800 450001 514000 Services - Homeless 40105 City of Mfamf CMIA BI-Weekly Miami Morales Karla P 17-Sep-21 Regular Pay Pay Value Money 14800.450001.512000,0000.00000 - 2005S. 14800 450001 512000 Services - Homeless 40105 City of Miami CMIA Bi-Weekly Miami Morales Karla P 17-Sep-21 Regular Pay Pay Value Money 14600.450001.512000.0000.00000 - 200.55 14800 450001 512500 Services - Homeless 40105 City of Miami CM1A 3 i-Wee kly Miami Morales Karla P 17-Sep-21 Regular Pay Pay Value Money 14300.450001.512000.0000.00000 - 71.87. 14800 450001 5/2000 Services - Homeless 40105 City of Miami CMIA Bf-Weekly Miami Morales Karla P 17-Sep-21 Regular Pay PayValue Money 14800.450001.512000.00013.00300 - 133.70 14800 450001 512000 Services - Homeless 40105 City of Miami CMIA RI -Weekly Miami Morales Karla P 17-Sep-21 Regular Ray Pay Value Money 14800,450001512000,0000.00000 - 133,70 i 14600 450001 512000 Services - Homeless 40105 Clay of Miami CMIABI-Weekly Miami Morales Karla P 17-Sep-21 Regular Pay Pay Value Money 14800,450001,512000,0000,00000 - 133.70 14800 450001 512000 Services - Homeless 40105 City of Mfamf CMIABI-Weekly Miami Morales Karla P 17-Sep-21 Regular Pay pay Value Money 14800.450001512000.0000.00000 - 19553 14800 450001 512000 Services - Homeless 40105 City of Mfamf CMIA81-Weeky Miam) Ramos Carlos E 17-Sep-21 55ER Pay Value Money 14300,450001521000.0000.00000 - 96.34 14800 450001 521000 Services - Homeless 28716 City of Miami CMIA BI-Woody Miami Raman Carlos 8 17Sep•21 Medicare ER Pay Value Money 14800,450001.521000,000000000 - 22,53 14300 450001 521000 SerViees - Nameless 28716 City of Miami CMIABI-Weakly Miami Ramos '.Carlos E 17-Sap-21 Regular Pay Pay Value Money 14800.450001512000.0000,00000 - 160.44 14800 450001 512000 Services - Homeless 26716 City Of Miami CMIR Si -Weekly Miami Ramos Carlos E 17-Sep-21 Regular Pay Pay Value Money 14809,450001.5120000000.00000 - 162.44 14800 450001 512000 Services -Homeless 28716 City of Miami CMIA8i-Weekly Miami Ramos Carlos E 17-Sep-21 Regular Pay Pay Value Money 14800,450001512000.0000.00000 - 150.44 14800 450001 512000 Services - Homeless 28716 Cfty5fMiami CMIABi-Weekly Miami Ramos Carlos E 17-Sep-21 Regular Pay Pay Value Money 14600,450001512000.0000.04000 - 154.42 14800 450001 512000 Services - Homeless 28715 City of Miami CMIA Bi-Weakly Miami Ramos Carlos E 17-5ep-21 Regular Pay Pay Value Money 14800.450001512000.0000.00000 - 156.43 14800 450001 512000 Services - Homeless 28716 City of Miami C1NIA8i-Weekly Miami Ramos Carlos E 17-5ep-21 Regular Pay Pay Value Money 14800.450001512000.0000.00000 - 154.42 14800 450001 512000. Services - Homeless 28716 City of Miami CMIA BI-Weekly Miami Ramos Carlos E 17-Sep-21 Regular Pay Pay Value Money 14800.450001,512000.0000.00000 - 158.43 14800 450001 512090 Services -Homeless 28716 City of Mlaml CMIA 81-Weekly Miami Ramos Carlos E 17-Sep-21 Regular Pay Pay Value Money 14800.450001.512000.0000.00000 - 160A4 14800 450001 512000 Services - Homeless 28716 City of Miami CMIA 81-Weekly Miami Ramos Carlos E 17-Sep-21 Illness Pay Value Money 14800.450001.512000A000A0o00 - 172.47 14800 450001 512000 Services -Homeless 28716 City of Miami CMIA81-Weekly Miami Ramos Carlos E 17-Sep-21 Holiday Pay Pay Value Money 14800,450001.512000:0000.00000 - 160.44 14800 450001 512000 Services - Homeless 28715 4387510 45-21018 4387511 45-21018 4387512 45-21019 2754 Salaries 44469 2754 Pica Taxes 44469 2757 Sala%es 44469 4387513 45-21019 2 2757 Pica Taxes 44469 954.71 Currency 73.04 Currency 58059 Currency 44.41 Currency 954.71 73.04 580.59 44.41 954.71 73A4 58059 44.41 non -reimbursable 9Y21CP09302021-To post Payroll Expenditures covered by 13MI5, PP. Pay Day 9/17/2021 non -reimbursable F421C11109302021-To post Payroll Expendltures Covered by HMI5, PP. Pay Day 9/17/2021 non -reimbursable Fy21CP09302021-To goat Payroll Expend[tures covered by FC, PP. Pay Day 9/17/2021 non-relmb ursab le FY21CP09302021 To post Payroll Expenditures covered by FC, PP. Pay Day 9/17/2021 COSTING DETAIL FUND: 14800 -ORG: 450001 CansolfdaUonSet Name Payroll Name GRE Last Name First Name Middle Name Effective date Element Name Input Value 1.1OM Cost Allocation Segments Debit Amount Accrual Type Fund Organliatlon Object Location Name Employee Number City of Miami' CMIA Bi-weekly Crty of Miami Morales Karla P l-0ct-21 Vacation Taken Pay VeIue Money 14800.450001-512000,0000.00000 - 133.70 14800 450001 512000 Services - Nameless 40105 City of Miami CM IA Bi 'rLreeky City of Miami reiorales Karla P 1-Oct-21 Medicare ER Pay Value Money 14500.450001.521000,000,00000 - 1731 14800 450001 521000 Services -Homeless 40105 City of Mraml CMIA Bi-Weekly Crty of Miami Morales Karla P 1-Oct-21 SS ER Pay Value Money 14800.450001.521000.0000.00000 - 74.94 14800 450001 521000 Services -Homeless 401o5 City of iNiami CM IA Bi Weekly City of Miami :Morales Karla P 1-0ct-21 Regular Pay Pay Va lue Money 14800.450001.512000,0000.00000 - 133.70 14800 450001 512000. Services -Homeies5 40105 Cftr of Miami CMIA Bi-Weekly City of Nl ism Morales Karla P 1-Oct-21 Reg0lar Pay Pay Value Money 14800 .450001.512000 .0000.00000 - 133.70 14800 450001 5111100 Serelces- Homeless 40105 of Miami CM IABi Weedy My of Miami Morales Karla P 1-Oct-21 Regular Pay Pay Value Money 14800.450001.512000,0000.00000 - 133.70 14800 450001 512000 Services -Homeless 40305 City of Miami CMIA 6i-Weekly City of Miarni Morales Karla P 1-0cA21 Regular Pay Pay Value Manes 14800.450001.512000.0000.00000 - 133.70 14800 450001 5320005erelcee-Homeless 40105 City of Miami CMIA 61-Weekly City of r.iizmi Morales Karla 'P 1-Oct-21 Regular Pay Pay Value Money 14800.450001.512000.0000.00000 - 133.70 14800 450001 512000 Services - Homeless 40105 City Of Mami CM IA Bi-Weekly City of Miami Morales Karla P 1-Oct-21 Regular Pay Pay Value Money 14600.450001.512000.0000,00000 - 133,70 14800 450001 512000 Serv[ces- Homeless 40105 City Of Mimi CMIA Bi-Weekly City of Miami -Morales Karla P 1-Oct-21 Regular Pay Pay Value Money 14800.450001512000.0000,00000 - 133.70 14800 450001 512000 Serelces- Homeless 40105 City Miami Du1IA81-Weekly City of Miami Morales Karla P 1-Oct-21 Regular Pay Pay Value Money 14800.450001.512000.0000,00000 - 133.70 14800 450001 512000 Services - Homeless 40105 City of Mlaml CMIAeI-Week13 City of Miami Morales Karla 8 1-0ot-21 Regular Pay Pay Value Money 14800.450001.512000.000.00000 - 127.01 14800 450001 5121100. Services - Homeless 40105 City of Miami CM IA Br -Weekly City of Miami Ramos Carlos £ 1-Oct-21 Illness Pay Value Money 14800,450001.512000.0000.00000 - 4.22 14800 450001 512000Services-Homeless 7871E City of Miami _ CM IA 61-Weekly City of Miami Ramos Carlos E 1-Oct-21 illness Pay Valve Me ney 14800.4500001,512000.0009.00000 - 168.46 14800 450001 512000 Serelces -Homeless 28716 City of MEamI CMIA 81-Weeks City of Miami Ramos Carlos E 1-Oct-21 Illness Pay Valve Money 14800.450001.512000.0009.00000 - 168,46 14800 450001 512000 Serv€cos - Homeless 28716 City of Miami CMIA 81-Weekly City of Miami Ramos Carlos E 1-Oct-21 illness Pay Value Money 14800.450001.5120130.0000.00000 - 168.46 14800 450001 512000 Services - Homeless 28716 City of Miami CMIA Br -Weekly City of Miami Ramos Carlos E 1-Oct-21 Regular Pay Pay Value Money 14800.450001.512000.0000.000110 - 16846 14800 450001 512000 Services -Homeless 28716 CltyofMiami CMIA Br -Weekly City of Miami Ramos Carlos 6 1-Oct-21 Regular Pay Pay VaIva Money 3.4800.450001.512000.0000.00000 - 164.25 14800 450001 512000 Services -Homeless 28716 City of Miami CMIA BE -Weekly City of Miami Ramos Carlos E 1-0ct-21. Regular Pay Pay Value Money 14800.450001.512000.0000.00000 - 168.46 14800 450001 512000 Services -Homeless 28716 City of Miami [MIRE[ -Weekly City of Miami Ramos Carlos E 1Oct21 Regular Pay Pay Valve Money 14800.450001.512000,0000.00000 - 168.46 14800 450001 512000 Services - Homeless 28716 City of Miami CMEA Br -Weekly City of Miami Ramos Carlos E 1-0ct-21. Regular Pay Pay Value Money 14800.450001.512000.0000.00000 - 168.46 14800 450001 512000Services-Homeless 29716 City of Miami CMEA 6i-Weekly City of Miami Ramos Carlos E 1-0Ct-21 Regular Pay Pay Value Money 14800.460001.512000.0000..00000 - 166.46 14800 450001 512000 Services -Homeless 28716 City of Miami CMIA Bi-Weekly City of Miami Ramos Carlos E 1-Oct-21 Regular Pay ,Pay Value Money 14800.450001512030.0000.00000 - 168.46 14800 450001 512000. Services -Homeless 28716 City of Miami CMEA BiAVeekiy City of Miami Ramos Carlos E 1-Oct-21, 55 ER Pay Value Money 14800.450001.521000.0000.00000 - 101.56 14800 450001 521000 Services -Homeless 28716 City of Miami CMIA 6i-Weakly City of Miami' Ramos Carlos E 1-Oct-21 Medicare ER Pay Value Money 14800.450001,521000.0000.00000 - 23.75 14900' 450001 5210001SaryCos - Homeless 2871E 4418461 45-21013 443.8402 46-21018 4418403 45-21019 4418404 45-21019 1 1 2754 Salaries 44469 2754 Elba Taxes 44463 2 2757 Regular 44469 2757 Fica Takes 44469 954.71 Currency 73.04 Currency 580.59 Currency 4441 Currency 954.71 73.04 580.59 44.41 S54.71 73.04 580.59 44.41 non -reimbursable FY21CP101221-To post Payroll covered by HMIS, PPE; 9-25-2021 Estimated. non -reimbursable Fy21CP101221-To post Payroll covered by 1-1M15, PPE: 9-25-2021 Estimated. non-relmburoa5le F321CP101221-To post Payroll covered by HM15, PPE: 9-25-2021 Estimated. non-rofmbursab le FY21CP101221-To post Payroll covered by HMIS, PPE: 9-25-2021 Estimated. Gonzalez -Gutierrez, Alberto From: Gonzalez -Gutierrez, Alberto Sent: Friday, June 10, 2022 10:06 AM To: Ellis, Terrell T. (HT) Cc: Perez, Carmen; Torres, Sergio; Cervantes, Nelson (HT); Abreu, Maria (HT); Figueroa, Natalia; Elliott, Anlska Subject: RE: EFY21- Open Invoices -14800 Attachments: HMIS wires summary FY 2021.xlsx Hi Terrell, Attached please find our records related to the HMIS wires receipts from the City of Miami, Finance Department during the FY 2021, the last payment was on 5/24/2022 for $2,055.45, according with the total amount paid ($22,610.50) we still have to receive the amount of $2,055.50. As you know this grant pays the same amount every month, if the City of Miami received the wire without any clarification about the month that is being paid, it is not possible for us to match the wire with the month. Please, pay the amount you consider most adequate. Thanks, Alberto, 1 Wire amount $2055.50 -Payment Detail /Trace: 091000012015280 1 Receiver ID: 50707313 Effective Date: 07/2812021 28-1uI-21 WIRE 1W210728-01)02 2,055_50 Wire amount $2055,50 -Payment Detail /Trace: 091000012015282 1 Receiver 1D: 50707224 Effective Date: 07/28/2022 20-Jul-21 WIRE : W210728-0D03 2,055.50 Wire amount $256,09-5.50 -Payment Detail /Trace: 091000014638842 / Receiver ID: 50707638 Effective Date: 07/30/2021 Invoice Gross Amount Currency IG Fee UAP Fee Discount Currency Net Amount Currency 27974038 $2,05.5.50 USD $0.00 $0.00 53.00 USD $2,055,50 USD 25163319 $77,15.2.00 USD $0.00 $0.00 50.30 USD $77,152,00 USD 24626819 $66,110.00 USD $0.00 $0,00 $0.30 USD $66,110,00 USD 28623596 $110,778.00 USD 50.00 $0.00 $0.00 US° $110,778.00 USD Total Wire amount Effective Date: $256,095.50 $2,1356,55 -Payment 08/03/2021 Detail /Trace: 091000010276761 1 Receiver ID: 50707779 LI LInvoke Gross Amount Currency IG Fee UAP Fee Discount Currency Net Amount Currency 27974102 $2,055.55 USD $0.00 $3,001 $0.001 U5D $2,055,55 USD Wire amount $9•6,237.81 -Payment Detail !Trace: 091000015458948 / Receiver JD: 50709833 Effective Date: 08/26/2021 Invoice Gross Amount Currency IG Fee UAP Fee Discount Currency Net Amount Currency 27977443 $25,631.86 USD $0.00 $0.00 $0.00 USD $25,631.86 USD 27977351 $2,055,50 USD $0.00 $0.D0 $0,00 USD $2,055.50 USD 29064428 $2,055.50 USD $0.00 $0.00 $0.00 USD $2,055.50 USD 27977366 $2,055.50 USD $0.00 $0.00 $0.00 USD $2,055.50 USD 2797742E $25,193,81 USD $0.00 $0.00 50.00 USD $25,193.81 USD 27977640 $2,055.50 USD $0,00 $0.00 $0.00 USD $2,055.50 USD 27977560 537,190.14 USD $0.00 $000 $0.00 USD $37,190.14 USD Total $96,237.81 ;_. . - 5t3710376 __.i...__....___..._. Wire amount Effective Date: $2,055.50 -Payment 09/01 / 2021 091000012430393 .. / Receiver ID: Detail /Trace: 13 1-Sep-21 WIRE W210901-OD10 2,055.50 . _ Wire amount $111,288.06 -Payment Detail /Trace: 091000012870243 / Receiver ID: 50713963 Effective Date: 10/08/2021 Invoice Gross Amount Currency iG Fee UAP Fee Discount Currency Net Amount Currency 30128085 $2,055.50 USD $0.00 $0.00 $0.00 USD $2,055.50 USD 30128403 511,250.00 USD $0.00 $0,00 $000 1)50 $11,250,00 USD 29409477 $11,250.00 USD $0.00 $G..,00 $0.00 USC $11,250.00 USD 29409453 511,250.00 USD $0.00 $0.00 $1,00 USD $11,250,00 USD 29409070 511,250.00 USD $0.00 $0.00 $2.00 USD $11,250.00 USD 29408833 511,250.00 USD $0,00 $0.00 $3.00 USD $11,250.00 1J5D 29408290 511,250.00 USD $0.00 $0.00 54.00 USD $11,250,00 USD 1 .29408192 $11,250.00 USD 50.00 $0.00 55.00 USD $11,250.00 USD L 29407661 $11,250.00 USD $0,00 $0.00 $0.00 USD $11,25100 1)50 30110345 519,232.56 USD 50.00 $0.00 $0.00 USD $19,232.55 USD 2 From: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Sent: Friday, June 10, 2022 9:25 AM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miarnigov.com> Cc: Perez, Carmen <CaPerez@miamigov.com?; Torres, Sergio <STorres@miamigov.com>; Cervantes, Nelson (HT) ¢Nelson.Cervantes@miamidade.gov>; Abreu, Maria (HT) <Maria.Abreu@miamidade.gov> Subject: RE: EFY21- Open Invoices -14800 CAUTION: This is an email from an external source. Do not dick links or open attachments unless you recognize the sender and know the content is safe. Good Morning Alberto: Hope all is well. As I stated in a prior email, we show the August invoices as paid. We need for you to please reconcile your records and determine which month may be outstanding. I am unable to process another August invoice. Something is coded incorrectly. have to process the invoice based on the paperwork submitted for that month. Our system will not process another August invoice. It will be a duplicate. Please advise. Regards, Terrell- T. Eras, %tanager, .7LTContracts Division 5Vtiami-(Dade County 1fomefess Trust 111 NW 1n Street, Suite 27-310 �Vfrnmi, Flarrda 33128 From: Gonzalez -Gutierrez, Alberto eAGonzalez-Gutierrez@miamigov.com> Sent: Friday, June 10, 2022 9:18 AM To: Ellis, Terrell T. (HT) eTerrell.EllisC miamidade.gov> Cc: Perez, Carmen <CaPerezt miamigov.com>; Torres, Sergio <STorres@miamigov.com> miamigov.com> Subject: RE: EFY21- Open Invoices -14800 EMAIL RECEIVED FROM EXTERNAL SOURCE Good morning Terrell: Thanks for the recent payments, please see below an update of the primary care amounts pending for payment from FY 2021. The amounts of $2,055.50 (HMIS) and $11,250.00 (055) are still pending payment. 3 HOMELESS PP OCac - PRIMARY MrcE 0PANTS •FY 2020-2621 SUMMARY Of ;ROW L.I'sSEMEN 7 REQUESTS MOPAYMENFS i .ra r►u x> Sud;et n icajazt Pt•2b2:1•STAFMAWS [tud2et: 24.666;00 PC • 2021 • MA Budget: ac1.000.0EF 1C-2023.5ror- 5/ 4 04440t4 :635, E2M 0C.2C 1•IO.1 budget 12.500.O£1 Reimburse Par1d by the Pr1d by the talc! !rr, the :Reimburse- Paid Ire ttsrt Pamdllng MAK NCR1104:113 Pr3rrttllag4br, Rolm-bonen Homeless Per.drrgfor Role bussoire 11044 ia Pen/Pirtiet' _ mom Homv S far Mcsnthi R4 ...St Tfss1 s d''4.00 I ent_ 140.106,11 S}YLS.t, _ . +r?2 Vnent nt Aouast , Trust pdrlMe st ; ' Rei, sT 4rtit :h. rn4(aL 0c102Q S•,.Sa 2.9,s5.51:1 - 75x93.$1 zs.* )•s1 1 DSO Cpc' 3 zso.p0 ilcrwml6er26 2 0S5.54 055. SO 15,621 AG IS 611.845 i d.sDLt i 11 50.O0 . 6ett1YlbQt 2O 7y455.50 2 055.50 25,E 8A.74 4S;'se9.24 - >x250 0t7r'_ 11250.00_ 4. ...__.. __ _ _.. 14nu421 2 755.$0 2.0$5.S0 - 37 90;1A 32,2990124 •• - ^- 21250 Q0 i 12.150.E - _. - Flebru47•21 2.655_50_ 2A35_55 2-41.2io,19.1 24,236.1_ _ ._. - 13.,250,0 I - 112SO.Otl 9?7!�d &77.ir . _ . Man11-21 2,055.50 w 2055.50 __ _ 14A4237 4.44237 t- : w 1.1350 00 1;50.00 AIR. IS agt,15 r 1 3OGS.SR 24S21,7; 24,942 ,22 r 21, 5000 1.1.00,00 - 426.50 426,50 May f1 _2055.59 -:_:11..: SS- 2,05�.54 2-4,38a.s1. 241.384,68 _ _ - x1,250•cc 1.1,250.0] 7176.2a T{�r.25 2urt4- 1 2 05S56 90 _� 055.50 21,969 1E 13.s99;1G . - .. ___ 11,250 t0 11,2 Sd.00 •_ 513... 523.76 Sefy4..1. r 2,055.i0 2,06.5.SO I - 2,925.31 2.5A/6, 31 0.CK7. _ I1,250.00 - 1 „ .50,011 . _. _ _ .74'5.20 . - - 74 gL? - __ --"... Iyskra21 2,055.50. 23055.50 19,3.32.56 35,232.56 _9,02} 21.250,00 11.250.00 - -• 5eptsmber23 2.055.50 . 2,055.45 0.00 1$1 x3.13 19..13.3,13 t'1 350:bp i 11.25000 - TOTAL 24,66646 22,616.36 2,055.50 298,705.22 298,70S>32 4.00 135„e06.00 12.3,'750.06 16i7 1,250 i 4,113.40 r 01%40 • # Regards, Alberto From: Perez, Carmen <CaPerezPmiamigov.com> Sent: Friday, June 3, 2022 10:50 AM To: Gonzalez -Gutierrez, Alberto<AGonzaiez-Gutierrez@miamigov.com> Cc: Torres, Sergio <STorresPmiamigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Louissaint, Bertine <BLouissaint(c miamigov.com> Subject: FW: EFY21- Open Invoices -14800 Good morning Alberto: The following invoices are still open in PnG as of June 1, 2022. Please let me know when the money will be received. r Number Dr ift , lrwo ce t . lr vfee Amount `=Bs nee C ue.... If iII Through 21212 i 1121213 [12121?1 �135.600 00.[ 1'1:,250 00'.f3O SEP-2021 .. s# 27 Thank you 34,990 33 i. 24,230,19 130P-20'21 1 2.055 50 30 SEP-2021 Carmen Perez Financial Analyst I City of Miami - Finance - 444 SW 21° avenue 6t'I' Floor Miami, FL 33130 Ph. (305) 416-1963 a�J2eC�m]am1�4YS�?JE1 WW miamiao� cQm From: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez( mia m igov.com> Sent: Friday, May 6, 2022 11:38 AM 4 To: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Cc: Torres, Sergio <STorres[E)miamigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Cervantes, Nelson (HT) Nelson.Cervantes@miamidade.gov>; Perez, Carmen <CaPerez{c miamigov.com,; Lucdor, Patrick <PLucdor@miamigov.com>; Green, La Kendra (HT) <Lakendra.Green@miamidade.gov>; Figueroa, Natalia <NFigueroa@ miamigov.com> Subject: RE: EFY21- Open Invoices -14B00 Hi Terrell: Thank you!. Attached please find the wire summary received by the City of Miami, you can also find attached the emails received from Financial Department of the City of Miami related to the HMIS wires, and according to the emalls attached I have not received any information which l can associate the payment to a specific month. 5 Wire arrrount 52055.60 Payment Detail ',Trace: 091000012015280 t Recelvrr EC:,5O707313 Effective Date: 071 2& JI 1-21 WIRE V112-10723-0002 2,01; 50 (Wire t0unt-$2O5 80-.PaymentDelai!!Ma z 081000012d1 82 fReceiver /D:50707224 Effective Date: 07128/2022 2S4L12.1: WI Elf" W21 07254XXI3 2.055.E W`ta arnOurrt 525.195.50-Paitment ID l !'Thad. 0 100 ttecti've Date: 07130/2021 42 / Reaeher 10: 50707638 invoice G rimsArtiount Currency IGFee AP Fee DIsCOrint Currency Net Amount Currency USED 27974035 $2,055.50 USD $0.00 $0.06 50.00' USD $2,05550 2. 168319 . $77,152.00 USD $000 50.00 :$0.00, USD 577,152.470 USD 24626829 . $&.110.El0 1.115£► 50,00 $000' $0.00-1JS 1 $66,1113.0;7 USI? 286.255,95 $110,775.00 USD S0.00 50.00 $0.00 USD $110,778.t70 USD Total $256,0955.50 Wire amount 82,065,55 -Payment Detail /Trace. 091000410278761 1 Receiver tl: 50707T79 Effective Date: 08103E2021 lrnrvlcs ` Gross nt Currency IG Fee UAF Fee Discount Currency Nlet Amount Caere rh: v 27974108 $2,055.55 USD $0.00 $.00 $0.00 USD $2,05$.55 USG? Wre amotat S98137.51-Payment 17et0 ir lam 09T000016458948 1,R;'.eoei r JD; 50709633 mon .nectwwe,Daie. yiSiZtifidUZT 3rtveite. y , Gross Cur [. .. 10;Fee LAP fee Cola wrd t.*amnt r Net Amount ! 4 rrteecarl+ 279774 3 $25,01.8 USCG $0,00 $0.00 $0,00 USD S25.63 ..5ei SUS© 27977351. $2.O S.50 3}S6 $0.00 $0.00 $0.00 USD uS!7 52)355.50 USD USD 29064428 $Z,0S5,50 USE? _ T $0.00 $0.007 $0.00 S3.05553 2797736-6 $2,055.50 USD $0.00 $006 so.fxc USD 52,05530 USD 27977428 $25.193.81 USD 50.00 $0.00 $0.00, us $ 25,193,61 USD 27977640 $2,05S,S0 USE) $0.00 $000 $0..00 USD $2,05550 USD 27977560 $37,190.14 USDW 50.00 $0,00 50..00 USD $37,'190.14 U5D 896,237.81 Wore ornount $2,055.50 -Flttifrrient DeIE33TG fTr • E b91f7f7t3Ct12430 1 Receiver 1D: 5[7i'14375 Eif2Ct1+,Date< 413lC112029 • 1-vet--21 WIRE W210501-0010 2.063.60 W ro amount. Stin ,266.06 •P3 merit Detail (Trace: 09100000129T02a 3 J 1i Im ID:; 5C1713968 Effectivepater, 1i O9I2021 Invoice Gross Amount Curren IGFee UAPFee Discount urreny rietAmount tlurresrc 30128085 $2,055.50 USD $0.00 $0,00: y $0.00USD $2A,05$30 USD 301284•03 50 $11,3.00 USD $0.00 $0.00 $0.00 USD $11,250.00 USD 29409477 511,250.00 USD $0P a $040 $0.00 U5D 5111,250.00 USD 294094 3 : $)1 , 250:00USD _ _ . $0.00 $ 0.00 - $1.00 USD $11,250.00 : LAD 29409070 512.250.00 USD 50.00 $ 0,00 $2.00. USD $11,230,00 ]USD 21405839. $1i,230.e0 90 $0.00 $0,00 $3.00. USD $ 21,25000 USE] 29405290 $122,250.00 &!•S0 $0,00 $0,001 $4.Oo vs or $21,2$0110 List 29408192 .... $11,350.00 USD $0,00 $0,30 $5.00 us 511,250 00 4.50 29407661 $11,350.00 USD $0.00 $000 $0.00 USD $11,250.00 USD 30110345 ^ $19,232,S6 USO $0,00 $0,00 $$0.00 U5C] $11232.55 USD Total Regards, Alberto Si ,288.08 J4I!S S2.055. 0 $2,t35.5(i_j S`.055_5 S2,055.50 S2,055:5Q 1 TOTAL HN#S Wires 6 From: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Sent: Friday, May 6, 2022 9:24 AM To: Gonzalez -Gutierrez, Alberto<AGonzalez-GutierrezCa7miamigov.com> Cc: Torres, Sergio <STorresPmiamigov.com>; Elliott, Aniska <AElliott()miamigov.com>; Louissa int, Bertine <BLouissaint@miamigov.com>; Cervantes, Nelson (HT) <Nelson.Cervantes(«7miamidade.gov>; Perez, Carmen <CaPerezpmiamigov.coma; Lucdor, Patrick <PLucdor@miamigov.com,; Green, LaKendra (HT) <Lakendra.Green@miamidade.gov> Subject: RE: EFY21- Open Invoices -14800 CAUTION: This is anemail from an external source. Do not click links or open attachments unless you recognize the sender and know the content is safe. Alberto: Based on the documentation provided, I will process the February MOA next week. We need to know the month for the HMIS. It is not August. I have to provide the documentation for that month to process the payment. Our system shows the month you indicated as already processed. Please advise. TerTeri Thomas Earls .Manager, 5fomefss Trust Contracts Division .7btfanii-Dade County .1for etess Trust (305) 375-1490 Office (305) 375-2722 Fax "Delivering ExceQence Everyday„ lieratiZilMIAMI--DADE COUNTY HOMELESS TRUST From: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Sent: Friday, May 6, 2022 9:16 AM To: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade..ov> Cc: Torres, Sergio <STorres@miamigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Louissa int, Bertine <BLouissaint@miamigov.com>; Cervantes, Nelson (HT) Nelson.Cervantes@miamidade.gov>; Perez, Carmen <CaPerez@miamiRov,com>; Lucdor, Patrick <PLucdor@miamigov.com>; Green, LaKendra (HT) <Lakendra.G ree n@miamidade.gov> Subject: RE: EFY21- Open Invoices -14800 EMAIL RECEIVED FROM EXTERNAL SOURCE Good morning Terre': Thanks for your prompt response. In the case of MOA, the February 2021 invoice was submitted on March 12, 2021 via email, because 1 did not have access to the remote folder at that moment (see the email attached). 7 Primary Carr Reirobt rsein nt requests -Febroiy 2021 OGcruzk+z.6ulietrilz. �1MIx rtn, I* .01AtekliXtAdro co” Ki ,tiffs Toro r.pax TmeksooprraitemimirNthuta nrbetoonrawr Mien .110v ,u-Lrto.,v ,; t.p-.. fltnreoch 5tihpkrneef kt Wing PC-4,02I -SWF-I +n bci:irr+teit tIAa'sl Feb 21121.opei 1 OAR to.OSli 2r}21•$YAIf-1 Rtimt.;utamirit0 r.r.b Z021.94I' 171, • 1iR ICc20A 14140.4 Rain lttnsrsner+t tecliA/5.t irt. 42I:0 GDod morAint terbtndja: Miliehrd 01.040frOleittilleWaitu Ctrdr'rtr€aumIAtfarMeimonthrtrrvlhruitry. �l.. nooks, add enjoy yaw kvgpkc+llt, 3rItRO.1it f•: A rart[n 1Ar5 t ' HMIS, according to the wires received from Financial Department of the City of Miami we have only collected ten payments, as you know the HMIS covered the same amount every month, and it is difficult to identify the month with the invoice, because when the City sends us the wire to be applied, they do not specify the month. ID: According with the information provided by Nelson the pending amounts have been paid, thanks Nelson. Carmen: Could you please, check if the amounts below were received by the City?. PC-202140-1 30126357 0000009985 .CITYMIAMI 3/25/2022 2 00(171956 Pik 50728346 3/25/2022 677:000 .30127890 �000o09985 CITY OF IV IAMMI 5/25/2022 2:00 011601954 Paid 50728346 3/25/2022 705.250 O55: I have not received notification from the city about the wire for 11,250.00 Carmen: Could you please confirm if the City has received this wire? It seems to me that now it is more difficult to follow the payment status because the old website is no longer available. (https://w85exp.miamidade.gov/Vlnvoice/1 0a vendor login.isp). Thanks and Regards, Alberto From: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Sent: Thursday, May 5, 2022 4:21 PM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Cc: Torres, Sergio <STorres()miamigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Louissaint, Bertine <6Louissaint@miamigov.com>; Cervantes, Nelson (HT) <Nelson.Cervantesi6miamidade.gov> Subject: RE: EFY21- Open Invoices -14800 CAUTION: This is an email from an external source. Do not click links or open attachments unless you recognize the sender and know the content is safe. Alberto: 8 We have reviewed the invoices and this is the current update: MOA: will be submitting the invoice for March, April and June 2021 today for processing. The February invoice does not appear to have been submitted and is not in the folder. HMIS: I have submitted the September 2021 invoices for processing. Our system shows August as processed and paid. Was this payment applied to another month incorrectly, possibly February and that may be outstanding? Please advise. ID: All of the outstanding payments were pending in the system. I see your new document is showing disbursement of one. The others should follow. 055: Please confirm that this remains outstanding. We show this invoice as submitted. Terrelt"T, EQi, Manager, ifTContracts Division Miami -Dade County Jfomefe rs Trust 111 YV'W 1'* Street, Suite 27-310 Miami, FCorida.33128 From: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Sent: Thursday, May 05, 2022 4:08 PM To: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Cc: Torres, Sergio <STorres(mian'tiigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Cervantes, Nelson (HT) <Nelson.CervantesCtmiarnidade.gov> Subject: Re: EFY21- Open Invoices -14800 EMAIL RECEIVED FROM EXTERNAL SOURCE Good afternoon Terrell: Do you have any update on the amounts pending payment for FY2021?, we have only received the amount of $838.15,. Thanks and Regards, Alberto 9 • MOM ELM Pk GRAM PR IIMMY CABE Y 262/34•021 uMr Of kiiduwisimEirifFicti.F6iri:Aii6iPiamttrrs Itrarets),) PC•20.2.1-57AFF411IAIS 1E.9.•_2,1titL.P37.,,,,..,.............. PC .2•3210.10A fludpit 340,050.d0 PC-2012/••STAFF.141CSAC ; 113.41.10)M u , on ive,M21.16.1 Lu.503.00 'Until KqIQfflPd Math% liAriburiu m111 64queg AslibytIve ittirk141-0 Trust I 1'c rer111/40 1 pvenitput • r IRV kniNSPInn r c nt :Request I Pik' kro ithi ilkilliitixs Trust fanillwroF pgrWirig _ButIcei Rommo ok rirtu,suai Ptl4d by th 0 Hammier'. 'DWI Peridang; for PAVriiiint i r , merit L .0 quors. Pagiry ilia 1tomwin/2 T tilt: Pidr tot 02001110r1 0 Ctob421.21 jr -1-14:iciiiP.,..._ TO _ 12402110•21 _._ F.12811rAT1- Itawch•2.1 _ . ._..,_ 0,0a-21 Po qi-21. 47)ipt .21 S4-pior.bEr-21 ._.... 2)555.56. _ 240,55.16, __kk5§716., ys5.so 2.,P.•5!?.. 2)2551i0 2,655 '!"0 _ 2p5s.15.611_16 25155 i/ Kos5.c.-0- 85 5 SS 2,055. 9) ........_ .....2.05i9:1 .2655.16 *5.§) - - - 25j191.21 ! ! 25,319.)1 3.119o. IA r 201,23019 2...1_442. 51' ' . S22: L 24,2114.611 A,016,7)_. . 11,21156 19121.11 2.&193.11 26,11i..116 42112_74 174s1.14 - - r---- - .243 241 25,91.6.31 19,232.56 '9121.11 - - . 2123019 24/,112.5.7 911, 72 ' 2it3 - 21,n.9.* .,..., 0.b6 p.a'r[ 42566) 1.1.230.00 LI, 250.020 Wow 14256 65 • 11250.06 ia.ISke0 11,250.00 11,251166 22a51111/0 1125000 _ . .62 1-250 - ii,25osoo 11,2503:6. .,11,.254.tv 11,156.61 . • • • . - --- .., • - ......• - • . 21,250.6C • • - B77OLt • • • • 6.39,21 ,...... - 4.16:•80 - 1100 ..,...„. 745.20 . • • • 17.00 .... '766.25 35.4613r .;a,i. 7 .A... 12)165.21 .64 3a266 32521.22 _ . ... ... 9alscaii pAi3,3$ . . . 99,16211 12 ,ma.os 11,422.63 • - _•• - ...., _ - •2,055.50 2055_45 1125602 ---40) ; 11,2 5i0):! y.25411(6, 142k.,co /12560 11,1Stcet . tal a 4 --- g•1•50 7%.25. ., . _....--_ 2.05.,5,so 2,05.56 2,665.50 2,655,56 ... 54;6 745;w • . - „... - • TOTAL V1,656.06 14555.05 4. 00.95 25110 512 : 20 1,O12.16 97,640..64 111,606.66 123 76100 _,.L. 11,250,40 4 17,40 ,421.22 Get Outlook for iOS From: Perez, Carmen <Ca Perez@miamigov.com> Sent: Thursday, May 5, 2022 1:44:04 PM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Cc: Torres, Sergio <STOrreS@MiannigOv.cOM>; Elliott, Aniska <AElliott@miann›; Louissaint, Bertine <BLouissaint@miamigov.com> Subject: FW: EFY21- Open Invoices -14800 Good afternoon Alberto: The following invoices are still open in PnG as of Apr 30, 2022. Please let me know when the money will be received. J i A\ ,.intr_i N L.-hi b el. ra :Dfitilri.. !r1,,,,-,i6-.! Nii .1:1'.4-i' -...0 Atli it 101061.6.Q1UO' • ii ---1,---- r , . I 1?4,0%aIBM, Throvah . ,5,1 91',043:64, 30-5Ep-2;02 di 0754' ,16, 121213. 1 ..,. 4,647,41 i 564 sEp20:,.,,i _.,. p7ST 'r.17 . 121214 135, oco,op i 11 ,250.00 ',.30- SEF-2021 :,,•• : . - ,• ;,-....-.... ....g...--L 21215 445,2000!I C.00 30-SEP-2021 .-____,;...-....._........_...., .,_ -,....ki.,-:-.... • Thank you .1136 74i • , 114i5a7 10 Carmen Perez Financial Analyst I City of Miami - Finance - 444 SW 2nd avenue 6"' Floor Miami, FL 33130 Ph. (305) 416-1963 - caperezOmiamigov.com www.miamIgov.com From: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Sent: Thursday, March 31, 2022 9:58 AM To: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gova Cc: Louissaint, Bertine <BLouissaint@miamigov.coma; Torres, Sergio <STorres@miamigov.com>; Elliott, Aniska <AElliott@miamigov•com>; Perez, Carmen <Ca Perez@miamigov.com> Subject: RE: EFY21- Open Invoices -14800 Hi Terrell, The difference between the other spreadsheet comes from the HTMT amount, the amount of $44,520.00 has been covered by ESG, so you not need to pay this amount, see below the all spreadsheet. Regards, Alberto 11(14,11CLESS PROGRAM - PRIMARY CAM GIIANI.5 - FY "202 o-1411:.L SUMMARY OritriwoRSrMEDl7rw ut:sTsAIMPAYMEHTS GrilAtbtss -l+ai,Bc: ii0ti0I PC-1021-STAPE-1•10415 kelgrtt 7.4,E;66.0a PC-2021-ho. 13Litise1: 3412;11c000 PC-2021-ST Fri-0S5,0C budget: 115, .00 PF-211]•m-L a id et: 12,51:oa PC•2 8 e!: 14 kaborse gilmberitra pgridlilt Icr 11tlrr.busserMl: I' .faffiv ei 11641ir$.cn ell Plindm5 ki Awn1 Pgnclin$lot Rolm lurie Plscalillis 0Ilk RR'p fl Pid eJfnI M . n1ttN1lest. fl!i171itnt tu•Ctt Old Ttyni jfl ,fiq drIt Doiri Diu eM11 utar 1.1. Orkabthr 20 2,055.56 2,065.5b 25 i13,11 5,'1Si#::6-1 - 11,250.00 11,250.00 - -NouK•rnbef30 .XU5550 -x055.50 25,631d{s • 25.631.86•11.250 1 17,250.00 . __ _.� _ " 171xember 0 205,1U Z ts5S.5ci - 2$,383 74 25,38914 11,25O00 1:1;25b.00 - - Jsngisy 2„1a , 2,05 S4 ..2,p55,50 . - _ 37 '190.14 y7,.1SW 14 , - 41.250.00 11,250.00 - Febnxure-.21 2.055.50., 2.055.55 '_ 24230.19. .. 24230.19 a1y25000- 11.25D.00 87700 • B77{+D Morclr 21 2.145.50 2,055,50 24.,+b42.S7 ah,41dt.37 11.250.00 11,260,00 9313:15 8MI L5 Apr11,21. 2,055,.50. .2055,50 24.951.72 34,481.7 11.254.00 11.250.00 • 426.50 426.50 - Mciv-71 -- 2,055,50 2,05s,So - _.. 24,384113 7 ,38.1.63 - ,.. 11,250.00 i1,2.50.00 7U6.2i 70.2.5 .. . iune-21 2,055.50 2.055.50 23.9'9.1.5 - Z3.113{9.16. 11.2S0.05 11,250,00 523.70 523,70 - July -RI first 21 2,055 50 3 0-55.50 2 055.50 • . 2,055.50 25,916.31 19,232.56 - 25.91G 31 13,232,66 .0 Oi(k.. 0l 00l ,11 250_00 3t,250.03 31.25A.D0 11,250 00 - _. --- -'- -- __ . 7a5 . __ . � $ _. __ = SeSt404Y0,r-21 2.055.50 • g.065, a /8,12 13 Iai 2 13 _ 11,259.00 _ 11250.00 7oTAL 24,466.00 , 20,555.06 4,110.95 258,745;B2 201,062.18 97,6+13,44 135,-000JII 123,750.00 1.1,2S4.00 4,.111.412 11696,0O 2,421_40 44,5 0.00 From: Ellis, Terrell T. (HT) <TerreIl.Ellis@miamidade.gov> Sent: Thursday, March 31, 2022 9:50 AM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miarnigov,com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Torres, Sergio <STorres@miamigov.com>; Elliott, Aniska <AElliott@miamigov.com>; Perez, Carmen <CaPerez@miamigov.com> Subject: RE: EFY21- Open Invoices -14800 CAUTION: Fhis is an email from an external source. Do not click links or open attachments unless you recognize the sender and know the content is safe. 11 This spreadsheet does not totally match what the other one has. Please advise. Terre a-T. El ? , %tanager, .Ji Contracts Division 1iami-Dade County'€nme€ess Trust 111.fW 1t street, suite 27-310 Miami, Tkni€a 33128 From: Gonzalez -Gutierrez, Alberto<AGonzalez-Gutierrez@rniamigov.com> Sent: Thursday, March 31, 2022 9:29 AM To: Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Torres, Sergio <STorres(miamigov.com7; Elliott, Aniska <AElliott@)miamigov.com>; Perez, Carmen <CaPerez@miamigov.com> Subject: RE: EFY21- Open Invoices -14800 EMAIL. RECEIVED FROM EXTERNALSOURCE Hi Terrell, Thank you, attached please find the copy of the amounts pending for payment, as you know the HTMT amount was covered by ESG. Ht?M.ELEE,S t OGR/M-PRIMARY CAftEGRAN'S'.S - PY 1020.2.621 SUMMARY OF REIMBURSEMENT RECOES1S ,Aav'r3 PAYMENTS Grarrka .+ audit arncunt C-2029.-SrAFP 1•HMIS P• Budget: 24,666.00 PC -2021- MCIA Budget: 34Q,00040 . PCrZ 21-STAFF-3-ossiFc Budget; 135,000.CD A Re:lrrtl urse Paid by the s 'Pali bytbe Paid by the in molt Homeless 'P1andrefur Reimht,tsern1 Pendiir% it,r Relmburserne Ho Fri eles5 Pending rr Months- Request Trust :payment ent Request I Trust grailment nit Request Trust payment H Ottober 24 .,. 2.055.50 ... 2.055.50 : _ . ,. 25,193.31 ] 25,193.9i1 , 11T2:50.4o 11 porno . November 2b 2,05.5.50 2,055,50 h. 25,531,96 25,631.96 - 11,250.00 11.250.00 - December2D 2 05550 2,O55.5Ji - 23,399.74 25 a9.74 - 11,250.00 11,250.00 - Jar/toffy-21 2)355.50 2,055.50 37,190.14. i 37,190.14 - 11,250.00 .11,,250.00 . Pebr.ua -21 2,055.50 2,055.5:5 . 24,230.19 I 24,230.15 11,250.00 11,250.00 - _-- �— 8 March-21 2,055.50 2,055.50 [ - 24,442.57 I - 24 t42.57 11,250.03j 11,750.00 - s Apr11-21 2,055.50 2,055.50 1 24,991.72 ' - 24,581.7.2 11,250.00 11,,250.00 - 4 _m._._i�iv 2.1 .. 2)355.50 ..T3 755.50 .� - 24,384.63 24,3EA 63 11,250.00 11250.00 _- .. - 7 3una-21 2,055.50 2,055.511 - 23.989.16 - 23,989 16 11.250.00 11.250.00 - 5 Ally--23 2,053.50 2,055.50 - 25.916.31 2.5,91.6.31 0.00 11,250.00 11.250.00 i, J443gu5# 21 2,055,59 - 2,055.50_ 1.9,232 56 19,232.5E (0.00} 11,250.00 11„250.00 September-21 2,055.50 - -:,055.45 28,123.13 I 18,123.1.3 - 11,250.00 1] 250.O0 TOTAL24,666.00 20,555,os 4,110.95. 2.93,705,02 1 201,062.1.1 97441.04 135,000.00 1.23,790.00 11.,2S0.00 ; 4,1 Regards, Alberto _ - From: Ellis, Terrell T. (HT) <Terrell.Ellisfflmiamidade.gov> Sent: Thursday, March 31, 2022 9:15 AM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com>; Perez, Carmen <CaPerez@miamjgov.corn> Cc: Louissaint, Bertine <BLouissaint@miamigov.coma; Torres, Sergio <STorres@miamigov.com> Subject: RE: EFY21- Open Invoices -14800 12 CAUTION: This is an email from an external source. Do not click links or open attachments unless you recognize the sender and know the content is safe. Good Morning: I have responded to the prior email. Could some please identify the breakdown of the chart? We are working from a prior excel spreadsheet sent by Alberto. Terr'etI°I: EGIts, 9elanager, NT Contracts (Division aliaini-Dade County .Womekss gust 111 4'1it Street, Suite 27-310 7biiami,'FYorida 33128 From: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Sent: Thursday, March 31, 2022 9:11 AM To: Perez, Carmen <CaPerez@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Torres, Sergio <STorres@miarnigov.corn>; Ellis, Terrell T. (HT) Terre 11. E 1l is@ m is m idad e. gov> Subject: RE: EFY21- Open Invoices -14800 EMAIL RECEIVED FROM EXTERNAL SOURCE Good morning Carmen: I requested to the Homeless Trust an update of the amounts pending but unfortunately I can't do nothing else about it. Please, when you send the emails include Sergio Torres. Regards, Alberto From: Perez, Carmen <CaPerez@miamigov.com> Sent: Thursday, March 31, 2022 9:00 AM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov,com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com> Subject: FW: EFY21- Open Invoices -14800 Good morning Alberto. FYI List of open invoices as of 03.30.22 13 6�vwarr] Number I'Drattl A.1;! I~nvolce Arrio irrt 1.8.16eide Due Tlirough • 1,2767 • -€ 2'1212 ._...- 12;t213 .....,. 12'1214 1.1:1215 134,000,343 9,647_41 44,50 00 g7.843.64. i3O-SEP-2021 13,532 35';30 SEP-202'1 t 25000; f:30 SEP-202'1.. _:; 0 00 $EP 2012:1 • y Thank you Carmen Perez Financial Analyst ii City of Miami - Finance - 444 SW 2"`' avenue 6" Floor Miami, FL 33130 Ph. (305) 416-1963 - caoerez@miamigov corn www mlamlgo.Ysom From: Perez, Carmen Sent: Wednesday, March 2, 2022 1:03 PM To: Gonzalez -Gutierrez, Alberto <AGonzalez-Gutierrez@miamigov.com> Subject: RE: EFY21- Open Invoices -14800 Thanks Alberto. From: Gonzalez -Gutierrez, Alberto<AGonzalez-Gutierrez@miamigov.com> Sent: Wednesday, March 2, 2022 12:44 PM To: Perez, Carmen <CaPerez@miamigov.com> Cc: Elliott, Aniska <AElliott@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Ellis, Terrell T. (HT) <Terrell.Ellis@miamidade.gov>; Green, LaKendra (HT) <Lakendra.Green@miamidade.gov>; Torres, Sergio <STo ryes @ m is m igov.corn Subject: RE: EFY21- Open Invoices -14800 Good afternoon, Carmen: 14 am sorry for this delay, but the solution is not in my hands. In the case of Award 2758, the amount ($44,520.00) will be removed from this project when the CD Department completes the posting of the JE submitted OE 010). The rest of the open invoices are still pending for payment from the Homeless Trust. Regards, Alberto From: Perez, Carmen <CaPerez@miamigov.com> Sent: Wednesday, March 2, 2022 11:41 AM To: Gonzalez -Gutierrez, Alberto<AGonzalez-Gutierrez@miarnigov.com> Cc: Elliott, Aniska <AEfliott@miamigov.com>; Louissaint, Bertine <RLouissaint@miamigov,com> Subject: FW: EFY21- Open Invoices -14800 Good morning Alberto, The following invoices are still open invoices in PnG as of Feb 28, 2022. Please let me know when the money will be received The JE to reclass the $44520.00 is still pending in PnG ( Invoice 121215). in rce UI11 §aiy.( ofh1lar Ns Thank you STI V1212.134,999 3 , [ 97,1r4:3 64 I&.-sE•P--:7021' 1 1t214 135,O00 Ott. [ 11,25g.00• J30-8EP-2021 '12121• 4r4, 20 -00 3 ,.. _.� 414,.520 I 0 iQ"5EP--2021 Carmen Perez 71[IBM iri+u90 15 Financial Analyst I City of Miami - Finance - 444 SW 2nd avenue 60 Floor Miami, FL 33130 Ph- (305) 416-1963 - g rg amLamlaov,cam www miaruigov'Com From: Perez, Carmen Sent: Monday, February 14, 2022 3:21 PM To: Gonzalez -Gutierrez, Alberto eAGonzalez-Gutierrez@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com> Subject: FW: EFY21- Open Invoices -14800 Good afternoon Alberto, The following invoices are still open invoices in PnG as of Feb 14, 2022. Please let me know when the money will be received. The JE to reclass the $44520.00 is still pending in PnG { Invoice 121215). J irr..roFLti..'`�IJr ' '�•I.ajSy it' Or NIllarni) A1+ rd Numbar a t JAR Irirticice ld Invciiee lamotsts< 121 12 '1 134,990.33; 54 12757 �. 275 Thanks t12,''1213.: _.. ti.2 214 12'121.5 —11 Balance Due 1113111 Tlinough 97,643 64 130-SEP-2021 9 647.41i, 6,5.32,35 130 SEP-20.21 135.i t3i7.00. 1 SE_ 1,250 00 130-P-20211 44:,520,00 44,52000 r30 SEP-2021 ._ ._ *�}66. . lr I,ri-ice ri9. Carmen Perez Financial Analyst I City of Miami -- Finance - 444 SW 2'4 avenue 60' Floor Miami, FL 337.30 Ph. (305) 416-1963 - caDerez@miamiggv.com. www mlamigov com 16 From: Perez, Carmen Sent Wednesday,]anuary1I 20221:43PIVI To: Gonzabz-Go1|ernaz,Alberto <AGonza|ez'Gut/e/rcz(cDm|ono|govzom> Cc: Louissaint, Bertine<BLoujssaintomiamiguv.00m> Good afternoon Alberto, The following invoices are still open invoices inPnGasofJan 12,2O22. Please let nxeknow when the money will be 41 ' un 47 �A�~.�'/ iCredb�d�� ` ��c�`��e' !� Date� 121214 I35,000.00 1I3,750.00 21,250l0 30'Sep-21 121212 134,999.33 37,365.69 97,643.64 30-3op-21 121213 9,647.41 1,696.00 7,951.41 30'Sep'21 122215 44520J08 1,419.06 43,100.94 30-Sep-21 Total 159,945.99 Carmen Perez Financial Analyst I oLrvrryl|vm/ - nnoo,e **4sw 2n'Javcn"n am Floor Miami, n'z31xo Ph. (3os) 416-1963 'ow From: Perez, Carmen Sent: Wednesday, October 2D,2DZ11:O7PIVI To:Gonza|ez'Gutierrez A|berto<AGonza|ez_Gutie/naz@)miom|Rov.oxm> Cu: 8edine Louisnaint(8Louiaaa|nt@miam|goy.CD[n)<8Louinom|nt8mmiam(gov.com> Subject. EFY21'Open Invoices 'l480D Good afternoon Alberto FYI The following Invoices were created as part of the end of FY21. 17 274 , 757 1i2758 17 Regards tAavard Nt mbsr 'Fr AR I rtaoi •be NI In to Amount i Glance Due 1 i �3i11 Thral i1 , 12753 _�.a..� 4121212 134,999 33' 13,99q 33 F30 SEPF2021 121211 9,647.41 19.647.41 30-SEP-2021 15.21214 135,000M. 135. 010.OQ 130-SEP-2021 12121.6 44 5 20 001 44,520 00 30SEP 202 I Carmen Perez Financial Analyst I City of Miami — Finance - 444 SW Zn° avenue G"' Floor Miami, FL 331.30 Ph. (305) 416-1963 - caperezamlam gov.com www.mlamigov cam 18 CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO: FROM : Erica T. Paschal Director Department of Finance omas L. Carr Assistant Chief of Police Administration Division DATE : SUBJECT: PnG & GL BL 08-15-2022 JUL 0 8 2022 JE Request - PnG Project No. 19-192025 REFERENCES: ENCLOSURES: Please take the necessary steps to process a Journal. Journal Entry should reflect the following: FY 21 Speed & Aggressive FILE Account Number Debit Credit Description 00001.190101.514000.0000.00000 $8,943.85 Transfer of Expenditure 12000.190101.514000.0000.00000 $8,943.85 Total $8,943.85 $8,943.85 Project Award Task Expense Organization Amount 19-192025 2713 02 OT 190101 ($8,943.85) The Police Budget Unit personnel has completed the JE processing under the General Ledger, as required. Should you have any questions regarding this request, please do not hesitate to contact Maricelis Perez, Admin. Assistant 1, in the Police Business Management Section at (305) 603-6207. TLC:JB:mp Attachment Perez, Maricelis From: Jean -Michel, Pierre <PJean-Michel@miamigov.com> Sent: Thursday, July 7, 2022 12:12 PM To: Perez, Maricelis Cc: Soler, Alfredo; Louissaint, Bertine Subject: RE: A2713 JE Memo Revision Request [EXTERNAL EMAIL] Caution: This is an email from an external source. Do not click links or open attachments unless you recognize the sender and know the content is safe. Hi Mari, The object code refers to the highlighted amount $16,599.84. Whereas the entry for $10,357.43 (now $8,943.85) refers to the current FY. Object codes 481101 and 891101 LB Louissaint, Bertine <BLouissaint@miamigov.com> To Rojas, Victoria; Borrego, Ricardo; • Woldegiorgis, Zewditu Cc • Li, Eric it, Perez, Maricelis- Police; Pope, Shedrick; • Fernandez, Wendy; • Riley, Tara- Police; • Quintana, Shirley; Hernandez, Rene Dept JE Doc# Update Object Codes to 481101 and 891101.xlsx 25 KB Journal Name MPDMP03092022 FY18 Justice and Mental Training City Match several check dates MPDMP03182022 FY 20 VOCA Reclass MPDMP03182022 FY 21 VOCA Reclass MPDMP03182022 Smart Policing Grant Reclass MPDMP03222022 FY 21 Speed and Aggressive Grant Reclass 1 Debit Credit Number 3,037.23 3,037.23 251637 9,685.95 9,685.95 252127 17,723.74 17,723.74 252126 1,429.05 1,429.05 252128 16,599.84 16,599.84 252287 =l NS Award Number Draft AR invoice NL invoice Amount [Balance Due Bill Through I Invoice Date GL Date i1Invoice Status 1.2713 1 1121059 18,306.65 [! 0.00 08/27/2021 08/27/2021 08/27/2021 [Accepted in Receiv ,2713 2 121284 166,190 44 0 00 09/30/2021 [09/3012021 09/30/2021 'Accepted in Receiv r l ` ". � 121827 16,599.84 0.00 O6/23/2022 2713 8E1 10,357.431 8,943,85,i l06/23/2022 06/23/2022 ecepted in Receiti 2713 4 '06/29I2022 106(29/2022 06/29/2022 Accepted in Receii f P Bill Amount Thank You, :'468 Description 10,209.39 1FY22 PJM11042021 To Police Payroll OT Expenses for Ck Date 10/15/2021. 148.04 FY22 PJM11042021 To Police Payroll OT Expenses for Ck Date 10/15/2021. Pierre Jean -Michel Financial Analyst City of Miami — Finance - 444 SW 2nd Ave, 6th Floor Miami, FL 33130 Ph. (305) 416-1292 — }jean-michel@miamigov.com From: Perez, Maricelis <5629@miami-police.org> Sent: Thursday, July 7, 2022 12:00 PM To: Jean -Michel, Pierre <PJean-Michel@miamigov.com> Subject: RE: A2713 JE Memo Revision Request CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM TO : FROM: Erica T. Paschal Director Department of Finance Thomas L. Carroll Assistant Chief of Police Administration Division ❑ATE : SUBJECT: MAR 2 1 2022 JE Request - PnG Project No. 19-192025 REFERENCES: ENCLOSURES: FY 21 Speed & Aggressive FILE Please take the necessary steps to process a Journal. Journal Entry should reflect the following: Account Number Debit Credit Description 00001.190101.489900.0000.00000 $16,599.84 Transfer of Expenditure 12000.190101.489900.0000.00000 $16,599.84 Total $16,599.84 ' $16,599.84 Project Award Task Expense Organization Amount 19-192025 2713 02 Equipment 190101 $16,599.84 The Police Budget Unit personnel has completed the JE processing under the General Ledger, as required. Should you have any questions regarding this request, please do not hesitate to contact Maricelis Perez, Admin. Assistant I, in the Police Business Management Section at (305) 603-6207. TLC:JB:mp Attachment PnG CASH RECEIPTS WIRE er CIIEC:K,IVIOLINT R5CEISTD IN TILE 11ANA Prepared By: Pierre Jmn.311ehe1 INVOICE AMOUNT 39,856.27 THESE FUNDS NEED TO RE TRANSFERRED TO: 99,412 99 AR bo.reorIP CUSTOMER/I Wire Ts..m..Npl1 S TO APPLY NOTES 1212E-4 1016 306503-4 1256.37 Claim 655 sentto CR en 03(15/22 On Account 15642 Al Nen-minb,an..d4 per 0441 Total Trans, l0 5.411.59 Total Wire 9412.99 MITE muery' TO CA96 PPa7T0 Sign4hue Trans Id 3/130921 Ewenna0O1e0 ochre 1mn•IL of riq;,nce C.LII Fomedl Fu„e P.O. Talk Award raped Type Item nate Employee/5oppller Quantity UOM prof Func Bur Proleetsu AR Invoke Bill Amour Comment Espnd Ore Non -labor Non -labor I Prvdr Lees Recur legal Entity 437039019-192015 1 2713 Overtime 25-Sep-21 claim 5 9019.43 Currency 2,019.45 3019,E-5 121284 FY31MN032320211E To post PO Payroll oT Enu 190101- Police Field Operations C.... City of Mia City of Miami 437039119-192025 2 2713 Flo Taxer 25-Sep--21 Claim 5 43.78 Currency 4479 43,78 121284 FY219400523202.112 To post PD Payroll OT Ecp 190101- Police Fleid Openrlont C.... Cry of Mia City or RI iamI 437037919-192025 1 27I3 Overtime 25-5ep-21 Claim 6 0259 Currency 6.259 b0 5259 121284 FFY21 MR09282011 J6 To post PD Payroll OT Eno 190101- Police Field a peranou C.... City of Mia City of Mlaml 4270379 19-192025 2 2713 Pica Taxer 25-5ep,21 Claims 30.76 Currency 90.76 90,75 121284 FY22 MR0928202118 To post PO Payroll oT Ecp 190101-Polk. Field 0perarloro C .... City of Mia City of Miami Invoice Total 941293 n<ern9/15/201; Note: Apply were amount of g12,_51,1t towards lnvoice9121284.Thereby, reducing non-Irirnburea bleanount to 516.599.84. Dept to send to mmmbslon, then provide a JE requesting m offset 516,55944 Nun./ C.11 Invraixr. nnmra mourn 9yelc. nor 911 newer] 090ae GL Ode Vie 1 17tfir 1BYM65- Od111127J201, 03r112921 'P5,r27,7C71 2111 7 r41Yw mme,1W Je.450.1 46,04,2121 ➢lla., 0/942921 AR Invoke Number 121234 VNra1Re2Jp34 307223 Amount 161,190.44 Comment Amnl o,00 d lee niaim a2 - aI I 307220-1 30721E-1 306503 (22,672,09) (14.841 92) Claim e2 Claim p3 1102,820.02) Claim 14410, Earlia1611 Balance Due 26,8E-8.41 Per 0ep1. n5nadmbumeable by tale Ch6 Arent 9,256.57 On Account 126.42 Non.relnbureeabl. per Dept Trame T9e2 Trani ID Bu CO. d- 1 Num _ Type Elm !tern Ev.nt D:r: 4370380 3,019.45 1 Overtime 9/25/1021 4370379 6,259.00 1 Overtime 9185/2521 43703131 43.79 2 Eke Tauet 9/15/1021 4370379 90.7E 2 rice Tames 9(25/2021 9,412.99 25,356.41 (9,256.57) Claim 85.6 Wlre amoeme applled pn 3/15/22 16,599.34 Nan-relmhorseble Add. Fa,. In RS.. nal VAUM un ns 1 40 sign. ay eurnt a,eatl Epnalal h.ieum and is. 11. City eat K.lk a ln p,oeAtls or tiny ellxl•a t nYment nrxv,, ICIE Nw . n4m Ciy of Miami OFFICIAL RECEIPT T1tal 9� Depanm0 094,14.1- No. 50��6,�. 8,,5,,'� late ,�.I o,wlwrr, we,. Cwe.,P awn•Ew.ce. pst-w.,e. pem.e.el Prrvdxsna41ar1npn lrri Ic.,en..e ,.... pt.....creauur mitt Syr. DMASCI DAYS ...my its sic 06-1023.00 r-SS ISOa00-00-pe.7v� e11 205 SO0e5l7 taw Iv 9/at as 064E-001-1 -iSt.- MO 050000 s,Ts m ,c .r Iaeo3 +4 - rl eoe9 ,r.nc STATE OF FLORIDA 4-34-439 552 DEPARTMENT OF FINANCIAL SERVICES AMOUNT MINE-THOUSAND-Tu0-3DN0RE0-FIFTY-SIR 6 57/100 DOLLARS DUPLICATE 01/14/22 uaod � TYE 'f.enixE"T MIAMI f4"i5113-17oa esetimil S. CM /I It..5..g.757,271 ERPENse eaexum CITY OF MIAMI, FLORIDA INTER -OFFICE MEMORANDUM Erica T. Paschal, Director DATE: Finance Department Jaqueline Lorenzo, Interim Director Department of Real Estate & Asset Management SUBJECT: REFERENCES: ENCLOSURES: June 24, 2022 PnG & GL BL 07-19-2022 Reclassify expenses from 40-B30685 Award 1697 to 40-B30685C Award 1350 Attachment A (Reso, Minutes Snippet) Attachment B (Oracle 40-B30685 Project Info) Attachment C (Expenditures Report) Attachment D (PnG Revenue &Expense Report) Attachment E (40-B30685C Funds Available) On April 8th, 2010, the City Commission passed a resolution authorizing the City Manager to accept a grant in the amount of $172,000.00 from the "Miami -Dade County Safe Neighborhood Parks Bond Program" for the acquisition of land located at 1814 Brickell Avenue. The grant required the allocation of matching from non -general fund monies. Matching funds used were allocated from Special Revenue Fund Contribution to Capital (Award 1350) and loaded under project 40-B30685 (See attached A & B). The City subsequently received a reimbursement from Miami -Dade County in the amount of $171,248.30; however, a total $172,000.00 was fully expended against the grant award 1697 leaving a non -reimbursable difference of $751.70 (See attachment C & D). The Department has identified a sibling project (40-B30685C) which maintains a fund balance Special Revenue Fund Contribution to Capital (Award 1350). As this expense is no longer reimbursable, and the original project 40-B30685 is now closed, the Department requests that the difference of $751.70 be reclassified to utilize a portion of the remaining funds in 40-B30365C (See attachment E) We ask to reclass said expense in the following manner: Account PATEO Transaction ID Debit Credit 40-B30685, A#1697, T: 07, E: Land, 0: 221100 445988 $751.70 35000.221100. 481101 00.00000 Account PATEO Transaction ID Debit Credit 31100.291001.r )00.00000 40-B30685C, A#1350, T: 04, E: Land, 0: 291001 445988 $751.70 TOTAL EXPENSES TO BE ADJUSTED: $751.70 Thank you for your assistance and if you have further questions, please feel free to contact Gabriel Brito at X1460. J L/G B cc: Pedro Lacret, Budget Coordinator Office of Management & Budget Pg. 1 Victoria E. Rojas, Finance Manager Finance Department Bertine Louissaint, Senior Financial Analyst Finance Department Rene Hernandez, Grants Financial Analyst Finance Department Barbara Hernandez, Director Parks Department Latoya Osborne, Special Projects Coordinator Parks Department Pg.2 Hernandez, Rene From: McGinnis, Lai -Wan Sent: Tuesday, July 19, 2022 2:49 PM To: Hernandez, Rene; Jacks -Palomino, Charlene Cc: Louissaint, Bertine; Lucdor, Patrick; Brown, Carol; Quintana, Shirley Subject: RE: JE 40-B30685 Award 1697 $751.70 Time Sensitive: Baseline Request and Temporary Project Status Change Hi Rene, The baseline is done. The projects have changed to the Approved status; please change back to the Close or Pending Close statuses respectively once the entry has been completed. Kind Regards, Lai -Wan E. McGinnis Capital Budget and Financial Administrator Miami Riverside Center l Office of Management & Budget 444 SW 2" d Avenue, 5th Floor, Miami, FL 33130 Office: (305) 416-1261 Fax: (305) 400-5278 From: Hernandez, Rene <ReHernandez@miamigov.com> Sent: Tuesday, July 19, 2022 1:11 PM To: McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Jacks -Palomino, Charlene <CJacks-Palomino@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com>; Brown, Carol <CarBrown@miamigov.com>; Quintana, Shirley <squintana@miamigov.com> Subject: RE: JE 40-B30685 Award 1697 $751.70 Time Sensitive: Baseline Request and Temporary Project Status Change Importance: High Hi all, The JE has been approved. Please baseline. Systematic extension to process JE. It has been extended for today only. 1 Award Management 1 Operating Unit City of Miami Number Short Name SNPB # 2- Brickell Ave Full Name Start Date 12-01-2009 Close Date 07-19-2022 Purpose Culture/Recreation Organization 291001 - Parks - Admini Award Amount 172,000.00 1697 Template SNPB # 2- Brickell Ave Park Land J Funding Sc Funding Source Am Pre-) Revenue Hard Limit Invoice Hard Limit Fun Additionally, please change the project status to approved. I will confirm when the JE has been processed so that it can be changed back. Projects, Templates Operating Unit City of Miami Number Type Long Name Trans Duration 09-30-2006 0-B30685 Sponsored Indirect Name Organization Brickell Avenue Park - Land Acquisition - 09-30-2026 Status Projects:, emplates Operating Unit City of Miami Number ' Nan Type Sponsored Capital Organizatic Long Name Brickell Avenue Park Shade Structures - D2 Trans Duration 06-01-2014 - 102-01-2026 Stab. 0-B 068 C Thanks, 2 Grants Financial Analyst City of Miami Finance Department 444 SW 2"d Ave, 6th Floor Miami, FL 33130 Phone: 305-416-1036 Email: rehernandez@miamigov.com Website: http://www.miamigov.com/finance From: McGinnis, Lai -Wan <Imcginnis@miamigov.com> Sent: Thursday, June 23, 2022 10:24 AM To: Hernandez, Rene <ReHernandez@miamigov.com>; Brito, Gabriel <GBrito@miamigov.com> Cc: Lorenzo, Jacqueline <JacLorenzo@miamigov.com>; Hernandez, Yvonne <YHernandez@miamigov.com>; Hernandez, Barbara <BaHernandez@miamigov.com>; Osborne, Latoya <LTOsborne@miamigov.com>; Jacks -Palomino, Charlene <CJacks-Palomino@miamigov.com>; Alcala, Daniel <DAlcala@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com>; Brown, Carol <CarBrown@miamigov.com> Subject: RE: JE 40-B30685 Award 1697 $751.70 Time Sensitive: No Funds Available: 4th Request (Funding Source Change) Confirmed. That is correct and the changes can be made on the existing JE. The project is in pending close as to not have any potential charges. Once the JE is sent to finance I will update the status to approved. Kind Regards, Lai -Wan E. McGinnis Capital Budget and Financial Administrator Miami Riverside Center I Office of Management & Budget 444 SW 2"d Avenue, 5th Floor, Miami, FL 33130 Office: (305) 416-1261 Fax: (305) 400-5278 From: Hernandez, Rene <ReHernandez@miamigov.com> Sent: Thursday, June 23, 2022 9:33 AM To: McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Brito, Gabriel <GBrito@miamigov.com> Cc: Lorenzo, Jacqueline <JacLorenzo@miamigov.com>; Hernandez, Yvonne <YHernandez@miamigov.com>; Hernandez, Barbara <BaHernandez@miamigov.com>; Osborne, Latoya <LTOsborne@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com>; Jacks -Palomino, Charlene <CJacks-Palomino@miamigov.com>; Alcala, Daniel <DAlcala@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Lucdor, Patrick <PLucdor@miamigov.com>; Brown, Carol <CarBrown@miamigov.com> Subject: FW: JE 40-B30685 Award 1697 $751.70 Time Sensitive: No Funds Available: 4th Request (Funding Source Change) Importance: High Good morning, 3 Lai -Wan, Per our conversation, please confirm that DREAM can reclass the expenditure using award 1350. In addition, the project is currently in a status of pending close. I think you will need to change the status to active and I will advise when the journal entry has posted so that you can change it back to pending close. Operating Unit Number Type Long Name Brickell Avenue Park Shade Structures - D2 Trans Duration 06-01-2014 City of Miami Sponsored Capital Name Organization _ 02-01-2026 Status Gabriel, Upon confirmation from Lai -Wan, please revise the journal entry. Debit P#40-B30685C A#1350. As you are aware, no funds are available under P#40-B30685C A#1422. Please submit the revised redline memorandum no later than Monday, June 27. The current reporting period is closing next week in PnG and we would like to post the journal entry this month if possible. Account 35000 221100.661000.0000.00000 Account PATE 40-B 221100 PATEO 4 Project Number Award Number Budget Version 40-B30685C 1350 E C8uduet Funds Check Results Project Budget Version E rickell Ave Park Shade Str As always, thank you for your attention, Grants Financial Analyst City of Miami Finance Department 444 SW 2nd Ave, 6th Floor Miami, FL 33130 Phone: 305-416-1036 Email: rehernandez@miamigov.com Website: http://www.miamigov.com/finance From: Hernandez, Rene Sent: Thursday, April 14, 2022 8:28 AM To: Rojas, Victoria <VRojas@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com> Subject: FW: JE 40-B30685 Award 1697 $751.70 Time Sensitive: No Funds Available: Third Request Importance: High Victoria, As requested. 5 Project Number 40-B30685 Award Number 1422 Budget Version Project Narrie Brickell Award Name Impact Budget Statue Baseline Euiciet Funds (heck Results Project Budget Version Brickell Ave Perk Shade :tr Operating Unit Number Type ..:ronoorecl Capital City of Miami 0-B: f IF7Fi�i N;rriE OrganiZatior Long Name Brickell Avenue Park Shade Structures - B2 Trans Duration 06-01-2014 _ 02 01-2026 St;tu. Thanks, Rene From: Hernandez, Rene Sent: Wednesday, April 6, 2022 1:31 PM To: Brito, Gabriel <GBrito@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; Lorenzo, Jacqueline <JacLorenzo@miamigov.com>; Hernandez, Yvonne <YHernandez@miamigov.com> Subject: FW: JE 40-B30685 Award 1697 $751.70 Time Sensitive: No Funds Available: Third Request Importance: High Good afternoon Gabriel, Hope your week is going well. 6 As you are aware, we have been unable to process the attached journal entry because the project/award combination used does not have funds available. Additionally, because the expenditure is not allowable under the current award, it must be moved out of the award's expenses as soon as possible. Please note this is the third request. Please let us know if funds will be made available and when, or a revised journal entry will be submitted. Thanks, From: Hernandez, Rene Sent: Monday, March 7, 2022 8:27 PM To: Brito, Gabriel <GBrito@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com> Subject: RE: JE 40-B30685 Award 1697 $751.70 Time Sensitive: No Funds Available Importance: High Good evening Gabriel, Please advise status. Thanks, Rene From: Hernandez, Rene Sent: Thursday, February 24, 2022 5:36 PM To: Brito, Gabriel <GBrito@miamigov.com> Cc: Louissaint, Bertine <BLouissaint@miamigov.com>; McGinnis, Lai -Wan <Imcginnis@miamigov.com> Subject: FW: JE 40-B30685 Award 1697 Time Sensitive: No Funds Available Importance: High Hi Gabriel, It appears the budget for this project was defunded and funds are no longer available to process the attached JE. Please advise. Former Budget and Funds Available 7 Project Number 4-E 3n';EC Award Number 1422 Budget Version Project Narne Eriokell Me Park Shade Award Name _Irip cL Fees Nev Ordir Budget States Easelined Project Budget Version Br Lkell /ve Park Shade SIT Award _ ripa0t Fees He Status Baselined wrd Topr .i, r;3r, rg==r a t_:=r_I..:ocou_,.., Budgetary Control Level Current Budget and Funds Available Project Number Award Number Budget Version 40-B30685C 1422 Project Budget Version Project Name Brickell Ave Park Shade Award Name _Impact Fees New Ordi Budget Status Baselined Brickell Ave Park Shade Str Additionally, the project is pending close. Award _Impact F Status Baselined 8 Projects, Templates Summary Operating Unit Number Name Project TypE Thanks, From: Louissaint, Bertine <BLouissaint@miamigov.com> Sent: Monday, February 14, 2022 4:00 PM To: Hernandez, Rene <ReHernandez@miamigov.com> Subject: FW: JE 40-B30685 Award 1697 Hi Rene, Please save. From: Brito, Gabriel <GBrito@miamigov.com> Sent: Monday, February 14, 2022 3:25 PM To: Finance JEs <FinanceJEs@miamigov.com> Cc: Lacret, Pedro <PLacret@miamigov.com>; Louissaint, Bertine <BLouissaint@miamigov.com>; Hernandez, Rene <ReHernandez@miamigov.com>; Hernandez, Barbara <BaHernandez@miamigov.com>; Osborne, Latoya <LTOsborne@miamigov.com> Subject: JE 40-B30685 Award 1697 Attached please find a required JE for Award 1697 related to Brickell Ave Park Land Acquisition Project. (40-B30685) Thank you, GabrlelJ. Brlto Senior Staff Analyst Department of Real Estate and Asset Management 444 SW 2 Avenue, 3rd Floor Miami, Florida 33130 Phone: 305.416.1460 Gbrito@miamigov.com 9 Trans Id Project Task Award Expnd Type Item Date Project Burdened Cost Comment Expnd Org 5036376 40-B30011 1.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (3,129.89) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, CMIA Regular, Various Trans IDs 401000 5036377 40-B30011 1.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (44.78) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Medicare_ER, Various Trans IDs 401000 5036378 40-B30011 1.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (191.49) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, SS_ER, Various Trans IDs 401000 5036379 40-B30011 1.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (23.75) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Cell Phone Allowance, Various Trans IDs 401000 5036380 40-B30011 1.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (25.00) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Automobile Allowance, Various Trans IDs 401000 5036381 40-B30011 2 2039 Transfer In -Prior Year adjustm 17-Aug-22 (38,000.09) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Construction, Various Trans IDs 401000 5036382 40-B30011 3.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (2,608.58) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, CMIA Regular, Various Trans IDs 401000 5036383 40-B30011 3.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (28.85) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Medicare_ER, Various Trans IDs 401000 5036384 40-B30011 3.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (224.26) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, SS_ER, Various Trans IDs 401000 5036385 40-B30011 3.02 2039 Transfer In -Prior Year adjustm 17-Aug-22 (26.25) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Cell Phone Allowance, Various Trans IDs 401000 5036386 40-B30011 4 2039 Transfer In -Prior Year adjustm 17-Aug-22 (741.56) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, CMIA Regular, Various Trans IDs 401000 5036387 40-B30011 4 2039 Transfer In -Prior Year adjustm 17-Aug-22 (10.54) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Medicare_ER, Various Trans IDs 401000 5036388 40-B30011 4 2039 Transfer In -Prior Year adjustm 17-Aug-22 (45.05) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, SS_ER, Various Trans IDs 401000 5036389 40-B30011 8 2039 Transfer In -Prior Year adjustm 17-Aug-22 (3,410.77) FY22 RH08172022 To Reclass Non -Reimbursable Expenditures Posted in P# 40-B30011, Professional Services, Various Trans IDs 401000 (48,510.86) Hernandez R Cc: Darnel, W eodcr, Pan, Brown, Card Winer, �039 SE o Reclass Edoendtdreenday,September 30, 20228'. 19'.35 AM Attachments: Imamoorl Imaoe911 Vm Good morning Bertine, Please Interface. Thanks, Rene From: Loulssalnt, Bernne<BLoulssalnt@mlamlgov.com> Sent: Thursday, September 29, 2022 4:36 PM To: Hernandez, Rene <ReHernandez@mlamlgov.com> Cc: Daniel, Velouse<VDanlel@mlamlgov.com>; Lucdor, Patrick<PLucdor@mlamlgov.com>; Brown, Carol <CarBrown@mlamlgov.com> Subject: RE: A20391E to Reclass Expenditures HI Rene, Please use the trans IDs below to create the Invoice to apply the open Invoices. Regards, Bertine Loulssalnt Senior Financial Analyst FinanceOW of Miami - 5 an. (305) 4161r (305) 41s 9s2-binu6ccarn ®miamio3o ov com From: Brown, Carol <CarBrownCrxmlamlgov.com> Sent: Thursday, September 29, 2022 3:51 PM To:Hernandez, Rene<.RPHPrnandPzf5mlamleov o Cc: Daniel, Velouse <VDanlelCrxmlamlgov.com>' Lucdor, Patrick<PLucdorCrx mlamlgov.com>' Loulssalnt, Bernne<BLoulssalntCrxmlamlgov.com> Subject: RE: A20391E to Reclass Expenditures Good Afternoon, Please provide an update on the status of the journal entry referenced below. OCI Is trying to close the award and the journal entry must take place before It can be defu nded and closed. Thank You From: Lucdor, Patdck<PI Hrdor[drmlamlPov om> Sent: Friday, September 16, 202211:33 AM To:Hernandez, Rene<.RPHPrnandPzfurmlamleov om> Cc: Brown, Carol<CarRrownfurmlamlgov om>•Danel, Velouse<VDanlelfurmlamleov om> Subject: FW : A20391E to Reclass Expenditures HI Rene, Dld you receive the reciass entry submitted by OCI for$48,510.86 award 2039 please? The Invoice balance Is still not offset yet. Thank you.! Petrick Lucdor Sr. Flnancial Analyst Crty of Mon,—Flnance— 444 SW 2. Ave, 6« Floor, Mlaml, FL 33130 Ph. (305) 416-1981— Fax (305) 416-1390—plucdorCrx mlamlgov.com— www. mlamlgov.com From: Alc la, Daniel <DAlcala Crxmlamlgov.com> Sent: Frid y, September 16, 2022 11:28 AM To: Lucdo, Patrick<pi::Horfurmlamlgov om> Cc: Clavijo Diego <DClavijo-cCr0mlamlgov.com>' McGlnnls, Lai -Wan <ImcginnisCr0miamigov.com>' Brown, Carol <CarBrownCr0mlamlgov.com> Subject: RE: A2039 JE to Reclass Expenditures Good Morning, I submitted thatJE a month ago. Regards, Daniel Alcor la Dalca laCroM lamlgov.com Budget Analyst Off Ice of Management & Budget (305) 416-1513 Tell us how we're doing at: https:/Mww.surveymonkey.com/r/3WRCX2W From: Lucdor, Patrick Sent: Friday, September 16, 2022 11:26 AM To: Alcor la, Daniel <DAlcalaCrxmlamlgov.com> Cc: Clavijo, Diego <OCIavllo.Yrxmlamlgov om>' McGlnnls, Lal-Wan <jm ginnk(mmlamlgov om>' Brown, Carol <CarRrownfurmlamlgov om> Subject: RE: A2039 JE to Reclass Expenditures Daniel, Is there any update on the pending reclassJE please? Thank you! Petrick Lucdor Sr. Flnancial Analyst Crty of MI401—Flnance— 444 SW 2. Ave, 6« Floor, Mlaml, FL 33130 Ph. (305) 416-1981 — Fax (305) 416-1390—pinrdorfur mlamlgov om—www mlamleov om From: Alcor la, Daniel <OAloelafuDmlamlgov om> Sent: Tuesday, July 26, 2022 11:45 AM To: Brown, Carol <CarBrownCrxmlamlgov.com> Cc: Lucdor, Patrick<PI urdorfuDmlamlgov om>' Clavijo, Diego <OCIavllo.Yrxmlamlgov om>' McGlnnls, Lal-Wan <jm ginnk(mmlamlgov om> Subject: RE: A2039 JE to Reclass Expenditures Good Morning, What are the expendltures listed on that open Invoice then? I need to know what exact expendlture types I need to move, unless the type Is Irrelevant and Ijust need to move that amount. (Usually Flnance JEs makes me reflect exactly what I am moving before approving the JE) Regards, Daniel Alcor la Oalra lafuBMlamlgov om Budget Analyst 0ff Ice of Management & Budget (305) 416-1513 Tell us how we're doing at: fjjpsoMm✓w survevmonkevcom/r/3WRCX2W From: Brown, Carol Sent: Tuesday, July 26, 202211:27 AM To: Alala, Danlel<DAlcalafurmlamlgov om> Cc: Lucdor, Patrick<PLucdorCrxmlamlgov.com>' Clavljo, Diego <DClavljo-cCrxmlamlgov.com>' McGinnis, Lal-Wan <ImcglnnlsCrxmlamlgov.com> Subject: RE: A2039 JE to Reclass Expenditures Good Morning, Yes, that Is correct, however, with the previous journal entry for the $1,916.62 the amount did not add up correctly either If you review the documentation provided for that journal entry. Hence, the explanation In my initial email. Oracle reflects that there Is an open invoice of $48,510.86, which has been determined that, this amount wlll not be reimbursed. Therefore, that Is the total amount to be reclassed. Thank You From: Alcor la, Daniel <DAlaia Crx mlamlgov.com> Sent: Tuesday, July 26, 202210:18 AM To: Brown, Carol<CarRrownfurmlamlgov om> Cc: Lucdor, Patrick<PLucdorCrxmlamlgov.com>' Clavljo, Diego <DClavljo-cCrxmlamlgov.com>' McGinnis, Lal-Wan <ImcglnnlsCrxmlamlgov.com> Subject: RE: A2039 JE to Reclass Expenditures Good Morning, I was looking at the backup for tills and when I remove the Imes In the prevlousJE's I get$48,409.95. Not the amount referenced In your e-mall below. Please advise. Regards, Daniel Alcor la Dalca laPM lamlgov.com Budget Analyst Off Ice of Management & Budget (305)416-1513 Tell us how we're doing at: hops:/Mwvvv.surveymonkey.com/r/3WRCX2W From: Brown, Carol Sent: Thursday, July 14, 202210:42 AM To: Ala la, Daniel <DAlcala Crxmlamlgov.com> Cc:Lucdor, Patrick<pl urdorfurmlamlgov om>'Clavljo, D iego<D('Iavllo-ramlamlgov om>'McGlnnls,Lori-Wan<jmr.gnnk(mmlamlgov om> Subject: A2039 J E to Reclass Expend Itu res Good Morning, Pursuant to the previous journal entry forthls project, attached Is the complete expenditure report for the above referenced project. The prevlous journal entry request did not Identify the expenditures by transaction Identification numbers, so I could not attest to the Ilne Items that made up the total of $1,916.92 (amount of prevlous journal entry). Please proceed with the journal entry In the amount of $48,510.86. Thank you for your patience and assistance regarding this request. Thank You From: Alcor la, Daniel <DAlaia Crx mlamlgov.com> Sent: Tuesday, July 5, 202211:08 AM To: Brown, Carol<CarRrownfurmlamlgov om> Subject: Backups forlournal Entries Good Morning Carol, I am working on setting up the JE for B30011 AwardN2039, an you provide which of the expenses were considered to be non -reimbursable so I know what type of expenses to move the money to. Thank you very much, Daniel Alcor la Dais laaMlamlgov om Budget Analyst Off Ice of Management& Budget (305)416-1513 Tell us how we're doing at: ryjpsjsmnv survevmonkevcom/r/3WRCX2W