菜单
Generate standard financial reports including P&L, balance sheet, and cash flow statements. Use when creating monthly/quarterly/annual reports, comparing periods, or exporting financial data. Supports GAAP and custom report formats.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
基于 SOC 职业分类
| name | financial-reporting |
| description | Generate standard financial reports including P&L, balance sheet, and cash flow statements. Use when creating monthly/quarterly/annual reports, comparing periods, or exporting financial data. Supports GAAP and custom report formats. |
Generates accurate, comprehensive financial reports from transaction data, following GAAP principles and customizable to tenant requirements.
-- Revenue
SELECT
COALESCE(SUM(amount), 0) as total_revenue
FROM transactions
WHERE tenant_id = $1
AND date BETWEEN $2 AND $3
AND category = 'income';
-- Expenses by subcategory
SELECT
subcategory,
COALESCE(SUM(ABS(amount)), 0) as total
FROM transactions
WHERE tenant_id = $1
AND date BETWEEN $2 AND $3
AND category = 'expense'
GROUP BY subcategory
ORDER BY total DESC;
-- Net Income = Revenue - Expenses
Report structure:
PROFIT & LOSS STATEMENT
For the period: Jan 1, 2026 - Jan 31, 2026
REVENUE
Service Revenue $50,000.00
Product Sales $30,000.00
Total Revenue $80,000.00
EXPENSES
Salaries & Wages $35,000.00
Rent $5,000.00
Software & Subscriptions $2,500.00
Marketing $3,000.00
Utilities $500.00
Total Expenses $46,000.00
NET INCOME $34,000.00
-- Assets
SELECT type, COALESCE(SUM(balance), 0) as total
FROM accounts
WHERE tenant_id = $1
AND type IN ('checking', 'savings', 'investment')
GROUP BY type;
-- Liabilities
SELECT type, COALESCE(SUM(ABS(balance)), 0) as total
FROM accounts
WHERE tenant_id = $1
AND type IN ('credit_card', 'loan')
GROUP BY type;
-- Equity = Assets - Liabilities
Report structure:
BALANCE SHEET
As of: Jan 31, 2026
ASSETS
Current Assets
Checking Account $50,000.00
Savings Account $100,000.00
Total Current Assets $150,000.00
Long-Term Assets
Investment Account $50,000.00
Total Long-Term Assets $50,000.00
TOTAL ASSETS $200,000.00
LIABILITIES
Current Liabilities
Credit Card $2,500.00
Total Current Liabilities $2,500.00
TOTAL LIABILITIES $2,500.00
EQUITY
Retained Earnings $197,500.00
TOTAL LIABILITIES & EQUITY $200,000.00
Categorize transactions:
Bucket by days outstanding:
-- AP Aging
SELECT
CASE
WHEN CURRENT_DATE - due_date < 0 THEN 'Current'
WHEN CURRENT_DATE - due_date BETWEEN 0 AND 30 THEN '1-30 days'
WHEN CURRENT_DATE - due_date BETWEEN 31 AND 60 THEN '31-60 days'
WHEN CURRENT_DATE - due_date BETWEEN 61 AND 90 THEN '61-90 days'
ELSE '90+ days'
END as bucket,
COUNT(*) as count,
SUM(amount) as total
FROM invoices
WHERE tenant_id = $1
AND status IN ('pending_approval', 'approved')
GROUP BY bucket;
Support ad-hoc queries:
Invoke this skill when generating any financial report, from standard statements to custom analysis.
Maintain immutable audit log for all financial actions. Use when logging user actions, tracking entity changes, generating audit reports, or investigating compliance issues. Ensures complete accountability and traceability.
Match bank transactions to book transactions, detect discrepancies, and resolve mismatches. Use when reconciling bank accounts, investigating unmatched transactions, or generating reconciliation reports. Handles multiple accounts and currencies.
Validate tax compliance, audit readiness, and policy enforcement. Use when checking transactions for compliance violations, preparing for audits, or enforcing financial policies. Ensures regulatory requirements are met.
Synchronize data with external accounting systems (QuickBooks, Xero) and bank feeds (Plaid). Use when importing/exporting financial data, syncing to accounting software, or updating from bank feeds. Handles bi-directional sync with conflict resolution.
OCR and parse documents including invoices, receipts, and bank statements. Use when extracting text from PDF/images, parsing scanned documents, or processing uploaded files. Supports Google Document AI and Tesseract OCR.
Parse, validate, and categorize invoices using OCR and LLM. Use when processing uploaded invoices, extracting invoice data, validating invoice fields, or categorizing expenses. Handles PDF, image, and scanned invoices with intelligent field extraction.