The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.
The quotation mentions rebuilding an Excel sheet to some web application.
"This process must be as simple and correct as possible."
Not "as correct as possible", just correct.
If it's any less correct than "correct" it's not correct
I wonder, if they mention correctness explicitly at this point, does that mean all other points are assumed to be incorrect by default?
I've actually had a customer who wanted VAT on invoices calculated per product, which was completely irrelevant, instead of over the complete invoice.
The problem is, you're going to round VAT to two decimals, because no one ever pays €0.001.
So by adding up all the VATs for each product we got rounding errors (and those rounding errors added up!).
If you calculated the VAT over the entire invoice (like EVERYBODY in that business does) it wouldn't add up.
But for some reason they really wanted to have the VAT per product.
We went as far as to round to 16 decimal places, but we still ended up with rounding errors
Ultimately, we actually went for "as correct as possible with x decimal places."
In this case "correct" was of course VAT over the entire invoice because that was the only legal kind of VAT
Here if a product is marked as 4.99 you'll pay 4.95 at the till / cashier, due to us no longer having 2c coins. AFAIK the rounding is only done on the total, but if you wanted to save a few cents you could pay for each product individually.
Not around here as mathematically correct rounding is applied here. 4,99 and 4,98 will result in 5,00. 4,96 and 4,97 will become 4,95. Unless you pay with your debet/credit card then it remains whatever it is.
Over here, in a store (for example, supermarket), VAT is included in the product price.
So 500 gr. (pre-packaged) grapes costs €2.19 incl. VAT.
If you buy two packs, you pay €4.38.
If you pay cash everything is rounded to 5 cents, so €4.38 would become €4.40, but €4.37 would be €4.35.
I can't remember the last time I paid cash at a store
This particular company sold meat (wholesale), so a customer would order five ribs, but they would pay per kg.
The customer gets an estimated price, based on what my customer sent them, then that customer would weigh everything again, and that weight was invoiced.
Naturally, you don't know the VAT until the actual invoice.
And since the VAT isn't included in the individual prices, like in a supermarket, you really can't do anything other than calculate VAT over the entire invoice
It's how I invoice too, and pretty much every business in the Netherlands.
If we didn't have the 1c piece (penny) here in the US, not too many cashiers would be able to round it correctly to the nearest 5c. It goes to show that we should better fund our education system. Because it is biting us in the rear.