Nonprofit Grant Tracker Spreadsheet and Deadline Calendar
$12.99
A missed grant report or a lapsed registration costs more than the time it takes to track them. This nonprofit bookkeeping spreadsheet for grants and compliance has a grant tracker with reports due and budget vs actual, a compliance calendar dated from your year-end, a written financial policies starter in Word, a fixed assets register, petty cash reconciliation, a mileage and reimbursement log, and a partner and outreach fund tracker. Excel, Google Sheets and Word.
Share
What's inside
- Nonprofit_Grant_Tracker.xlsx + EXAMPLE: one line per grant from prospect to closeout; payments, grant expenses by budget category, received, spent, award left and receivable; reports due; budget vs actual with an indirect-cost cap check; spending pace; a board summary
- Nonprofit_Compliance_Calendar.xlsx + EXAMPLE: an editable task library of recurring filings, payroll deposits, state registrations, insurance renewals, board duties and finance tasks, with due dates calculated from your fiscal year-end; month view and board summary
- Nonprofit_Written_Financial_Policies_Starter.docx + EXAMPLE (Word): a 13-section financial policy starter (roles, budget and reports, cash and donations, spending and approvals, bank reconciliation, restricted funds, donor receipts, pay and reimbursements, petty cash, client assistance and credit cards, property, conflicts of interest, records retention, review and adoption)
- Nonprofit_Fixed_Assets_Register.xlsx + EXAMPLE: equipment and property register with capitalization threshold, straight-line depreciation, disposals with gain or loss, a yearly roll-forward and a printable inventory sheet by location
- Nonprofit_Petty_Cash_Reconciliation.xlsx + EXAMPLE: imprest petty cash voucher log, cash counts by denomination, a one-page reconciliation with replenishment by account, and event cash boxes
- Nonprofit_Mileage_Reimbursement_Log.xlsx + EXAMPLE: accountable-plan style mileage (rate looked up by trip date from a table you keep current) and out-of-pocket expense claims, a people list with plan dates, and a printable reimbursement voucher
- Nonprofit_Partner_Outreach_Tracker.xlsx + EXAMPLE: monthly commitments to partner organizations and projects, payments by month covered, balance owed, a month-by-month grid and a committee summary
Who it's for
- Part-time treasurers, executive directors and bookkeepers at small nonprofits and charitable organizations (roughly 1 to 25 staff) who manage grants, keep up with filing deadlines and written policies, and handle petty cash, mileage reimbursements, equipment and partner support
Before you buy
Organizational tools only for small nonprofits and charitable organizations. Not tax, legal, or accounting advice. Not approved or endorsed by the IRS or any regulator. Does not guarantee compliance or a clean audit. The compliance calendar's tasks and due dates, the mileage rate and the dollar thresholds are general information and editable starting points, and the policy starter is a template; confirm each with a qualified CPA or attorney and the agency itself, and have your board review the policies before adopting them. Built by ReconciledBooksCo, a small shop run by an experienced accountant.
Excel and Google Sheets. No macros. Paid spreadsheet products include a blank file and a filled example, plus a Start Here tab in plain English.
Licensed for one organization per purchase.
