BuiltByEstradaBook a call

Grower Settlement Workbook

Produce and Cold Chain line

Settle consignment lots with your growers: every sale, commission, freight, cooling, inspection and other charge, the net per carton and the balance after advances. The settlement prints in US dollars with the peso amount at the exchange rate and date you choose, and each lot shows its PACA due date.

Excel and Google Sheets workbook, English and Spanish

Fare

$29

founding price until January 31, 2027 · then $47

Secure checkout by Stripe, which adds sales tax where it applies. You download the file as soon as you pay.

Not what you needed? Write to us within 30 days of purchase and we refund you in full.

Grower-Settlement-Workbook.zipSCREENSHOTS · full version
Grower Settlement Workbook: the Lots tab, with EXAMPLE data
Lots: tab with EXAMPLE data See the whole tab
Grower Settlement Workbook: the Sales tab, with EXAMPLE data
Sales: tab with EXAMPLE data See the whole tab
Grower Settlement Workbook: the Settlement tab, with EXAMPLE data
Settlement: tab with EXAMPLE data See the whole tab

Screenshots of the full version, taken from the real file. Every number in them is an EXAMPLE.

Download the free version (.xlsx) ↓

Free file: the Landed Cost per Carton calculator. This product comes as a full version only. See what each one has

What you do, what the sheet does

YOUTHE SHEET
You log each sale from a lotIt adds up gross sales and the average price
You type your chargesIt gives the net and the net per carton
You type the exchange rate and its dateThe settlement shows the balance in pesos too
The final sale date goes inIt shows the PACA due date and flags late lots

What the full version has

  • Growers tab with contact and payment method
  • Lots tab: cartons, sales, charges, net, net per carton, advances, balance and status
  • Sales tab with credits and adjustments
  • Settlement: one page for the grower in dollars and pesos
  • Totals by grower with the unpaid balance
  • PACA due date for consignment on every lot
  • English and Spanish versions

Who it is for

Distributors, brokers and commission merchants who sell consignment lots for growers in Mexico and Texas and settle in dollars.

Example prices say EXAMPLE. You enter your own once on the prices tab.

Free version and full version

The free file is the Landed Cost per Carton calculator, a small workbook that shows how BuiltByEstrada sheets work. This product is the full version, in English and Spanish.

FREE FILE (.XLSX)

  • Landed cost per carton for one item
  • A table to compare up to 5 items
  • English and Spanish files
Download the free version (.xlsx) ↓

FULL VERSION · $29

  • 5 tabs plus a Start here page
  • Room for 40 growers, 150 lots and 600 sales
  • English and Spanish files
Buy the full version →

Made by BuiltByEstrada in McAllen, Texas. In English and Spanish.