Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.mathership.com/llms.txt

Use this file to discover all available pages before exploring further.

Inventory Ledger

The inventory ledger is the movement history of your ingredient stock. Every receipt, sales issue, waste entry, transfer, or stock count adjustment creates a ledger entry. These entries explain why the current stock balance changed.

What is the inventory ledger?

The ledger is a detailed record of stock movements. It helps you answer questions like:
  • Why did stock go down?
  • When was stock received?
  • Which order created this stock movement?
  • Which POS sale reduced stock?
  • Which stock count corrected the balance?
  • What is the current stock value?
  • Which storage unit was affected?

When to use the ledger

Use the ledger when you want to:
  • Check the history of one ingredient
  • Investigate stock differences
  • Review recent inventory movements
  • Understand cost changes
  • Check which order or POS sale caused a movement
  • Verify receipts, waste, transfers, and adjustments

Ledger entries

Each ledger entry represents one inventory movement. A ledger entry can include:
FieldMeaning
IngredientThe ingredient affected
Storage unitWhere the stock changed
Transaction typeThe movement type
QuantityPositive or negative stock movement
Unit costCost per base unit
ValueTotal value of the movement
DateWhen the movement happened
SourceRelated order, stock count, transfer, or POS transaction

Positive and negative quantities

Ledger quantities can be positive or negative.
QuantityMeaning
PositiveStock increased
NegativeStock decreased
Examples:
MovementQuantity effect
Receiving an orderPositive
POS sales usageNegative
WasteNegative
Transfer outNegative
Transfer inPositive
Stock count correctionPositive or negative

Transaction types

Common ledger transaction types include:
TypeMeaning
RECEIPTStock was received into inventory
ISSUEStock was consumed, usually from sales or recipes
WASTEStock was removed as waste
TRANSFER_OUTStock was moved out of a storage unit or company
TRANSFER_INStock was received from a transfer
ADJUSTStock was corrected through a stock count

Viewing ledger history for an ingredient

To view the ledger history of an ingredient:
  1. Go to Inventory
  2. Open a storage unit
  3. Select an ingredient
  4. Open Ledger or Movement History
The ledger shows all movements for that ingredient in the selected storage unit.

Ledger summary

The ledger page can show summary values for the selected ingredient and storage unit. Typical summary values include:
SummaryMeaning
Current balanceCurrent stock quantity
Total receiptsTotal stock received
Total issuesTotal stock removed
Total entriesNumber of ledger movements
The summary may also show week-over-week changes, such as whether receipts or issues increased compared with the previous week.

Running balance

The ledger can show a running balance after each entry. This helps you understand how the stock level changed over time. Example:
DateTypeQuantityBalance after
01.04.2026RECEIPT+20 kg20 kg
03.04.2026ISSUE-4 kg16 kg
05.04.2026WASTE-1 kg15 kg
08.04.2026ADJUST+2 kg17 kg

Receipts

A receipt is created when ordered products are transferred into inventory. This usually happens after receiving a vendor order. Example:
Product orderedIngredient mappedLedger movement
2 boxes tomatoesTomatoesRECEIPT +20 kg
5 packs milkMilkRECEIPT +50 L
Receipts depend on product-to-ingredient mapping. If a product is not mapped, Mathership cannot correctly convert it into ingredient stock.

Issues

An issue is created when stock is consumed. This can happen through:
  • POS sales
  • Recipe usage
  • Manual stock issue logic
  • Imported sales data
Example:
Sales itemRecipe or mappingLedger movement
Ribeye steakUses 300 g ribeyeISSUE -0.3 kg
Tomato soupUses 150 g tomatoesISSUE -0.15 kg
POS-related stock usage depends on the connected POS system and the mappings configured in Mathership. The ledger keeps the movement history general, so it can support different POS integrations over time.

Waste

Waste entries reduce stock when ingredients are discarded. Use waste entries for:
  • Spoiled goods
  • Preparation loss
  • Breakage
  • Incorrect production
  • Returned or unusable stock
Example:
IngredientWaste reasonLedger movement
TomatoesSpoiledWASTE -2 kg
MilkExpiredWASTE -3 L

Transfers

Transfers move stock between storage units or companies. A transfer usually creates two ledger movements:
StepTransaction typeEffect
Ship transferTRANSFER_OUTStock decreases in source storage
Receive transferTRANSFER_INStock increases in target storage
Example:
MovementStorage unitQuantity
TRANSFER_OUTMain storage-10 kg
TRANSFER_INKitchen storage+10 kg

Stock count adjustments

When a stock count is posted, Mathership compares the counted quantity with the book quantity. If there is a difference, an adjustment entry is created. Example:
Book quantityCounted quantityAdjustment
12 kg10 kgADJUST -2 kg
8 L9 LADJUST +1 L
Stock count adjustments should be reviewed carefully. They correct the balance, but they do not explain the original cause of the difference.

Cost and value

Ledger entries can include cost information.
FieldMeaning
Unit costCost per base unit
ValueQuantity multiplied by unit cost
Inventory valueCurrent stock value based on ledger movements
For received goods, costs may come from the order or from a weighted average cost. For issues, waste, and adjustments, Mathership can use the current weighted average cost.

Weighted average cost

Weighted average cost helps value inventory when the same ingredient is received at different prices. Example:
ReceiptQuantityCost
Receipt 110 kg€5.00/kg
Receipt 210 kg€7.00/kg
The weighted average cost becomes €6.00/kg.
Cost calculations are only as accurate as the received prices and product mappings.

Source objects

A ledger entry can be linked to a source object. This helps you trace the movement back to its origin. Examples:
SourceMeaning
Order itemStock came from a received vendor order
Stock count lineStock was adjusted by a count
Transfer lineStock changed because of a transfer
POS transactionStock changed because of imported or connected sales data

POS source data

If a POS integration is used, ledger entries may include source data from the connected POS system. Depending on the integration, this can show:
  • POS item name
  • Amount sold
  • Sales value
  • Article or product ID
  • Order or transaction ID
  • Receipt or billing number
  • Sale date
This helps connect stock usage to actual sales.
The exact POS source fields can differ between integrations. Mathership keeps the ledger structure general so future POS systems can use the same movement history.

Reviewing recent movements

Recent movements can be shown on the inventory dashboard. They help you quickly check what changed recently. Typical recent movement data includes:
FieldMeaning
IngredientAffected ingredient
Storage unitAffected storage location
TypeTransaction type
QuantityStock movement
ValueInventory value change
DateMovement date

Filtering ledger data

Depending on the page, ledger data can be filtered by:
  • Company
  • Storage unit
  • Ingredient
  • Date range
  • Transaction type
  • Activity status
  • Current stock range
This is useful for reports and audits.

Common workflows

Investigate missing stock

  1. Open the ingredient
  2. Select the relevant storage unit
  3. Open the ledger
  4. Review recent ISSUE, WASTE, and ADJUST entries
  5. Check related source objects
  6. Correct mappings or stock counts if needed

Check if an order was received

  1. Open the order
  2. Check whether items were transferred to inventory
  3. Open the ingredient ledger
  4. Look for a RECEIPT entry
  5. Confirm quantity, cost, and storage unit

Review POS stock reduction

  1. Open the ingredient ledger
  2. Look for ISSUE entries
  3. Check the related POS source data
  4. Verify recipe, product, or POS mapping
  5. Correct mappings if stock usage is too high or too low

Correct stock with a count

  1. Start a stock count session
  2. Count the ingredient in the storage unit
  3. Post the count
  4. Review the created ADJUST ledger entry
  5. Check the new current balance

Best practices

Post movements in the correct storage unit

Always select the correct storage unit when receiving, wasting, transferring, or counting stock. Wrong storage units create confusing ledger histories.

Keep product mappings accurate

Product-to-ingredient mappings affect receipts and stock usage. Check:
  • Correct ingredient
  • Correct unit conversion
  • Correct packaging factor
  • Correct base unit

Keep POS mappings accurate

POS mappings affect how sales reduce ingredient stock. Check:
  • Correct POS item
  • Correct recipe or ingredient mapping
  • Correct portion size
  • Correct quantity multiplier
  • Correct storage unit logic

Review large adjustments

Large ADJUST entries can indicate:
  • Missing receipts
  • Incorrect POS mappings
  • Incorrect waste entries
  • Wrong storage unit selection
  • Counting mistakes

Use clear waste reasons

When posting waste, use clear reasons. Examples:
  • Expired
  • Spoiled
  • Preparation loss
  • Breakage
  • Returned from service

Check recent movements often

Recent movements help catch mistakes early. Review them regularly, especially after:
  • Large deliveries
  • Menu changes
  • POS import setup
  • Stock counts
  • Transfers between locations

Common problems

Stock balance looks wrong

Check:
  • Ledger entries for the ingredient
  • Correct storage unit
  • Recent stock count adjustments
  • Missing receipts
  • Duplicate receipts
  • POS issue entries
  • Waste entries

Receipt is missing

Check:
  • Order was received
  • Product was mapped to an ingredient
  • Storage unit was selected
  • Item was not already posted
  • Quantity received was greater than zero

Stock decreased unexpectedly

Check:
  • POS sales import
  • Recipe mapping
  • Waste entries
  • Transfer out entries
  • Stock count adjustments

Cost looks wrong

Check:
  • Order item prices
  • Unit cost overrides
  • Product mapping factor
  • Ingredient base unit
  • Weighted average cost history

Ledger entry has no source

Some entries may not have a detailed source object, especially manual or imported movements. Use date, transaction type, storage unit, and quantity to identify the likely cause.

Ingredients

Manage the ingredient master list used in ledger entries.

Storage Units

Manage storage locations where stock movements are recorded.

Receiving Orders

Receive vendor orders and create receipt ledger entries.

Stock Counts

Count stock and create adjustment ledger entries.

Waste

Post waste and reduce stock with waste ledger entries.

Transfers

Move stock between storage units or companies.

Inventory Reports

Analyze stock, movements, costs, and activity.

POS Integrations

Connect sales data to ingredient stock usage.