HomeMy WebLinkAboutBack-Up DocumentsCITY OF MIAMI, FLORIDA
INTER -OFFICE MEMORANDUM
CA LI 6. 3 is i '1
TO:
FROM:
Erica Paschal
inance Director
i.
illian Blondet, Director
Office of Grants Administration
DA
REFERENCES:
ENCLOSURES.
Monday, June 26, 2017
FILE:
Employ Miami Dade Program 15-16
This memo is to respectfully request a PNG and GL entry to correct the receivable in award #2223 reported as
non -reimbursable per the request of Finance.
PNG
Project
Number Award Task Expend Type Organization Credit/Debit
CFDA 17.278-
37-371004-P15 2223 DW Regular Salaries 371001 (34.08)
GL
General Ledger Account Debit Credit
00001.371001.512000.0.0 34.08
15500. 371001512000.0.0 (34.08 f
If you have any questions regarding this request, please contact Deborah Bittan at (305) 416-1591.
CC: Jorge Blanco, Loretta Jeanty
RECEIVED
JUN 2 7 2017
CITY OF MIAP,11 - FINANCE
DIRECTOR'S OFFICE
Aeqx-
Award 2223 - City of Miami- Employ Miami -Dade program Non -reimbursable expenditures 2015-2016
1) Are there any grant expenditures deemed non -reimbursable?
Yes
2) How much is deemed non -reimbursable?
$34.08
3) Why was the amount deemed non -reimbursable (un-allowable expense, missed deadline to claim, etc.)?
This expense was missed and passed the deadline to claim
4) How will the department cover the shortage (Le., what other funds will be used — general fund allocation, another
project, etc.)
Shortage will be covered by the general fund.
5) What actions have been taken by the department to avoid the project deficit (current deficit and future deficits)
Currently implementing e-civis grant management system.
2223 Close out Screen Shots
Ex$
Er
Operating Unit City of MIAMI
Project Number
Task Number
Award Number 2223
Trans Id
Project Name
Task Name
Award Name Employ Miami Dade
Expenditure Ory
0 Do:tern:5Mo* Nom
MEM
Date
II4AR-2017
4AR-2017
4.AP-2017
4AP-2017
4AR-2017
4AR-2017
4AR.2017
4AP-2017
Employee/Supplier Quantity UOM Proj Func Eurde Project Burdene Accrued Reyent. Bill Ami
-965 83 Currenc -965.83 -965.83
-24.09 Currenc -24.09 -24 09
-5 99 'Curette -5.99 -5.99
-E 73 Currenc -8.73 -8_73
-17.4 Current: -17.413. -17.40
-31.28 Current -31 28 -31 20
-14.0E. Currenc -14.08 -14.013
-4.8 Currenc -4.90 -4.90
4AR-2017
41AP::017
-42,48 Currenc -42.48 -42.40
7.75 Currenc 7.75 7.75
I 27,202.27 127,202.27
Totals
Item Details
Reventle Stinlararif
Award Number Draft Revenue Customer Agreement
Project Functior Project Functional Re
51,000 31 lAc
50,317.21 Ac
II Mt 1 PnG- South Florida .:,2223
-).2")3
USD
PnG- South Flonda 2223
2223 3
2223 4
PnG- South Florida 2223
USD
USD
PnG- South Florida 2223
36,001.07 ,Ac
USD .9,116.32 IAc
Run PtQuesi
Totals
127,202.27
1 Release 1
Expenditure Items
Qpen
0 Invoice Summary (City of Miami)
MEM
a
Customer
Bill Split Agreement Invoice Currency Invoice Amount Invoice Status
19,1051 18 Accepted in Recei,,.
31,556 R9 Accepted in Pecei'y
2223 USD 40,523 06 Accepted in Recei'y
'PnG- South FIT'Ida 100 2223 USD
PnG- South Florida 100 2223
USD
PnG- South Florida 100
PnG- South Florida 100
2223 USD
PnG- South Florida 100 2223 USD
• ______________
PnG- South Florida 100 1223 USD
33,517.94 Accepted in Receiv
2,519.20 Accepted in Recei.,..
9,160.32 Accepted in Recei%
PnG- South Fionda 100 2223 USD -9,11F.32 Accepted in Recei.v
PnG- South Florida 2223 USD -33,517.94 Accepted in Receiv
South Florida 2223 USD -9,150.32 'Accepted in Receiv
-PnG- South Florida 100 2223 USD 33,517.87 Accepted in Receil,
Print 1
Totals AR Invoice
127,202 27
Lines
(.:1 edit
Qpen
Invoice Summay (City of Mlarni)
SN
Award Number
2223
2223
2223
. •
2223
2223 7 117336
2223 8 1 17360
Drail AR Invoice Nu Invoice Amount Balance Due Bill Through Invoice Date GL Date Invoice Status
._ •
3
I I 66)5 19,051.18 0.00 26-JUN-2016 213=JIJN-20 1,3 28-JUN-2016 ,Accepted in Recei,,,
I l',3353 31,556 39 0.01 ",:-..11_1L-2016 31-J1X-2016 31-J111,2016 Accepted in ReceiNp
- - --- • .--
40,523.06 . 0 00 ,15-SEP-2016 15-5FP-20 16 I5-SEP-2016 Accepted in Receio •
2223
• __ • _
-rn
3
4 1 16967
5 116965
6 117046
33,517 94 0 CO i1S-SEP-2016 15-SEP-2016 15-SEP-2016 Accepted in Recen,
2,51920 0.00 :1E-SEP-2016 16-SEP-2016 16.SEP-2016 'Accepted in Recap,
9,150 32 0 00 '30-SEP-2016 12-SFP-'0133 313-SEP-2018 Accepted in Recery
-9,116.32 0.02 06-MAR-2017 06-MAR-2017 03-NAP-20 17 Accepted in Receil.
;33,517.94 0.02 .15-SEP-2016 15-SEP-2016 .101 -MAR-21[117 Accepted in Pecei'v
9 1 17352
10 1 17355
Print 1
-9,150.32
.33,517.37
Totals
AR Invoice
0.00 =a7.1-SEP-2016
30-SEP-20 16 C I -IvIAR•2017 Accepted in Recei,.. t
21-MAR-2017 21-1C1AP-2017 21-NIAP-2017 =Accptd in Pecery
Lines
Award Number Draft AR Invoice WI Invoice Amount Balance Due Bill Through
2223 4 I -,.E:..6: :1 1'1 0 -.:0 11'.1-EE7-I1,I,3
2222 5 1 :;:...:t, _ .-.- ' Ci 00 I0.]:..E.--2111;3
2222 6 1 ''1.-..: :i : .,_• -,:. 0.00 30-SE t?-=,-._:!;E:.
2223 7 1 ! 7 :=], -., 1 113 3= 0_00 03- tvl.A1=.- C2 1 7
2223 5 1 '7H.,:: -'33 517 94 0 00 15-EEI.--2016
2223 3 ! '7 --52 -9 , 1 .:-Ci K. 0 L-.17 -...• .t;•_,_.!;7.
I 2223 10 1 '7 15 ±'.-. 5'727
2223 1 1 •.r., 150 2.r.i.i.
2223 12 1 —15._' 9,1 16 32
2223 1 3 I '-.7=f:..3 -9,1 16 32 0 00 23-MAP-2017
4!
Print 1
Tpt els AP Immo Lines
Open
Involce Date, GL Date Invoice Status Creditei
15- SEP-2016
S E 10-SEP-2016
II-SEP-2016
7 DB-MAP-2017
15-7F :6 CI 4-ILR_201, : et; 4
IJI-MAP-20 17 Accepted ir
2! - 21-MAR-201 7 Accered =
21-MAP-2017 Accepted
21-NetAP-2C17 22-MAP-2017 Accerect L,
23-MAR.20 17 2.3-MAR-201 7 Accepted ir
—
van|Narne Revenue Budget Actual Cost
rp|uYN/am.
^
I
132,40846 150,000[0
/ |
|
.
.
CommbmentAmount
|
FleoourceStmtua '| Acum|y /|
A-Nord|nqmry !
/
Invoice Review
,
,