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