Close Reconciliation Evidence

About this kit

Checks a bounded reconciliation sheet for unexplained differences and missing support.

• Reads Google Sheets within your chosen scope
• Returns evidence and review questions
• Runs on demand; no business-data writes

How it works

Drive

Checks a bounded reconciliation sheet for unexplained differences and missing support. Read a finite Google Sheets range: up to 200 rows and 16 relevant columns total. Formatted values are available; formula provenance and edit history are not.

App access

Drive

All files

Visible fields

• Name
• Mime type
• Modified time
• Web view link

Allowed operations

• Get file metadata
• Read sheet data

Setup inputs

• Sheet ID Tab and Range

Setup questions

• What materiality rule and currency apply to reconciliation exceptions?