Regional finance and accounting standards skill covering Colombia (NIIF/DIAN/CTC), Ecuador (SRI/USD dollarization), Mexico (SAT/CFDI), United States (GAAP/ASC 606), Spain (AEAT/SII), and pan-Americas considerations. Use whenever the user mentions financial regulations, tax compliance, electronic invoicing, transfer pricing, CTC calculation, intercompany billing, multi-currency management, localization requirements, withholding taxes, or labor cost structures for IT services companies operating across these regions. Essential for SAP localization configuration and fit-to-standard financial workshops. Also trigger when discussing cost-vs-sale segregation, Activity Type cost rates, margin visibility, arm's length pricing, or any cross-border billing. Trigger: CTC calculation, transfer pricing, intercompany billing, tax compliance, e-invoicing, SAP localization, withholding taxes, Activity Type rates, margin visibility.
From pmnpx claudepluginhub javimontano/mao-pm-apexThis skill is limited to using the following tools:
evals/eval-result-1.mdevals/evals.jsonreferences/ctc-formulas-by-country.mdreferences/tax-and-invoicing-matrix.mdSearches, retrieves, and installs Agent Skills from prompts.chat registry using MCP tools like search_skills and get_skill. Activates for finding skills, browsing catalogs, or extending Claude.
Searches prompts.chat for AI prompt templates by keyword or category, retrieves by ID with variable handling, and improves prompts via AI. Use for discovering or enhancing prompts.
Provides SwiftUI patterns for @Observable state management, view composition, NavigationStack navigation, environment injection, and performance optimization in iOS/macOS apps.
"You cannot manage margin if cost and price live in the same number."
Provide financial regulatory guidance for IT services companies operating across Colombia, Ecuador, Mexico, United States, and Spain. Covers accounting standards (NIIF/IFRS, US GAAP), tax compliance, electronic invoicing, transfer pricing, CTC calculation, intercompany billing, and SAP localization.
This skill resolves the common IT services problem of blended rates — segregating CTC-based internal cost from client-facing sales price — enabling real margin visibility in SAP CO.
For detailed CTC formulas with worked examples per country:
references/ctc-formulas-by-country.mdFor tax systems, e-invoicing, withholding matrix, AT table:references/tax-and-invoicing-matrix.md
Full formulas, examples, hourly conversion:
references/ctc-formulas-by-country.md
Base Salary (monthly)
+ Mandatory Social Security (employer portion)
+ Mandatory Benefits (vacation, bonuses, profit sharing)
+ Voluntary Benefits (health insurance, retirement match)
+ Non-salary Allocations (tools, office, training)
= TOTAL CTC per month
Internal Cost Rate = Monthly CTC / Productive Hours
Productive Hours = Standard Hours - Vacations - Holidays - Sick - Training
| Country | Standard Hours/Mo | Typical Productive | Payroll Factor |
|---|---|---|---|
| Colombia | 192 (48h/wk) | 160-170 | ~49-55% |
| Ecuador | 160 (40h/wk) | 148-158 | ~32% |
| Mexico | 192 (48h/wk) | 155-165 | ~35-40% |
| US | 173 (40h/wk) | 155-165 | ~25-35% |
| Spain | 160 (40h/wk) | 140-152 | ~35-40% |
The payroll factor varies significantly because social security structure differs per country. Colombia's is highest due to combined health+pension+ARL+prestaciones. Ecuador is lowest because of simpler IESS structure.
IT services companies often use a single blended rate per resource that mixes internal cost with client price. This makes real margin invisible and creates key-person risk when only one person knows the cost formula.
Layer 1 — CTC Cost Rate: Calculate CTC per country → hourly rate. Load into SAP Manage Cost Rates by Activity Type and period.
Layer 2 — Sales Price: Client-negotiated rate, independent of CTC. Load into SAP Manage Sales Prices with pricing conditions by client, profile, seniority, currency.
Layer 3 — Automatic Margin: SAP CO-PA calculates Margin = Sales Price - Cost Rate per Activity Type per posting. No manual calculation needed.
Activity Types map skill levels to separate Cost Rate and Sales Price:
| Level | Description | Typical Margin Range |
|---|---|---|
| Architect | Architecture, cross-project design | 40-60% |
| Lead | Technical/management leadership | 35-55% |
| Senior | Autonomous execution, mentoring | 30-50% |
| Semi-Senior | Executes with minimal supervision | 30-45% |
| Junior | Developing, requires guidance | 25-40% |
Functional role (DevOps, QA, Frontend, etc.) is NOT an Activity Type dimension — it maps to employee qualifications in personnel master.
For specific rate ranges and full AT table:
references/tax-and-invoicing-matrix.md
Resource works for a domestic client. Billed by local entity. No intercompany. CTC from local formula.
1. Sending entity incurs CTC cost (local currency)
2. Sending invoices receiving: CTC x (1 + markup %) = IC Price
3. FX conversion at transaction date rate (IAS 21 / NIC 21)
4. Receiving entity records IC cost (local currency)
5. Receiving bills end client at Sales Price
6. Month-end: IC clearing, FX revaluation
7. TP documentation attached
Central services (HR, Finance, IT) allocated to all entities. Cost-Plus 5-8%. Allocation key: headcount or revenue.
IT staff provision (people under client direction)?
|-- YES: Market comparables available?
| |-- YES -> CUP (third-party rate cards)
| |-- NO -> Cost-Plus (CTC + 5-12% markup)
|-- NO: Shared services (HR, Finance, IT support)?
|-- YES -> Cost-Plus 5-8% (low value-added safe harbor, OECD Par. 7.45)
|-- NO: IP licensing or product development?
|-- YES -> TNMM or Profit Split (requires benchmark study)
|-- NO -> Consult tax advisor
When two entities transact cross-border, withholding applies in both directions depending on service type, jurisdiction, and applicable double taxation agreement. Always verify:
For specific withholding matrix:
references/tax-and-invoicing-matrix.md
File: XX_Analisis_Financiero_Regional_Deep.html