Jump to content

CDBG: Difference between revisions

From Team Wiki
Created
 
updated
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Creating the Beneficiary Report
When awarded a CDBG grant, you will receive a Contract Execution letter. The organization is bound by the requirements of the contract.


Sample Past Contract Execution letter:


To run the report
''The contract file should include, but not be limited to, the contract and copies of any and all correspondence,''


''invoices, reports, statistics, documents, etc. This file must be kept for a period of five (5) years from the date''


Log in to Link2Feed
''of your organization’s last qualified financial audit that includes this project as completed. In addition, you''


Click on Reports
''should have a financial management system in place and a procurement policy to address any''


Click on New Report
''issues regarding hiring of personnel or making purchases with our funds.''


Under "Statistics Report" click " + New Report"
''Please note that your contract start date is [date] and we cannot reimburse for any costs incurred''


''before that date. To avoid invoicing problems that can result in delays in processing reimbursements,''


''Create a New Statistics Report:''  
''please be sure to submit your invoices on a monthly basis, as required by the contract. To be considered''


Titled: [Month] CDBG [Year of the Grant]
''complete, all invoices must include the following:''


That is: just for me
''1. Requisition Form. We pay on a cost reimbursable basis. We pay no late fees or past due amounts.''


''The requisition sheet is the only form that should have an original signature. Please make a complete''


''I want to schedule the report:''
''copy of the invoice exactly as you forward it to our office and place in your contract file.''


Leave the settings as they are
''2. Beneficiary Report form. Community Development Block Grant funds are intended to be used for low''


''to moderate income individuals in the City of Pittsburgh and it is necessary that we collect information on''


''For the following time period:''
''those persons being served with these funds. The Beneficiary Form must be submitted with each''


Enter each month of the grant period separately with the "or between" date selections
''invoice.''


''3. Written Narrative Program/Project Activity Report. Using your own format and based on your scope''


''For the following:''
''of services, you must submit a brief narrative report describing the services you provided during the time''


Check off Organizations: PBRO1044-1: Brookline Christian Food Pantry
''period covered by your invoice.''
----
----




''For the following program types:''  
'''How to Guide for creating the Beneficiary Report'''


Check off  Pantry & TEFAP
To run the report


Log in to Link2Feed


''With the following report selections:''
Click on Reports


Check off Ethnicity: Client (Unique) and Income (Net): Households (Unique)
Click on New Report


Run an "Interactive Household report "


Click Create Report
Titled: [Month] CDBG [Year of the Grant]


That is: just for me


<nowiki>''</nowiki>I want to schedule the report:<nowiki>''</nowiki>


Open the Beneficiary report sent by the CDBG contact via email
Leave the settings as they are


Refer to the reports from Link2Feed to complete the form.
<nowiki>''</nowiki>For the following time period:<nowiki>''</nowiki>  


To breakdown ethnicity:
Enter each month of the grant period separately with the "or between" date selections


Ethnicity per Link2Feed  |  Ethnicity per CBDG
<nowiki>''</nowiki>For the following:<nowiki>''</nowiki>


Asian | Asian
Check off Organizations: PBRO1044-1: Brookline Christian Food Pantry
 
Black/ African American  | Black
 
Black/ African American + Another Ethnicity  |
 
Hispanic/ Latino  | WH
 
Middle-Eastern/ North African  | Multi-Racial
 
Other  | Multi-Racial
 
Other Multiple Ethnicity  | Multi-Racial


Undisclosed  | Omitted
<nowiki>''</nowiki>For the following program types:<nowiki>''</nowiki>


White/ Anglo  | White
Check off  Pantry & TEFAP


To break down income:
For INCOME


Google the Median Family Income for Pittsburgh.
Open the Beneficiary report you generated


Divide that number by 12 to calculate the monthly.
Scroll to down to find “Household Size: Individuals (Unique)


Calculate 30% and 50% of that monthly number.
Click on a Label with the number of individuals in the household (1, 2, 3, 4, 7, etc.)


You can use the data from the Link2Feed report to complete columns 7-9 of the beneficiary form.
That will regenerate the report for that household size.  


Scroll down to find “Monthly Household Income: Individuals (Unique)


Make sure the number of people served from columns 1-5 & 6 is equal to the number of people reported in columns 7-9.
For ETHNICITY


Remove all pivots from when you were generating reports for income


[[Category:Finance]]
Scroll down to Ethnicity: Individuals (Unique)
[[Category:Finance How To]]

Latest revision as of 23:30, 17 October 2023

When awarded a CDBG grant, you will receive a Contract Execution letter. The organization is bound by the requirements of the contract.

Sample Past Contract Execution letter:

The contract file should include, but not be limited to, the contract and copies of any and all correspondence,

invoices, reports, statistics, documents, etc. This file must be kept for a period of five (5) years from the date

of your organization’s last qualified financial audit that includes this project as completed. In addition, you

should have a financial management system in place and a procurement policy to address any

issues regarding hiring of personnel or making purchases with our funds.

Please note that your contract start date is [date] and we cannot reimburse for any costs incurred

before that date. To avoid invoicing problems that can result in delays in processing reimbursements,

please be sure to submit your invoices on a monthly basis, as required by the contract. To be considered

complete, all invoices must include the following:

1. Requisition Form. We pay on a cost reimbursable basis. We pay no late fees or past due amounts.

The requisition sheet is the only form that should have an original signature. Please make a complete

copy of the invoice exactly as you forward it to our office and place in your contract file.

2. Beneficiary Report form. Community Development Block Grant funds are intended to be used for low

to moderate income individuals in the City of Pittsburgh and it is necessary that we collect information on

those persons being served with these funds. The Beneficiary Form must be submitted with each

invoice.

3. Written Narrative Program/Project Activity Report. Using your own format and based on your scope

of services, you must submit a brief narrative report describing the services you provided during the time

period covered by your invoice.




How to Guide for creating the Beneficiary Report

To run the report

Log in to Link2Feed

Click on Reports

Click on New Report

Run an "Interactive Household report "

Titled: [Month] CDBG [Year of the Grant]

That is: just for me

''I want to schedule the report:''

Leave the settings as they are

''For the following time period:''  

Enter each month of the grant period separately with the "or between" date selections

''For the following:''

Check off Organizations: PBRO1044-1: Brookline Christian Food Pantry

''For the following program types:''

Check off  Pantry & TEFAP

For INCOME

Open the Beneficiary report you generated

Scroll to down to find “Household Size: Individuals (Unique)

Click on a Label with the number of individuals in the household (1, 2, 3, 4, 7, etc.)

That will regenerate the report for that household size.

Scroll down to find “Monthly Household Income: Individuals (Unique)

For ETHNICITY

Remove all pivots from when you were generating reports for income

Scroll down to Ethnicity: Individuals (Unique)