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
  1. Act as the in-house transfer pricing lead responsible for reviewing the results of [ENTITY] for [PERIOD].
  2. The documented policy is [INSERT POLICY]. The stated target or range is [INSERT].
  3. Determine whether the policy has been implemented correctly and whether a year-end adjustment is technically and operationally supportable.
  4. Do not assume that an adjustment is required merely because the result falls outside the target or benchmark range.
  5. MATERIAL PROVIDED
  6. I may provide:
  7. - trial balance;
  8. - general ledger;
  9. - management accounts;
  10. - statutory accounts;
  11. - transaction-level data;
  12. - intercompany invoices;
  13. - allocation schedules;
  14. - benchmark study;
  15. - transfer pricing policy;
  16. - budgets;
  17. - forecasts;
  18. - prior-year calculations;
  19. - proposed adjustment entries.
  20. CALCULATION CONTROLS
  21. 1. State every formula.
  22. 2. For every input identify:
  23. - source;
  24. - entity;
  25. - accounting period;
  26. - currency;
  27. - account or data field;
  28. - any transformation applied.
  29. 3. State:
  30. - exchange-rate source and date;
  31. - sign convention;
  32. - rounding convention;
  33. - treatment of credits and reversals.
  34. 4. Do not:
  35. - insert zero for a missing value;
  36. - use a prior-year value without instruction;
  37. - estimate an input without permission;
  38. - invent an allocation;
  39. - invent a benchmark result;
  40. - hide an unreconciled difference.
  41. 5. If a required input is missing, state:
  42. CALCULATION BLOCKED: MISSING INPUT
  43. Then identify the precise missing input and continue with any analysis that remains possible.
  44. 6. Do not exclude a cost solely because it is exceptional, unusual, non-recurring or reduces the desired result.
  45. 7. Do not recommend the median by default.
  46. WORK REQUIRED
  47. A. DATA RECONCILIATION
  48. Reconcile:
  49. - transaction-level data;
  50. - invoices;
  51. - management accounts;
  52. - trial balance;
  53. - statutory accounts;
  54. - tax computation where provided.
  55. Identify:
  56. - duplicated accounts;
  57. - omitted accounts;
  58. - incorrect account mapping;
  59. - prior-period entries;
  60. - manual adjustments;
  61. - foreign-exchange differences;
  62. - consolidation entries;
  63. - unexplained variances.
  64. B. TESTED RESULT
  65. Define and calculate:
  66. - numerator;
  67. - denominator;
  68. - profit level indicator;
  69. - tested period;
  70. - segmentation basis.
  71. Analyse the treatment of:
  72. - pass-through costs;
  73. - shareholder costs;
  74. - stock-based compensation;
  75. - foreign exchange;
  76. - provisions;
  77. - impairments;
  78. - restructuring costs;
  79. - litigation costs;
  80. - exceptional items;
  81. - non-operating income and expenditure.
  82. C. VARIANCE BRIDGE
  83. Quantify separately where data permits:
  84. - volume;
  85. - sales price;
  86. - purchase price;
  87. - product mix;
  88. - customer mix;
  89. - capacity utilisation;
  90. - productivity;
  91. - foreign exchange;
  92. - market conditions;
  93. - inventory;
  94. - bad debts;
  95. - exceptional events;
  96. - accounting treatment;
  97. - transfer pricing implementation.
  98. D. ADJUSTMENT ANALYSIS
  99. Calculate the adjustment required to reach:
  100. - lower quartile;
  101. - median;
  102. - upper quartile;
  103. - documented policy target.
  104. For each scenario determine:
  105. - whether it is consistent with the policy;
  106. - whether the benchmark remains reliable;
  107. - whether the outcome reflects the materialisation of economically significant risk;
  108. - whether the counterparty jurisdiction is expected to recognise the adjustment;
  109. - whether the adjustment changes the transaction rather than implementing it.
  110. E. SECONDARY CONSEQUENCES
  111. Flag potential consequences for:
  112. - corporation tax;
  113. - deductibility;
  114. - withholding tax;
  115. - VAT;
  116. - customs;
  117. - foreign exchange;
  118. - statutory accounting;
  119. - distributable reserves;
  120. - Pillar Two;
  121. - corresponding adjustments;
  122. - MAP.
  123. OUTPUT
  124. Produce:
  125. 1. Data-quality findings.
  126. 2. Account-mapping schedule.
  127. 3. Reconciliation to the accounts.
  128. 4. Tested result calculation.
  129. 5. Variance bridge.
  130. 6. Adjustment scenarios.
  131. 7. Root-cause analysis.
  132. 8. Recommended treatment.
  133. 9. Journal and invoicing instructions.
  134. 10. Required approvals.
  135. 11. Evidence trail supporting the recommendation.
  136. 12. Matters requiring local-country confirmation.
  137. Do not provide a final recommendation if the tested result does not reconcile.
  138. Status: DRAFT — NOT FOR POSTING UNTIL FINANCE, TAX AND LOCAL-COUNTRY REVIEW.

Professional implementation guide

  1. Choose
  2. Copy
  3. Contextualise
  4. Challenge
  5. 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.