VAT and Surcharge Calculator

Overview

The step that trips people up when issuing an invoice is separating the tax-inclusive price from the tax-exclusive base. A quotation usually states the inclusive figure, the ledger needs the net revenue and the output VAT separately, and the surcharges are then calculated not on the sale but on the VAT amount itself. This tool chains the whole sequence. It first splits the amount into a net base and VAT using the selected rate, dividing an inclusive figure by one plus the rate, or multiplying an exclusive figure by the rate. It then treats that VAT as the base for urban construction tax at 7, 5 or 1 percent depending on location, the 3 percent education surcharge and the 2 percent local education surcharge, with an option to halve all of them for small businesses. The final output lines give the VAT, the surcharge total, the combined tax burden and the tax-inclusive total, which is exactly the set of numbers an invoice or a costing sheet needs.

Features

• Two-way split between inclusive and exclusive amounts across six rates: 13, 9, 6, 5, 3 and 1 percent
• Surcharges itemised: urban construction tax at 7, 5 or 1 percent, education surcharge 3 percent, local education surcharge 2 percent
• A small-business halving switch applies to the surcharges as a group, making the two scenarios easy to compare
• Five headline figures: net base, VAT amount, surcharge total, VAT plus surcharges, and the inclusive total
• Every field recalculates instantly, which suits the trial and error of picking a rate before invoicing
• Copy the result as a four-part string, or export a single CSV row into a quotation or bookkeeping voucher

How to use

1. Enter the amount and state whether it is tax-inclusive or tax-exclusive
2. Choose the rate: 13 percent goods, 9 percent construction and transport, 6 percent modern services, 5 or 3 percent simplified, 1 percent small-scale relief
3. Pick the urban construction band that matches the taxpayer location: city 7, county or town 5, elsewhere 1
4. Toggle the halving option if the small-business relief applies and watch the surcharge total change
5. Copy or export the VAT and surcharge figures for the quotation, invoice note or voucher

Notes

• The construction band follows where the taxpayer is registered, not where the invoice is issued, so choosing city rates for a county business overstates the surcharge
• The base is the VAT actually paid, not the sales amount; with carry-forward credits, exemptions or immediate refunds the surcharge can legitimately be zero
• The halving relief touches the six taxes and two fees only, which includes the surcharges but never the VAT itself
• Statutory rates and simplified levy rates are different systems; a small-scale taxpayer issuing a special invoice may sit at 3 percent rather than the 1 percent relief
• This tool computes the output side of a single transaction and ignores input credits; the payable amount is output minus input
• Surcharges share the VAT filing calendar, so a late invoice issued in a later month brings both a catch-up payment and a late fee
• Rounding follows standard half-up behaviour at two decimals, matching how invoices are typically printed
• Every surcharge line is derived from the VAT amount rather than the sales value, so toggling the halving option changes the three surcharge lines but never the VAT itself, and the total always equals VAT plus those three lines.