Transcript Slide 1

Financial Reporting for Your
Cooperative Agreement
Pretoria, South Africa
30 November - 3 December 2009
Demystifying Finance Jargon
•
•
•
•
•
•
Award/Ceiling Amount
Obligation Amount
Pipeline
Burn Rate
Financial Modification
Accruals
2
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
Burn Rate
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
3
FINANCIAL REPORTING CYCLE
Initial
Advance
1. SF 1034
2. SF 270/2
31 Oct 09
First Quarter
Advance Payments
1. SF 1034 (3) each for 30 days
2. SF 270/2 submitted monthly
30 Nov 09
31 Dec 09
First Quarter Liquidation Period
(3 Months’ liquidation in 1 Voucher)
1. SF 1034
2. SF 1034 + SF 269
3. SF 269
31 Jan 10
Second Quarter
Advance Payments
1. SF 1034 (3) each for 30 days
2. SF 270/2 submitted monthly
28 Feb 10
30 Mar 10
31 Apr 10
Second Quarter Liquidation Period
(3 Months liquidation in 1 Voucher)
1. SF 1034
2. SF 1034 + SF 269
3. SF 269
4
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
advances from USAID
5
SF-1034 – TO REQUEST AN ADVANCE
 You will submit three SF-1034s requesting three
separate advance payments for the quarter (one for
each month – 3 month rolling advance).
 This is designed for your organization to maintain a
uniform cash flow.
 SF-1034s must be marked at the top of the form with
“Request for Advance.”
 You must submit to the paying office indicated in the
grant letter an original and three copies of SF-1034.
6
SF-1034 Voucher –
LIQUIDATION OF ADVANCE
 At the end of the quarter you will submit another SF-1034 for
liquidation of the advance.
 To liquidate advances the form must be marked at the top
with “Liquidation of Advances.”
 No new advance can be made until this liquidation voucher is
received from the recipient (REMEMBER: There is a knock
on effect).
 Each voucher must be identified by the agreement number
and must state the total costs for which advance is being
requested.
7
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
Remember 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
(Use continuation sheet(s) if necessary)
relevant finance
PAYMENT:
APPROVED FOR
office. Details are
PROVISIONAL BY:
found in your PARTIAL
FINAL
Agreement PROGRESS TITLE:
P
A
I
D
B
Y
insert the
number and date
of the contract
$0.00
$0.00
$0.00
change
(Payee must NOT use the space below)
TOTAL
EXCHANGE RATE
DIFFERENCES
$0.00
AMOUNT VERIFIED;
CORRECT FOR
(SIGNATURE OR INITIALS)
ADVANCE
PURSUANT TO AUTHORITY VESTED IN ME, I CERTIFY THIS VOUCHER IS CORRECT AND PROPER FOR PAYMENT .
(DATE) (AUTHORIZED CERTIFYING OFFICER)
(TITLE)
Remember 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
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;
CHECK NUMBER
ON ACCOUNT OF U.S.
CHECK NUMBER
ON (Name of Bank)
TREASURY
paid by; date
CASH
DATE
PAYEE
invoice received
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.
should be left
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
BLANK
corporate name, as well as the capacity in which he signs, must appear. For example: "John Doe Company, per John TITLE
1
2
3
Smith, Secretary", or "Treasurer", as the case may be.
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
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
$0.00
$0.00
$0.00
$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
BY:
AMOUNT VERIFIED;
CORRECT FOR
TITLE:
(SIGNATURE OR INITIALS)
$0.00
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
Report of Expenditures and Advance Control
Used to
document, track,
and analyze
advances
Cumulativ
e
Expenditu
re through
The actual amount of the
advance must be net of any
projected cash balances
SF-1034 Exercise
 Your NGO in Zambia recently became a DGP partner in October
2009 and is requesting funds for Feb – April 2010 under the
following scenario:
1. The approved budget is $1,000,000. The Cumulative advances as
of 1 January 2010 will be $500,000 and the expenditure reported
for this period (1 October – 31 December 2009) is $420,000, and
the projected expenditure for January 2010 is $78,000.
2. The organization needs $20,000 in advance for each month from
Feb – April 2010.
 Complete the SF-1034 & Report of Expenditures and Advance
Control from October 09 to April 2010 (for the second quarter
advance)
12
SF269 – FINANCIAL REPORTING FORM
 You will use it to request funds and liquidate advances
from USAID.
 Complete every 3 months (due 30 days after end of
quarter)
–
–
–
–
1 October 2009 – 31 December 2009, due 30 January 2010
1 January 2010 – 31 March 2010, due 30 April 2010
1 April 2010 – 30 June 2010 due, 31 July 2010
1 August 2010 – 30 September 2010, due 31 October 2010
13
Award /Grant #
Final report – Yes/No
Accounting Basis
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 – 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
19
Internal Control
 There are different ways in reporting financials in US$
 The most appropriate way is to use Weighted Average Cost of
Capital Method (WACC) from a financial management point of
view.
US$
Exchange Rate
Local Currency
Example:
($1=R)
BUDGET Exchange
Rate Used
4
Income - Jan
$100,000
6
R600,000
Income - March
$100,000
10
R1,000,000
TOTAL RECIEVED
$200,000
R1,600,000
EXPENSE (Jan-March)
R1,600,000
BALANCE
R0.00
20
Internal Control – Scenario 1
Convert Expenses at Budget
Rate
US$
BUDGET Ex Rate Used
Ex Rate ($1=R) Local Currency
R4
Income - Jan
$100,000
R6
R600,000
Income - March
$100,000
R10
R1,000,000
TOTAL RECIEVED
$200,000
EXPENSE (Jan-March)
($400,00)
BALANCE
($200,000)
R1,600,000
R4
(R1,600,000)
R0.00
21
Internal Control – Scenario 2
Convert Expenses at most recent
Exchange Rate
US$
BUDGET Exchange
Rate Used
Exchange
Rate ($1=R)
Local Currency
R4
Income - Jan
$100,000
R6
R600,000
Income - March
$100,000
R10
R1,000,000
TOTAL RECIEVED
$200,000
EXPENSE (Jan-March)
($160,00)
BALANCE
$40,000
R1,600,000
R10
(R1,600,000)
R0.00
22
Internal Control – Scenario 2
Convert Expenses at
Weighted Average Cost of
Capital (WACC)
US$
BUDGET Exchange
Rate Used
Exchange
Rate ($1=R)
Local Currency
R4
Income - Jan
$100,000
R6
R600,000
Income - March
$100,000
R10
R1,000,000
TOTAL RECIEVED
$200,000
=R1,600,000/
$200000
R1,600,000
EXPENSE (Jan-March)
($200,00)
R8
(R1,600,000)
BALANCE
$0
R0.00
23
Questions?
24