Property AP and Bank Integrity Diagnostic

Description
I built this diagnostic for group controllers and property finance teams that need a defensible control map before system or process remediation begins.
The Excel model consolidates invoice, payment, bank, approval, and mapping registers. It isolates duplicate invoices, duplicate payments, missing approvals, late invoice entry, invalid invoice links, off-system payments, unmatched bank debits, missing GL postings, and aged or entity mapping exceptions.

The Executive Dashboard summarizes the control position. It reports open exceptions, critical and high items, indicative exposure, and unreconciled lines. Two charts show the concentration of exceptions and unresolved activity by account.

The Exception Register provides line-level evidence. The Remediation Plan assigns the issue, control response, owner, priority, and recommended action. Ten embedded checks confirm source counts, totals, mapping coverage, exception counts, and synthetic-only status.

The source layers are structured for controlled Power Query ingestion. The current workbook uses formula-driven tests so the diagnostic logic remains transparent and reviewable.

The model supports pre-remediation reviews, month-end control assessments, portfolio governance, and evidence preparation across multi-entity property operations.

This is a self-serve professional model. It does not change AppFolio or another ERP. It does not include custom mapping, accounting advice, native backend development, or synchronous support.

Require bespoke integration or custom forensic architecture?

Engage my services directly via Upwork.