Skip to content
Industries · Manufacturing · Coffee roasting

ERP for coffee roasters, built on ERPNext

One ERP for coffee roasters, from the green-bean sample to the cupping score and the wholesale order. You buy, roast, blend, pack and sell coffee in one system, so the stock and the accounts keep up with every step.

We have implemented ERPNext for coffee roasters in Egypt.
The process

From green bean to cup, in one system

1

Green beans

You receive each supplier lot into the green-bean warehouse.

2

Sample and grading

You measure and grade a sample of each lot before you approve or reject it.

3

Roasting

A work order sends green coffee to a roaster, then records the roasted quantity.

4

Cupping

The taster scores each roast, then accepts or rejects it.

5

Blending and packing

Operators blend the accepted coffee to its recipe and pack it.

6

Sales

You deliver each wholesale order and invoice it.

7

Accounts

Every movement carries its value into both stock and the ledger.

Problems we solve

What coffee roasters struggle with, and how the ERP answers

Every green-bean lot is different

Two lots of the same origin can still differ in crop year, processing, moisture and density. When that data stays in the buyer’s notebook, nobody can tie a roast back to the beans it came from.

Roasting loss hides in the stock

Green coffee loses weight in the roaster. Unless you compare green in with roasted out for every roast, the loss disappears into the stock figures.

Blends are recipes

A blend is a recipe of several coffees, and its cost moves whenever the recipe or the cost of one bean moves.

One coffee, many packs

The same roasted coffee leaves the roastery in several pack sizes, and the bags, labels and cartons are also stock.

The cupping table decides quality

A roast that fails at the cupping table should not reach a customer, and stored coffee still changes with moisture.

Wholesale orders need production behind them

A roaster sells to cafés, offices and shops, and an order often asks for coffee the roastery has not roasted or packed yet.

What we set up

What we set up in an ERP for coffee roasters

Seven things we have built or configured for roasters, each with its screen.

Green-bean sample register

Before you buy or use a lot, you record its sample: name, supplier, country of origin, crop year, processing method and grade. The record also holds moisture, water activity, density and colour degree, with quality readings taken from a template. You then approve or reject the sample, and the decision stays with the sample record.

Submitted green-bean sample record marked approved, with origin, crop year, processing, grade, moisture, water activity, density and a readings table, demo data
Green-bean sample, approved: supplier, crop year, processing, grade, country, colour, moisture, water activity and density, together with readings from the template

Roasting report: green in, roasted out

The roasting report puts green in next to roasted out for every roast, so you read the roasting loss roast by roast. For each work order and roaster, it lists the green coffee required, the green quantity actually transferred to the roaster and the roasted quantity produced, for the dates you choose.

Roasting report table listing roasting work orders with status, roasted item, roaster, roasted produced, green required and green transferred, demo data
Roasting report: per work order and roaster, the roasted quantity produced, the green quantity required and the green quantity transferred (column names in Arabic)

A roasting screen for the floor

Roasting staff work from one screen that lists the production orders waiting for each roaster, with the item, the status and the roasted quantity produced so far. From the list they create a roast for a work order, so nobody on the floor has to find their way through the full ERP menus.

Roasting screen table with three roasting orders, their green and roasted quantities, status badges, start or stop roasting buttons and a new job card button, demo data
Roasting screen: the orders in process on the roasters, with green and roasted quantities, start and stop buttons, as well as 'New Job Card' to create a roast (the app's column names are in Arabic)

A cupping score on every roast

A quality screen lists the roasts of an item. For each roast the taster records aroma, taste, aftertaste, acidity, body, balance and defects, then an overall score and a description, and marks the roast accepted or rejected.

Job card of a roast showing the cupping inspection template, the inspection date and a readings table ending with the score and the result, demo data
A roast's job card with the cupping template's readings, the overall score and the result 'accepted' (reading names are in Arabic)

Moisture and water activity in the warehouse

The team checks stored coffee on a cycle. Each check records the date, the item, the warehouse, the moisture level and the water activity, so the roaster has a history per warehouse instead of a paper log.

Submitted check record with date, item, warehouse, water activity and moisture level, demo data
Moisture and water-activity check of a green coffee in the green-coffee store (the app names this record 'Temperature Monitoring Cycle')
List of fourteen submitted moisture and water-activity checks with date, item and water activity, demo data
The list of checks across the green, roasted and packed coffee

Blend recipes and item coding

A new green coffee or blend starts as an item-coding request. For a blend, the request holds the recipe as a percentage of each coffee per kilogram and the roasted item group it belongs to, together with the item’s Egyptian e-invoice code. When you submit the request, the system creates the items and their bill of materials, and work orders then use that recipe.

Submitted item coding record of type blend with three roasted coffees and their share per kilogram, demo data
Item coding of a house blend: the share of each roasted coffee in one kilogram
Default bill of materials of the blend with three roasted coffee lines, quantities per kilogram, rates and amounts, demo data
The bill of materials created for the blend, including the quantity and cost of each roasted coffee

Blending and packing job cards

Blending and packing have their own screen. It lists the job cards with the work order, the production item, the workstation and the quantities, and lets the operator start and stop each job. When the operator starts a blend order from the screen, the roasted coffee moves to blending, and the operator then completes the blending job card on the same screen. Packing instead runs on standard ERPNext work orders, with a bill of materials for each pack.

Table of four job cards in progress on a packing line with work order, production item, quantity, completed quantity, status and start and stop buttons, demo data
Mixing and packing screen: job cards in progress with work order, item, quantity and workstation, and start and stop buttons

Screens show demo data.

Modules

ERPNext modules and integrations used

ERPNext modules

Bills of materials, work orders, job cards and workstations for roasting, blending and packing.

Warehouses for green, in-process and roasted coffee, as well as for packaging.

Green coffee and packaging from order to receipt.

Wholesale orders, deliveries and invoices.

Stock value, receivables and payables.

Integrations

E-invoice item codes kept on each item.

Stories

Where we have done it: coffee roasters in Egypt

Client name withheld

A specialty coffee roaster in Egypt

Coffee roasting with its own cafés · Egypt

One system from the green-bean sample to the cupping score.

What we set up
Client name withheld

A coffee roaster and packer in Egypt

Coffee roasting and packing · Egypt

Production, stock and accounts in one system.

What we set up

More screens: stock, lot ledger and wholesale orders

Three more screens from the ERP for coffee roasters, the stock and order views a roaster uses every day.

Roasting screen in the ERP for coffee roasters: a table with three roasting orders, their green and roasted quantities, status badges, start or stop roasting buttons and a new job card button, demo data
Roasting screen: the orders in process on the roasters, with green and roasted quantities, start and stop buttons, as well as 'New Job Card' to create a roast (the app's column names are in Arabic)
Stock balance report from the ERP for coffee roasters, listing green coffees, packaging and roasted coffees by warehouse with balance quantity, value and in and out quantities, demo data
Stock Balance: green, roasted, in-process and packaging stock by warehouse, with both quantity and value
Stock ledger filtered on one batch with a purchase receipt, transfers to the roasting work-in-progress store and repeated outgoing roast entries, demo data
Stock ledger of one green-bean lot: the receipt, then the transfers to the roaster and the green coffee taken by each roast
Orders screen table of draft wholesale orders with customer, item, delivery date, required, actual, reserved and produced quantities and a submit button, demo data
The app's orders screen: wholesale orders with the café or office, the item, and the required, in-stock, reserved and produced quantities (column names in Arabic)

Screens show demo data.

FAQ

Frequently asked questions about ERP for coffee roasters

Have you implemented ERPNext for coffee roasters before?

Yes, for coffee roasters in Egypt: the work ran from standard manufacturing, stock and accounts to roaster-specific records such as green-bean samples, roasting reports and cupping scores.

The roasting report lists, for each work order and roaster, the green coffee transferred to the roaster and the roasted coffee produced. The difference between the two is the loss for that roast.

Yes, the taster scores each roast on aroma, taste, aftertaste, acidity, body, balance and defects, gives it an overall score, then marks it accepted or rejected.

Yes, a blend is an item whose recipe is the percentage of each coffee per kilogram. That recipe is its bill of materials, while blending itself runs as an operation with its own work orders and job cards.

Both: purchasing, stock, manufacturing, sales and accounts are standard ERPNext. The sample register, the roasting and packing screens, cupping scores and the roasting report are additions that we built for roasters and then adapt to each one.

Yes, through our ETA e-invoicing integration. Each coffee item carries its e-invoice item code, either GS1 or EGS.

Frappe Certified Gold Partner

Running a roastery? Ask about a similar project

Tell us how you buy, roast, pack and sell, then we will show you how the same steps run on ERPNext.