Six signs your import business has outgrown spreadsheets
Six operational signs the spreadsheet is costing money: a missed free-time date, a supplier paid twice, a landed cost nobody trusts, and what fixes each.
Short answer: An import business has outgrown its spreadsheet when the file starts costing money: deadlines learned from the invoice, a supplier paid twice, a landed cost nobody trusts, and a business that stops when one person is out. Every sign has one cause: the container has no single record.
An import business has outgrown its spreadsheet when the file starts costing money. The six signs are operational, not technical: a demurrage bill you learned about from the invoice, a supplier paid twice or paid short, a landed cost nobody trusts, the same number typed three times, customers asking you where their cargo is, and a business that stops when one person is out. Every one of them has the same cause. The container has no single record, so each piece of it lives somewhere else.
Why it matters: each sign has a price, and the price arrives late. A free-time date missed by three days is a few hundred dollars. A supplier overpayment is the deposit you will spend a month recovering. A landed cost nobody trusts is a price list built on a guess, on every product, all year.
How the scattered system happens
Nobody chooses it. The first containers get a spreadsheet because a spreadsheet is enough. Supplier conversations move to WhatsApp because that is where the supplier answers. Bills of lading and packing lists arrive as email attachments and stay there. The accounting package sees the shipment when the invoice is booked, weeks after anything could be decided.
Three tools, each holding a piece, none holding the whole. The person who built the spreadsheet becomes the only one who can answer a question about a container, and the business runs on their memory. The six signs below are what that looks like from the outside.
Sign 1: you learned about a deadline from the invoice
Free time at the terminal ends on a date. Demurrage accrues per container per day after it, at the rate in the terminal or carrier tariff. The date exists the day the container is discharged. In a scattered system it is in an email from the broker, or in nobody's file at all, and the first time anyone sees it is on the bill.
The bill can be late by design. Under the Federal Maritime Commission's billing rule, a carrier or terminal has to issue a demurrage or detention invoice within 30 calendar days of the last day the charge was incurred, and the invoice has to show the container number, the free-time start and end dates, and the specific dates the charges accrued. So the invoice tells you exactly which date was missed, up to a month after it could have been acted on.
The larger cost sits behind it. Cargo may stay at the place of unlading only until the fifteenth calendar day after landing; after that it goes to a general-order warehouse at the consignee's risk and expense. A container nobody was watching does not just accrue demurrage. It can leave the terminal in a direction you did not choose.
What fixes it: the last free day recorded on the container's record the day it is known, and one person whose job on Monday morning is to read the list of containers with a free day this week. Software can put the date there automatically from the carrier's events; a spreadsheet can hold it too, if someone types it in and someone else reads it.
Sign 2: a supplier was paid twice, or paid short
The deposit is paid against the proforma. The balance is paid against the final commercial invoice. Between the two, quantities and prices change: a line dropped, a price renegotiated, a short pack. When the proforma is a PDF in one inbox and the final invoice is a PDF in another, the balance is calculated from whichever one the person paying has open.
The result is a supplier paid the full original amount for a shipment that was cut, or a balance paid short because the deposit was never matched to the right proforma. Either way there is a reconciliation call with a supplier in another country, in the other language, about a number that was correct on the day it was typed.
What fixes it: the deposit sits on the same record as the proforma it was paid against, and the final invoice is compared line by line to that proforma before the balance is released. The comparison is the control, and it only works when both documents are on the container.
Sign 3: a landed cost nobody trusts
Ask three people what a product from the last container cost per unit and you will get three numbers. One used the purchase order price. One added freight. One divided by the quantity ordered rather than the quantity received.
Illustrative figures. A container of tile: goods $16,560, freight $2,450, insurance $180, duty $1,408, brokerage $325, drayage $640, two days of demurrage $310. Total $21,873. Divided by the 1,800 square metres ordered, $12.15. Divided by the 1,782 that arrived undamaged, $12.27. The second number is the true cost; the first is the one in the price list, because the count against the packing list never made it into the file.
The seven lines that make up landed cost arrive over weeks, and the last ones arrive after the file is closed. The 7-line formula is simple. What a spreadsheet cannot do is keep accepting lines against a container that somebody has already marked done.
What fixes it: every cost attached to the container it belongs to, whenever it arrives, and the per-unit cost recalculated from what was received. When the demurrage invoice shows up six weeks late, it lands on the right container and the price list moves.
Sign 4: the same number typed three times
The container number is typed into the tracking sheet, then into the accounting system, then into the email to the customer. One of the three has a transposed digit, and now tracking and accounting refer to different boxes. The invoice total is typed from the PDF into the payment file and again into the ledger. The purchase order quantity is typed into the proforma check and again into the receiving sheet.
Each retype is a place for a number to drift, and there is no way to tell which copy is right except by going back to the document. In a scattered system, going back to the document means asking the one person who knows which email it is in.
What fixes it: the number is entered once, on the container's record, and every other surface reads from it. The commercial invoice, the packing list and the bill of lading live on that record as files, so the source is one click away rather than one person away.
Sign 5: customers ask you where their cargo is
If you sell what you import, or forward it on to a customer in Latin America, the question "where is my container?" arrives by WhatsApp, several times a week, and someone answers it by looking up the carrier's site and typing the answer back. The answer is right at the moment it is sent and stale an hour later.
This one is a sign of growth, and it is the first one customers see. A distributor who answers status questions by hand has an operations lead who spends part of every day as a call centre.
What fixes it: a status the customer can read themselves, from the same record the operations team works on. Whether that is a portal or a scheduled email matters less than the fact that it comes from the record and not from a person.
Sign 6: the business stops when one person is out
The spreadsheet has an owner. When that person is on holiday, sick or has left, nobody can say which containers are open, what each one still needs, or what has been paid. The knowledge was in the file's structure and in their head, in roughly equal parts.
This sign has a compliance edge. Records relating to an entry have to be kept for five years from the date of entry, and a business that cannot find the packing list from last spring because it was attached to an email thread in a former employee's inbox has a problem that is bigger than one container.
The person who keeps the spreadsheet leaves, and the business goes with them. Every owner who has hired a first operations manager has felt some version of this on the new hire's first day, when the training consisted of opening a file and explaining what each colour meant.
What fixes it: the record exists outside any one person. A new hire opens the list of containers, sees what each one is waiting for, and starts working. The explanation of what the colours mean is not needed because there are no colours.
The six signs, side by side
| Sign | What it costs | What fixes it |
|---|---|---|
| A deadline learned from the invoice | Demurrage per day, general order after day 15 | The last free day on the record, read weekly |
| A supplier paid twice or short | The overpayment, and the call to recover it | Deposit and final invoice on the same record as the proforma |
| A landed cost nobody trusts | A price list built on the wrong number | Every cost on its container, divided by units received |
| The same number typed three times | A transposed digit found weeks later | Enter once, read everywhere, documents attached |
| Customers asking where their cargo is | An operations lead working as a call centre | Status read from the record, not relayed by a person |
| The business stops when one person is out | Weeks of recovery, records nobody can find | The record exists outside anyone's head |
What a system of record changes
The phrase sounds like an accounting term. For an import business it means one thing: the container is the record. The purchase order, the proforma, the deposit, the bill of lading, the packing list, the customs entry, every cost and every payment attach to the container they belong to, and nothing about that container is typed anywhere else.
The six signs go away for the same reason they appeared. The free day is on the record. The proforma and the final invoice are on the record. The costs land on the record after the file would have been closed. The number is entered once. The customer reads the record. The new hire reads the record.
This is also why the record has to be the container and not the invoice or the ledger. Accounting software is organised around the chart of accounts, and it sees a shipment when the invoice is booked. An importer's day is organised around boxes in transit, and the decisions that cost money happen before any invoice exists.
When you do not need it yet
A system of record is not the first thing an importer needs, and buying one too early replaces a working spreadsheet with a half-configured system nobody updates.
You are probably fine with a spreadsheet when:
- One person owns every container from purchase order to final payment, and that person is not leaving.
- Every file stays open until the last invoice arrives, and someone actually goes back and posts a late demurrage bill against the right container.
- Nobody sells from the landed cost in the file without checking it against the received count.
- Your customers do not ask for status, or you have so few shipments that answering by hand is minutes a week.
If all four hold, keep the file and keep the discipline. The Container Control Method works on paper. The signs in this post are what it looks like when one of the four stops holding, and they usually stop holding one at a time, quietly, which is why the invoice is often the first anyone hears of it.
In practice
Take your open containers, all of them, and for each one answer three questions on one page: what stage is it at, what is the last free day, and what is still owed on it. If the answers take a morning to assemble, that morning is the cost of the scattered system, and it is being paid every week by whoever assembled it.
Then pick the sign that has cost you most in the last year. For most importers it is the first or the third: a free-time date learned from the invoice, or a price list built on the purchase-order cost. Fix that one on the container record you have, even if the record is still a spreadsheet: the last free day in its own column, read every Monday, or the received count next to the ordered count, with the per-unit cost divided by the first.
When the discipline stops depending on one person, move the record somewhere that enforces it. Clasto keeps that record on the container: purchase order, supplier invoices, documents, landed cost per product and payments on one record, in English and Spanish, with a portal where customers read the status themselves. The record matters more than the tool. An importer who can answer the three questions in a minute, for any container, has already outgrown the spreadsheet in the way that counts.
Frequently asked
How many containers a month before a spreadsheet stops working?
There is no number. The spreadsheet fails when more than one person needs to update it, or when a cost arrives after the file was closed. A company moving three containers a month with two people editing the same file can be past the limit; one person moving eight can be fine.
Is the fix just a better spreadsheet?
Sometimes. If one person owns every container and closes each file only after the last invoice, a disciplined spreadsheet holds up. The signs in this post appear when that discipline depends on one person's memory.
What is a system of record for an import business?
One place where each container has a single record and everything about it, the purchase order, invoices, documents, costs and payments, is attached to that record rather than typed again somewhere else. The record is the source; every report is a view of it.
What does a missed free-time date actually cost?
Demurrage accrues per container per day after free time ends, at the rate in the terminal or carrier tariff. The invoice must reach you within 30 calendar days of the last day charged, so the bill can arrive weeks after the container left the port.
Do I need software before I hire my first operations person?
You need a record that the new hire can read without you. Whether that record lives in software or in a well-kept file matters less than whether it exists before they start.