메뉴
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.