TP reconciliation P&L builder
Adds a reconciliation P&L per trading partner, with check formulas, to a transfer pricing Excel workbook.
What it does
Two command-line Python scripts that add a 'Reconciliation PnL' sheet to a transfer pricing Excel workbook: one part per trading partner, with parent and partner sums and a check cell per year, from the workbook's P&L and services sheets. A text wizard asks for the workbook, years, parent code, sheet names and exclusions; needs pandas and openpyxl. No README; described from the code's comments.
Licence unknown: we found no licence we could recognise. Check with the maintainers before you reuse the code.
Where it fits on the map
In the processes
- Operational transfer pricingStep 3 · Monthly monitoring & forecast
Similar projects
Of the same kind, for a shared jurisdiction or tax area. Not a ranking.
- bank_retenue_syncERPNext app for Tunisian withholding certificates: ingestion, reconciliation and issue from invoices.
- CACAO (IDB)IDB web platform for tax administrations to receive, validate, store and analyse taxpayers' accounting data.
- CBCR-TPChecks a country-by-country report XML file against the OECD schema, Luxembourg rules and safe harbour tests.
- Comparables_IdentificationScript that ranks candidate comparables by the similarity of their business descriptions to a tested party.
- CountryByCountrySolution (SARS)C# WinForms app that builds South Africa's SARS country-by-country declaration XML from Excel and checks it.
- CPAverse Tax Prep AgentAI agent for tax preparation workflow automation, with agent skills and standard operating procedures.
Maintain this project?
Link to this page from your README, so readers find the facts, the notes and where it fits. The badge is a small SVG served from this site.
[](https://tax-oss.com/projects/tp-reconciliation-pnl/)