Start 2025 with a living workbook that turns ARC rules into a monthly plan for your research project. This guide introduces an auto-scaling tool and a practical template that help you map three-year allocations, smooth irregular expenses and show clear Budget vs Actual reporting.
Use the UQ DE26 Budget Tool alongside spreadsheet methods to align DE26 D2 and D3 forms from your first draft. UQ ran an information session on 4 February 2025 and the rejoinder window opened in late June; these dates help you time edits and keep momentum toward the applications and review period later in the year.
Why this matters: a single, unified approach keeps formulas safe, categories consistent and numbers audit-ready. Follow a simple process: pick the right template, link costs to DECRA forms, then build growth and variance checks so your plan stays accurate and compelling to reviewers.
Key Takeaways
- One workbook can translate ARC rules into a monthly, three‑year plan.
- Pair the UQ DE26 templates with spreadsheet practices for strong D2/D3 drafts.
- Time your edits with UQ sessions and the June–July rejoinder window.
- Protect formulas and keep consistent categories to remain audit-ready.
- Clear templates help present a strategic, credible plan that supports outcomes.
Set up for 2025: context, timelines and what your budget must cover
Anchor your 2025 plan on the critical dates, sessions and tools that guide strong submissions. Start by using the UQ information session on 4 February 2025 to clarify scheme rules and frame your team’s work. Note the rejoinder window opened 25 June; UQ ran a Rejoinder Information session on 26 June (1–2pm AEST). Internal rejoinders were due to UQ by 2 July and to ARC by 8 July.
Keep staffing and costs consistent across forms. The ARC normally provides up to $50,000 per year for three-year projects. Use the UQ DE26 Budget Tool (updated 17/02/2025) plus the DE26 D2 Budget Justification and D3 Details of Non-ARC Contributions templates to record staff time, equipment, travel and partner support.
Follow a simple workflow: update your RMS Person Profile, populate UQ templates, submit to the Research Office for internal review, then finalise submission to ARC. Use sponsored worksheets (General Expense, Cost-Sharing, Salary 9 month, F&A Detail and Quicktips) to keep numbers auditable.
Practical checklist
- Translate session dates into task deadlines and review points.
- Document non-ARC contributions early with the D3 form.
- Use the D2 justification to tie each line item to project outcomes.
| Item | Action | Key date / note |
|---|---|---|
| Information session | Clarify rules and templates | 4 Feb 2025 (UQ) |
| Rejoinder period | Prepare responses and internal review | 25 Jun – 8 Jul 2025 (UQ internal by 2 Jul) |
| Templates | Populate DE26 Tool, D2 and D3 | DE26 Tool updated 17/02/2025 |
| Funding overview | Plan staff and project costs | Up to $50,000 p.a.; align with forms |
decra budget calculator excel: build an auto-scaling budget that fits the DECRA process
Start by downloading the UQ DE26 workbook and aligning its tabs to the project’s reporting needs. This gives you a single source of truth that mirrors sponsored workbook conventions and speeds internal review.
Download and prepare your workbook
Open the UQ DE26 Budget Tool and match the General Expense, Cost‑Sharing, Salary 9 month and F&A Detail tabs to your chart of accounts. Protect formula rows before inserting or deleting lines to keep roll-ups intact.
Create categories that match forms
Use clear categories for staff time, project costs, indirects and non‑ARC contributions. Map each line to DE26 D2 and D3 fields so reconciliation to RMS is straightforward.
Auto-scale for 2025 and plan irregular costs
Label months, apply justified percentage growth and link sub-categories to major headers so changes flow automatically. For lump payments, either place the value in the expected month or average it across months using a holding account row.
Comments, checks and reporting
Use comments on cells to explain assumptions and decisions. Add a small instructions panel that lists each step you follow before monthly updates.
“Treat the workbook as a living record: clear notes and intact formulas speed review and build reviewer confidence.”
Track Budget vs Actual and align to goals
Create simple graphs for month-to-month variance and percentage-of-income by category. Link staff lines to your training plan to show how resources support researcher development and project outcomes.
| Step | Action | Why it matters | Quick tip |
|---|---|---|---|
| Prepare tabs | Align General Expense, Cost‑Sharing, Salary, F&A | Keeps numbers auditable | Protect formula rows first |
| Map categories | Match lines to D2/D3 and RMS | Simplifies reconciliation | Use consistent naming |
| Auto-scale months | Set labels and growth rates | Reduces manual edits | Link sub-categories to headers |
| Report & review | Graphs, variance checks, notes | Shows impact and readiness | Keep an instructions panel |
Validate, report and submit with confidence
Before external lodgement, run a short internal validation sequence so the Research Office can act decisively. A reliable final check reduces last‑minute changes and helps your team move from draft to submission with clarity and calm.
Internal review workflow
Generate a full application PDF from RMS, then select “Submit to Research Office.” RMS does not alert the Research Office automatically, so email the UQ DE26 Application Certification Form and the UQ DE26 Pending and Newly Funded ARC grants form to arc-discovery@research.uq.edu.au.
If RNTA is needed, complete the request form in RMS and lodge it within internal deadlines. Keep a clear record of correspondence so your case aligns with scheme rules.
Keep your system updated
Update your RMS Person Profile and ensure team and opportunity fields match every form and page. Use UQ Library metrics resources—Scopus, SciVal and related tools—to strengthen ROPE statements and evidence of engagement.
“Treat the internal review as a final quality gate: clear records, timely requests and simple reports speed approval.”
- Generate reports after major edits to speed internal checks.
- Use session advice and research office support to refine rejoinders and responses.
- Lock a schedule for routine updates so forms and attachments remain current.
Conclusion
Lock in a steady review routine so your plan stays a living record that supports research goals and training outcomes. Revisit the workbook each month, update categories and add short comments that explain unusual costs or staff changes.
Use the guide as a simple checklist at each milestone. Confirm your template and form versions, align budget justification lines, and run a final compliance check against opportunity rules and funding limits.
Keep a short follow-up list: confirm templates are current, book a session with your research office, and export a few Budget vs Actual reports. When you support research with a clear, auditable plan, you make it easier for reviewers and your team to see the path to impact.