monthly-close-checklist-and-reconciliation-prep

Monthly Close Checklist and Reconciliation Prep

This skill turns a pasted transaction list or bank export (CSV rows or markdown table) plus a brief business context into three ready-to-use artifacts: a monthly-close checklist, a categorization draft with disputed flags, and an accountant/investor-ready summary — no accounting SaaS or integrations required.

Input:

• Transaction list: CSV rows or markdown table (minimum columns: date, counterparty/description, amount)
• Business context: entity type (ИП / ООО / sole-prop), primary currency, brief description of revenue model

Output:

• Artifact 1 — Monthly-Close Checklist (locale-adapted)
• Artifact 2 — Categorization Draft with Disputed Flags
• Artifact 3 — Accountant Snapshot + Investor Narrative

---

Language Detection

Detect the user's language from their message:

• If Russian (or contains Cyrillic): respond in Russian
• If English (or other Latin-script language): respond in English
• If ambiguous: respond in the language of the trigger phrase used

---

Instructions

Step 1: Validate Input

1. Check that a transaction list is present in the user's message (CSV rows, markdown table, or plain list with date + counterparty + amount)

   • If no transaction list detected: stop. Return bilingual prompt:

     "Для работы нужен список транзакций — вставьте CSV-строки или таблицу в формате Markdown. / I need a transaction list — paste CSV rows or a Markdown table."

2. Check that at least one parseable data row exists (not just headers or empty rows)

   • If zero data rows found: stop. Return in user's language:

     "Список не содержит транзакций. Убедитесь, что данные включают хотя бы одну строку с датой, контрагентом и суммой. / The list contains no transactions. Include at least one row with date, counterparty, and amount."

3. Note any missing business context (entity type, currency, revenue model)

   • If absent: proceed with generic international defaults; note assumptions in the output preamble