Record the inputs and covered charges. Keep guessed values visibly separate from measured ones.
Compare a later amount using the same contents, destination and packing before calling the difference an error. When an assumption changes, update that part of the plan. A planning result reserves money; the amount presented for payment belongs in a separate field.
Name the scope of the estimate
Write down whether the amount concerns goods, international transport or the whole plan. An item-only estimate is useful for comparing candidates but cannot tell you what the final parcel will cost. A transport estimate needs its destination, selected service, weight and dimensional assumptions beside it. Leave an unknown input visible instead of filling it with a convenient small value.
Keep currencies separate until you have an exchange basis for the comparison. If a later payable amount uses another currency, recording both original amounts makes the difference easier to explain. Do not treat a private conversion as the rate that a payment service will necessarily apply.
Replace assumptions without erasing history
When measured packing information becomes available, make a new estimate for that configuration. Mark the earlier one as superseded, not as a second charge to add. A changed estimate may reflect different inputs; a payment is a different event again. The payment guide keeps top-ups and order charges from being counted twice, while the calculator guide explains a like-for-like freight comparison.
Continue reading
Kakobuy Shipping Calculator · Kakobuy Spreadsheet Guide · Kakobuy Spreadsheet Links · Kakobuy QC Photos