Planning and reporting · Word + Excel + PDF
Monthly shelter operations report template
Free monthly shelter report template in Word and PDF, plus an Excel workbook for occupancy and activity totals. Includes editable fictional examples.
Made to customize. Change the wording, add your shelter’s details, and share with your team. No account needed.
Monthly report template
For a director or shift lead to explain the month and assign next actions.
See a filled-in example
Fictional sample — replace the details before use.
Monthly totals workbook
Calculate the figures for the report from daily counts. Includes an editable worked month.
Make your first copy
- Use the workbook to total the month, then transfer reviewed figures into the Word report.
- Add your shelter name and count definition. Rename narrative headings for your team or board.
- Keep coverage and turnaway definitions with the figures. Examples are fictional and stay separate.
Word and Excel files are editable and unlocked. PDFs are print copies. Save a master, then use a separate working copy.
Use the Excel workbook to review the month's aggregate counts, then explain the results in the Word report. Keep the reporting period, capacity, and count definitions consistent. Include missing coverage and operational changes alongside the totals, followed by a named owner and next action for each issue.
How to use it
- Enter daily aggregate counts in the workbook and choose the reporting month. Review completeness before copying results into the report.
- Show occupied and available bed-nights alongside the occupancy percentage. Describe capacity changes and any missing nights.
- Report admissions, departures, and turnaway attempts with their definitions. Do not label admissions or turnaway attempts as unique people.
- Add operational issues, a responsible person, and a due date. Review the report for resident-identifying detail before sharing it.
FICTIONAL EXAMPLE
A monthly explanation with an action
- September example
- 30 nights reported; 594 occupied bed-nights; 660 available bed-nights; 90.0% occupancy.
- Capacity change
- Four beds were out of service for the first 15 nights: 60 unavailable bed-nights.
- Activity
- 44 admissions, 40 departures, and 12 turnaway attempts; these are events, not unique residents.
- Next action
- Jordan will review the maintenance schedule by October 5 to reduce repeat bed closures.
What the terms mean
- Unavailable bed-nights
- Out-of-service beds summed over the reporting nights. Holds are tracked separately.
- Turnaway attempt
- A recorded request for shelter that could not be accommodated. The same person may make multiple attempts.
- Operations report
- A management summary using local operating records. It is not a substitute for an official funder submission.
Adapt it to your shelter
Document your shelter's count time and turnaway recording rule. Use the official reporting definitions and required systems for funder or HMIS submissions. Do not infer housing outcomes from occupancy.
Published by ShelterCurrent · Web guidance updated .
Downloads prepared September 8, 2026 · Version 1.1.
Sources and further reading
These references provide context. The downloads are original ShelterCurrent templates, not official forms or endorsed materials.
Start the monthly review with complete nightly counts
The report remains a management summary built from your reviewed records. Compare the nightly routine behind those figures: checking attendance, resolving gaps, and recording completion.
Explore the ShelterCurrent demo with fictional data. No account is required.