Ledger Copilot
Sign in

/gov · Why switch · Migration playbook

How we move you over — week by week.

18-month playbook. PHA-Web stays running through month 12. We earn the right to take over each function by proving it on your real data first. No forced cutover, full rollback available at any phase, and cutover is timed to your natural PHA-Web renewal so you don't have to break the existing contract mid-term.

1
Foundation
Days 1-30

Bank feeds, data import, training, baseline audit

2
Parallel Run
Days 31-90

Books reconcile both ways. MS 365 live.

3
Trust Earned
Months 4-12

HOTMA/NSPIRE/VMS/LOCCS prepared in LC. PHA-Web kept as fallback.

4
Cutover
Months 13-18

HUD-50058 + all compliance submissions move to LC. PHA-Web sunset.

Phase 1: Foundation (Days 1-30)

Get the bank feed live, import the existing data, train the team, run the first continuous-audit report. PHA-Web is untouched.

WhenTaskOwnerDeliverable / output
Day 0Kickoff call: review current PHA-Web setup, identify accounting team contacts, confirm scopeLedger Copilot CSM + PHA Finance DirectorSigned scope statement, RACI matrix
Day 1-3Read-only access to bank accounts (Plaid Link) + import 90 days of statementsPHA Finance DirectorBank feed live; reconciliation begins
Day 4-7PHA-Web data export — 50058 history, tenant master, vendor list, GL trial balance, asset registerPHA-Web admin (PHA side) + LC migration conciergeValidated data import; row counts reconciled to PHA-Web reports
Day 8-14Chart of accounts mapping — PHA-Web codes → FDS-aligned chart we shipLC migration concierge + PHA Finance DirectorApproved COA; first trial balance generated in LC
Day 15-21Staff training (3 sessions × 90 min): accounting team, compliance officer, executive directorLC training teamStaff certifications; training video library access
Day 22-30First continuous-audit run + SEMAP/PHAS forecastLC AI engine (automated)Baseline audit report with SHA-256 fingerprint

Phase 2: Parallel Run (Days 31-90)

Same numbers, two systems. If they diverge by >1%, cutover is paused until variance is root-caused. Most variances are due to timing differences or category mapping; rarely real errors.

WhenTaskOwnerDeliverable / output
Day 31-45Parallel-run validation: same month closed in PHA-Web and LC; reconcile discrepanciesPHA Finance DirectorVariance report; root causes documented
Day 46-60Bank reconciliation runs nightly on LC; PHA-Web reconciliation stays as backup but is no longer authoritativeLC sync engine (automated)Daily reconciliation reports; exception queue worked by PHA team
Day 61-75First FDS draft generated from LC books (year-end forward) with full tie-out traceLC reporting + PHA Finance DirectorFDS draft validated against audited financials
Day 76-90First MS 365 integrations (Excel export, Outlook send) live for board reportingPHA IT + LC supportBoard packet generated from LC, distributed via Outlook

Phase 3: Trust Earned (Months 4-12)

LC takes ownership of advanced functions PHA-Web doesn't cover well (HOTMA, NSPIRE pre-audit) and starts preparing the regulatory submissions PHA-Web still files. For 90 days, every submission gets prepared in both systems and compared.

WhenTaskOwnerDeliverable / output
Month 4-6HOTMA impact analysis run across full tenant roster; remediation planLC AI engine + PHA Compliance OfficerPer-family rent impact + action list
Month 4-6NSPIRE pre-audit run on full property portfolioLC engine + PHA Physical OperationsPredicted NSPIRE score + defect remediation queue
Month 7-9VMS submission prepared in LC, submitted via PHA-Web (validate match)PHA Finance + LC reportingTwo-source VMS — LC numbers should match PHA-Web exactly. Variance > 1% blocks cutover.
Month 10-12LOCCS draw preparation moves to LC; PHA-Web kept as fallbackPHA FinanceLC-prepared draws tracked against HUD acceptance; cutover criterion is 3 consecutive months accepted without correction

Phase 4: Cutover (Months 13-18)

Board approval, archive snapshot, single-batch HUD-50058 test, then full sunset at the natural PHA-Web renewal anniversary — timed so you don't break the existing contract mid-term and don't have to rush the timeline.

WhenTaskOwnerDeliverable / output
Month 13-15Cutover decision meeting — review parallel-run data, sign off on full cutover planExecutive Director + Board + LC teamBoard resolution authorizing cutover
Month 13-15Final PHA-Web data export (archive snapshot retained 7 years per HUD record retention)PHA-Web admin (PHA side)Archive package with content hashes; storage in OneDrive or SharePoint
Month 16-17HUD-50058 prep cutover — last record prepared in PHA-Web, next prepared + validated in LC; the PHA files with HUD either way. Single-batch test first.PHA Compliance Officer + LC reportingClean LC validation report; the PHA's IMS/PIC upload of the LC-prepared batch succeeds
Month 18PHA-Web contract sunset (or downgrade to view-only archival)PHA Finance DirectorPHA-Web line item removed from the books; single-engine operation begins

RACI — Who owns what

R = Responsible (does the work). A = Accountable (signs off). C = Consulted. I = Informed.

ActivityLedger CopilotPHAPHA-WebHUD
Bank feed setupRA
Data export from PHA-WebCAR
Chart-of-accounts mappingRAC
Staff trainingRA
Parallel-run validationARI
HUD-50058 submission (during transition)CARI
HUD-50058 submission (post-cutover)RAI
FDS / FASS-PH preparationRACI
VMS monthly submissionRACI
Cutover go/no-go decisionCAI
Final archive of PHA-Web dataCARI
HUD audit response (during transition)CACR

Risk register

Every concern your board will raise, with the mitigation written down before they ask. We'd rather over-engineer the rollback than miss a HUD deadline.

Data export from PHA-Web is incomplete or corrupted

HIGH

Mitigation: Pre-cutover, we run row-count + checksum reconciliation against three known sources: PHA-Web reports, the GL trial balance, and bank statements. Cutover blocked until all three match.

Staff resistance to a second system during side-by-side

MED

Mitigation: Side-by-side period intentionally limited to 6 functions. Most staff continue using PHA-Web; only Finance team learns new workflows in months 1–6. Compliance team onboards in months 7–12.

HUD-50058 submission failure during cutover window

HIGH

Mitigation: The PHA-Web-prepared and LC-prepared batches overlap — the PHA files the same batch from both sources for 30 days and compares. If the LC-prepared batch shows any discrepancy, the PHA-Web-prepared one stays authoritative, so the compliant filing still goes through.

Audit timing conflicts with parallel run

MED

Mitigation: We schedule cutover phases to avoid year-end audit window. If your fiscal year ends Dec 31, cutover happens in Feb–April or June–August. Never in your audit period.

PHA-Web contract early-termination penalty

LOW

Mitigation: We don't end PHA-Web mid-term. Full cutover is timed to natural contract anniversary. Side-by-side year ends precisely at PHA-Web renewal.

HUD field office unfamiliar with new tool

LOW

Mitigation: We notify your HUD field office in writing at kickoff with the migration plan. Provide them with sample LC reports + side-by-side comparison to PHA-Web outputs. They retain right to request either format.

Rollback plan

What "back out" looks like.

We never cross a bridge we can't cross back. Six guardrails ensure your agency can return to PHA-Web-only operation at any phase, with no compliance gap or data loss.

  • PHA-Web remains operational and authoritative for compliance submissions through Month 18
  • All LC data is exportable to standard formats (CSV, FDS templates, 50058 XML) at any point
  • Bank-feed connection can be disconnected without affecting bank account access
  • Trial-balance roll-back: if LC books drift from PHA-Web, we re-import PHA-Web data as source of truth and resume parallel-run
  • Cutover decision can be reversed up to 30 days post-cutover — PHA-Web account stays paid during this window
  • Worst case: PHA returns to PHA-Web-only operation with 90 days of LC continuous-audit data exported as PDF for board records

PHA-Web data importer

What we pull from your existing PHA-Web installation during Day 4-7 of Phase 1. All imports are validated row-by-row before LC accepts the data as authoritative.

HUD-50058 history
Volume: Per agency: typically 50K–500K rows over 5 years
Format: XML (PHA-Web native) or CSV
Validation: Per-record validation against IMS/PIC error codes; flag historic submissions that would fail under current edits
Tenant master
Volume: Active + historical tenants — 1K–50K records
Format: CSV with PHA-Web schema
Validation: EIV-match validation on income fields; race/ethnicity field consistency
Vendor master
Volume: 200–10,000 vendors
Format: CSV
Validation: Duplicate detection, TIN format validation, W-9 currency check
GL trial balance
Volume: Year-end snapshots — last 7 years
Format: CSV or QuickBooks export
Validation: Total debits = total credits; balance sheet ties to bank statements
Lease + occupancy register
Volume: Active leases — 500–20K
Format: CSV
Validation: Move-in dates ≤ current date; rent calc TTP ties to 50058
HAP register history
Volume: Monthly snapshots — last 36 months minimum
Format: CSV
Validation: Sum(HAP) ties to bank disbursements ties to VMS submission
Asset register
Volume: Capital assets — 100–10K rows
Format: CSV
Validation: Accumulated depreciation reasonableness; HUD-cost-tracking codes preserved
Bank account info
Volume: Operating + investment + reserve accounts
Format: Linked via Plaid; PHA-Web data archived
Validation: Account balances reconcile to GL cash accounts
User accounts + roles
Volume: 10–500 active users
Format: CSV
Validation: Manual review; LC roles mapped 1:1 where possible; staff trained on new role names

Next step

Bring your Finance Director and IT lead. We'll review your specific PHA-Web setup, identify the 3-5 risks unique to your agency, and produce a customized 18-month plan before any commercial commitment.