An automated financial tool for generating standardized balance sheets from profit statements and transaction ledgers.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install balance-sheet-cn
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install balance-sheet-cn 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 Balance Sheet Generator?
The Balance Sheet Generator is a specialized component of Openclaw Skills designed to streamline corporate accounting and financial reporting. By processing source Excel files—including profit statements, detailed transaction ledgers, and existing templates—it automates the complex task of reconciling monthly or annual balances.
This skill ensures high technical accuracy by maintaining original spreadsheet formatting, borders, and Excel formulas while updating financial figures based on 11 strictly defined accounting rules. It is an essential utility for bookkeepers and financial analysts looking to reduce manual entry errors and speed up reporting cycles.
Balance Sheet Generator Use Cases
- Monthly and annual financial statement preparation.
- Automated reconciliation of bank accounts across multiple institutions like China Merchants Bank and Bank of Communications.
- Summarizing accounts receivable, prepayments, and accounts payable from raw transaction data.
- Real-time generation of balance sheets within an AI-driven workspace.
How Balance Sheet Generator Works
- The system reads a source Excel file containing three mandatory sheets: Balance Sheet, Detail Sheet, and Profit Statement.
- It preserves all existing document formatting, including merged cells, fonts, and column widths.
- It shifts previous cumulative totals to 'Last Month Balance' columns.
- It aggregates data from the Detail Sheet (Column M for bank names and Column A for balances) to update specific asset rows.
- It pulls operational profit figures from the Profit Statement into the current balance sheet.
- It re-calculates all cells containing Excel formulas to ensure the accounting equation remains balanced.
- A final standardized .xlsx file is generated in the workspace root.
Balance Sheet Generator Setup
To install and use this skill within your Openclaw environment, follow these steps:
# Navigate to the skills directory
cd ~/.openclaw/workspace/skills/balance_sheet_generator
# Run the generator via CLI
python3 scripts/generate_balance_sheet.py <path_to_source_excel> [output_path]
Alternatively, you can trigger the skill conversationally by uploading your file to the workspace and saying "Generate balance sheet".
Balance Sheet Generator Data Schema & Taxonomy
The skill expects a specific Excel structure to function correctly:
| Sheet Name | Required Columns | Description |
|---|---|---|
| Balance Sheet | B, C, D | Templates for Last Month, Current Month, and Cumulative totals. |
| Detail Sheet | A, C, H, M | Contains Balance, Category (AR/AP), Amount, and Bank Account names. |
| Profit Statement | B, E | Contains Operating Profit identifiers and corresponding values. |
Output File: balance_sheet.xlsx (Generated in the workspace root with 2-decimal precision).
Balance Sheet Generator Advanced Features
- Multi-bank aggregation: Automatically sums multiple entries for specific bank accounts found in the transaction detail.
- Formula Preservation: Intelligently keeps native Excel formulas (e.g.,
=D7-B7) intact while updating the underlying data. - Sequential Rule Execution: Implements a strict 11-step logic pipeline to ensure data dependency and integrity.
- Python API: Can be integrated into larger financial pipelines using the
BalanceSheetGeneratorclass.
SKILL.md
Loading
Related Openclaw Skills
Feishu Agent Config Helper
A specialized configuration assistant that streamlines the integration process between Feishu messaging robots and OpenClaw agents.
Cron Cost Guard
A specialized auditing tool designed to prevent silent token budget burns and model conflicts in AI agent cron configurations.
Journal Deep Intel Intelligence Station
A professional academic intelligence tool designed to automatically crawl and extract deep metadata from major scientific journals like Nature, Science, and Cell.
Juniper JunOS Device Health Check
A professional diagnostic skill for structured triage and health assessment of Juniper MX, SRX, EX, QFX, and PTX platforms.
JRJ News & Financial Report Search
A professional financial data skill providing real-time A-Share market news and brokerage research report summaries through authoritative sources.
QR Code Detection & Decoding
A high-performance API skill for detecting, decoding, and classifying QR codes and barcodes from images or URLs.
Featured*
