| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 768 |
| Technical Name |
gb_uk_partial_exemption_vat_calculator |
| License | OPL-1 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Lines of code | 768 |
| Technical Name |
gb_uk_partial_exemption_vat_calculator |
| License | OPL-1 |
| Website | https://gencbaris.com/odoo_plugins/ |
| Versions | 18.0 19.0 |
UK Partial Exemption VAT
HMRC standard-method partial exemption: recovery %, de-minimis and annual adjustment worksheet
Businesses that make both taxable and exempt supplies must apportion input VAT under HMRC's standard method, one of the fiddliest corners of UK VAT usually wrangled in error-prone spreadsheets. This worksheet-driven calculator handles direct attribution, the residual recovery percentage rounded up the HMRC way, the two-limb de-minimis test and the annual adjustment that reconciles the year. Thresholds like the GBP 625 monthly limit and 50 percent ratio are settings, seeded to current HMRC figures, and a wizard can pre-fill from posted ledger data. It suits VAT managers, accountants in practice and finance teams in property, finance and charity sectors. Worksheet and format generation only, no filing to HMRC.
Key Features
Standard-method recovery percentage
The gb.pe.calculation model splits input VAT into taxable (T), exempt (E) and residual (R) and applies compute_recovery_percent: taxable / (taxable + exempt), rounded up to the next whole percent as HMRC requires when residual VAT is under the rounding limit. residual_recoverable then apportions the R pot.
Direct attribution lines with audit trail
When use_lines is on, gb.pe.calculation.line records each cost category with its input VAT and an attribution of taxable, exempt or residual. _rollup_lines sums them into the headline T/E/R figures on create, write and unlink, giving a defensible per-cost trail rather than three typed-in numbers.
Full de-minimis test
Each calculation runs both de-minimis limbs: the exempt input VAT monthly average against the GBP 625 limit and the 50 percent of total input VAT ratio. deminimis_passes and deminimis_test_detail show PASS or FAIL per limb, and when passed all input VAT including exempt becomes recoverable.
Annual adjustment worksheet
The gb.pe.annual model aggregates a year's period calculations, recomputes the annual recovery percentage and de-minimis position, and produces the adjustment field: positive means reclaim more, negative means repay HMRC. action_pull_periods attaches every unassigned period calculation in the year automatically.
Import figures from posted ledger
The gb.pe.import.wizard pre-fills a calculation from posted journal items: it sums the tax-base of sale invoices under the taxable and exempt tax codes you map and totals purchase input VAT over the period via _read_group, creating a computed calculation as a starting point you then refine.
Configurable HMRC thresholds
gb.pe.settings holds per-company parameters: the de-minimis monthly limit (GBP 625), the 50 percent total-input ratio, the rounding residual limit and the tax-year-end month (March default). get_for_company auto-creates settings, and figures recompute when thresholds change as HMRC rules evolve.
Printable worksheet output
get_worksheet_text builds a plain-text HMRC-style standard-method worksheet listing the T/E/R inputs, supplies, recovery percentage, residual recoverable and the de-minimis detail. action_print_worksheet computes if needed and posts it to the chatter, giving an inspector-ready record.
Use Cases
Screenshots
Annual Adjustments
Pe Calculations
Import From Ledger
Pe Settings
Why Choose This Module
Businesses that make both taxable and exempt supplies must apportion input VAT under HMRC's standard method — one of the fiddliest corners of UK VAT, usually wrangled in spreadsheets. This worksheet-driven calculator handles direct attribution, the residual recovery percentage, the de-minimis tests and the annual adjustment, with all thresholds configurable and seeded to current HMRC figures. Worksheet/format generation only — no filing to HMRC.
Specifications
- Compatible: Odoo 18.0 / 19.0
- License: LGPL-3
- Languages: 35+
- Author: Baris Genc
- Dependencies: account
- Support: odoo@gencbaris.com
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