Key takeaways
- One catch receipt per boat delivery, per species.
- Sales point back at the receipt, so the kilos reconcile.
- Mark a cost deductible only if the consignor agreed to it.
- Remit from CONSIGNOR REMITTANCE, not from a notebook.
A consignacion trader handles other people's fish and other people's money on the same morning. Kilos arrive before dawn, are sold in a dozen lots at different prices, and the boat owner arrives at noon asking for a number. IsdaDesk PH keeps the catch receipt as the anchor: kilos received, kilos sold, sales value, commission, and the ice and hauling that were agreed as deductible. The remittance that comes out is a figure both sides can walk through line by line.
Register consignors with their rate
Each boat owner is listed once with the boat name, the landing site, and the commission rate agreed with them. That rate drives every settlement, so it is never renegotiated from memory at the table.
Species are listed with a local name and a typical price per kilo, which keeps the morning's pricing consistent across whoever is manning the stall.
Receive the catch by receipt
A catch receipt records the date, the consignor, the species, and the kilos received. It is the single row the boat owner will ask about later.
Kilos sold and sales value are pulled back from the sale rows, and kilos unsold is what did not move, which is the spoilage conversation worth having the same day.
Sell against the receipt
Each sale records the receipt, the buyer, the kilos, and the price per kilo. Amount, payments, balance, and status are computed, so a restaurant on seven-day terms stays visible instead of being forgotten.
Because sales point at receipts, the kilos always reconcile, and the checks flag any sale pointing at a receipt that does not exist.
Deduct, remit, and show your work
Ice, hauling, and other costs are logged with the consignor they belong to and a Yes or No on whether they are deductible. Only the Yes rows reduce a share.
CONSIGNOR REMITTANCE shows sales value, commission, deductions, remittance due, amounts already remitted, and the balance to pay, which is the sheet to turn around and show.
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.
IsdaDesk PH Microsoft Excel Edition is designed for Microsoft Excel 2019 or newer on Windows or macOS.
No fisheries-licence or BFAR compliance, catch documentation or traceability certificates, weighing-scale or POS hardware links, cold-chain temperature logging, payroll or tax computation, and no official receipts.
Frequently asked questions
What if part of the catch does not sell?
Kilos unsold stays on the receipt. Only what actually sold contributes to sales value, commission, and the remittance.
Can commission differ per boat owner?
Yes. Each consignor carries their own rate, and the commission on their sales is computed with it.
Are ice and hauling always deducted?
Only when you tag the cost to that consignor and mark it deductible. Everything else stays a cost of the stall.
Does this replace official records?
No. No fisheries-licence or BFAR compliance, catch documentation or traceability certificates, weighing-scale or POS hardware links, cold-chain temperature logging, payroll or tax computation, and no official receipts.
