💰 Finance & Accounting

Flag reconciling items in Google Sheets

💰 Finance & AccountingGeminiBeginner

Task · Account reconciliation
Time saved · 1 hr per rec (estimate, not measured)

Steps

1. Open the sheet in Google Sheets
2. Open the Gemini side panel
3. Enter the prompt
4. Verify results against a pivot table or manual check

Prompt / template

Compare column B (ledger) with column E (statement) and list items that appear in only one, with totals.

Source · https://support.google.com/docs/answer/14218565
Last checked · 2026-10-16

More Finance & Accounting workflows →