DRC Royalty & Tax CalculatorVersion-controlled DRC Mining Code royalty rates, NSR computation, super-profit levy, CAMI surface rental, DGRAD quarterly return and automatic GL posting — all in Odoo.
|
|
|
|
Need Help?Contact us at odoo@grevlin.com or find us on X at @GrevlinGlobal ✓ 30 days free support included |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Discuss (mail)
• Invoicing (account) • Employees (hr) • Inventory (stock) |
| Community Apps Dependencies | Show |
| Lines of code | 5003 |
| Technical Name |
grev_od_mining_royalties |
| License | OPL-1 |
| Website | https://grevlin.com |
DRC Royalty & Tax Calculator
The DRC Royalty & Tax Calculator automates royalty computation for DRC-based mining operations under the 2018 Mining Code. Every sale lot flows through the NSR engine, super-profit levy is computed automatically, and journal entries are posted to your GL.
Note
Requires :doc:`../grev_od_mining_base/doc/index` and :doc:`../grev_od_mining_production/doc/index`.
Warning
This module ships rate tables as reference data. Always verify current rates with your legal counsel and the official DRC Ministerial Decrees before filing a DGRAD return.
Overview
Key Features
- Version-controlled rate tables — DRC 2018 (active), 2002 (superseded), Zambia 2024 presets
- NSR calculation — gross revenue − TC − RC − penalties − deductions per lot
- Super-profit levy — automatic DRC 2018 trigger at realised price > feasibility × 1.25
- Quarterly royalty computation — aggregates monthly NSR calculations into a period report
- DGRAD quarterly return — official DRC format PDF, reconciled to GL within USD 0.01
- CAMI surface rental — Q1-only per title category and hectares
- Automatic GL posting — one journal entry per tax category on approval
Configuration
Account Mapping
Before posting royalties, configure the account mapping at :menuselection:`Mining Royalties --> Configuration --> Account Settings`:
- Royalty expense account — debited on posting
- Royalty payable account — credited on posting
- Separate accounts for: Royalty, Super-Profit Levy, Export Duty, Surface Rental
Rate Version Management
Go to :menuselection:`Mining Royalties --> Configuration --> Rate Versions`.
Only one version per country can be active at a time. Activating a new version automatically supersedes the current active version. Effective date ranges must not overlap.
Usage
NSR Calculation Workflow
- Go to :menuselection:`Mining Royalties --> Operations --> NSR Calculations`.
- Click :guilabel:`Create`.
- Link the sale line and lot; set concentrate tonnes, grade, payability %.
- Enter the treatment charge, refining charge, penalties, and other deductions.
- Click :guilabel:`Validate` — the rate line is frozen for audit immutability.
NSR Formula
payable_metal = concentrate_tonnes × grade_pct/100 × payability_pct/100 gross_revenue = payable_metal × reference_price treatment = concentrate_tonnes × tc_usd_per_t refining = payable_metal × rc_usd_per_unit nsr = gross_revenue − treatment − refining − penalties − other_deductions royalty_amount = nsr × royalty_rate_pct / 100
Super-Profit Levy
Triggered when:
realised_price > feasibility_reference_price × (1 + trigger_pct/100) default trigger_pct = 25 (i.e. > 125% of feasibility reference) super_profit_base = (realised_price − feasibility_ref × 1.25) × payable_metal super_profit_levy = super_profit_base × levy_pct / 100 default levy_pct = 25
Creating a Quarterly Computation
- Go to :menuselection:`Mining Royalties --> Operations --> Royalty Computations`.
- Click :guilabel:`Create`.
- Select site, date range (one quarter = 3 monthly NSR calc sets).
- Click :guilabel:`Review`, then :guilabel:`Approve`.
- Click :guilabel:`Post` — journal entries created (one per category).
- Link to the DGRAD return for the quarter.
DGRAD Quarterly Return
The DGRAD return aggregates three monthly computations into the official quarterly filing in the DRC format prescribed by DGRAD (Direction Générale des Recettes Administratives, Domaniales et de Participations).
- Go to :menuselection:`Mining Royalties --> Compliance --> DGRAD Returns`.
- Click :guilabel:`Create`, select site, year, and quarter (Q1–Q4).
- Link the three monthly royalty computations.
- Totals (royalty + super-profit + export duty + Q1 surface rental) compute automatically.
- Click :guilabel:`Generate PDF` — reconciled to GL totals within USD 0.01.
- Click :guilabel:`Submit` after filing with DGRAD.
Note
Surface rental (CAMI) is included only in Q1 returns. The system enforces this automatically — Q2/Q3/Q4 returns will show surface_rental = 0.00.
Technical Details
GL Posting Idempotency
Re-posting an already-posted computation does not create duplicate journal entries. The system checks for existing entries linked to the computation before creating new ones.
DGRAD Reconciliation Tolerance
The DGRAD PDF totals must reconcile with posted journal entry amounts within USD 0.01. The system raises a validation error if the divergence exceeds this tolerance.
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module