How it works
For each line calculate net × quantity, round its tax to cents, then sum line net, tax and gross amounts.
Input definitions
- CSV: item,net unit price,quantity,tax percent
- Plain text; maximum 200,000 characters.
A worked example
- CSV: item,net unit price,quantity,tax percent
- item,net,quantity,rate A,100,2,20 B,50,1,5
Assumptions & limits
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
Sources & review
Maintained by AnsRio. Methods and examples use automated checks; this does not imply independent professional certification.
Method updated 2026-10-17. Content checked against the stated method and examples. Our verification approach.
Common questions
Why can line-rounded tax differ from invoice-rounded tax?
Rounding each item line before summing can differ from rounding a single aggregate tax amount. This tool uses per-line cents rounding and your entered rates.
How does Mixed-rate sales tax basket work?
For each line calculate net × quantity, round its tax to cents, then sum line net, tax and gross amounts.
What are the limits of Mixed-rate sales tax basket?
Entered-data planning worksheet. No legal, payroll, tax-filing or accounting certification.
How do I keep the full worksheet?
Run the tool and choose Download file. The on-page table is a preview and may show only the first 20 rows; the downloaded file contains the full result. CSV downloads escape spreadsheet formula prefixes. Inputs and files are processed on your device.