Workflow · Finance close · Opening soon
Volunteer hours report
Export your sign-in sheet from Excel, then upload it to Mammoth. It totals each volunteer's hours by program for the latest quarter in the sheet, and values that time at 30 dollars an hour.
Someone typed
“total each volunteer's hours by program for the quarter from our sign-in sheet, and value that time at 30 dollars an hour”
The agent read it as
Total each volunteer's hours by program for the quarter from Volunteer sign-in sheet, and value that time at 30 dollars an hour, using the latest quarter in the sheet.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Volunteer sign-in sheet
CSV export · 45 rows
Step
Total hours and value
Step 1
Result
Volunteer Program Hours
44 rows
Schedule
Runs when you say
Proposed
- FileVolunteer sign-in sheetCSV export · 45 rows
- StepTotal hours and valueStep 1
- ResultVolunteer Program Hours44 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 44 rows came out.
- Download Volunteer sign-in sheet sample (45 rows)Excel: open the sign-in sheet workbook and export the quarter's rows to CSV
What you get back
The result of that run, the rows to look at first.
Volunteer Program HoursSample data44 rows
| Volunteer | Program | Hours | Value ($) |
|---|---|---|---|
| Ava Chen | Community Garden | 4 | 120 |
| Ava Chen | Food Pantry | 4 | 120 |
| Ava Chen | Front Desk | 4 | 120 |
| Ava Chen | Tutoring | 4 | 120 |
| Caleb Turner | Community Garden | 4.50 | 135 |
| Caleb Turner | Food Pantry | 4 | 120 |
| Caleb Turner | Tutoring | 3.50 | 105 |
| Ethan Brooks | Community Garden | 4 | 120 |
| Ethan Brooks | Food Pantry | 4.50 | 135 |
| Ethan Brooks | Front Desk | 4 | 120 |
| Ethan Brooks | Tutoring | 3 | 90 |
| Hannah Singh | Food Pantry | 4 | 120 |
How it works
How to use the Volunteer Program Hours workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Volunteer Program Hours: questions
How do you track volunteer hours by program from an Excel export?
Export your sign-in sheet from Excel, then upload it to Mammoth. It totals each volunteer's hours by program for the latest quarter in the sheet, and values that time at 30 dollars an hour. Rows that do not match the rules stay out of the totals until you change the rules or fix the source file.
Which export should you use?
Use the Excel file that contains the sign-in sheet rows you want to report on. Make sure it has the columns needed for volunteer, program, date, and hours.
What happens to rows that do not match?
Rows that do not fit the rules are not included in the result. You can review them, then update the source file or the rules so they match next time.
How do you change the rules?
Edit the rules in words, then run the workflow again. You can change the quarter logic, the grouping by program, or the hourly value if your report needs a different setup.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.
- Profit and loss by monthBuild a monthly profit and loss statement from a QuickBooks general ledger export, with revenue, COGS, gross profit, expenses, and net income.See the workflow Built by the agent
- Real estate commission splitWork out real estate commission on each closed sale and split it between the listing agent, buying agent and brokerage.See the workflow Built by the agent
- Loan amortization from statementsBuild a monthly loan amortization schedule from an Excel export, with interest, principal, and remaining balance for each loan.See the workflow Built by the agent
- Accrued expenses scheduleBuild an accrued expenses schedule from QuickBooks exports. Match purchase orders to vendor bills, calculate unbilled amounts, and flag items that need accrual.See the workflow Built by the agent
- Cash conversion cycle by monthWork out cash conversion cycle each month from QuickBooks exports, using month-end balances and monthly sales.See the workflow Built by the agent
- Expense report from card transactionsTurn Amex card exports into an expense report per employee, with category totals and missing receipts flagged.See the workflow Built by the agent