Skip to content
Workflow · Reconcile · Opening soon

Payment posting reconciliation

Upload the remittance file, the bank deposit file, and the claims export from Excel. Mammoth matches the rows, then shows the check number, payer, claim ID, paid amount, and deposit status.

Early access opens shortly. Check back soon.

Someone typed

“match the remittance payments to the bank deposits and claims, show the check number, payer, claim id, paid amount, and deposit status: Agrees when the check matches a deposit, Not deposited when it doesn’t; also show deposits with no remittance”

The agent read it as

Match the Remittance payments to the Bank deposits and Claims, show the check number, payer, claim id, paid amount, and deposit status: Agrees when the check matches a deposit, Not deposited when it doesn’t; also show deposits with no remittance.

What the agent built

6 steps, each one an ordinary Mammoth step you can open and change.

  1. File
    Remittance payments
    CSV export · 35 rows
  2. File
    Bank deposits
    CSV export · 35 rows
  3. File
    Claims
    CSV export · 35 rows
  4. Step
    Prepare remittance keys
    Step 1
  5. Step
    Prepare deposit key
    Step 2
  6. Step
    Prepare claim key
    Step 3
  7. Join
    Match claims
    35 of 35 paired
  8. Join
    Match bank deposits
    34 of 35 paired
  9. Step
    Set deposit status
    Step 6
  10. Result
    Remittance deposit matching
    36 rows
  11. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 36 rows came out, and the join paired 35 of 35 rows; the join paired 34 of 35 rows.

What you get back

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

Remittance deposit matchingSample data36 rows
Check numberPayerClaim IDPaid amountDeposit status
CHK-784299···No remittance
CHK-784232Apex InsuranceCLM-1032390Not deposited
CHK-784219SummitCareCLM-1019300Agrees
CHK-784229Northlake HealthCLM-1029260Agrees
CHK-784205Northlake HealthCLM-1005975Agrees
CHK-784206Pioneer BenefitsCLM-1006320Agrees
CHK-784207SummitCareCLM-10071,088.40Agrees
CHK-784208Apex InsuranceCLM-1008730Agrees
CHK-784209Harbor MutualCLM-10091,645.30Agrees
CHK-784210EverwellCLM-1010250Agrees
CHK-784211Northlake HealthCLM-1011540Agrees
CHK-784204Harbor MutualCLM-1004455.20Agrees
36 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the Remittance deposit matching 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.

Remittance deposit matching: questions

How do you reconcile payment posting?
Upload the remittance file, the bank deposit file, and the claims export from Excel. Mammoth matches the rows, then shows the check number, payer, claim ID, paid amount, and deposit status. It flags deposits that agree, deposits that are not deposited, and deposits with no remittance.
What export should you use for this workflow?
Use the Excel exports that contain the remittance file, the bank deposit list, and the claims data. The workflow needs the fields that identify the check, payer, claim, amount, and deposit.
What happens to rows that do not match?
Rows that do not find a match stay in the result with a status that shows what is missing. A remittance with no matching deposit is marked Not deposited, and a deposit with no remittance is also listed.
How do you change the matching rules?
Edit the steps in plain words, such as how you prepare the remittance key, deposit key, or claim key. Then rerun the workflow so the new rules are applied to the exported files.

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.