Cash data in your BI dashboard

Goal: your BI tool or data warehouse has up-to-date balances and categorised transactions from COMMITLY, next to your other company data.

1. Balances: GET /accounts/ returns every account with its balance, plus company figures: total, available_limit and the forecast balances with their limits for the end of this month, next month, three months ahead and the fiscal year end. Store a snapshot per day to chart the development.

2. Transactions: GET /transactions/ returns categorised bookings, 100 per page by default and up to 1,000 with page_size. Filter by date with min_date and max_date, or load only what changed with min_date_updated.

   rows, page = [], 1
   while page:
       data = requests.get(f"{BASE}/transactions/", headers=auth(),
                           params={"page": page, "page_size": 1000,
                                   "min_date": "2026-01-01"}).json()
       rows += data["results"]
       page = page + 1 if data["next"] else None

   Always call https://app.commitly.com/api; if a next link points to another host, take only the page number from it.

3. Categories: load GET /categories/ (a plain list, not paginated) as a dimension table and join transactions on category.id. The parent field gives you the hierarchy for drill-downs.

4. Plans and forecast: load plan, scenario and forecast budgets to compare actuals with plan in your BI tool.

Prefer to ask instead of building a dashboard? With the MCP server your AI tool can build dashboards from the same data, including daily balances for plans, scenarios and the forecast.