I need to split VAT-inclusive amounts into net price and tax

Built!

VAT Reverse Calculator converts VAT-inclusive amounts and net prices across many lines at once, with a choice of rounding at the won level.

Current workflow

To back out the net price from a VAT-inclusive amount, you divide the total by 1.1 — and in practice, people often do this on a calculator, one line at a time, copying each result by hand. Clean amounts like ₩11,000 are fine, but amounts like ₩13,333 produce decimals, and rounding down versus rounding to the nearest won leaves you off by a won here and there. On top of that, the tax you get by rounding each line and adding them up can differ by a few won from the tax on the lump sum, so if you don't know which basis your client uses, the figures won't reconcile. The usual workarounds are pasting into a single-amount calculator twenty times, or writing ROUND formulas line by line in Excel.

Solution

VAT Reverse Calculator

How to use

1. Paste the amounts, one per line. 2. Pick a direction — VAT-inclusive → split into net price and tax / net price → add VAT. 3. Check each line's category and tax rate, and pick the rounding rule — round, truncate, or round up — applied at the won level. 4. Copy the resulting table of per-line net prices and tax amounts into your tax invoice or spreadsheet.

Example

- Input: ₩11,000 VAT-inclusive → Result: net price ₩10,000, VAT ₩1,000 - Input: ₩13,333 VAT-inclusive → Result: net price ₩12,121, VAT ₩1,212 (rounded). Dividing by 1.1 leaves a fraction, so you switch the rounding rule (round / truncate / round up) to find the one that matches your total. A 20-line item list is handled in a single paste.

Open tool
View details
Limits
- You can set a tax rate per line and mark tax-exempt or zero-rated items. Check that the category and rate you entered are correct. - Issuing the tax invoice itself still happens in Hometax (the Korean tax filing system). This tool covers the step of producing the numbers you'll enter there.
Cost type
Free

This is a calculator, so it cannot reconcile numbers that were built on different bases. If a unit price carries a fraction and you multiply by quantity, the total can drift by a won or two; and if your client reconciles on the lump-sum basis while you calculate per line, the figures will never meet. The tool shows both the per-line values and the value calculated from the total, but which to use depends on your client or tax contact, so agree on the rounding basis before you calculate.

Support

I have this problem too · 0 people

Sign in to support or ask a question

Comments

Be the first to comment.

Additional information

Delete a post made without signing in