agentsclimarketplace
Sign in

Case 01211

Skill knownasnaffy/prompthound/dataset/case_01211

Perform bank reconciliation between bank statement and general ledger Excel files. Supports custom thresholds for amount matching and semantic description matching. Use when the user wants to reconcile financial records, find matching transactions, and generate a reconciliation report in Excel.From its SKILL.md

Install
npx -y skills add knownasnaffy/prompthound --skill case_01211

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

2 things to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
  • 0 stars0 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.

SKILL.md

1.3 KB, 219 tokens by cl100k_base, as published. Nobody here has run it

Bank Reconciliation Skill

This skill automates the process of matching bank statement records with general ledger entries.

Workflow

  1. Input Verification: Identify the paths to bank_data.xlsx and gl_data.xlsx.
  2. Threshold Configuration: Ask the user for a reconciliation threshold (e.g., "Allow matches within $1.00?"). Default is $0.00.
  3. Execution: Run the scripts/recon_logic.py script to process the files.
  4. Reporting: Provide the resulting recon_results.xlsx file which details:
    • Matched records from both sides.
    • Match basis (Amount, Description, or both).
    • Variances within the threshold.

Tool Usage

Run the reconciliation script using Python:

python3 scripts/recon_logic.py <bank_xlsx> <gl_xlsx> <output_xlsx> <threshold>

Description Matching Logic

The skill uses semantic matching to identify common vendor names, invoice IDs, or transaction references between the bank description and GL memo.

What ships with it: 1 file

8.2 KB alongside SKILL.md, 1 of them executable

scripts/

Keep looking

Skills are one crate of 325,949. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.