An automated financial analysis tool that performs period-over-period variance checks on Statement of Cash Flows data pulled from QuickBooks Online.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install scf-quick-compare
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 scf-quick-compare 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 SCF Quick Compare?
The SCF Quick Compare skill is a specialized financial reporting tool designed for Openclaw Skills users who need deep visibility into cash movements. It automates the extraction of Statement of Cash Flows (SCF) data directly from QuickBooks Online (QBO) and performs a rigorous period-over-period variance analysis across Operating, Investing, and Financing activities.
By mirroring professional accounting workflows, this skill generates a comprehensive 4-tab Excel workbook that includes high-level summaries, granular line-item details, and automated flags for material variances. It ensures data integrity through built-in balance validation, ensuring that net change and ending cash balances align perfectly with the source data.
SCF Quick Compare Use Cases
- Monthly close reviews where a MoM or YTD cash flow variance analysis is required.
- Investigating significant shifts in cash position to answer client queries regarding cash swings.
- Identifying drivers behind changes in operating liquidity, capital expenditures, or financing activities.
- Detecting mid-month adjustments in QuickBooks Online using the built-in Change Data Capture (CDC) log.
How SCF Quick Compare Works
- The skill connects to the QuickBooks Online API using the configured company slug and credentials.
- It extracts the Statement of Cash Flows data for both the current and prior periods (or YTD ranges).
- A classification engine parses every row, assigning items to Operating, Investing, or Financing sections based on keyword matching.
- Variance logic is applied where positive deltas are flagged as Favorable, indicating increased cash generation or retention.
- The tool performs dual-balance validation ($1 tolerance) to ensure the integrity of the cash flow segments and the final cash balance.
- A 4-tab Excel workbook is generated, containing a Summary, Detail, Flags for material variances, and a CDC Log for auditability.
SCF Quick Compare Setup
To use this tool within the Openclaw Skills framework, ensure you have the necessary dependencies and QBO access.
# Install the required Excel handling library
pip install openpyxl
# Ensure you have a valid Node.js QBO client with an auth token.
# Run the comparison for the current month vs. prior month
python3 scripts/pipelines/scf-quick-compare.py \
--slug your-company-slug \
--current-start 2026-03-01 --current-end 2026-03-31
SCF Quick Compare Data Schema & Taxonomy
The skill organizes financial data into a structured Excel output with the following taxonomy:
| Tab | Content | Key Data Points |
|---|---|---|
| Summary | Executive Overview | Operating/Investing/Financing totals, Net Change, Balance Validation. |
| Detail | Line-item Breakdown | Hierarchy preservation, section color-coding, and YoY/MoM % variance. |
| Flags | Materiality Analysis | Items with ≥10% change or ≥$2,500 absolute variance with analysis notes. |
| CDC Log | Change Audit | Delta comparison against the last cached run stored in .cache/scf-quick-compare/. |
SCF Quick Compare Advanced Features
- Change Data Capture (CDC) caching to track line-item modifications between report runs.
- Smart Analysis Notes that provide plain-English interpretations for AR buildup, CapEx alerts, and debt activity.
- Support for YTD (Year-to-Date) vs. Prior YTD comparison modes.
- High-precision financial calculations using Python Decimal with ROUND_HALF_UP to eliminate floating-point errors.
- Sandbox environment support for testing report outputs without affecting production data.
SKILL.md
Loading
Related Openclaw Skills
Media.io Image To Cartoon Generator
An AI-powered skill that converts real-world photos into high-quality cartoon-style illustrations via the Media.io OpenAPI.
TypeScript SDK: Wallet Adapter (React)
A comprehensive guide for integrating secure, browser-based wallet connections and transaction signing into React applications on the Aptos network.
Chinese Sensitive Word Detection
A comprehensive Chinese content compliance checker that scans for sensitive, restricted, and high-risk terms across major social media platforms.
Locksmith Service
A comprehensive locksmith coordination skill providing emergency unlocking, smart lock upgrades, and police-registered security services.
Lizhi FM Hot Trend Analysis
An AI-powered skill for retrieving and analyzing public performance metrics and trending data from the Lizhi FM podcast platform.
HFT Paper Trader
An autonomous high-frequency paper trading framework designed for crypto backtesting and strategy refinement using multi-indicator TA scoring.
Featured*
