LaunchKit · 2026
Back to Skills

odoo-reporting

Query Odoo data including salesperson performance, customer analytics, orders, invoices, CRM, accounting, VAT.

0
455 downloads
by @ashrf-in

Setup & Installation

openclaw skills install @ashrf-in/odoo-reporting

Or with the ClawHub CLI, for registry-managed skill folders outside a full OpenClaw workspace:

npx clawhub install odoo-reporting

What This Skill Does

Connects to an Odoo instance via XML-RPC or JSON-RPC to query sales orders, invoices, journal entries, CRM records, and accounting data. Reports are generated locally as WhatsApp cards (PNG), PDFs, or Excel files. All operations are strictly read-only.

Reports pull directly from account.move.line and the chart of accounts rather than Odoo's summary views, so balance sheets balance correctly including proper treatment of Odoo's current-year earnings suspense account.

When to use it

  • Check a salesperson's order count and invoiced revenue for a given quarter
  • Run AR aging to identify which customer invoices are overdue by bucket
  • Generate a one-page CFO executive summary for a monthly finance review
  • Compare revenue vs expenses across two custom date ranges
  • Find top customers by revenue for a specific period or salesperson

Example Workflow

Here's how your AI assistant might use this skill in practice.

INPUT

User asks: How is Ahmed's sales performance this quarter?

AGENT
  1. 1Search res.users for a user matching 'Ahmed' to retrieve their user_id
  2. 2Query sale.order filtered by user_id for the quarter date range, aggregate order count and total amount
  3. 3Query account.move for posted invoices linked to that salesperson and check payment_state
  4. 4Generate a KPI WhatsApp card with orders, revenue, and invoice collection rate
OUTPUT

1080x1080 PNG card showing Ahmed's order count, total revenue, and invoice payment status for the quarter

Requirements

Accounts, API keys, or tools you or your AI assistant may need to set up while using this skill.

Odoo instance URL, database name, and user account (ODOO_URL, ODOO_DB, ODOO_USER)Odoo API key or account password (ODOO_PASSWORD) — API key generated from Odoo Settings > Account Security > API Keys