Skip to content
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.

Early access opens shortly. Check back soon.

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.

  1. File
    Claims export
    CSV export · 45 rows
  2. Step
    Calculate monthly collection rates
    Step 1
  3. Result
    Net Collection Rate
    15 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 15 rows came out.

What you get back

The result of that run, the rows to look at first.

Net Collection RateSample data15 rows
PayerMonthNet collection ratePaymentsNet charges
Aurora Health Plan2026-08-0193.8%937999
Aurora Health Plan2026-09-0193.8%936998
Aurora Health Plan2026-10-0191.9%870947
BluePeak Insurance2026-08-0180.2%465580
BluePeak Insurance2026-09-0194.1%1,0971,166
BluePeak Insurance2026-10-0192.8%746804
CedarCare HMO2026-08-0193.3%775831
CedarCare HMO2026-09-0191.6%685748
CedarCare HMO2026-10-0193.3%1,0301,104
Meridian Mutual2026-08-0193.5%882943
Meridian Mutual2026-09-0193.4%878940
Meridian Mutual2026-10-0194%1,0351,101
15 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Net Collection Rate workflow

  1. 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.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 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.

Early access opens shortly. Check back soon.

Workflows like this

Consolidate entities, compare budget to actual, build a trial balance, review month-on-month moves and work out commission.

All finance close templates →