Still reconciling in Excel after implementing Workiva? What to keep and what to move

Workiva is implemented. The statements, management report, or board package are built there. Yet every cycle someone exports data to Excel to reconcile totals, apply recurring adjustments, or build a bridge before the package can move forward.

This is about reporting bridges: tie-outs, recurring adjustments, and mapping steps that feed the Workiva package. Balance-sheet account reconciliations usually belong in your ERP or a reconciliation tool, and are not the subject here.

A controlled, well-understood spreadsheet analysis can be the right tool. The question is whether the spreadsheet is occasional analysis, or a recurring manual bridge that the reporting process depends on every period.

Pick one reconciliation that still runs in Excel and trace it from source to the reviewed report line.

Illustrative figures.

Keep unexplained differences visible on the map. A balancing line added to make the bridge tie is itself a finding.

• The same export, paste, and formula steps happen every cycle.
• The workbook’s output is typed or pasted into a Workiva spreadsheet rather than linked.
• Only one person can run it, and the steps are not written down.
• Reviewers re-perform the reconciliation because they cannot see how it was built.
• A late adjustment means redoing the bridge by hand.

• It is exploratory or one-off analysis.
• Its inputs and logic change materially every cycle.
• It supports a judgment, and the judgment is what the reviewer needs to see.

Moving a recurring bridge into Workiva usually means three things: a stable input, logic that lives in formulas instead of hand steps, and a link from the result to the report line.

• Input. Either a controlled upload each period or a Wdata table fed by a supported connection. Importing the old workbook once does not create a live connection. See what Wdata is and when finance teams need it.
• Logic. Mappings and exclusions expressed as formulas or queries a reviewer can read, not as a sequence of manual edits.
• Output. The reconciled figure linked into the reporting spreadsheet or document, so a correction flows through instead of being re-keyed.

Before switching over, run the new version in parallel with the Excel bridge for at least one real cycle and compare results line by line. Replace the spreadsheet only when the two agree and the differences you do find are explained.

Review the process map with your Controller and reporting team. Identify which steps support accounting judgment and which repeat the same calculations or transfers each period. Keep accounting decisions with the designated approver and plan the repeatable steps with the source, approvals, and review checks intact.

The goal is to make one reconciliation understandable, keep the analysis that belongs in a spreadsheet, and move only the repeatable bridge that can be safely rebuilt and verified. For a fuller example of separating inputs, calculations, and presentation, see moving an Excel management report into Workiva.