Loading...

Run: Grant Drawdown and Cash Management Log

Track federal grant drawdowns, cash-on-hand days, and disbursement timing in one audit-ready log. Use it to document CMIA and Treasury-State Agreement compli...

Fill this out, get a PDF emailed to you. No account required. Want to run it with your team and track results? Sign up free →

Log Entry and Grant Identification

Date this log record is being created. Defaults to today.
Select the federal agency that awarded the grant.
The Assistance Listing number (formerly CFDA) as listed in SAM.gov.
Federal payment system used to request this drawdown.

Drawdown Request Details

Date the drawdown was submitted to the federal payment system.
Total dollar amount requested in this drawdown. Do not include cents beyond two decimal places.
Federal cost-share percentage for this award (e.g., 75 for a 75/25 match requirement).
Method used to calculate the drawdown amount, per your agency's cash management procedures.
Select all budget categories included in this drawdown request.
Record the confirmation number from the federal payment system for reconciliation.

Disbursement Timing and Cash-on-Hand Compliance

Date the drawdown was credited to your agency's bank account.
The disbursement date projected when the drawdown was initiated.
Date funds were actually paid out to payees (vendors, subrecipients, employees).
Automatically calculated as Actual Disbursement Date minus Funds Received Date. Review against your TSA threshold.
Maximum days cash may be held per your Treasury-State Agreement or agency policy. Typically 0–3 business days for most programs.
If yes, complete the Interest Liability section below.

Interest Liability Assessment

Days held minus TSA threshold days.
Current Treasury Financial Management Service (FMS) rate per 31 CFR § 205.29. Obtain from TreasuryDirect or your state treasury office.
Calculated as: Drawdown Amount × (Interest Rate / 365) × Excess Days. Show your calculation in the notes field.

Expenditure Reconciliation

List all GL account codes to which this drawdown is posted.
Sum of all expenditures posted in the GL for this drawdown period.
Total award amount minus cumulative drawdowns to date.
Required if subrecipient pass-through funds are included. Per 2 CFR § 200.332.

Supporting Documentation

Upload the drawdown confirmation from ASAP, G5, PMS, or other payment system.
Upload the GL detail, expenditure report, or financial report supporting the drawdown amount.
Upload bank statement excerpt or treasury confirmation showing funds received date.
Upload any additional documentation (invoices, subrecipient reports, disbursement registers).

Supervisor Review and Certification

By checking this box, I certify that the information entered in this log is accurate and complete to the best of my knowledge, and that the drawdown amount is supported by actual or imminent expenditures.

Get your results

Enter your email — we'll send you a PDF of your filled-out template, plus the occasional MangoScoop newsletter (templates, workflow tips, product updates). Unsubscribe anytime — link is in every email.

Generated with MangoApps Templates — browse 250+ free
Ask AI Product Advisor

Hi! I'm the MangoApps Product Advisor. I can help you with:

  • Understanding our 40+ workplace apps
  • Finding the right solution for your needs
  • Answering questions about pricing and features
  • Pointing you to free tools you can try right now

What would you like to know?