Codex pulls every transaction from QuickBooks through an MCP connector, categorises the expenses, breaks down your revenue, charts monthly profit, and flags the trends worth your attention. By the time you finish your morning coffee, the Excel workbook is ready and the accountant email is drafted in your Gmail.
Most property investors I know have a day job, or run their own business, and build their portfolio on the side. The deal-hunting is the fun part. The admin is the slog that gets pushed to the weekend, or worse, until the accountant starts chasing. This guide turns quarter-end books into a twenty-minute job, run while the kettle boils. Every quarter follows the same template, so the second quarter is faster than the first.
A categorised expense breakdown for the quarter. A revenue split by source. A monthly profit chart. A short list of flagged trends and one-off outliers worth a second look. Everything bundled into a single Excel workbook with the one-page summary on the front tab and embedded charts. The accompanying email to your accountant sits in your Gmail Drafts folder, attachment ready, awaiting one click.
This is Codex working as an operator, not just an analyst. You give it the job, it executes end to end. That is the Day 10 stage-two pattern applied to the one task most investors actively avoid.
A paid ChatGPT plan with Codex access. Codex runs inside your ChatGPT account. The free tier does not include connectors. Plus, Pro, Team, and Enterprise plans do. Check what your current plan allows before you start.
A bookkeeping platform Codex can read from. QuickBooks Online or Xero are the two most common. Both have hosted MCP servers you can point ChatGPT at, like DeepLedger for QuickBooks. If your books still live in a spreadsheet, you can also feed Codex a CSV export and the rest of the workflow still holds.
Gmail connected to ChatGPT. The Gmail connector lets Codex draft the email straight into your Gmail Drafts folder with the workbook attached. You open Gmail, scan the draft, and hit send.
The ChatGPT Gmail connector is read and draft only. Codex cannot send the email itself. That is by design. You stay in control of the send. Codex builds the draft, you review it once, you hit send. The twenty-minute promise still holds. The pause at the end is a feature, not a bottleneck.
Two connectors before the prompt. QuickBooks via an MCP server so Codex can read your books directly. Gmail via the native connector so Codex can drop the email draft straight into your inbox. Both are one-time setup. Every future quarter inherits the same wiring.
ChatGPT does not ship with a native QuickBooks connector. You point it at a hosted MCP server that exposes QuickBooks to Codex. DeepLedger is the cleanest path. Same setup pattern works for any QuickBooks MCP server you trust.
DeepLedger) and the MCP server URL: https://mcp.deepledger.ai/mcp.Xero works on exactly the same pattern with a Xero-aware MCP server. If you are on a different bookkeeping platform, check whether the vendor or community publishes an MCP endpoint. If not, a CSV export from the platform's reporting screen still drives the rest of the workflow.
The Gmail connector is native to ChatGPT. No MCP server needed. The same Settings panel handles it.
If your accountant prefers Outlook, the equivalent Microsoft 365 connector covers the same workflow. The prompt in step 02 changes nothing other than the connector name.
Connectors carry your existing access permissions. Codex can only see and do what your QuickBooks and Gmail accounts can already see and do. If you have separate SPV company files, only the ones your login can open will be readable. Gmail is read and draft, not send. The OpenAI connector is intentionally limited so you stay in the loop on every outbound email. Both behaviours protect you and are not switches to override on a quiet weekend.
Open a new Codex task. Paste the prompt below. Codex pulls the transactions from QuickBooks via MCP, asks one or two clarifying questions about your expense categories, then goes to work. The prompt is the contract for the whole run.
My QuickBooks is connected via MCP. Pull every transaction from the most recent complete quarter for my business account. Then do four things: 1. Categorise every expense by type. Use the categories my accountant cares about: mortgage interest, service charges, repairs and maintenance, professional fees, utilities, insurance, marketing, software, travel, and other. If a transaction does not fit cleanly, flag it for me rather than guessing. 2. Analyse my revenue streams. Break income down by source and show what share each source contributes to the quarter. 3. Visualise monthly profit across the quarter as a bar chart, with a line for net profit and a stacked breakdown of expense categories underneath. 4. Flag any unusual spending trends or one-off outliers worth my attention. Anything more than two standard deviations above the category average, anything in a category that did not exist last quarter, anything that looks like a duplicate. Produce a single Excel workbook with these tabs: - Summary: a one-page view with the headline numbers (total revenue, total expenses, net profit, quarter-on-quarter delta), the categorisation table, the monthly profit chart embedded as an image, and the flagged trends list. - Transactions: the cleaned, categorised transaction list. - Revenue: the revenue split by source, with absolute amounts and percentage share. - Trends: the flagged outliers with a one-line note explaining why each was flagged. Format the Summary tab so it prints cleanly on a single A4 page in landscape. Embed all charts as images in the workbook so they render without a live data connection. Then draft an email to my accountant at [accountant@example.com] through the Gmail connector and save it in my Drafts folder. Subject line: "Quarterly bookkeeping summary, [business name]". Body: three short paragraphs covering the headline numbers, what changed versus the previous quarter, and the items flagged for their attention. Attach the Excel workbook. Do not send. I will review the draft in Gmail and send it myself.
Usually one or two clarifying questions about your category definitions. Whether service charges include or exclude reserve fund contributions. Whether mortgage capital repayments should sit under loan repayments or be excluded from the P&L entirely. Whether you want gross or net of VAT.
Answer these once and Codex will remember the calls for the rest of the run. Save the answers in a note for next quarter so you can paste them in alongside the prompt.
The four-step run takes Codex a few minutes once the prompt is in. Categorisation is the longest step. Revenue analysis, the profit chart, and the trend flags follow in sequence. Nothing else needs your input until the draft email is ready for your approval.
Codex reads each transaction line, matches description and amount against the category list, and assigns a tag. Anything ambiguous gets a flag with a one-line note explaining why it could not be assigned automatically.
The output is a tagged transaction list and a category-level total table. The flagged items sit at the top for your review.
Every income transaction grouped by source. Rental income separated from advisory fees, consulting work, course sales, or whatever else your books carry. The output is a table with absolute amounts and percentage share by source.
This is the layer where you spot the revenue concentration risk. If one source is doing eighty percent of the work, that is something to know before Q2.
A bar chart by month showing net profit. Underneath, a stacked breakdown of expense categories so the seasonality of each category is visible at a glance. Service charges spike in the month they are billed. Marketing tracks campaign cycles. Repairs cluster around tenant turnover.
The chart is generated as an image you can drop into a board pack or a partner update. No design work required.
Outliers more than two standard deviations above the category average. New categories that did not appear in the previous quarter. Transactions that look like duplicates. Anything that needs a human eye before the books close.
This is the layer that earns the workflow its keep. The categorisation is table stakes. The flagged trends are what stop a duplicate invoice or a runaway subscription from slipping through the quarter undetected.
The first run will produce a longer flag list than future quarters. Codex is still learning your edge cases. Resolve each flag once and the call is locked in for next time. By the third run the flag list usually shrinks to genuine outliers rather than category ambiguity.
Once the workbook is built, Codex writes the email draft to your Gmail Drafts folder with the workbook attached. You open Gmail, scan the draft, and send. That is the one human step in the loop and it is the right one to keep.
Subject line: "Quarterly bookkeeping summary, [your business name]". Clear, scannable, no ambiguity about what is inside.
Email body: Three short paragraphs. Headline numbers for the quarter, what changed versus the previous quarter, and a short list of items flagged for the accountant's attention.
Attachment: The full Excel workbook with the Summary tab on the front, embedded charts, and the supporting tabs for Transactions, Revenue, and Trends. Designed so your accountant can open the Summary tab on a phone and the full detail tabs on a laptop.
Codex confirms in the chat once the draft is saved. Open Gmail in a new tab. Open the draft. Scan the three-paragraph body, open the Summary tab of the workbook, and check the headline numbers against what Codex showed you in the chat. If everything reconciles, hit send.
For repeat quarters, the review takes thirty seconds. You are checking that the headline numbers look right, the flagged trends are real, and the accountant's address is the correct one. That is the entire human input on top of a fully automated run.
The native ChatGPT Gmail connector cannot send on your behalf. By design. If you genuinely need autonomous send (for example, a regulated reporting pipeline), wire it through a Zapier MCP or a custom MCP server that exposes a send-email tool. For quarterly bookkeeping the draft-and-review pattern is the right one. Thirty seconds in Gmail is cheap insurance.
Codex runs inside ChatGPT. QuickBooks you are paying for either way. The MCP connector and the Gmail connector are free. The cost of the workflow is the cost of the time you save.
A paid ChatGPT plan with Codex access is the only new software spend. The free tier does not include Codex.
From opening the Codex task to approving the email send. Most of that is the coffee. The actual work Codex does in the background runs in a few minutes.
The MCP connector and the Gmail connector are free to install. You are paying for the underlying QuickBooks and Google accounts either way.
You sit down on the second Monday after quarter-end. You open ChatGPT, paste the locked prompt, and walk away. The categorisation runs, the workbook builds, the trends get flagged, and the email draft lands in your Gmail. You open it on the train, scan, hit send, and the quarter is closed.
The same pattern fires every quarter from a single template. Once a year, the same workflow rolls into a year-end pack ready for tax filing. That is the trade Day 19 ships.
Every prompt in this 30-day series is one capability. FourthspaceOS bundles all of them into a single product: underwriting, comps, market research, deal sourcing, portfolio tracking, and investor reporting. The product runs natively on the same Anthropic agents and plugins you are learning to use this month.
Waitlist members get founding pricing, early access, and one new prompt delivered each day for the next 30 days.
Founding pricing locks in for waitlist members.
One email a day for 30 days. No spam. Unsubscribe whenever.
Send them this page. The MCP connector and the Gmail connector are both free. The hardest part of the setup is deciding which accountant gets the email. The hours saved compound over every quarter that follows.
Find me on Instagram ↗Add the QuickBooks MCP. Add the Gmail connector. Save the prompt from step 02 in a note. Block twenty minutes on the Monday after quarter-end. By the time the coffee is done, the quarter is signed off and your accountant has the workbook.
Start at step 01 ↑