Skip to main content

Building dashboards from your Finaloop data with AI tools

Have Claude, ChatGPT or another AI tool build a dashboard from your live Finaloop data and re-run or schedule it, so your key numbers are always one message away.

Written by Emily Burrows

About

Applies to: Finaloop Accounting, Margins

With the Finaloop MCP connected, Claude, ChatGPT or another AI tool can build a dashboard from your live Finaloop data: sales by channel, margins, ad spend, cash and the rest, laid out the way you want it. Ask once, then re-run the same prompt whenever you want fresh numbers, or have your AI tool send it on a schedule.

The Finaloop MCP (Model Context Protocol) is a secure connection between Finaloop and your AI tool. Every number in the dashboard comes from your Finaloop data at the moment you ask, not from a file you pasted in.


Before you begin

  • Connect your AI tool to Finaloop. See Connect Finaloop to your AI tools.

  • Your Finaloop role is Admin, CFO, Tax CPA / Accountant or Operator / VA - Full access, so the MCP can read your sales, ads and reports.

  • Decide what the dashboard is for (a Monday review, a board update, a Black Friday war room), so you know which numbers and comparisons to ask for.


1. Start from a ready-made dashboard prompt

Finaloop has dashboard prompts you can copy and adapt, written to pull the right data and say how each number is calculated.

  1. Go to Dashboard and click Ask AI.

  2. Under Suggested for this page, find Build a live dashboard. Click Full prompt library to see every prompt, grouped by topic.

    Ask AI about your business panel on the Dashboard with the Build a live dashboard prompt and the Full prompt library link.

    ① Build a live dashboard, ② Copy prompt, ③ Full prompt library.
    ​

  3. Click Copy prompt, or Open in your AI tool, for example Open in Claude.

  4. Paste the prompt into a new chat, change anything you want, and send it.

Your AI tool pulls the data from Finaloop and lays out the dashboard. Most AI tools can also draw the numbers as charts and tables.

Dashboard prompts in the library include:

  • Build a live dashboard: sales, margins, ads, top SKUs and cash on one page you can refresh

  • Build an ads dashboard: weekly spend, blended and new-customer return on ad spend (ROAS) and cost per acquisition (CPA), with marketing efficiency ratio (MER) and profit on ad spend (POAS) by month

  • Weekly business review: last week by channel, with sales, orders, customers, ad spend and profit


2. Write your own dashboard prompt

A dashboard prompt works best when it names five things:

  • The period, and what to compare it with: month to date against the same days last month and last year

  • The numbers: net sales, orders, average order value (AOV), ad spend, contribution margin, cash on hand

  • The breakdown: by sales channel, top 10 SKUs, by ad platform

  • Where each number comes from: "from my books" for P&L figures, "from my sales data" for orders as they happened

  • What to call out: "a short read of what changed and what needs attention"

For example: Build me a dashboard I can re-run any time for month to date against last month: net sales and orders by channel, ad spend and MER, contribution margin by channel from my books, top 10 SKUs by profit, and cash on hand. Say how fresh the data is.

Once it looks right, save the prompt, so you can run the same dashboard again with one message.


3. Get it on a schedule

If your AI tool can run scheduled tasks, it can rebuild the dashboard or a report for you and send it where your team works. The prompt library has two ready-made ones:

  • Schedule my P&L: Pull my P&L for review, then schedule a monthly P&L summary to be posted to Slack on the 10th of the following month.

  • Build a custom report: a weekly business report from your P&L, with sales, spend and profit and 3 takeaways, sent every Monday morning

Your AI tool needs its own connection to the place it posts, such as Slack or email. For a file that refreshes every day without an AI tool, use the Google Sheets sync in Report center. See Opening, exporting and scheduling reports in Finaloop.


4. Keep your dashboard accurate

  • Re-run it for new numbers. A dashboard in your AI tool holds the numbers from the moment it was built.

  • Ask it to show its work: "Which transactions make up that number?" turns a figure you have to trust into one you can check.

  • Expect sales data and your books to differ for the same day, and say which one you want. See What the Finaloop MCP can see and change.

  • For totals and breakdowns the MCP returns at most 1,000 rows per answer, which covers dashboards. For every row of a busy month, ask for an export instead.

In Margins: In Margins, connect through the Margins MCP and open the prompts from AI Tools in the sidebar. Margins dashboards draw on your sales, ads and spend data; the P&L prompts are for Finaloop Accounting. See Connect Margins to your AI tools.


FAQs

Does my dashboard update itself?

No. It shows the numbers from when your AI tool built it. Send the prompt again, or schedule it in your AI tool, to refresh it.


Can the AI tool change my books while building a dashboard?

No. Reading sales, ads and reports never changes anything. Changes such as creating a bill need your approval in your AI tool. See What the Finaloop MCP can see and change.


Related articles


Need help?

If your AI tool can't reach your Finaloop data, or a dashboard number doesn't match what you see in Finaloop, reach out to our Support team through chat or at [email protected].

Did this answer your question?