Home Get Help Goto App
Switch language: Dansk

Input-output balance

The report Input-output balance summarizes which lots with a certain certificate has gone in and out of production and inventory and shows the balance between in and out.

You can use the report for the organic inspection or for any other certification scheme that requires an input-output balance audit.

Where to find the report

  1. Click Production in the top menu.
  2. Select the Input-output balance in the section Reports in the drop-down menu.
  3. To select certification body, enter part of the name of the certification body in the field Certification Body and select it among your partners.
  4. Select a From Date as a minimum. If no To Date is selected, the period will run till Today.
  5. Click Apply.
  6. Use the buttons to the right above the table view the table in a printer friendly format or export to Excel.
  7. The button XLSX exports the current table to Excel. The button XLSX (All) exports all tabs in the report to Excel.

Tabs, rows and columns in the report

In the sections below, you can read about the individual tabs, rows and columns in the report.

Raw Material Balance

This table shows the different SKUs within the selected certification scheme, that you marked as Raw Material when you set up your SKU. Below the SKU Name in the table, you can see which Unit of Measure is used in the report (to the right).

The rows in the table show the following:

Beginning, stock-taking This is your stock-taking as it was in the beginning of the selected period.
+ Purchased, received This is what you purchased in the selected period and thus was added to your inventory.
+ Produced, received This is what you produced (out of raw materials) in the selected period and thus was added to your inventory.
- End, stock-taking This is your stock-taking in the end of the selected period. If you did not select a To Date, the period will run till Today.
= Estimated consumption This is the sum of your inventory in the beginning of the period and what you purchased and produced within the period minus your inventory in the end of the period.
- Sold, delivered This is what you sold in the period and which has been dispatched from the warehouse.
- Consumed, certified production This is what you have used for certified production within the period.
- Consumed non-certified consumption This is what you used of certified products in the non-certified production.
- Lost This is what you registered as lost within the period.
= Difference This is the difference between the caluculated (expected) consumption and the actual consumption. The difference should be zero. If the difference is positive or negative, it means that there is something that has not been accounted for, like loss that you did not calculate with.
Difference, percentage This is the difference in percentage.

RM: Stock Movements

This table shows Stock Movements for Raw Materials (RM).

The rows in this table show the SKUs within the selected certification scheme that you marked as Raw Material when you set up your SKU.

The rows show the following for each SKU:

End stock according to records This is your stock as it was by the end of the period before the selected period.
Adjustments related to stock-taking These are the adjustments you may have made as a consequence of the stock-taking by the end of the last period.
= Stock, beginning This is your stock at the beginning of the selected period.
Lots The following rows show the status each of the lots on the SKU.

The columns in the table show the following:

Lot The lots on stock per SKU.
Movement Date The date the lot went in or out of your inventory.
Order The order that moved the lot in or out of your inventory.
Certificates Here are the certificates you may have attached to the individual lot.
Units Shows which units (Lot Unit and Unit of Measure) you use to measure the individual SKU or lot.
Quantity, Lot Unit The quantity you moved in and out of your inventory calculated in lot units.
Quantity, UoM The quantity you moved in and out of your inventory measured in Units of measure.
Accumulated Indicates how much is in your inventory after the lot went in or out of the inventory.

Finished Good Balance

The rows in this table show the different SKUs within the selected certification scheme, that you marked as Raw Material when you set up your SKU. Below the SKU Name in the table, you can see which Unit of Measure is used in the report (to the right).

The rows show the following for each SKU:

Beginning, stock-taking This is your stock-taking as it was in the beginning of the selected period.
+ Purchased, received This is what you purchased in the selected period and thus was added to your inventory.
+ Produced, received This is what you produced (out of raw materials) in the selected period and thus was added to your inventory.
- End stock-taking This is your stock-taking in the end of the selected period. If you did not select a To Date, the period will run till Today.
= Estimated sales This is the sum of your inventory in the beginning of the period and what you purchased and produced within the period minus your inventory in the end of the period.
- Sold, delivered This is what you sold in the period and which has been dispatched from the warehouse.
- Consumed, certified production This is what you have used for certified production within the period.
- Consumed, non-certified production This is what you used of certified products in the non-certified production.
- Lost This is what you registered as lost within the period.
= Difference This is the difference between the caluculated (expected) consumption and the actual consumption. The difference should be zero. If the difference is positive or negative, it means that there is something that has not been accounted for, like loss that you did not calculate with.
Difference, percent This is the difference in percentage.

FG: Stock Movements

This table shows Stock Movements for Finished Goods (FG).

The rows in this table show the SKUs within the selected certification scheme that you marked as Finished Goods when you set up your SKU.

The rows show the following for each SKU:

End stock according to records This is your stock as it was by the end of the period before the selected period.
Adjustments related to stock-taking These are the adjustments you may have made as a consequence of the stock-taking by the end of the last period.
= Stock, beginning This is your stock at the beginning of the selected period.
Lots The following rows show the status each of the lots on the SKU.

The columns in the table show the following:

Lot The lots on stock per SKU.
Movement Date The date the lot went in or out of your inventory.
Order The order that moved the lot in or out of your inventory.
Certificates Here are the certificates you may have attached to the individual lot.
Units Shows which units (Lot Unit and Unit of Measure) you use to measure the individual SKU or lot.
Quantity, Lot Unit The quantity you moved in and out of your inventory calculated in lot units.
Quantity, UoM The quantity you moved in and out of your inventory measured in Units of measure.
Accumulated Indicates how much is in your inventory after the lot went in or out of the inventory.

Recipes

This table shows the relation between raw materials and finished goods.

The rows in the table show the recipes that are used in the production of within the selected certification scheme.

The columns in the table show the following:

Recipe  
Description  
Actual production  
Expected share of finished good (%)  
Expected quantities used in production  

Input / Output

The rows in this table show the different SKUs within the selected certification scheme, that you marked as Raw Material when you set up your SKU. Below the SKU Name in the table, you can see which Unit of Measure is used in the report (to the right).

The rows show the following for each SKU:

Beginning, stock-taking This is your stock-taking as it was in the beginning of the selected period.
+ Purchased, received This is what you purchased in the selected period and thus was added to your inventory.
+ Produced, received This is what you produced (out of raw materials) in the selected period and thus was added to your inventory.
- Sold, delivered This is what you sold in the period and which has been dispatched from the warehouse.
- Consumed, non-certified production This is what you used of certified products in the non-certified production.
- Lost This is what you registered as lost within the period.
- End stock-taking This is your stock-taking in the end of the selected period. If you did not select a To Date, the period will run till Today.
= Available for own production (certified)  
- Estimated consumption based on recipes  
= Difference This is the difference between the calculated (expected) consumption and the actual consumption. The difference should be zero. If the difference is positive or negative, it means that there is something that has not been accounted for, like loss that you did not calculate with.
Difference, procent This is the difference in percentage.
×

Tilmeld dig nyhedsbrev

Få de nyeste vejledninger i din indbakke.

Tutorials

Get Started

Import & Export of Data

Integrations

Master Data

Settings

Order Management

Inventory Management

Financials

Reports

Miscellaneous