Odoo Accounting Operations
When to Use
- •Syncing transactions from Odoo (daily at 6 AM recommended)
- •Generating financial summaries (revenue, expenses, net profit)
- •Retrieving invoices and payment status
- •Preparing data for CEO Briefing
- •Analyzing expense categories and trends
Instructions
- •
Sync Transactions (retrieves last 30 days):
bashpython3 .claude/skills/odoo-accounting/scripts/main_operation.py --action sync
Syncs invoices, payments, expenses from Odoo. Prevents duplicates.
- •
Financial Summary:
bashpython3 .claude/skills/odoo-accounting/scripts/main_operation.py --action summary --period monthly
Options:
--period daily|weekly|monthly|custom --start YYYY-MM-DD --end YYYY-MM-DD - •
List Invoices:
bashpython3 .claude/skills/odoo-accounting/scripts/main_operation.py --action invoices --status unpaid
Options:
--status all|paid|unpaid|overdue - •
Expense Analysis:
bashpython3 .claude/skills/odoo-accounting/scripts/main_operation.py --action expenses --top 10
Categorizes expenses and shows top spending areas.
- •
Check Status:
bashpython3 .claude/skills/odoo-accounting/scripts/main_operation.py --action status
- •
Verify Connection:
bashpython3 .claude/skills/odoo-accounting/scripts/verify_operation.py
Environment Variables Required
bash
ODOO_URL=http://localhost:8069 ODOO_DB=your_database_name ODOO_USER=your_user_login ODOO_PASSWORD=your_api_key_or_password # API key allows secure access without main password
Output Files
- •
AI_Employee_Vault/Accounting/transactions_YYYY-MM.json- Monthly transaction data - •
AI_Employee_Vault/Accounting/summary_YYYY-MM-DD.md- Financial summaries - •
AI_Employee_Vault/Accounting/invoices_current.json- Active invoices
Validation
- • Odoo API authenticated successfully
- • Transactions synced without duplicates
- • Financial calculations accurate
- • Audit log entry created
See REFERENCE.md for JSON-RPC setup and API details.