Your clone updates the cash workbook from the finance emails

Many finance teams still update the cash picture by hand: open the bank report, open the AR aging attachment, retype numbers into a workbook, check the totals, save a copy, write a summary email. It takes 30–60 minutes, twice a week, and one mistyped digit can travel all the way to leadership.

Finance Report Autopilot does the repetitive part and keeps a person in charge of the risky part. Your clone:

• finds the latest recurring finance emails from your {SENDERS} since its last run,
• reads the attachments directly (PDF, CSV or Excel),
• extracts bank balances by account, AR aging buckets (current / 30 / 60 / 90+) and top past-due customers,
• writes values only into the input cells you mapped ({INPUT_MAP}), never into formula cells,
• recalculates and audits the workbook (#REF!, #VALUE!, #DIV/0!, totals that do not tie),
• saves a dated copy and keeps the original as the template,
• emails the workbook (or a link) with a short summary to {RECIPIENTS}.

What you get:

• Finance and operations managers who rebuild the cash report from emailed bank and AR reports every week.
• Controllers and finance analysts who want consistent inputs and an error audit before numbers go out.
• Leadership (CEO, COO, CFO, owners) who want a reliable twice-weekly view of cash position and past-due receivables.
• Small and mid-size teams that run cash management in a master workbook and receive reports by email.

   Trigger
   ├─ Scheduled: {SCHEDULE} (e.g. Mon and Thu, 8 AM)
   └─ On demand: "Run the finance report"
                         │
                         ▼
 ┌───────────────────────────────────────────────────────────────────┐
 │  "Finance Report Autopilot" skill                                 │
 │                                                                   │
 │  1. Find new emails since last run from {SENDERS}                 │
 │       subjects like {SUBJECT_PATTERNS}                            │
 │  2. Read attachments directly (PDF / CSV / Excel)                 │
 │  3. Extract: balances by account · AR buckets · top past-due      │
 │       (low confidence or missing value → STOP and ask)            │
 │  4. Map each value to a target cell using {INPUT_MAP}             │
 │  5. Show EXTRACTED VALUES + TARGET CELLS                          │
 └───────────────────────────────┬───────────────────────────────────┘
                                 │
        Approval mode ({APPROVAL_RUNS} runs): you reply "yes"
                                 │
                                 ▼
 ┌───────────────────────────────────────────────────────────────────┐
 │  Update the workbook ({WORKBOOK})                                 │
 │   · save a dated copy "Cash Report – YYYY-MM-DD"                  │
 │   · write inputs ONLY into mapped cells (never formulas)          │
 │   · recalculate and run the ERROR AUDIT                           │
 │       (#REF!, #VALUE!, #DIV/0!, totals that do not tie)           │
 │  Audit fails → stop, report, do NOT send                          │
 │                                                                   │
 │  Email {RECIPIENTS}: workbook or link + short summary             │
 │   · changes since last report · cash position                     │
 │   · AR over 60 / 90 days · anything unusual                       │
 │  Optional phase 2: cash suggestions (clearly labeled)             │
 └───────────────────────────────────────────────────────────────────┘

#Example input map

During setup, the clone proposes a mapping table and you confirm it cell by cell. Example (yours will differ):

Formula cells are listed in the map as "never write" so the clone knows exactly what to leave alone.

Your clone matches these to the exact skill names in your workspace. Confirm them in your skill catalog before saving the skill. Your clone will report the exact names it finds.

Skill names can differ slightly between orgs. Confirm the exact names in your skill catalog before saving the skill.

Pick one email provider (required):

Pick one workbook route (required):

Also required:

• Map input cells precisely and lock formula cells. The input map is the safety net. List formula cells as "never write". In Excel or Google Sheets, also protect formula ranges so accidental writes are blocked.
• Report formats change. If a bank or AR report changes layout, extraction can break. If confidence is low or a value is missing, the clone stops and asks. It never guesses.
• Keep the template separate from dated copies. The original is the template and is never written to. Every run writes to a new dated copy.
• Scanned PDFs extract worse than CSV or Excel. Ask senders to include a CSV or Excel version when possible.
• Tell the clone to read PDFs directly. Do not rely on an old PDF-to-text skill. Gmail and Outlook operators read attachments themselves.
• Finance data is sensitive. Keep {RECIPIENTS} short, prefer links over attachments, and keep the dated copies folder restricted.
• Confirm file permissions on OneDrive and SharePoint. The clone's connection needs edit access to the workbook and the copies folder. SharePoint "access denied" usually means the Microsoft connection needs to be recreated to pick up new permissions.
• Since the last run. The clone tracks when it last ran. If you change the schedule or miss a run, tell it the date range to cover.
• Read every instruction before saving the skill. You are responsible for what your clone does.