Workflow · Finance close · Opening soon
Net collection rate
Upload your claims export from Excel. The workflow groups rows by payer and month, then calculates net collection rate from payments divided by charges minus contractual adjustments.
Someone typed
“calculate net collection rate by payer and month: payments divided by charges minus contractual adjustments”
The agent read it as
calculate net collection rate by payer and month from Claims export.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
Claims export
CSV export · 45 rows
Step
Calculate monthly collection rates
Step 1
Result
Net Collection Rate
15 rows
Schedule
Runs when you say
Proposed
- FileClaims exportCSV export · 45 rows
- StepCalculate monthly collection ratesStep 1
- ResultNet Collection Rate15 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 15 rows came out.
- Download Claims export sample (45 rows)Excel: Claims workbook > Claims export sheet > Save As CSV
What you get back
The result of that run, the rows to look at first.
Net Collection RateSample data15 rows
| Payer | Month | Net collection rate | Payments | Net charges |
|---|---|---|---|---|
| Aurora Health Plan | 2026-08-01 | 93.8% | 937 | 999 |
| Aurora Health Plan | 2026-09-01 | 93.8% | 936 | 998 |
| Aurora Health Plan | 2026-10-01 | 91.9% | 870 | 947 |
| BluePeak Insurance | 2026-08-01 | 80.2% | 465 | 580 |
| BluePeak Insurance | 2026-09-01 | 94.1% | 1,097 | 1,166 |
| BluePeak Insurance | 2026-10-01 | 92.8% | 746 | 804 |
| CedarCare HMO | 2026-08-01 | 93.3% | 775 | 831 |
| CedarCare HMO | 2026-09-01 | 91.6% | 685 | 748 |
| CedarCare HMO | 2026-10-01 | 93.3% | 1,030 | 1,104 |
| Meridian Mutual | 2026-08-01 | 93.5% | 882 | 943 |
| Meridian Mutual | 2026-09-01 | 93.4% | 878 | 940 |
| Meridian Mutual | 2026-10-01 | 94% | 1,035 | 1,101 |
How it works
How to use the Net Collection Rate 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.
Net Collection Rate: questions
How do you calculate net collection rate by payer and month?
Upload your claims export from Excel. The workflow groups rows by payer and month, then calculates net collection rate from payments divided by charges minus contractual adjustments.
What export should you use?
Use the claims export from Excel. It should include payer, month, payments, charges, and contractual adjustments in separate columns, or the closest matching fields in your file.
What happens to rows that do not match the rule?
Rows that do not fit the steps are left out of the result for that calculation. You can review them, fix the source data, and run the file again.
How do you change the rules in words?
Edit the step text to describe the grouping and formula you want. For example, change the payer or time period, or rewrite the rate formula using the columns in your export.
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