The blank tax cell that changed the close

Equal gross amounts do not establish equal bases

T601, T602 and T603 all belong to fictional Mia Chen and use a supplied 40% service rate. Each gross amount is $110.00. T601 supplies $10.00 tax. T602 has no tax value. T603 supplies $0.00. The case chooses an excluding-tax calculation basis and, only where tax is absent, a 10% assumed rate.

These inputs illustrate the engine’s behaviour. They do not establish how any particular sale should be taxed or what a business should exclude from commission. The explicit-zero row is a deliberately supplied data condition. Its meaning must come from the actual source and confirmed arrangement, not from this example.

Three branches of one calculation

T601 uses $110.00 − $10.00 = $100.00. T602 divides $110.00 by 1.10 under the stated assumption, also producing $100.00. T603 subtracts the supplied zero, leaving $110.00. Applying 40% gives $40.00, $40.00 and $44.00. The combined basis is $310.00 and commission $124.00.

Why subtracting ten percent is the wrong reversal

For T602, subtracting 10% of the $110.00 gross would remove $11.00 and leave $99.00. That is not the same as reversing a gross amount built from a $100.00 basis plus 10% of that basis. The denominator belongs to the original basis, so the reversal is division by 1.10.

At the 40% commission rate, the mistaken $99.00 basis produces $39.60, forty cents below the assumed-tax result. A formula can be short, familiar and still use the wrong denominator. The tax-basis comparison tool shows the assumed tax and the resulting basis together so that this step remains inspectable.

What filling the blank actually asserts

Replacing T602’s blank with zero changes its meaning from “tax not supplied” to “tax supplied as zero.” Under this example policy, its basis rises from $100.00 to $110.00 and commission from $40.00 to $44.00. Replacing T603’s explicit zero with a blank does the reverse, reducing its commission by $4.00.

Do not bulk-fill empty cells to make a spreadsheet look complete. First determine whether the source omitted a value, used a different report definition or intentionally supplied zero. Preserve the original condition and document any corrected working copy. A clean-looking column can hide a material assumption change.

Missing tax is not currently a workspace stop sign

The public CSV health checker marks absent tax as a review finding and asks for an explicit assumption before an excluding-tax calculation. The workspace engine, however, uses the configured assumption when the tax value is missing; it does not create a dedicated missing-tax hard stop. The reviewer must therefore check this condition deliberately.

An empty review queue cannot establish that every supplied tax value was complete or appropriate. Inspect the import preview and a few source rows, especially when changing report types. If the source should contain explicit tax but does not, obtaining the correct export may be more useful than proceeding with an assumption.

The negative form needs consistent signs

A refund with gross −$110.00 and supplied tax −$10.00 has a −$100.00 basis and −$40.00 commission under the same rate. Gross −$110.00 with positive $10.00 tax is rejected by the importer because the supplied tax has the wrong sign. A refund with absent tax uses the recorded assumption and also produces a −$100.00 basis in this case.

Check both sign and magnitude. A tax amount cannot exceed the absolute gross amount in the supported import. Those checks catch inconsistent inputs; they do not validate the business’s tax treatment. Keep that distinction when explaining why a file passed or failed.

Check the data condition before the total

Download the three-row file and inspect its tax column before importing. The blank cell must remain blank and the explicit zero must remain zero. Set the stated excluding-tax policy and 40% service rule. The expected total is $124.00, not $120.00 and not $132.00.

We ran the three basis inputs directly through the current engine and obtained $100.00, $100.00 and $110.00. The executed public-tool suite also covers assumed tax, signed refunds and invalid tax signs. The practical result is a checklist question: which values were supplied, and which were inferred under a recorded assumption?