Monday financial pulse: weekly QuickBooks summary in Slack

Build me an agent workflow that sends a Monday morning financial pulse to Slack so I walk into the week knowing where cash and margin actually stand.

Trigger: cron, every Monday at 7:00am in my local timezone.

What the agent should do on each run:

1. Use QuickBooks Online (the Run Reports operation) three times to pull the Profit and Loss, Cash Flow, and Balance Sheet reports for the trailing week (Monday through Sunday of the week that just ended).

2. Call Run Reports again for the same three reports, but for the prior week (the seven days before that), so it can compare week over week.

3. Compute the week-over-week deltas for the metrics a founder cares about: total revenue, gross margin (and gross margin percentage), total operating expenses, ending cash balance, total accounts receivable, AR over 60 days, and total accounts payable. Express each delta as both a dollar change and a percentage change.

4. Write a short narrative summary (three to five sentences) that highlights the two or three most material changes. Examples of the tone I want: "Revenue up 18% week over week, driven by enterprise renewals closing on Thursday." "Ending cash dropped $42k, mostly from quarterly vendor bills paid out on Wednesday." "AR over 60 days grew by $8k. Two customers slipped past their net-30 terms." The narrative should focus on what changed and why it probably changed (based on the largest line items moving), not restate every number.

5. Use the Slack Bot integration (Send a Message) to post the summary to a Slack channel I designate when I set up the workflow. The message should lead with the narrative paragraph at the top, then include a small Slack-formatted table at the bottom with the headline numbers: revenue, gross margin, operating expenses, ending cash, AR, AR over 60 days, and AP. For each row show this week, last week, the dollar change, and the percent change.

Use the Slack Bot integration (not the user-token Slack integration) so the post is attributed to a bot and keeps working even if I leave the workspace.

This should be an agent workflow rather than a code workflow because deciding which two or three deltas matter most and writing a natural-sounding "so what" sentence requires reasoning, not a fixed template.

Configurable inputs at setup time: the QuickBooks Online connection, the Slack Bot connection, the destination Slack channel ID, and my timezone.

Additional information

What does this prompt do?

Pulls last week's Profit and Loss, Cash Flow, and Balance Sheet from QuickBooks Online, plus the same numbers from the week before, so it can compare the two.
Computes the changes that actually matter to a founder: revenue, gross margin, operating expenses, ending cash, accounts receivable, and accounts payable.
Writes a short plain-English narrative calling out the two or three biggest movements (for example, revenue up 18% on enterprise renewals, ending cash down on quarterly vendor bills).
Posts the summary to a Slack channel you pick, with a clean table of the headline numbers underneath.

What do I need to use this?

A QuickBooks Online account with at least one full week of bookkeeping closed out.
A Slack workspace and a channel where the financial pulse should land (a private founder or leadership channel works well).
A Slack admin who can install the bot in your workspace and add it to that channel.

How can I customize it?

Change the schedule. Move it off Monday at 7am, run it twice a week, or send it the last business day of each month.
Swap the Slack channel, post to a private DM with the founder instead, or send it to multiple channels.
Adjust which metrics get called out. Add burn rate, runway in months, payroll as a share of revenue, or a top-customers breakdown.
Tell the agent which deltas you care about most so the narrative leans into your priorities (cash, growth, profitability, or collections).

Frequently asked questions

Does this work with QuickBooks Desktop?

No. It uses QuickBooks Online. If you are on QuickBooks Desktop, you would need to move to Online or export your reports manually.

Can I send the summary somewhere other than Slack?

Yes. You can change the destination to email, Microsoft Teams, or a Notion page when you set the prompt up. Slack is just the default because it is where most founders already check in on Monday morning.

How are the comparison numbers calculated?

The agent pulls the trailing week from QuickBooks and pulls the same range from the week before, then compares the two. You can ask it to compare against a four-week trailing average or the same week last year instead.

Will the message dump every line of my P&L?

No. The point is the one paragraph summary. The agent picks the two or three biggest movements and writes about those, then includes a small table of headline numbers (revenue, gross margin, operating expenses, ending cash, AR, AP) at the bottom.

Who in my company will see the message?

Only the people in the Slack channel you choose. Most founders point this at a private leadership or finance channel, or send it as a DM.