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