Universal Credit remittance reconciliation, done in seconds
Stop reconciling Universal Credit remittances against a spreadsheet by hand. PropertyOps parses Dawsons Excel and Windrush PDF statements, matches every line to the right tenant, and flags missing UC payments before they become arrears.
The problem with manual UC reconciliation
A typical supported-accommodation managing agent receives one remittance per RSL per cycle. Each contains 10–60 tenants. Each line has to be matched to the right person, checked against expected rent, and chased if short. For a 20-property portfolio that's 2–4 hours a week, every week.
Names don't match
RSLs spell tenant names inconsistently. "Mohammed" becomes "Mohamed", "Abdullah" becomes "Abdulla". One typo and a payment is "missing".
Clawbacks are invisible
UC clawbacks for over-payment or moved-out tenants surface as line-item deductions. Manual reconcilers either miss them or spend hours tracking them down.
The 4-weekly drift
UC pays a flat 4-week amount, but period lengths swing 27–29 days. Every cycle looks short or long against a per-day expected rate. False positives drown real issues.
Statement formats vary
Dawsons sends Excel, Windrush sends PDFs, smaller RSLs send anything. No two formats are alike. Building one spreadsheet per RSL doesn't scale.
How PropertyOps reconciles UC remittances
A purpose-built pipeline for the supported-accommodation workflow. No generic accounting software bolted on.
Upload
Drag the remittance PDF or Excel onto the Payments page. RSL is auto-detected.
Parse
Dedicated parsers extract every line — tenant name, period, amount, clawback reason.
Match
Fuzzy name + postcode matching links each line to a tenant. Unmatched lines surface for review.
Track
Outstanding balances and missing-payment alerts auto-update across the dashboard.
What you get
Built specifically for UK supported accommodation, with the UC quirks baked in.
Dedicated Dawsons + Windrush parsers
Bespoke Excel and PDF parsers tuned for the two largest UK supported-accommodation RSLs. Generic line-by-line fallback for everything else.
Days-based variance detection
Missing-payment alerts use days-of-coverage vs days-since-ELA, not pound deltas. No more false positives from 27-vs-28-day cycle drift.
Per-tenant outstanding balance
Live outstanding figure for every tenant: expected since their start date, minus actually received. Backdated UC payments handled correctly.
Cycle view + CSV export
Group by UC period (e.g. 17/05 cycle) and see who paid, who didn't, who got clawed back. Export for accountant or council audit.
Rent settings as structured data
Per-property bespoke rates (Dawsons-style) or per-RSL-bed-count rate cards (Windrush-style) — expected payments resolve automatically.
Clawback visibility
Every deduction is tagged with its reason and the cycle it affected. Recover them or write them off, but never miss them again.
Frequently asked questions
What is UC remittance reconciliation?
Universal Credit remittance reconciliation is the process of matching payments received from the DWP or an RSL against expected rent for each tenant. Because UC is paid in 4-weekly cycles direct to the landlord, every cycle produces a remittance that must be split between tenants, checked against expected amounts, and chased when short.
Does PropertyOps support Dawsons and Windrush remittance formats?
Yes. PropertyOps ships dedicated parsers for Dawsons (Excel) and Windrush (PDF) remittances out of the box. A generic line-by-line parser handles other RSLs. Each line is matched to a tenant by name and property postcode, with manual override.
How does PropertyOps detect missing UC payments?
It compares unique days of UC coverage against days since each tenant's Effective Letting Agreement (ELA) date. When the gap exceeds 35 days (a full UC cycle + a one-week late-arrival buffer), the tenant surfaces on the Requires Attention panel. Severity escalates to high at 56 days (two cycles missed).
How long does remittance upload take?
Most weekly remittances are parsed in under 10 seconds. You get a per-tenant breakdown showing matched amounts, period covered, clawbacks, and any unmatched lines requiring manual review.
Can I export reconciled payment data?
Yes. Payment history exports as CSV per property, per tenant, or for the entire portfolio, with cycle-level grouping for accountant handover.
Is PropertyOps suitable for small portfolios?
Yes. Pricing starts at £3/room/month with no minimums. Built for single managing agents with a few HMOs, scales to portfolios of hundreds of rooms across multiple RSLs.
See a real remittance, reconciled in 11 steps
A locked-down walkthrough on the live product. No signup, no install. Upload a sample remittance and watch it parse, match, and flag the unpaid tenant.