Key takeaways
- Every box is tied to a sender, consignee and sailing.
- Balances are tracked per box, not per remittance.
- Missing required documents surface before arrival.
- Each container has its own computed margin.
A forwarder sells trust. A family abroad hands over a box packed for months, and the business promises it will reach a specific house in a specific barangay. The records problem is that the box, the money and the paperwork all move separately: the box travels by container, the payment is remitted from abroad, and the packing list arrives by message. BalikbayanDesk PH keeps the three attached to one box identifier from booking to doorstep.
One box, one identifier
Each box records its sender, its consignee, its sailing and the freight rate for its size. The total charge is that rate plus the zone surcharge, so a delivery to Argao or Bohol is priced for what it actually costs.
Because the consignee is a record rather than a scribble on the lid, the delivery address, province and zone are already known when the container is pulled out.
Payments settle per box, not per sender
A sender with four boxes usually pays in one remittance. Recording that against each box lets the paid amount and balance stay correct per box.
The release check then reads Released with balance whenever a box marked Delivered still carries an unpaid amount, which is the single most common way a forwarder loses money quietly.
Documents before the ship arrives
Packing lists, sender identification and consignee identification are logged per box and marked required or optional. Anything required but not submitted reads Missing.
That list is worth reading at cutoff rather than at the port, because a missing packing list found on arrival delays the whole consolidated container, not one box.
The container is the profit centre
The sailing carries the freight cost quoted for the container. Every box billed against it adds to the freight billed, and customs, trucking, ferry and warehouse expenses are tagged to the same sailing.
Gross margin and margin percent then say whether the container was worth running, and the margin check labels it Healthy, Thin or Loss so a badly filled sailing is obvious before the next one is booked.
Review exceptions every week
Resolve duplicate IDs, missing links, overdue balances, negative amounts, and open operational items in CHECKS before using the dashboard for decisions.
BalikbayanDesk PH Private Google Sheets Web App is designed for use with a Google account, Google Sheets, and Apps Script, using owner-only deployment by default.
No Bureau of Customs filing or electronic manifest submission, no carrier or shipping line booking, no live vessel tracking, no courier or rider dispatch app, and no automatic SMS to consignees.
Frequently asked questions
Does it file anything with Customs?
No. It keeps your own record of which documents each box has and which are still missing. Filing and brokerage stay outside the workbook.
Can one sender pay for several boxes at once?
Yes. Record the remittance as separate payment rows against each box, and every box keeps its own correct balance.
How is a provincial delivery charged?
The consignee carries a delivery zone, and the box carries a zone surcharge on top of the size rate. Both are yours to set.
Does this replace official records?
No. No Bureau of Customs filing or electronic manifest submission, no carrier or shipping line booking, no live vessel tracking, no courier or rider dispatch app, and no automatic SMS to consignees.
