Reconciliation Check
Automated integrity check for any TIS workbook. Verify formulas, totals, mappings, and data quality in seconds.
Included free with every PnP TIS. Every TIS generated by PnP automatically includes a Reconciliation Check tab at no extra cost. This standalone tool is perfect for verifying workbooks from other sources or previous versions.
What We Check
- Structure — Required sheets present, sorted tab headers valid, Bank Summary has period data
- Tie-Outs — Bank Summary vs sorted tabs, CC Summary vs CC sorted, Fed_TIS lines vs sorted aggregates
- Data Quality — Unmapped transactions (NEEDS REVIEW), out-of-period dates, duplicate rows
- Formula Integrity — Reconciliation bridge check, unexplained differences, CC double-counting detection
How is this different from the TIS reconciliation section?
The TIS rec section (already in Fed_TIS) answers: "Do the totals balance?" — it shows a difference number and tries to explain it with bridge items.
The Reconciliation Check answers: "Is the entire workbook trustworthy?" — it goes beyond the totals and checks:
- Are there transactions sitting in "NEEDS REVIEW" that never got labeled?
- Are there dates from the wrong year mixed in?
- Do the sorted tab totals actually match what the Bank Summary says?
- Are there duplicate rows inflating numbers?
- Does the CC Summary roll forward correctly?
Think of it this way: the TIS rec is a trial balance. This tool is an integrity review.
0
/100
PASS
What to do next
Show technical details
| Status | Check | Result | Suggested Fix |
|---|
AI Diagnostics
Claude analyzed the failed checks and identified root causes.
Includes "Reconciliation Check" tab + "AI Diagnostics" tab (when applicable).
How the Full Pipeline Works
1
Upload
→
2
Label
→
3
TIS
→
4
Check
Coming soon: Full Agent Orchestrator — upload raw bank statements and let the AI run the entire pipeline (Label → TIS → Audit) for you.
Buy $PNP