Use the purchased item and quantity as the starting point, then account for the applied discount, tax, selected shipping and any separately recorded fee in the same currency. First establish which amounts already include tax or discounts so you do not count a component twice. Each difference needs a matching order line and a rule or configuration record. An explained amount can be communicated to the buyer; a line that conflicts with the intended rule needs a targeted correction. An unexplained remainder is still unresolved, even if the overall total looks plausible.
For: A research-only merchant or support lead comparing a WooCommerce product price with the total on an actual checkout or order.
Compare records from the same purchase: the selected product or variation, quantity, price shown at the time, cart summary and order totals if an order exists. Record whether the displayed product amount was a regular price or a sale price. A current product page cannot prove the price that accompanied an older order, especially when the selected variation or promotion has changed.
Keep unit price and quantity distinct from the extended line amount. Also label each figure as before or after discount and including or excluding tax, using the actual record. Without those labels, adding the visible figures can count a discount twice or add tax that is already included. If you do not have the earlier catalog view, leave that comparison unknown and reconcile the order's own components first.
A coupon amount needs an eligible item or cart
WooCommerce core distinguishes percentage, fixed-cart and fixed-product coupons. It also documents product restrictions, sale-item exclusions, individual-use restrictions and usage limits. An advertised coupon amount is therefore not automatically the discount on this order. Compare the actual coupon and eligible order lines with its type and restrictions, rather than subtracting the promotion's headline amount from every cart.
For a missing discount, record whether the coupon was applied and what message accompanied the attempt. If email eligibility matters, WooCommerce checks the billing email; record only whether the authorized comparison matched. Its minimum-spend rule uses cart subtotal plus tax. Free shipping also requires the linked shipping-method setup. These are useful checks for explaining the discount and shipping lines; detailed repair of a rejected coupon belongs to the coupon-specific investigation.
If the discount agrees with the configured coupon but disagrees with the offer the merchant intended, the arithmetic alone does not close the issue. Record the rule-versus-offer mismatch. If an extension changes coupon handling, name that extension and obtain its actual rule rather than assuming the core behavior explains its result.
Keep tax and shipping visible without adding them twice
WooCommerce separately configures whether prices are entered with tax, which address supplies the calculation basis, and how prices and tax totals are displayed. Read those settings alongside the order's recorded tax breakdown and the product's assigned tax class. A catalog amount and a checkout amount can be presented on different tax bases. Do not interpret an included-tax disclosure as another amount to add without checking the underlying breakdown.
For the selected WooCommerce Flat Rate method, the documented cost can include the method cost plus shipping-class costs. Per-class calculation charges each class, while per-order calculation uses the most expensive class. Its tax status determines whether tax applies to the shipping cost. Keep the shipping amount and any shipping tax separately identifiable even if the buyer sees a combined presentation.
Use these facts to locate the component responsible for the difference, not to redesign the tax or delivery rules from this overview. If the unexplained amount is confined to tax or shipping, carry that component and its inputs into the dedicated guide. The correct tax treatment requires the merchant's qualified advice; a tax amount appearing in software does not establish liability.
Name the fee source and reconcile the remainder
Copy every fee line actually present on the order. For each, find the extension, custom configuration or other record that supplied it and the conditions it used. A label that sounds like a gateway fee is not proof that the payment provider added it. If no record identifies the source, leave the fee unassigned rather than inventing a formula or using it to explain the remainder.
Compare the currency labels as well as the symbols. If a currency tool is installed, use its records to determine whether it changed the underlying amount or only the display. This worksheet does not supply an exchange rate. A payout amount or a customer's bank-statement figure is a different comparison from the store's checkout total and should not be used to balance it.
Reconcile with a consistent basis: use either recorded net item amounts and separately recorded taxes, or recorded gross amounts with included tax identified. Subtract only discounts not already reflected in the amounts you chose, and include shipping and evidenced fees once. Record any residual difference without rounding it away on an assumption. If the record cannot support that reconstruction, the missing breakdown is the next specific request.
Finish by marking each component explained, inconsistent with the intended rule, or unresolved. That gives support a factual explanation and gives the maintainer an exact line to investigate. For a Prism checkout-review consultation, describe the unresolved component and store platform. Agree the requested scope, responsibilities, fees and terms before work, and keep private order and payment records out of the public inquiry.
Total anatomy sheet
Use one real purchase. In the blank column record the actual amount, its inclusive/exclusive and before/after-discount basis, its evidence reference and the finding: explained, rule mismatch or unresolved. Count each component once. A mathematically balanced total can still contain an unintended rule.
Worksheet entries are not submitted by Prism’s worksheet and are not saved by the site. Use record types, availability, anonymized observations, or match/mismatch results. Do not enter government identifiers, customer names or addresses, customer messages, receipt-access links, card or bank details, passwords, or keys. Send sensitive documents only through the provider’s verified secure channel.
Total anatomy sheet. The last column is for temporary notes.
Component
Record to use
What the comparison decides
Your amount and finding
Selected item and quantity
Record to useThe actual product or variation, quantity and unit and extended amounts from the purchase record.
What the comparison decidesDetermines whether the comparison starts from the same item and quantity as the catalog observation.
Regular or sale price
Record to useThe dated price shown for that selection and the order's item price; mark historical evidence missing if unavailable.
What the comparison decidesSeparates a genuine price change or selection difference from later additions to the total.
Applied coupon discount
Record to useCoupon type, actual discount, eligible items and relevant restrictions or rejection message.
What the comparison decidesExplains the discount actually applied; a headline offer alone cannot determine it.
Tax component
Record to useRecorded item and shipping tax, price-entry basis, calculation-address basis, item tax class and display settings.
What the comparison decidesShows where tax is included or separately added, without deciding which legal treatment is due.
Selected shipping
Record to useThe selected method's amount and settings; for Flat Rate, method cost, class costs, calculation type and tax status.
What the comparison decidesAccounts for delivery separately from the product price and keeps any shipping tax from being added twice.
Fee lines
Record to useEach actual fee with the extension or configuration record that supplied it and its stated rule.
What the comparison decidesAn unidentified fee remains unresolved; do not assign it to a provider from its label alone.
Currency and display
Record to useCurrency labels and any installed currency tool's applicable configuration or record.
What the comparison decidesPrevents unlike currencies or display-only differences from becoming a false arithmetic comparison.
Remaining difference
Record to useFinal checkout total compared with the once-counted components on a consistent tax and discount basis.
What the comparison decidesA nonzero or unexplained difference names the next investigation; do not insert a balancing fee or assumed rounding amount.
Rule or explanation
Record to useThe supported finding for each component beside the merchant's intended offer and configuration.
What the comparison decidesExplained and intended can be communicated. A rule mismatch needs correction; an unsupported line needs evidence.
These are temporary notes. Leaving or reloading this page may clear them. Worksheet entries are not sent automatically. If you copy notes into the consultation message and submit the form, Prism receives them as part of your request.
Limits
This page reconciles a WooCommerce checkout total; it does not calculate tax liability, exchange rates or processing fees.
An installed extension's fee or discount behavior requires its own records. Core documentation does not prove the cause of an unseen order total.
Keep full addresses, billing emails, customer exports, payment-link tokens and card details out of worksheets and public inquiries.
WooCommerce coupon management — checked 2026-09-29. Core coupon types, product restrictions, sale exclusions, individual use and usage limits affect eligibility. Billing email supplies email matching, minimum spend uses subtotal plus tax, and free shipping requires linked method setup. Extensions can change handling.
WooCommerce tax configuration fields — checked 2026-09-29. Separate price-entry, calculation-address and display settings support comparing the tax basis of the catalog and checkout. The documented fields do not establish an individual merchant's tax liability or rounding result.
WooCommerce flat rate shipping — checked 2026-09-21. Flat Rate adds class costs to method cost; per class charges each class and per order uses the most expensive class. The method's tax status controls whether tax applies to that cost.