Monitoring & Year-End True-Up
Test whether the policy was implemented correctly and whether a year-end adjustment is actually supportable.
For external testing with synthetic inputs only. Do not enter confidential data. Verify outputs independently.
Required inputs (used externally only)
- trial balance
- general ledger
- management accounts
- statutory accounts
- transaction-level data
- intercompany invoices
- allocation schedules
- benchmark study
- transfer pricing policy
- budgets
- forecasts
- prior-year calculations
- proposed adjustment entries
Expected deliverables
- Data-quality findings
- Account-mapping schedule
- Reconciliation to the accounts
- Tested result calculation
- Variance bridge
- Adjustment scenarios
- Root-cause analysis
- Recommended treatment
- Journal and invoicing instructions
- Required approvals
- Evidence trail supporting the recommendation
- Matters requiring local-country confirmation
Prompt
For external testing with synthetic inputs only. Do not enter confidential data. Verify outputs independently.
- Role
- Inputs
- Variables
- Task
- Output
- Comment
- Prompt text
Act as the in-house transfer pricing lead responsible for reviewing the results of [ENTITY] for [PERIOD].The documented policy is [INSERT POLICY]. The stated target or range is [INSERT].Determine whether the policy has been implemented correctly and whether a year-end adjustment is technically and operationally supportable.Do not assume that an adjustment is required merely because the result falls outside the target or benchmark range.MATERIAL PROVIDEDI may provide:- trial balance;- general ledger;- management accounts;- statutory accounts;- transaction-level data;- intercompany invoices;- allocation schedules;- benchmark study;- transfer pricing policy;- budgets;- forecasts;- prior-year calculations;- proposed adjustment entries.CALCULATION CONTROLS1. State every formula.2. For every input identify:- source;- entity;- accounting period;- currency;- account or data field;- any transformation applied.3. State:- exchange-rate source and date;- sign convention;- rounding convention;- treatment of credits and reversals.4. Do not:- insert zero for a missing value;- use a prior-year value without instruction;- estimate an input without permission;- invent an allocation;- invent a benchmark result;- hide an unreconciled difference.5. If a required input is missing, state:CALCULATION BLOCKED: MISSING INPUTThen identify the precise missing input and continue with any analysis that remains possible.6. Do not exclude a cost solely because it is exceptional, unusual, non-recurring or reduces the desired result.7. Do not recommend the median by default.WORK REQUIREDA. DATA RECONCILIATIONReconcile:- transaction-level data;- invoices;- management accounts;- trial balance;- statutory accounts;- tax computation where provided.Identify:- duplicated accounts;- omitted accounts;- incorrect account mapping;- prior-period entries;- manual adjustments;- foreign-exchange differences;- consolidation entries;- unexplained variances.B. TESTED RESULTDefine and calculate:- numerator;- denominator;- profit level indicator;- tested period;- segmentation basis.Analyse the treatment of:- pass-through costs;- shareholder costs;- stock-based compensation;- foreign exchange;- provisions;- impairments;- restructuring costs;- litigation costs;- exceptional items;- non-operating income and expenditure.C. VARIANCE BRIDGEQuantify separately where data permits:- volume;- sales price;- purchase price;- product mix;- customer mix;- capacity utilisation;- productivity;- foreign exchange;- market conditions;- inventory;- bad debts;- exceptional events;- accounting treatment;- transfer pricing implementation.D. ADJUSTMENT ANALYSISCalculate the adjustment required to reach:- lower quartile;- median;- upper quartile;- documented policy target.For each scenario determine:- whether it is consistent with the policy;- whether the benchmark remains reliable;- whether the outcome reflects the materialisation of economically significant risk;- whether the counterparty jurisdiction is expected to recognise the adjustment;- whether the adjustment changes the transaction rather than implementing it.E. SECONDARY CONSEQUENCESFlag potential consequences for:- corporation tax;- deductibility;- withholding tax;- VAT;- customs;- foreign exchange;- statutory accounting;- distributable reserves;- Pillar Two;- corresponding adjustments;- MAP.OUTPUTProduce:1. Data-quality findings.2. Account-mapping schedule.3. Reconciliation to the accounts.4. Tested result calculation.5. Variance bridge.6. Adjustment scenarios.7. Root-cause analysis.8. Recommended treatment.9. Journal and invoicing instructions.10. Required approvals.11. Evidence trail supporting the recommendation.12. Matters requiring local-country confirmation.Do not provide a final recommendation if the tested result does not reconcile.Status: DRAFT — NOT FOR POSTING UNTIL FINANCE, TAX AND LOCAL-COUNTRY REVIEW.
Professional implementation guide
- Choose
- Copy
- Contextualise
- Challenge
- Verify
Limitations
DRAFT — NOT FOR POSTING UNTIL FINANCE, TAX AND LOCAL-COUNTRY REVIEW.
Version, origin and review
- Current version
- Version 1
- Origin
- AI-assisted
- Technical review status
- Not technically reviewed
- Published
- 17 Nov 2026
Contributors retain lawful intellectual property. Editorial review is not technical validation, and no prompt is certified.
Sources
No public source references supplied.