- Name the base and reference row before saving a tax row.
- Check each rate against the format its field asks for.
- Confirm which quantities a quantity-based row counts, then compare its amount with your hand calculation.
A service invoice with one tax row is easy to check. You look at the taxable amount, look at the rate, and see whether the tax matches. Add a second row for a different rate, or a row that is worked out from another row, and the arithmetic stops being obvious at a glance. Office staff often find the problem only when a customer questions a total, or when the month's tax report does not match the invoices behind it.
Most of these errors are not hard math. They come from three places: a row set up on the wrong base, a rate typed in the wrong format, or a quantity applied to the wrong lines. The software does what the setup tells it to do. When a total is wrong, the setup is usually where the mistake sits, not the invoice you are looking at.
This post covers those three mistakes with examples. The examples use the sales tax settings in Frappe ERPNext and the tax settings in WooCommerce, since both publish clear descriptions of how their tax rows work. Your accounting software may use different labels, but the questions you need to ask about each row are the same. The later sections explain why these errors get past review, and give a short check to run before any invoice with more than one tax row goes out.
The three mistake sections each include a test you can run on a draft invoice. Run them in order, because a problem in one row can look like a problem in another, and it is easier to isolate one cause at a time.