financeiro-ops

Organizes accounts payable, receivable, and cash flow tracking with masked financial data handling.

5|15|Updated Jul 8, 2026

Search Tags:#spreadsheet #cash flow #csv #reconciliation #collections #accounts receivable #financeiro

Ready to run

npx skills add https://github.com/clfigueiredo/hermes-infra-skills --skill financeiro-ops-clfigueiredo

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: financeiro-ops
Source: https://github.com/clfigueiredo/hermes-infra-skills/tree/main/.hermes/skills/forumtelecom/financeiro-ops
Command: npx skills add https://github.com/clfigueiredo/hermes-infra-skills --skill financeiro-ops-clfigueiredo

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas.

What problem does it solve? Managing day-to-day financial administration—tracking due dates, reconciling payments, drafting collection messages, and summarizing cash flow—is repetitive and error-prone when done manually across spreadsheets, ERPs, and bank exports. ## Core Features & Use Cases - Accounts Payable/Receivable Tracking: Normalize and classify open, overdue, paid, and negotiated entries with standardized dates and BRL values. - Reconciliation & Reporting: Validate CSV/OFX exports, deduplicate entries, and generate summaries by client, supplier, category, or period. - Safe Collection Drafts: Produce masked, human-reviewed collection message drafts and schedule payment reminders without exposing sensitive data. - Use Case: Export your ERP's receivables CSV, ask for a weekly overdue summary, and get a validated report with totals by status plus draft follow-up messages for each client. ## Quick Start Ask the assistant to list this week's due and overdue receivables from your exported financeiro.csv and draft a collection reminder for the largest overdue client.

Frequently Asked Questions about financeiro-ops

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I track accounts receivable and overdue payments in a spreadsheet?▼

Use a minimal schema of client, document, due date, amount, status, payment method, and notes, with statuses like open, overdue, paid, partial, or cancelled. Normalize dates to YYYY-MM-DD and values to decimal BRL before grouping totals by status or client.

How to reconcile a bank CSV or OFX export with pandas?▼

Load the file with pandas, normalize dates and amounts, then group by status or category to validate row counts and sums. Deduplicate entries using a composite key of client or supplier, document, due date, and value.

Can this skill send collection messages or make payments automatically?▼

No. It only drafts collection messages for human review and confirmation before any external send, and it never executes payments. Actual payment always requires human action in the bank or ERP system.

How is sensitive financial data protected when generating reports?▼

Identifiers such as CPF, CNPJ, bank details, PIX keys, and barcodes are masked to partial forms like ***1234 before appearing in any output. Full documents, statements, and credentials are never published to group chats or reports.

Why do financial totals come out wrong when summing spreadsheet values?▼

Totals fail when values like R$ 1.234,56 are treated as text instead of numbers. Normalize Brazilian currency strings to decimal format before summing, and confirm whether the user wants accrual (competência) or due-date (vencimento) views.