Reconcile a spreadsheet against a policy PDF
Attach both files and get exceptions with policy citations.
By Bot Cookbook
- Recipe
- Files and reports
- none (attachments)
- 14 Oct 2026
Method
- 01
Attach the PDF and the spreadsheet
Use the attachment control, or drag the files into the composer. The desktop composer accepts up to six attachments. Documents can be up to 25 MB each.
- 02
Say what each file is
Name the PDF as the policy and the spreadsheet as the transactions, in whatever words match your files. Ask it to cite the policy section for every exception.
- 03
Ask for a new spreadsheet and a short summary
Ask for those two results, and tell it to leave the originals unchanged.
- 04
Review the cards
Files come back as cards in the conversation. Open the new spreadsheet and read the summary before you act on an exception.
Prompts
01Ask for a spreadsheet with exact columnsA spreadsheet that meets the stated spec.noneView02Build a simple budget spreadsheetA budget spreadsheet.noneView03Check invoices for errorsA list of invoice problems.attachmentView04Clean up a messy CSVA cleaned CSV and a change log.attachmentView05Compare two versions of a documentA change list between versions.attachmentsView06Draft a monthly report from dataA one-page report draft.attachmentView07List key terms in a contractA key-terms list with quotes.attachmentView08Pull tables out of a PDFA spreadsheet of extracted tables.attachmentView09Reconcile a spreadsheet against a documentA new spreadsheet and summary.attachmentsView10Review my resume for a roleResume feedback and a new summary.attachmentView11Summarize a spreadsheet by groupA grouped summary with a chart.attachmentView12Turn notes into a slide outlineA slide outline.noneView13Weekly expense follow-upsA reconciliation plus unsent drafts.expense system, email, shared driveView