Grant Budget Template

Build funder-ready grant budgets with cost-share, justification and burn rate, and keep unallocated award money in view.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Finance

Tables

Grants, Budget Lines

Fields

24

Views

grid, timeline, kanban, dashboard

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Grants

14 fields · 2 sample rows

  • Grants (Grid)
  • Grant timeline (Timeline)
  • Pipeline (Kanban)
GrantTextFunderTextAward AmountCurrencyStartDateEndDateNext Report DueDateStatusSingle selectBudget LinesLink to another tableRequestedRollupCost ShareRollupSpentRollupUnallocatedFormulaBurn RateFormulaTime ElapsedFormula
Digital Literacy for Girls 2026Tata Trusts₹25,00,00022 Jul 202622 Jul 20279 Dec 2026ActiveProgramme manager (1 FTE), Trainers (4 × 0.5 FTE), Laptops for labs (40), Field travel to schools, Indirect costs (6%)₹24,80,000₹2,00,000₹12,23,000₹20,00049%33%
Clean Water Pilot – Rural OdishaGlobal Water Foundation₹18,00,00019 Dec 202619 Dec 202719 Mar 2027SubmittedWater quality test kits, Borewell contractor₹14,50,000₹2,00,000₹0₹3,50,0000%0%
Field details
Grant · Text
Funder · Text
Award Amount · Currency
INR
Start · Date
End · Date
Next Report Due · Date
Status · Single select
Drafting, Submitted, Awarded, Active, Closed, Declined
Budget Lines · Link to another table
Links to Budget Lines
Requested · Rollup
sum of Grant Request via Budget Lines
Cost Share · Rollup
sum of Cost Share via Budget Lines
Spent · Rollup
sum of Spent to Date via Budget Lines
Unallocated · Formula
IF({Award Amount}, {Award Amount} - {Requested}, BLANK())
Burn Rate · Formula
IF({Award Amount}, {Spent} / {Award Amount}, BLANK())
Time Elapsed · Formula
IF(AND({Start}, {End}), MAX(0, MIN(1, DATETIME_DIFF(TODAY(), {Start}, 'days') / DATETIME_DIFF({End}, {Start}, 'days'))), BLANK())

Budget Lines

10 fields · 7 sample rows

  • Budget (Grid)
  • Budget mix (Dashboard)
Line ItemTextGrantLink to another tableCategorySingle selectGrant RequestCurrencyCost ShareCurrencyTotal Project CostFormulaSpent to DateCurrencyRemainingFormula% SpentFormulaJustificationLong text
Programme manager (1 FTE)Digital Literacy for Girls 2026Personnel₹9,00,000₹0₹9,00,000₹3,00,000₹6,00,00033%Leads curriculum delivery across 12 schools.
Trainers (4 × 0.5 FTE)Digital Literacy for Girls 2026Personnel₹7,20,000₹0₹7,20,000₹2,40,000₹4,80,00033%
Laptops for labs (40)Digital Literacy for Girls 2026Equipment₹6,00,000₹2,00,000₹8,00,000₹6,00,000₹0100%Donor partner matches 25% in kind.
Field travel to schoolsDigital Literacy for Girls 2026Travel₹1,20,000₹0₹1,20,000₹38,000₹82,00032%
Indirect costs (6%)Digital Literacy for Girls 2026Indirect costs₹1,40,000₹0₹1,40,000₹45,000₹95,00032%
Water quality test kitsClean Water Pilot – Rural OdishaSupplies₹3,50,000₹50,000₹4,00,000₹3,50,0000%
Borewell contractorClean Water Pilot – Rural OdishaContractual₹11,00,000₹1,50,000₹12,50,000₹11,00,0000%
Field details
Line Item · Text
Grant · Link to another table
Links to Grants
Category · Single select
Personnel, Fringe benefits, Travel, Equipment, Supplies, Contractual, Other direct, Indirect costs
Grant Request · Currency
INR
Cost Share · Currency
INR
Total Project Cost · Formula
{Grant Request} + {Cost Share}
Spent to Date · Currency
INR
Remaining · Formula
{Grant Request} - {Spent to Date}
% Spent · Formula
IF({Grant Request}, {Spent to Date} / {Grant Request}, BLANK())
Justification · Long text

Grant Budget Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates