Grant Receivable Aging Report Guide

A grant receivable aging report tells leaders how much reimbursement money is still unpaid. More important, it shows whether the delay is normal, risky, or caused by a process problem.

For many nonprofits, reimbursement grants create a cash gap. The nonprofit pays payroll, rent, vendors, and program costs first. The funder pays after a request is submitted and approved. If receivables age without review, cash planning gets weaker.

Build the report from request dates

The aging report should start with the reimbursement request date or invoice date. If no request has been submitted, show that separately. Do not age an unsubmitted request as if the funder is late.

Core columns should include:

• Funder
• Grant
• Request or invoice number
• Request date
• Amount requested
• Amount approved
• Amount paid
• Open amount
• Aging bucket
• Expected payment date
• Status
• Owner
• Follow-up note

Use consistent aging buckets. A simple set is current, 1 to 30 days, 31 to 60 days, 61 to 90 days, and over 90 days.

Separate the status from the age

Age alone does not tell the story. A 45-day receivable may be fine if the grant pays quarterly. A 15-day receivable may be risky if the request was rejected.

Add a status field:

• Not submitted
• Submitted
• Under funder review
• Funder question open
• Approved for payment
• Partially paid
• Rejected or reduced
• Paid, not applied

This keeps the report honest. If the status is “not submitted,” the issue is inside the nonprofit. If the status is “funder question open,” the owner needs to answer. If the status is “paid, not applied,” cash came in but accounting has not closed the loop.

Tie each amount to support

For federal awards, 2 CFR 200.302 calls for financial records supported by source documentation. That principle is useful for all reimbursement grants.

Each open amount should tie to:

• Expense detail
• Payroll allocation support, if payroll is billed
• Approved budget line
• Reimbursement form or invoice
• Portal confirmation or sent email
• Funder response
• Cash receipt, once paid

If support is missing, flag the receivable. Do not wait for the auditor to find it.

Add a cash risk view

Receivable aging is also a cash tool. Show how much cash the nonprofit is carrying for each grant.

Add these fields when possible:

• Costs paid but not billed
• Costs billed but not collected
• Total cash advanced by the nonprofit
• Expected collection month
• Payroll or vendor pressure tied to the grant

This helps the executive director understand why revenue can look strong while cash feels tight.

The nonprofit cash flow warning signs for grants gives more examples of this problem.

Review old balances in the close

Make receivable aging part of the nonprofit monthly close grant checklist. During close, ask:

• Did we submit all eligible requests?
• Did any request get rejected?
• Are any funder questions waiting on staff?
• Did cash arrive after month end?
• Was cash posted to the right receivable?
• Should any amount be reserved, corrected, or written off?

Do not leave old receivables with notes like “pending.” State what is pending and who owns the next step.

Prepare the board summary

The board does not need every open invoice. It needs the few receivables that affect cash or risk.

A board summary can show:

• Total grant receivables
• Amount over 60 or 90 days
• Largest unpaid requests
• Requests not yet submitted
• Rejected or questioned costs
• Expected collections next month
• Cash gap caused by reimbursement timing

Keep the language plain. “Three grant receivables over 60 days total $84,000. Two are waiting on funder approval. One needs payroll support from the program team.”

That sentence is more useful than a dense table with no notes.

Close the loop after payment

When payment arrives, apply it to the right receivable and update the aging report. If payment is short, document the reason. If the funder paid a different amount than requested, compare the difference to the grant file.

GrantPipe can help track reimbursement status beside grant records and support files. It should not replace the finance review. The aging report still needs an owner who follows up, fixes support gaps, and tells leadership when cash is at risk.

An aging report works when it changes behavior. If the same request stays old for another month, the report should force a decision.

DEFINITION

Grant receivable

Money due from a funder for grant costs or award amounts the nonprofit has earned or billed under the agreement.

DEFINITION

Aging bucket

A group that shows how long a receivable has been open, such as current, 30 days, 60 days, or over 90 days.