ERPClaw General Ledger Manager for Openclaw

An AI-native accounting backbone for ERPClaw that manages the General Ledger and Chart of Accounts with immutable audit trails.

mailnike
v1.0.3
Feb 26, 2026
0
0
0

Install & Download

1. ClawHub CLI

The fastest way to install a skill directly from the registry.

npx clawhub@latest install erpclaw-gl

2. Manual Installation

Copy the skill folder to one of these locations

Global
~/.openclaw/skills/
Workspace
<project>/skills/

Priority: Workspace > Local > Bundled

3. Prompt Installation

Copy this prompt to OpenClaw to install it automatically.

Help me install erpclaw-gl using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).

Prefer to download?

Get the raw skill files in a ZIP archive.

What is ERPClaw General Ledger Manager?

ERPClaw GL serves as the financial single source of truth within the ecosystem of Openclaw Skills. Designed for AI-native ERP environments, it provides a robust, local-only SQLite-based system for managing complex financial data. The skill enforces the fundamental double-entry invariant (Debits = Credits) and maintains an immutable ledger where corrections are made through reversals rather than deletions, ensuring a perfect audit trail.

By integrating this skill, developers and accountants can automate fiscal year transitions, budget tracking, and cost center management. It acts as the core engine for other financial modules, providing standardized document numbering and real-time balance tracking without requiring cloud dependencies or external API calls.

ERPClaw General Ledger Manager Use Cases

  • Initializing a standardized Chart of Accounts (CoA) using US GAAP templates.
  • Managing fiscal year closing and reopening procedures with automated validation.
  • Recording and reversing General Ledger entries for journals, payments, and invoices.
  • Setting and monitoring department-specific budgets and cost centers.
  • Performing high-integrity financial audits and real-time balance lookups.

How ERPClaw General Ledger Manager Works

  1. Initialize the local SQLite database to store accounts, entries, and fiscal configurations.
  2. Load a Chart of Accounts template to establish the hierarchical account tree.
  3. Define fiscal years and cost centers to categorize incoming financial transactions.
  4. Post GL entries via the command-line interface, which validates double-entry balance before commitment.
  5. Utilize automated naming series to generate unique document identifiers for all financial activities.

ERPClaw General Ledger Manager Setup

First, ensure erpclaw-setup is complete. Then, initialize the database:

python3 ~/.openclaw/erpclaw/init_db.py --db-path ~/.openclaw/erpclaw/data.sqlite

If Python dependencies are missing, install the required packages:

pip install -r scripts/requirements.txt

ERPClaw General Ledger Manager Data Schema & Taxonomy

The skill manages eight primary tables in a local SQLite file. Financial amounts are stored as TEXT to maintain precision via Python Decimal types, and all IDs utilize UUID4.

Table Description
account Hierarchical Chart of Accounts using nested sets and parent IDs.
gl_entry Immutable record of all financial movements; cancellations use reversals.
fiscal_year Defined date ranges and period status (Open/Closed).
cost_center Departmental or project-based tracking for granular reporting.
budget Budgetary limits and alert configurations per account/cost center.
naming_series System for generating sequential, year-based document IDs.

ERPClaw General Ledger Manager Advanced Features

  • Immutable Audit Trail: Enforces data integrity within Openclaw Skills by requiring reversal entries instead of deletions.
  • Nested Set Logic: High-performance querying of complex account hierarchies and parent-child relationships.
  • Cross-Skill Coordination: Automatically provides document numbering and GL posting services to selling, buying, and payment skills.
  • Proactive Integrity Checks: Built-in validation to alert users if the ledger falls out of balance or if group accounts are targeted for direct entries.
  • Budgetary Controls: Automated warnings or hard stops when transactions exceed predefined fiscal limits.

SKILL.md


Loading

Related Openclaw Skills

METADATA

Requires
Bins python3
Github Stars: 0
forks: 0

Featured*