Payment posting reconciliation
“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”
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.
- FileRemittance paymentsCSV export · 35 rows
- FileBank depositsCSV export · 35 rows
- FileClaimsCSV export · 35 rows
- StepPrepare remittance keysStep 1
- StepPrepare deposit keyStep 2
- StepPrepare claim keyStep 3
- JoinMatch claims35 of 35 paired
- JoinMatch bank deposits34 of 35 paired
- StepSet deposit statusStep 6
- ResultRemittance deposit matching36 rows
- ScheduleRuns when you sayProposed
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.
- Download Remittance payments sample (35 rows)Excel: Open remittance workbook > sheet 'Remittance' > File > Save As > CSV
- Download Bank deposits sample (35 rows)Excel: Open bank deposit register > Data > Export to Excel
- Download Claims sample (35 rows)Excel: Open claims workbook > Claims tab > Export > CSV
What you get back
The result of that run, the rows to look at first.
| Check number | Payer | Claim ID | Paid amount | Deposit status |
|---|---|---|---|---|
| CHK-784299 | · | · | · | No remittance |
| CHK-784232 | Apex Insurance | CLM-1032 | 390 | Not deposited |
| CHK-784219 | SummitCare | CLM-1019 | 300 | Agrees |
| CHK-784229 | Northlake Health | CLM-1029 | 260 | Agrees |
| CHK-784205 | Northlake Health | CLM-1005 | 975 | Agrees |
| CHK-784206 | Pioneer Benefits | CLM-1006 | 320 | Agrees |
| CHK-784207 | SummitCare | CLM-1007 | 1,088.40 | Agrees |
| CHK-784208 | Apex Insurance | CLM-1008 | 730 | Agrees |
| CHK-784209 | Harbor Mutual | CLM-1009 | 1,645.30 | Agrees |
| CHK-784210 | Everwell | CLM-1010 | 250 | Agrees |
| CHK-784211 | Northlake Health | CLM-1011 | 540 | Agrees |
| CHK-784204 | Harbor Mutual | CLM-1004 | 455.20 | Agrees |
How it works
How to use the Remittance deposit matching 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.
Remittance deposit matching: questions
How do you reconcile payment posting?
What export should you use for this workflow?
What happens to rows that do not match?
How do you change the matching rules?
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
Match two sets of records line by line, and see what agrees, what differs and what is missing on either side.
- Bank reconciliationEvery line matched, flagged for a date check, or missing from one sideSee the workflow Template
- Payment reconciliationEach payout matched to its bank deposit, flagged for a date check, or missingSee the workflow Template
- Cash reconciliationEach day's takings matched to a bank deposit, or flagged as not bankedSee the workflow Template
- Payment processing fees by methodTrack payment processing fees by method each month, total sales and fees, and flag fee rates that are too high.See the workflow Built by the agent
- Three-way matchEach PO line: matched, partly received, billed more than received, or price differsSee the workflow Template
- Invoice reconciliationEach invoice paid in full, part-paid, overpaid or not paid, and payments with no invoiceSee the workflow Template