County finance reports ongoing Workday reconciliation issues; staff to pursue implementer support

Jul 29, 2026

Finance staff described bank‑to‑general-ledger reconciliation problems after Workday implementation, citing collapsed ledger lines and missing fund-to-bank links; staff filed tickets with the implementer (AMS), plan to use purchased AMS hours and will return with cross-office recommendations.

The full story

Johnson County finance staff (S3, S4) updated supervisors on ongoing challenges reconciling the general ledger to bank totals following the Workday conversion. Staff said a bank‑to‑book reconciliation report suggests the county may be balanced, but multiple entries, collapsed ledger lines and bank transactions not attached to specific accounts are creating a practical impediment to a standard bank reconciliation. "We have a rather large group of funds that are associated all with a rather large group of banks," Dana Aschenbrenner said, explaining the need for further troubleshooting and additional implementer support.

Staff reported they have submitted tickets to AMS (the implementer) and will try to exhaust purchased AMS hours before seeking external consulting, and requested a coordinated briefing that includes the auditor, treasurer and IT so all parties can arrive at a common recommendation. Supervisors urged a cross-office meeting to reach a clear, unified recommendation for the board.

Written with AI from the event video and transcript. Check it against the source ↓