Skip to main content
Kakobuy Spreadsheet Ledger

← All field notes

How Kakobuy Spreadsheet Practice Changed Between 2025 and 2026

Reviewed 2026-W40Version differenceTarget: kakobuy spreadsheet 2026 changes1653 words

Data this note rests on: Germany and Poland share a €150 threshold line, but the destination table holds 264 checked rows for Germany and none at all for Poland.

How it worked in 2025

In 2025 the working sheet held one destination threshold; in 2026 the same sheet holds six, and one of them has nothing standing behind it. Germany carries 264 checked rows and Poland carries zero, so two countries that share a €150 line do not share a confidence level. That asymmetry is the clearest single record of what changed, and it is visible in one column of the destination block.

The 2025 shape was a list plus a small fee block. Rows were copied in from a source marketplace with a title, a price and a category, and the fee block carried the six lines that still exist: item subtotal, domestic shipping at $1.40 per item, agent commission, payment surcharge, international freight as a single figure, and a destination tax line that was usually blank. The destination was treated as one place with one threshold, and the threshold lived in a single cell.

That shape worked because the spreadsheet was answering one question at a time. A buyer in one country comparing two rows against one another did not need a destination column, because the destination was the same on both sides of the comparison. The freight figure was a single number, the volumetric divisor was a single number, and the index rule was whatever the author used without writing it down. Fewer moving parts meant fewer cells to keep straight.

Where it broke was the moment a sheet was reused. The same list read against a second destination produced totals that were silently wrong for one of the two readers. The same parcel billed at a different divisor produced a freight figure that could not be reconciled with the first one. Nothing in the workbook flagged either event, because neither had a column to appear in, and a total that is wrong in the same direction for every row looks entirely consistent.

What changed in 2026

The destination layer became a table rather than a cell. Each destination now carries a threshold, a tax rate, a handling fee and a checked-row count, and the fee is as much a part of the record as the rate. Canada is the sharpest illustration: a CAD 20 threshold with 13 percent tax and a CAD 9.95 handling fee means the first item crosses the line, so the fee applies to a parcel that a US reader would treat as trivially small.

Destination thresholds and handling fees carried in the 2026 worksheet, reviewed 2026-W40
DestinationThresholdTax rateHandling feeChecked rows
United States$8000%$0196
United Kingdom£13520% VAT£835
Germany€15019%€6264
Poland€15023%Not confirmed0
CanadaCAD 2013%CAD 9.95138
AustraliaAUD 100010%$039
Source:
Destination threshold block in the working spreadsheet
Sample:
Six destinations; checked-row counts range from 264 (Germany) to 0 (Poland)
Recorded:
2026-W40
Known gap:
No qualifying sample yet for the Poland row: the handling fee is unconfirmed and its checked-row count is zero

The volumetric divisor stopped being a constant. A worksheet that carried a single divisor now carries a divisor set of 5000, 6000 and 7000, and the choice changes the billed weight for the same box. For a 40 by 30 by 20 carton, the volume is 24000 cubic centimetres: divided by 5000 it bills at 4.80 kg, by 6000 at 4.00 kg, and by 7000 at 3.43 kg. The formula is unchanged and reads as volumetric equals length times width times height divided by the divisor, with the billed weight taken as the greater of actual and volumetric.

One 40 × 30 × 20 carton at three divisors, actual weight 2.5 kg, marginal rate $9 per kg
DivisorVolumetric weightBilled weightWeight billed above actualCost of the excess
50004.80 kg4.80 kg2.30 kg$20.70
60004.00 kg4.00 kg1.50 kg$13.50
70003.43 kg3.43 kg0.93 kg$8.37
Source:
Volumetric weight worksheet, worked from carton dimensions and the divisor set
Sample:
One carton, 40 × 30 × 20 cm, actual weight 2.5 kg, marginal rate $9 per kg
Recorded:
2026-W40
Known gap:
The comparison holds one carton at three divisors and says nothing about how a carrier assigns a divisor to a given route

The index layer acquired an explicit gate. A row enters it when its photo group carries at least five images, and the current pool shows what that rule does in practice: 158 of 195 entries qualify, which is 81 percent, and 37 fall below the line. The gate turned a judgement made by feel into a countable field, and the count is now the first number worth reading in the sheet because it states how much of the list has been looked at.

The list itself became a described object rather than a private one. The pool in use carries 195 entries across 8 categories and 20 brands, all from a single source marketplace, with a median price of $31.76 and a range from $5.17 to $451.10. Publishing that composition makes two sheets comparable before their totals are compared: two lists with the same row count but different category mixes are no longer the same list, and the mix is now the first thing worth stating.

Commission and surcharge became adjustable rather than fixed. The defaults remain 5 percent and 3 percent, and both are now fields a reader can change, which means a total quoted from one workbook is only comparable with a total from another when both name their settings. A parallel change sits on the duty side: the rule note at /field-notes/eu-per-category-duty-rule/ describes assessment that runs per category rather than against the parcel total, which makes the composition of a box a first-order question.

The practical difference

The old shape had one line that could change a total; the new shape has six. A single item bought at the pool median of $31.76 attracts $1.40 of domestic shipping, $1.59 of commission and $1.04 of surcharge, then the $45 freight line, for a landed figure of $80.79. Four of those five additions did not exist as adjustable fields in the older arrangement, and the fifth was a constant that nobody had reason to inspect.

The divisor change is the most concrete of the three. Under a 6000 divisor the example carton bills 4.00 kg against an actual 2.5 kg, which costs $13.50 at a marginal rate of $9 per kg. At 5000 the same carton costs $20.70 and at 7000 it costs $8.37. The spread between the two extremes is $12.33 on one carton, which is roughly three quarters of the $16.22 headwear median and larger than most single-line changes a buyer will make in a week.

The threshold change moves cost between destinations rather than within one. A parcel that clears the US $800 line without tax can cross the UK £135 line at the same goods value and pick up 20 percent VAT plus £8, or cross the German €150 line and pick up 19 percent plus €6. Canada inverts the pattern entirely: with a CAD 20 threshold, a single item is enough to trigger 13 percent and a CAD 9.95 fee, so the tax line is never blank for a Canadian reader.

The coverage change alters what a row count means. A 195-entry list with 158 rows above the gate is a 158-entry list with 37 open questions attached. A 2025-style list that reported only its row count would describe the same file as larger than it is usable. Reading the gate alongside the count is the difference between knowing the size of a list and knowing the size of the part of it that has been examined.

What to change in your own routine

  1. Add a destination column and fill it per row rather than per workbook. A single destination cell at the top of a sheet silently applies to rows that were written for somewhere else, and the error only appears once the tax line is computed.
  2. Add a divisor cell next to the freight line and record which of 5000, 6000 or 7000 was used. The billed weight for an identical carton moves by 1.37 kg between the extremes, which is $12.33 at a $9 marginal rate.
  3. Record the checked-row count behind any threshold you rely on. The German row rests on 264 checked rows and the Polish row on none, and a total that does not state which of those it used cannot be audited later.
  4. Keep the fee settings visible. Commission at 5 percent and the surcharge at 3 percent are defaults, not constants, and two worksheets that disagree on them produce different landed totals from identical item prices.
  5. Write the photo gate into the sheet as a field rather than a habit. A row with fewer than five images sits outside the index layer, and 37 of 195 rows are in that position today.
  6. Date every extraction. The pool in use was extracted on 2026-09-29, and a row without a date cannot be ranked against one that has a date, which removes the only cheap signal the sheet produces.

Each of those six changes is a column, and none of them changes a formula. The reason to make them now rather than later is that the costs they expose are already being paid. A divisor recorded as 6000 instead of 5000 does not make a carton lighter; it makes the difference between $20.70 and $13.50 visible before the parcel is sealed rather than after.

The changelog at /vault/changelog/ is the place to check which of these fields moved most recently, because a sheet is only as current as its newest entry and the destination block is the part that changes most often. The forward view at /field-notes/where-spreadsheets-are-heading/ carries the same three threads further and sets out which indicators are worth watching over the next review cycles. Between the two, a reader can keep a workbook aligned with practice without rebuilding it.

Check the same numbers on Kakox

Instruments behind this note

Other field notes

This ledger is funded by referral links. Some links to Kakox on this site carry a referral that may earn us a commission; it does not change what you pay. How this site is funded