Transcript Slide 1

Understanding the Financial
Management of Your
Cooperative Agreement
Quito, Ecuador
13-16 October 2009
Demystifying Finance Jargon
•
•
•
•
•
•
Award/Ceiling Amount
Obligation Amount
Pipeline
Burn Rate
Financial Modification
Accruals
Fundamentals of Financial Management
Award
Amount
The total amount that is anticipated to
be spent by the USG over the life of the
project
Obligated
Amount
The amount the USG has committed to
spending on the project to date
Pipeline
The amount of funds obligated but
not yet spent
Burnrate
The rate at which the obligation is being spent.
It will give you an indication of how many
months left before you need an
additional obligation
NOTE: It is the Grantees responsibility to
track obligation funds spent – when
75% spent inform USAID to increase
obligation amount
$3,000,000
$2,000,000
Obligation
$ 2,000,000
– Expenses
$ 1,500,000
Pipeline/Balance $ 500,000
$1,500,000/24 months
= $125,000 per month
# months before obligation spent
= $500,000/$125,000
= 4 Months
Project Financial Reporting Cycle
SF 269
Financial
Report/ SF 1034
Liquidation
Report
1 Oct
2009
3 SF
1034
Cash
Advance
SF 269
Financial
Report/ SF 1034
Liquidation
Report
31 Dec 09
3 SF
1034
Cash
Advance
SF 269
Financial
Report/ SF 1034
Liquidation
Report
31 Mar 2010
3 SF
1034
Cash
Advance
SF 269
Financial
Report/ SF 1034
Liquidation
Report
30 June 2010
3 SF
1034
Cash
Advance
SF 269
Financial
Report/ SF 1034
Liquidation
Report
30 Sep
2010
3 SF
1034
Cash
Advance
Budget Tracking
•Tool that shows what a project has been doing
• Not just a finance tool, but an important tool for
technical staff, too
• Burn rate will fluctuate over project life
• Accurate projections are important and require
good communication
Standard Form-269
Quarterly Financial Status Reports – SF-269
• Submitted within 30 days after the end of
the quarter
• Shows how USAID funds have been used
• Monitors cost chare contributions
• Reflects a project’s current pipeline
SF-269: Steps to Completion
(Administrative Information)
1. USAID/GH/OHA
2. Cooperative Agreement number
3. Organizational Information
4. EIN as assigned by the IRS
5. Internal Reference Number
6. Final – Yes or Progress report - No
7. Cash recommended
SF-269: Steps to Completion
(Administrative Information)
8. Cooperative Agreement Start and End dates
9. Current reporting quarter
10. Case Study Exercise
11. Refer to Cooperative Agreement as applicable
12. Certification by Authorized Signatory
December 1, 2006
November 30, 2009
Four Options:
1. October 1
2. January 1
3. April 1
4. July 1
Four Options:
1. December 31
2. March 30
3. June 30
4. September 30
This should capture what
has been spent (both USG
and Cost Share)
accumulative to the
beginning for the quarter that
is being reported on. This
box should be the total of the
two columns below,
combined.
This box is the USG
dollars expended to the
start of the quarter that
is being reported on.
This box is the cost share
expended to the start of the
quarter that is being reported
on.
This should capture what
has been spent (both USG
and Cost Share) over the
quarter capture in #9 (This
box should be the total of the
two columns below
combined).
This box is the USG
dollars expended
during the quarter that
is captured in #9.
This box is the cost share
expended during the quarter
that is capture in #9.
This is all USG funding that
is expended to date
(including the quarter
captured in #9). Both boxes
are the same (IIIc and IIIg).
This is all the USG
funding that has been
obligated to date
(including the quarter
captured in #9).
This is the remainder
of all the USG funding
that has been
obligated to date
(including the quarter
captured in #9) - your
pipeline.
SF- 269 Exercise
• “Your NGO” has had the following expenditure – please complete the
SF 269 for January to March 2009:
From the start date of the
agreement through December
2009
Jan-March
2010
Total Project Expenses
$ 2,500,000
$ 500,000
Of total that total Project Expenses,
funded by USAID
$ 2,000,000
$ 400,000
$ 500,000
$100,000
Of that total Project Expenses,
Cost Share Funded
• The award amount for “Your NGO” organization is $4,000,000 and the
obligated amount to date is $3,000,000
Standard Form-1034


SF 1034 is the public voucher for purchases and
services other than personal
You will use it to request funds and liquidate
funds from USAID
SF-1034
 Three month rolling advance
 In the first month you will submit the SF 1034 for the
first quarter covering the second, third and fourth
months.
 This is designed for your organization to maintain a
uniform cash flow
 At the end of the quarter you will submit another SF
1034 for liquidation of the advance.
 You must submit to the paying office indicated in the
grant letter an original and three copies of SF-1034.
SF- 1034 Voucher
 You will submit three SF-1034s requesting three separate
advance payments for the quarter (one for each month).
 Each voucher must be identified by the agreement number
and must state the total costs for which advance is being
requested.
 SF 1034s must be marked at the top of the form with
“Request for Advance”.
 To liquidate advances the form must be marked at the top
with “Liquidation of Advances”.
Standard Form-1034
Timing for advances and liquidation
Initial Advance
Payments
1st Month
First Quarter Advance Payments
Second Quarter Advance
(3SF 1034s each for 30 Days)
(3 SF 1034s each for 30 Days)
2nd Month
3rdMonth
First Quarter Liquidation Period
(3 Months’ Advance in 1 Voucher)
4th Month
5th Month
6th Month
Second Quarter Liquidation Period
(3 Months Advance in 1 Voucher)
7th Month
VOUCHER NO.
PUBLIC VOUCHER FOR PURCHASES AND
SERVICES OTHER THAN PERSONAL
U.S. DEPARTMENT, BUREAU, OR
DATE VOUCHER PREPARED
SCHEDULE NO.
ESTABLISHMENT AND LOCATION
CONTRACT NUMBER AND DATE PAID BY
Leave Blank
REQUISITION NUMBER AND
DATE
PAYEE'S NAME AND ADDRESS
DATE INVOICE RECEIVED
DISCOUNT TERMS
PAYEE'S ACCOUNT NUMBER
SHIPPED FROM:
NUMBER
AND DATE
OF ORDER
TO:
DATE OF
DELIVERY
OR
SERVICE
WEIGHT:
ARTICLES OR SERVICES
(Enter description, item # of contract or Federal supply
schedule, and other information deemed necessary)
GOVERNMENT B/L NUMBER
QUANTITY
UNIT PRICE
COST
AMOUNT(1)
PER
$0.00
$0.00
$0.00
Include your
organization’s name
and mailing address
as sheet(s) if necessary)
(Use continuation
PAYMENT:
APPROVED FOR
it is found in your
PROVISIONAL BY:
Cooperative Agreement
PARTIAL
P
A
I
D
B
Y
FINAL
PROGRESS
ADVANCE
$0.00
$0.00
(Payee must NOT use the space below)
TOTAL
EXCHANGE RATE
DIFFERENCES
$0.00
AMOUNT VERIFIED;
CORRECT FOR
TITLE:
(SIGNATURE OR INITIALS)
PURSUANT TO AUTHORITY VESTED IN ME, I CERTIFY THIS VOUCHER IS CORRECT AND PROPER FOR PAYMENT .
(DATE) (AUTHORIZED CERTIFYING OFFICER)
(TITLE)
ACCOUNTING CLASSIFICATION
DOC NO
EARMARK
CURRCODE
CURRENCY
FUNDING
Schedule
number; paid
CASH
PAYEE
by; date
When stated in foreign currency, insert name of currency.
PER
If the ability to certify and authority to approve are combined in one person, one signature only is necessary.
invoice
Otherwise the approving officer will sign in the space provided, over his official title.
When a voucher is receipted in the name of a company or corporation, the name of the person writing the company or
received
corporate name, as well as the capacity in which he signs, must appear. For example: "John Doe Company, per John TITLE
Smith, Secretary", or "Treasurer", as the case may be.
should be left
Previous edition usable
NSN 7540-00-900-2234
PRIVACY ACT STATEMENT
The information requested on this form is required under the provisions of 31 U.S.C. 82b and 82c, for the purpose of disbursing Federal money. the information BLANK
CHECK NUMBER
ON ACCOUNT OF U.S.
TREASURY
DATE
CHECK NUMBER
ON (Name of Bank)
1
2
3
requested is to identify the particular creditor and the amounts to be paid. Failure to furnish this information will hinder discharge of the payment obligation.
Standard Form 1034
Revised October 1987
1987Department of the Treasury
1 TFM 4-2000 1034-121
VOUCHER NO.
PUBLIC VOUCHER FOR PURCHASES AND
SERVICES OTHER THAN PERSONAL
U.S. DEPARTMENT, BUREAU, OR
DATE VOUCHER PREPARED
SCHEDULE NO.
ESTABLISHMENT AND LOCATION
CONTRACT NUMBER AND DATE PAID BY
REQUISITION NUMBER AND
DATE
PAYEE'S NAME AND ADDRESS
DATE INVOICE RECEIVED
Request for Advance
should be numbered.
PAYEE'S ACCOUNT NUMBER
Don’t forget to change
GOVERNMENT B/L NUMBER
the numbers every
QUANUNIT PRICE time
AMOUNT
you fill a form!
TITY
DISCOUNT TERMS
SHIPPED FROM:
NUMBER
AND DATE
OF ORDER
TO:
DATE OF
DELIVERY
OR
SERVICE
WEIGHT:
ARTICLES OR SERVICES
(Enter description, item # of contract or Federal supply
schedule, and other information deemed necessary)
(1)
COST
PER
$0.00
$0.00
Insert the names
and address of
the relevant
Don’t forgetchange
to include the date!
finance office.
(Use continuation sheet(s) if necessary)
(Payee must NOT use the space below)
TOTAL
Details are found
PAYMENT:
APPROVED FOR
EXCHANGE RATE
DIFFERENCES
in your
PROVISIONAL BY:
AMOUNT VERIFIED;
PARTIAL
CORRECT FOR
Agreement
FINAL
P
A
I
D
B
Y
PROGRESS
ADVANCE
TITLE:
$0.00
$0.00
$0.00
$0.00
(SIGNATURE OR INITIALS)
PURSUANT TO AUTHORITY VESTED IN ME, I CERTIFY THIS VOUCHER IS CORRECT AND PROPER FOR PAYMENT .
(DATE) (AUTHORIZED CERTIFYING OFFICER)
(TITLE)
Don’t forget to
include the date!
ACCOUNTING CLASSIFICATION
DOC NO
EARMARK
CHECK NUMBER
CASH
CURRCODE
ON ACCOUNT OF U.S.
TREASURY
DATE
1
CURRENCY
CHECK NUMBER
Previous edition usable
ON (Name of Bank)
PAYEE
When stated in foreign currency, insert name of currency.
If the ability to certify and authority to approve are combined in one person, one signature only is necessary.
Otherwise the approving officer will sign in the space provided, over his official title.
3
When a voucher is receipted in the name of a company or corporation, the name of the person writing the company or
corporate name, as well as the capacity in which he signs, must appear. For example: "John Doe Company, per John
Smith, Secretary", or "Treasurer", as the case may be.
2
FUNDING
PER
TITLE
NSN 7540-00-900-2234
PRIVACY ACT STATEMENT
The information requested on this form is required under the provisions of 31 U.S.C. 82b and 82c, for the purpose of disbursing Federal money. the information
requested is to identify the particular creditor and the amounts to be paid. Failure to furnish this information will hinder discharge of the payment obligation.
Standard Form 1034
Revised October 1987
1987Department of the Treasury
1 TFM 4-2000 1034-121
VOUCHER NO.
PUBLIC VOUCHER FOR PURCHASES AND
SERVICES OTHER THAN PERSONAL
U.S. DEPARTMENT, BUREAU, OR
DATE VOUCHER PREPARED
SCHEDULE NO.
ESTABLISHMENT AND LOCATION
CONTRACT NUMBER AND DATE PAID BY
REQUISITION NUMBER AND
DATE
PAYEE'S NAME AND ADDRESS
DATE INVOICE RECEIVED
DISCOUNT TERMS
PAYEE'S ACCOUNT NUMBER
SHIPPED FROM:
NUMBER
AND DATE
OF ORDER
TO:
DATE OF
DELIVERY
OR
SERVICE
WEIGHT:
ARTICLES OR SERVICES
(Enter description, item # of contract or Federal supply
schedule, and other information deemed necessary)
GOVERNMENT B/L NUMBER
QUANTITY
UNIT PRICE
COST
AMOUNT(1)
PER
$0.00
(Use continuation sheet(s) if necessary)
PAYMENT:
APPROVED FOR
P
A
I
D
B
Y
PROVISIONAL
PARTIAL
FINAL
PROGRESS
ADVANCE
(Payee must NOT use the space below)
TOTAL
EXCHANGE RATE
DIFFERENCES
$0.00
You
may use this
$0.00
space to keep track
of$0.00
the account or
$0.00
job number
assigned
to the
$0.00
agreement or you
may leave it blank
BY:
AMOUNT VERIFIED;
CORRECT FOR
TITLE:
(SIGNATURE OR INITIALS)
TO AUTHORITY VESTED IN ME, I CERTIFY THIS VOUCHER IS CORRECT AND PROPER FOR PAYMENT .
Show thePURSUANT
month,
(AUTHORIZED CERTIFYING OFFICER)
(TITLE)
day and(DATE)
year,
ACCOUNTING CLASSIFICATION
beginning
DOC and
NO
EARMARK
CURRCODE
CURRENCY
FUNDING
ending datesCHECK
of the
NUMBER
ON ACCOUNT OF U.S.
CHECK NUMBER
ON (Name of Bank)
TREASURY
incurrence ofCASH
costs
DATE
PAYEE
claimed
for
When stated in foreign currency, insert name of currency.
PER
If the ability to certify and authority to approve are combined in one person, one signature only is necessary.
Otherwise
the
approving
officer
will
sign
in
the
space
provided,
over
his
official
title.
reimbursement.
When a voucher is receipted in the name of a company or corporation, the name of the person writing the company or
1
2
3
corporate name, as well as the capacity in which he signs, must appear. For example: "John Doe Company, per John
Smith, Secretary", or "Treasurer", as the case may be.
Previous edition usable
TITLE
NSN 7540-00-900-2234
PRIVACY ACT STATEMENT
The information requested on this form is required under the provisions of 31 U.S.C. 82b and 82c, for the purpose of disbursing Federal money. the information
requested is to identify the particular creditor and the amounts to be paid. Failure to furnish this information will hinder discharge of the payment obligation.
Standard Form 1034
Revised October 1987
1987Department of the Treasury
1 TFM 4-2000 1034-121
SF-1034 Exercise
 “Your NGO” in Ecuador is requesting funds for OctoberDecember 2009. The approved budget is $1,000,000, the
cumulative advances $500,000, cumulative expenditures
through December $420,000, the projected expenditures
for September is $20,000; the organization needs $20,000
in advance for each month. The expenditures for the
quarter are $18,000 for July, $21,000 for August and
$19,000 for September.
 Complete the SF-1034 & Report of Expenditures and
Advance Control