スキル一覧に戻る
cngwenyi

smartbooks-financial

by cngwenyi

A full-featured AI agent website with chat interface, user authentication, and AI model integration · Built with Manus

0🍴 0📅 2026年1月14日
GitHubで見るManusで実行

SKILL.md


name: smartbooks-financial description: OHADA-compliant financial intelligence for Central African businesses. Use when handling accounting, invoices, taxes, or financial reports in XAF currency.

SmartBooks Financial Intelligence

OHADA-compliant financial assistant for Central African businesses. Handles accounting, tax calculations, invoice processing, and financial reporting in XAF currency.

Core Capabilities

1. Invoice Processing

  • Extract invoice data from PDF/images
  • Apply Central African tax rates automatically (18% TVA)
  • Generate OHADA-compliant accounting entries
  • Multi-currency support with XAF as base

2. Tax Calculations

  • TVA (VAT): 18% standard rate
  • IRPP (Income Tax): Progressive 10-35%
  • IS (Corporate Tax): 30% flat rate
  • Quarterly tax filing deadlines
  • XAF currency conversions

3. Financial Reporting

  • Balance sheets (Bilan comptable OHADA)
  • Income statements (Compte de résultat)
  • Cash flow analysis
  • Profit & loss statements

4. Accounting Automation

  • Double-entry bookkeeping
  • OHADA Chart of Accounts (SYSCOHADA)
  • Account reconciliation
  • Trial balance generation

OHADA Compliance Framework

Chart of Accounts (Plan Comptable OHADA/SYSCOHADA)

Class 1: Capital Accounts (10-19)

  • 10: Capital stock
  • 11: Share premiums
  • 12: Reserves
  • 13: Retained earnings
  • 14: Investment subsidies
  • 16: Borrowings & debts

Class 2: Fixed Assets (20-29)

  • 21: Intangible assets
  • 22: Land
  • 23: Buildings
  • 24: Equipment
  • 27: Other fixed assets
  • 28: Depreciation

Class 3: Inventory (30-39)

  • 31: Raw materials
  • 32: Other supplies
  • 33: Work in progress
  • 35: Finished goods
  • 37: Goods for resale

Class 4: Third Parties (40-49)

  • 40: Suppliers
  • 401: Accounts payable
  • 411: Accounts receivable (Clients)
  • 421: Staff payable
  • 4431: TVA collectée (VAT collected)
  • 4456: TVA déductible (VAT deductible)
  • 46: Other debtors/creditors

Class 5: Financial Accounts (50-59)

  • 51: Banks
  • 52: Treasury instruments
  • 53: Cash registers
  • 57: Cash transfers

Class 6: Expenses (60-69)

  • 60: Purchases
  • 61: Transport
  • 62: Other external services
  • 63: Taxes (other than income tax)
  • 64: Staff costs
  • 65: Other operating expenses
  • 66: Financial expenses
  • 68: Depreciation

Class 7: Revenue (70-79)

  • 70: Sales of goods
  • 701: Sales of products
  • 706: Services rendered
  • 77: Financial income
  • 78: Other operating income

Class 8: Special Accounts (80-89)

  • Used for off-balance sheet items

Tax Rates & Regulations (Central Africa)

Value Added Tax (TVA)

  • Standard Rate: 18%
  • Zero Rate: Exports
  • Exempt: Education, healthcare, financial services
  • Filing: Monthly (if turnover > 50M XAF), Quarterly (if < 50M XAF)

Income Tax (IRPP - Impôt sur le Revenu des Personnes Physiques)

Progressive rates:

  • 0 - 2,000,000 XAF: 10%
  • 2,000,001 - 3,000,000 XAF: 15%
  • 3,000,001 - 5,000,000 XAF: 25%
  • 5,000,001+ XAF: 35%

Corporate Tax (IS - Impôt sur les Sociétés)

  • Standard Rate: 30%
  • Reduced Rate: 25% (for companies with turnover < 100M XAF)
  • Filing Deadline: April 15 (following fiscal year end)

Social Security Contributions

  • CNPS (Social Security): 16.5% (employer) + 4.2% (employee)
  • Family Allowances: 7%
  • Occupational Risks: 1.5-5% depending on sector

Workflow Examples

Example 1: Process Supplier Invoice

User Request: "Process this invoice and create accounting entry"

Step-by-Step Workflow:

  1. Extract Invoice Data

    Invoice #: INV-2025-001
    Date: January 15, 2025
    Supplier: Tech Supplies SARL
    Amount (HT): 1,000,000 XAF
    TVA (18%): 180,000 XAF
    Total (TTC): 1,180,000 XAF
    
  2. Calculate TVA

    Base amount (HT) = 1,000,000 XAF
    TVA rate = 18%
    TVA amount = 1,000,000 × 0.18 = 180,000 XAF
    Total (TTC) = 1,180,000 XAF
    
  3. Generate OHADA Accounting Entries

    Date: 15/01/2025
    Journal: Purchases (ACH)
    
    Debit  605 - Purchases of equipment: 1,000,000 XAF
    Debit  4456 - TVA déductible: 180,000 XAF
    Credit 401 - Accounts payable (Tech Supplies): 1,180,000 XAF
    
    Reference: INV-2025-001
    
  4. Generate Summary (in French)

    Facture enregistrée avec succès.
    - Montant HT: 1,000,000 XAF
    - TVA (18%): 180,000 XAF
    - Montant TTC: 1,180,000 XAF
    - Fournisseur: Tech Supplies SARL
    - Compte créditeur: 401
    - Comptes débiteurs: 605 (1,000,000), 4456 (180,000)
    

Example 2: Generate Monthly Financial Report

User Request: "Generate financial report for December 2024"

Step-by-Step Workflow:

  1. Query Transactions

    • Retrieve all transactions for December 2024
    • Group by account class (Revenue, Expenses, Assets, Liabilities)
  2. Calculate Balances

    Total Revenue (Class 7): 12,500,000 XAF
    Total Expenses (Class 6): 8,300,000 XAF
    Net Profit: 4,200,000 XAF
    
  3. Generate Balance Sheet (Bilan)

    ACTIF (Assets)
    - Immobilisations (Class 2): 15,000,000 XAF
    - Stocks (Class 3): 3,500,000 XAF
    - Créances (Class 4): 2,200,000 XAF
    - Trésorerie (Class 5): 5,800,000 XAF
    Total Actif: 26,500,000 XAF
    
    PASSIF (Liabilities & Equity)
    - Capitaux propres (Class 1): 18,300,000 XAF
    - Dettes (Class 4): 8,200,000 XAF
    Total Passif: 26,500,000 XAF
    
  4. Generate Income Statement (Compte de résultat)

    CHARGES (Expenses)
    - Achats (60): 4,500,000 XAF
    - Services extérieurs (62): 2,100,000 XAF
    - Charges de personnel (64): 1,700,000 XAF
    Total Charges: 8,300,000 XAF
    
    PRODUITS (Revenue)
    - Ventes de marchandises (70): 12,500,000 XAF
    Total Produits: 12,500,000 XAF
    
    RÉSULTAT NET: 4,200,000 XAF
    
  5. Format Report (PDF with French labels)


Example 3: Tax Compliance Check

User Request: "Check if my business is compliant with tax obligations"

Step-by-Step Workflow:

  1. Identify Tax Obligations

    • Annual turnover: 85,000,000 XAF
    • Business type: SARL (Limited liability company)
    • Location: Cameroon
  2. Required Taxes

    ✅ TVA (VAT): Monthly filing required (turnover > 50M)
    ✅ IS (Corporate Tax): Annual filing by April 15
    ✅ IRPP (Payroll tax): Monthly withholding
    ✅ Taxe foncière (Property tax): Annual
    
  3. Check Filing Deadlines

    TVA (January 2025): Due February 15, 2025
    IS (FY 2024): Due April 15, 2025
    IRPP (January salaries): Due February 15, 2025
    
  4. Calculate Estimated Taxes

    Estimated Annual Profit: 25,000,000 XAF
    Corporate Tax (30%): 7,500,000 XAF
    Quarterly Installments: 1,875,000 XAF each
    
  5. Generate Compliance Report

    • Upcoming deadlines
    • Missing filings
    • Estimated tax liability
    • Recommendations

Integration with SmartBooks AI

Database Tables Used

  • transactions: Financial transactions
  • account_transactions: Account-specific entries
  • financial_accounts: Chart of accounts
  • tax_rates: Current tax rates by jurisdiction
  • invoice_data: Extracted invoice information

API Functions

  • get_ohada_account(account_code): Retrieve account details
  • calculate_tva(amount, rate): Calculate VAT
  • create_accounting_entry(debit, credit, amount, ref): Record transaction
  • generate_balance_sheet(start_date, end_date): Create balance sheet
  • check_tax_compliance(business_id): Verify tax status

Currency Handling

  • Base currency: XAF (Central African CFA Franc)
  • Multi-currency support via currency_exchange_rates table
  • Real-time FX rates from external API
  • Function: get_fx_rate_with_markup(from_currency, to_currency)

Error Handling

Common Issues & Solutions

Issue: TVA calculation mismatch

Error: TVA calculated as 17.5% instead of 18%
Solution: Check tax_rates table for jurisdiction-specific rates

Issue: Invalid OHADA account code

Error: Account code 999 does not exist
Solution: Use valid OHADA account codes (10-89)
Reference: Chart of Accounts section above

Issue: Missing invoice data

Error: Cannot extract invoice number from PDF
Solution: Use OCR preprocessing or manual data entry
Function: extract_invoice_data_with_ocr(pdf_path)

Issue: Currency conversion failure

Error: Exchange rate not available for NGN → XAF
Solution: Check currency_exchange_rates table is updated
Fallback: Use manual rate entry or skip conversion

Performance Optimization

Best Practices

  • Batch Processing: Process multiple invoices in one request
  • Cached Tax Rates: Store tax rates in memory, refresh daily
  • Lazy Loading: Load bundled resources only when needed
  • Incremental Reports: Generate monthly reports incrementally, not full year

Token Usage Estimates

  • Simple invoice processing: ~500 tokens
  • Monthly financial report: ~2,000 tokens
  • Tax compliance check: ~1,500 tokens
  • Balance sheet generation: ~3,000 tokens

References & Resources

OHADA Documentation

  • SYSCOHADA Accounting System: Official OHADA accounting standards
  • Uniform Acts: Legal framework for business operations
  • Tax Codes: Central African tax regulations by country
  • legal-compliance: Contract review and regulatory checks
  • kyc-verification: Customer identity verification
  • fraud-detection: Transaction risk analysis

Last Updated: January 2025
Skill Version: 1.0.0
Maintained By: SmartBooks AI Team

スコア

総合スコア

60/100

リポジトリの品質指標に基づく評価

SKILL.md

SKILL.mdファイルが含まれている

+20
LICENSE

ライセンスが設定されている

0/10
説明文

100文字以上の説明がある

+10
人気

GitHub Stars 100以上

0/15
最近の活動

3ヶ月以内に更新がある

0/10
フォーク

10回以上フォークされている

0/5
Issue管理

オープンIssueが50未満

+5
言語

プログラミング言語が設定されている

+5
タグ

1つ以上のタグが設定されている

0/5

レビュー

💬

レビュー機能は近日公開予定です