A free playbook by The Aigent Lab

Portfolio & Operations

Portfolio & Operations · Playbook 19

Quarter-end books. Twenty minutes.

Connect your accounting platform to an AI coding agent, ask for a categorised P&L, a profit chart, flagged trends, and an Excel workbook, then have it draft the accountant email through your inbox connector. Bookkeeping in the time it takes the kettle to boil.


What this buys you.

The deal-hunting is the fun part of running a book of business. The admin is the slog that gets pushed to the weekend, or worse, until the accountant starts chasing. This turns quarter-end books into a twenty-minute job, run while the coffee brews.

Connect. Ask. Review.

01

Connect accounting and email

Wire your accounting platform through an MCP connector and your inbox through the native connector, so the agent can read transactions and draft emails.

02

Send the four-thing prompt

Categorise every expense, break down revenue by source, chart monthly profit, and flag unusual spending, all bundled into one Excel workbook.

03

Let it run

Categorisation is the longest step. Revenue analysis, the chart, and trend flags follow in sequence without further input.

04

Review the drafted email, then send it yourself

The agent drafts the accountant email with the workbook attached and saves it to drafts. You scan it and hit send.

The quarterly bookkeeping prompt
Pull every transaction from the most recent complete quarter. Categorise every expense, analyse revenue by source, chart monthly profit, and flag unusual spending. Produce a single Excel workbook. Then draft an email to my accountant with the workbook attached and save it to drafts. Do not send.

What it still gets wrong.

i.

It's read and draft only, by design

The agent cannot send the email itself. You stay in control of every outbound message.

ii.

The first run has more flags than later ones

The agent is learning your edge cases. Resolve each flag once and the call is usually locked in for next quarter.

iii.

Data quality upstream still matters

A messy chart of accounts produces a messy categorisation, however good the agent is.


Next Playbook

A personal finance audit for high-earning clients

Read Next ↗