Finance Statements

v1.0.1

Track financial statements (bank, credit card, insurance, CanadaLife, etc.) in memory tracking files. Use when: (1) user provides a new statement (PDF text,...

0· 371·0 current·0 all-time
byWilliam@winlinvip
Security Scan
VirusTotalVirusTotal
Benign
View report →
OpenClawOpenClaw
Benign
high confidence
Purpose & Capability
The skill name/description describe tracking financial statements and the SKILL.md only asks to list/read/create/append files under memory/finance/, which is coherent. No unrelated credentials, binaries, or external endpoints are requested.
Instruction Scope
Instructions explicitly require scanning, reading, and appending files in memory/finance/, parsing user-provided statement text (including page-by-page append), and validating arithmetic. This stays within the declared scope but does result in persistent storage of highly sensitive financial content (file paths, transactions, balances). The skill also records the user's provided source filename/path which could reveal local metadata.
Install Mechanism
Instruction-only skill with no install spec and no code files — lowest-risk install footprint (nothing is downloaded or written by an installer).
Credentials
No environment variables or external credentials are requested. The only requested capability is RW access to memory/finance/ (declared). This is proportionate to the task but gives the skill the ability to persist sensitive PII/financial data.
Persistence & Privilege
The skill is not always-enabled and uses normal autonomous-invocation defaults. It will write persistent data to memory/finance/ (its declared scope). Because the agent can be invoked and then write/append sensitive statements, you should be aware it can modify your stored financial memory when run.
Assessment
This skill appears internally consistent, but it stores sensitive financial information in the agent's memory files at memory/finance/. Before installing: 1) Only install if you trust the skill source. 2) Confirm you are comfortable with the agent saving transaction-level financial data and filenames in memory/finance/. 3) Consider limiting access (use test data first), enabling confirmations before writes, or disabling autonomous invocation if you want manual review before any changes. 4) Ensure backups, audit/logging, or encryption of stored files if they contain real PII. 5) Review any created or modified files after the first run to verify formatting and that no unintended data was recorded. If you need network export or third-party integrations, verify those are explicit in the skill (this skill shows none).

Like a lobster shell, security has layers — review code before you run it.

latestvk97bnms9ha8r48s3t07w3y6xgd821t9y
371downloads
0stars
2versions
Updated 1mo ago
v1.0.1
MIT-0

Finance Statements

Track and record financial statement data into memory tracking files.

Workflow

Step 1: Identify the Target File

Scan memory/finance/ for files matching *statement* patterns:

ls memory/finance/*statement* 2>/dev/null

Always present the list and ask the user which file(s) to update, even if they mentioned a target. This ensures the right file is confirmed before writing.

Step 2: Load Target File & Accept New Statement

  1. Read the target file to understand its existing structure, format, and conventions
  2. Accept the new statement content from the user — this includes:
    • The source file path (e.g., PDF filename like MasterCard Statement-1234 2025-03-25.pdf)
    • The statement content (extracted PDF text, pasted content, etc.)
    • Record both the file path and content for reference
  3. Identify the statement period, card/account, and key figures from the new data

Page-by-Page Mode

When the user says they'll provide pages one by one (or specifies a target file upfront):

  1. After Step 1, read the target file to learn its structure
  2. For each page the user provides:
    • Parse the content immediately
    • Append the parsed transactions to the target file right away (don't wait for all pages)
    • Confirm what was recorded (e.g., "Page 1: recorded 15 transactions, running total $X")
  3. After the last page (user says "done", "last page", or "that's all"):
    • Run Step 4 (validate math) against the full statement
    • Update the period index table with the summary row

This avoids losing context across many pages and gives the user incremental progress.

Chinese Statements

When statement content is in Chinese:

  • Translate descriptions to English but keep the original Chinese in parentheses
    • Example: Amazon Shopping (亚马逊购物)
  • Translate column headers, summary fields, and notes to English
  • Currency amounts stay as-is (CNY ¥, etc.)
  • Date formats: convert to YYYY-MM-DD

Step 3: Record

  1. Match the format and conventions of the existing file exactly (table structure, headers, field names, date formats, description shortening style)
  2. Add a summary row to the period index table (if one exists)
  3. Add the detailed statement section with:
    • Period summary (previous balance, payments, purchases, interest, fees, new balance, rewards)
    • Transaction table with all line items
  4. Insert in chronological order, before any other card sections
  5. Shorten merchant descriptions to match existing style (e.g., "GOOGLE*YOUTUBE SUPER G.CO/HELPPAY#NS ..." → "Google YouTube Super")

Step 4: Validate the Math

After merging, independently verify the statement's arithmetic:

  1. Sum all transactions (positive = charges, negative = credits/payments)
  2. Check: Previous Balance + Purchases & Debits − Payments & Credits + Interest + Fees = New Balance
  3. Check: Transaction sum should equal (Purchases & Debits − Payments & Credits)
  4. Report to user:
    • ✅ "Statement math checks out" if totals match (within $0.02 rounding tolerance)
    • ⚠️ "Discrepancy found: calculated X, statement says Y" if they don't match — flag specific items if possible

Also verify:

  • Cash back / points calculations if data is available
  • Payment due dates and minimum payments are recorded
  • No duplicate transactions (same date + amount + description appearing twice unless genuinely separate)

File Naming Convention

Statement files live in memory/finance/ and follow this pattern:

{bank}-{holder}-{type}-{accountid}-statements.md
  • bank: Institution name (rbc, bmo, cibc, td, mbna, manulife, hsbc-hk, scb)
  • holder: Account holder — john, jane, or joint
  • type: Account type (chequing, saving, mc, visa)
  • accountid: Last digits or full account number

Examples:

  • rbc-john-mc-1234-statements.md
  • rbc-jane-saving-5678901-statements.md
  • td-joint-9876543-statements.md
  • bmo-jane-123456789-statements.md

When creating a new statement file, follow this convention.

Create New Statement File from Existing Template

When the user wants to create a new statement file for a different bank/account using an existing file as a structural template:

  1. Read the source file to extract its structure: section headings, subsection titles, table headers, summary field names, index table format
  2. Create the new file (following the naming convention) with:
    • All section headings and subsection titles preserved
    • All table headers and column structures preserved
    • No data copied — use placeholders or leave empty rows
    • Update bank name, account number, card number references to the new account
  3. Present the new file to the user for confirmation before they start adding statements

This ensures consistent formatting across all statement tracking files.

Notes

  • When a card has both primary and co-applicant transactions, keep them in separate sub-tables (matching existing format)
  • Preserve existing content — only append new periods, never modify historical data
  • If the statement period already exists in the file, warn the user before overwriting

Comments

Loading comments...