← Back to Skills Marketplace
daveglaser0823

Ach Volume Estimator

by Daveglaser0823 · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
102
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install ach-volume-estimator
Description
Estimate Dwolla's end-of-month ACH transaction volume from daily KPI emails. Use when processing ACH KPI emails, when Dave asks about monthly volume projecti...
README (SKILL.md)

ACH Monthly Volume Estimator

Workflow

  1. Fetch the ACH KPI email:

    gog gmail messages search "subject:ACH KPIs" --account [email protected] --max 1 --json

  2. Download the PDF attachment (contains all charts and data):

    # Get message details with attachment IDs
gog gmail get \x3CMESSAGE_ID> --account [email protected] --json
# Find the attachment named "ACH KPIs.pdf" (mimeType: application/pdf)
# Download it:
gog gmail attachment \x3CMESSAGE_ID> \x3CATTACHMENT_ID> --account [email protected] --out ~/clawd/work/ach-kpis-latest.pdf

  3. Extract data from the PDF. The PDF contains Tableau dashboard exports with:

    • ACH Transactions chart: MoM bar chart with monthly totals, per-BD averages, 5/20/60-day comparisons
    • Client Growth charts (10K and 5K thresholds)
    • Top 60 Clients tables (60-day and 20-day comparisons)

    Key numbers to extract:

    • Current month transaction total (partial, from MoM bar chart)
    • Business days elapsed (derive from date range in "Prev. 20 Days" row or count from month start to report date)
    • YTD avg transactions per business day
    • SPLY monthly total for comparison

  4. Run the estimator:

    python3 ~/clawd/skills/ach-volume-estimator/scripts/estimate.py \
  --transactions \x3CMTD_TOTAL> --bds-elapsed \x3CBDS_SO_FAR> [--month YYYY-MM]

    Or if you already have per-BD rate:

    python3 ~/clawd/skills/ach-volume-estimator/scripts/estimate.py \
  --per-bd \x3CRATE> [--month YYYY-MM]

    Add --json for structured output.

  5. Compare to benchmarks:

    • Jan 2026 actual: 6.12M (20 BDs, 305K/BD)
    • Dec 2025 actual: 6.41M (22 BDs, 291K/BD)
    • SPLY from the PDF MoM chart

  6. Generate the visual dashboard:

    ~/clawd/scripts/ach-dashboard-gen

    This reads ~/clawd/work/ach-reports/latest-ach-data.json (or falls back to the latest markdown report) and writes ~/clawd/work/ach-reports/dashboard.html. View at: http://192.168.1.60:3013/html/work/ach-reports/dashboard.html TV mode: http://192.168.1.60:3013/html/work/ach-reports/dashboard.html?tv=1

  7. Deliver: Include estimate in the ACH KPI summary sent to Dave. Include the dashboard URL.

Output Format

One-liner: 2026-02 estimate: 5.81M txns | (19 BDs, 12 elapsed, 7 remaining) | 306,000/BD | (3,672,000 so far)

Business Day Calendar

Script uses US Federal Reserve bank holiday calendar (2025-2027 hardcoded). Excludes weekends and all Fed holidays (New Year's, MLK, Presidents' Day, Memorial Day, Juneteenth, Independence Day, Labor Day, Columbus Day, Veterans Day, Thanksgiving, Christmas).

Integration

Wire into the existing "Daily ACH KPIs summary to Dave" cron (9:30 AM ET weekdays). After extracting email data, run the estimator and append the monthly projection to Dave's summary.

Usage Guidance
This skill appears to implement what its name says, but the SKILL.md and included scripts assume access to resources that are not declared in the manifest: a specific Gmail account (via a 'gog gmail' CLI), local files under ~/clawd (including revenue_calibration.json and the dashboard HTML), and a local dashboard service at 192.168.1.60. Before installing or enabling this skill: 1) verify you trust the skill author and inspect the provided scripts locally (they are included) to confirm there is no hidden exfiltration; 2) be aware you must already have a Gmail CLI configured (or provide credentials)—do not use your primary account; use a least-privileged account or service account; 3) ensure you understand where files will be read/written (~/clawd) and that calibration files may contain sensitive financial data; 4) because there is no install step declared, confirm how/where the scripts will be installed and that they run in a controlled environment (VM/container) if you are unsure; 5) if you plan to allow autonomous invocation, consider restricting it until you confirm the skill's behavior and necessary credentials. If any of the above is unexpected, treat the skill as not ready for production use.
Capability Analysis
Type: OpenClaw Skill Name: ach-volume-estimator Version: 1.0.0 The ach-volume-estimator skill bundle is a specialized financial forecasting tool designed to process ACH KPI emails and generate volume and revenue projections. The scripts (estimate.py, revenue_forecast.py) implement sophisticated statistical models, including seasonal decomposition and trend analysis, and fetch legitimate economic data from the Federal Reserve (FRED). While the workflow involves high-privilege actions like searching a specific Gmail account ([email protected]) and modifying a local dashboard (update_dashboard.py), these behaviors are transparently documented and strictly aligned with the stated business purpose. No indicators of malicious intent, such as data exfiltration or unauthorized remote execution, were found.
Capability Assessment
⚠ Purpose & Capability
Name/description describe an ACH volume estimator and the included Python forecasting/revenue scripts are consistent with that. However, the SKILL.md explicitly instructs use of a Gmail CLI against [email protected], reading/writing files under ~/clawd, and invoking a local dashboard generator and internal IP (192.168.1.60). The manifest declares no required env vars, binaries, or install steps; that is inconsistent with what the skill actually requires to run.
⚠ Instruction Scope
Runtime instructions tell the agent to fetch an email (specific account), download a PDF attachment, extract numbers, run local Python scripts, and publish to a local dashboard. These steps read and write files in the user's home (~/clawd/work, revenue_calibration.json), rely on an external Gmail CLI ('gog gmail') and a local dashboard service, and would require credentials/config already present. The instructions do not request or document those credentials or tools.
⚠ Install Mechanism
No install spec is provided (instruction-only), yet the package includes multiple Python scripts and the SKILL.md expects them to exist at specific paths (~/clawd/skills/ach-volume-estimator/scripts/ and ~/clawd/scripts/ach-dashboard-gen). This is an incoherence: either the skill must install those files or the instructions should not assume they are present. Lack of an install step means a user could be misled about how these files arrive on disk.
⚠ Credentials
The skill does not declare any required environment variables or credentials, but the workflow needs access to a Gmail account ([email protected]) via a CLI (implying OAuth tokens or local config), and reads/writes sensitive local files (~/clawd/work/*, revenue_calibration.json). It also references an internal IP dashboard. Requesting none of these in the manifest is disproportionate and obscures the actual privileges needed.
✓ Persistence & Privilege
The skill is not marked always:true and does not request system-wide configuration changes. It will run Python scripts and read/write files in the user's ~/clawd area, which is expected for this tool. Note: the skill can be invoked autonomously (platform default); combined with the undeclared credential/file access above, that increases risk and should be considered by the user.
How to Use
  1. Make sure OpenClaw is installed (local or Docker)
  2. Run the install command in chat: /install ach-volume-estimator
  3. After installation, invoke the skill by name or use /ach-volume-estimator
  4. Provide required inputs per the skill's parameter spec and get structured output
Version History
v1.0.0
- Initial release of the ACH volume estimator skill. - Estimates Dwolla’s monthly ACH transaction volume using metrics from daily KPI emails and PDF attachments. - Calculates per-business-day rates and projects end-of-month totals using US Federal Reserve holiday calendar. - Provides concise, one-line estimates and integrates with ACH KPI summary reports and dashboard generation workflow.
Metadata
Slug ach-volume-estimator
Version 1.0.0
License MIT-0
All-time Installs 0
Active Installs 0
Total Versions 1
Frequently Asked Questions

What is Ach Volume Estimator?

Estimate Dwolla's end-of-month ACH transaction volume from daily KPI emails. Use when processing ACH KPI emails, when Dave asks about monthly volume projecti... It is an AI Agent Skill for Claude Code / OpenClaw, with 102 downloads so far.

How do I install Ach Volume Estimator?

Run "/install ach-volume-estimator" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.

Is Ach Volume Estimator free?

Yes, Ach Volume Estimator is completely free, licensed under MIT-0. You can download, install and use it at no cost.

Which platforms does Ach Volume Estimator support?

Ach Volume Estimator is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).

Who created Ach Volume Estimator?

It is built and maintained by Daveglaser0823 (@daveglaser0823); the current version is v1.0.0.

More Skills
self-improving agent
Captures learnings, errors, and corrections to enable continuous improvement. Use when: (1) A command or operation fails unexpectedly, (2) User corrects Clau...
⬇ 463556 · by pskoett
Skill Vetter
Security-first skill vetting for AI agents. Use before installing any skill from ClawdHub, GitHub, or other sources. Checks for red flags, permission scope, and suspicious patterns.
⬇ 259610 · by spclaudehome
Polymarket
Query Polymarket prediction markets. Check odds, find trending markets, search events, track price movements.
⬇ 232503 · by joelchance
Self-Improving + Proactive Agent
Self-reflection + Self-criticism + Self-learning + Self-organizing memory. Agent evaluates its own work, catches mistakes, and improves permanently. Use when...
⬇ 200551 · by ivangdavila
Github
Interact with GitHub using the `gh` CLI. Use `gh issue`, `gh pr`, `gh run`, and `gh api` for issues, PRs, CI runs, and advanced queries.
⬇ 191226 · by steipete
ontology
Typed knowledge graph for structured agent memory and composable skills. Use when creating/querying entities (Person, Project, Task, Event, Document), linkin...
⬇ 190235 · by oswalpalash

💬 Comments