Skip to main content
BeanFlux
PURCHASE SETTLEMENTS

Purchase settlements with no double entry.

Scale weight, yield factor, withholdings and advances all discounted. The signature-ready document comes out of the system — not out of someone’s spreadsheet.

SETTLEMENT · GRN-2026-0385
NET WEIGHT4,775 kg
YIELD FACTOR87
WITHHOLDINGS−COP 81,100
NET PAYABLE3,621,400 COP
CONFIGURABLE WITHHOLDINGSAUTOMATIC ADVANCESINSTANT PURCHASE RECORD
THE PROBLEM

Without a system, every settlement is a manual exercise

Settling a coffee purchase in Colombia means more than multiplying kilos by price. Trading companies know it:

01

Every settlement is built by hand, step by step.

Gross weight, tare, yield factor, base price, withholdings. One mistake in any step and the document is wrong — and you start over.

02

Withholdings live in a separate spreadsheet.

Income-tax withholding, municipal-tax withholding, coffee levy — in another file, calculated by hand. They don’t always match what applies to the supplier.

03

Advances sit in another file — if they were recorded at all.

At settlement time, the amount to discount depends on someone remembering to have written it down. Memory is not a control system.

04

The purchase record is generated in Word. From an old template.

Copy and paste, fill in the fields, check that the numbers add up. Fifteen minutes per settlement, multiplied by every purchase of the day.

HOW IT WORKS

From the scale to the finished document, in five steps

The purchase data is entered once and the system builds the complete settlement. No intermediate spreadsheets.

1

Weight comes in from the scale

Gross weight, number of bags and tare. The system calculates net weight without anyone doing it by hand.

2

The yield factor sets the net price

The yield factor was already recorded during the quality stage. The settlement pulls it in automatically and calculates the coffee weight and price to be paid.

3

Withholdings are applied by supplier

Income-tax withholding, municipal-tax withholding, coffee levy, stamp duty — configured by supplier type. The system applies them without anyone having to remember them.

4

Advances are discounted automatically

If the supplier has active advances, the system discounts them from the total before calculating the net payable. No parallel spreadsheets.

5

The purchase record comes out ready

With one click: the document with lot, quality, net weight, yield factor, price, withholdings, advances and net payable. Ready to print and sign.

Settlement — GRN-2026-0385Pending signature
Gross weight4,820 kg
Tare (64 bags × 0.7 kg)−44.8 kg
Yield factor (87)89.3%
Income-tax withh. 1.5%−COP 18,600
Coffee levy−COP 62,500
Advance ANT-2026-0039−COP 800,000
Net payable
3,621,400COP
HOW BEANFLUX SOLVES IT

From the scale to the document, with no steps in between

BeanFlux generates the complete settlement at the moment of purchase. The data is entered once and flows all the way to the final document.

Automatic settlement

Record the purchase with weight, quality and supplier. The system applies the yield factor, calculates the net price and generates the complete settlement with one click.

Configurable withholdings

Define the withholdings that apply by supplier type: income-tax withholding, municipal-tax withholding, coffee levy, stamp duty. The system applies them automatically as appropriate.

Advance control

Record advances given to producers and collectors. At settlement, the system automatically discounts the pending balance. No parallel files.

Signature-ready purchase record

Generate the record with every data point: supplier, lot, quality, net weight, yield factor, unit price, withholdings, advances and net payable. Ready to print and sign.

Let the system settle for you

We’ll show you how BeanFlux generates settlements, applies withholdings and controls advances in a 20-minute demo.

Book a demo →
20 MINUTES · NO SALES PITCHES