Stock Ledger Report

How the Stock Ledger works

The Stock Ledger shows stock movements that matter for stock reporting.

The report tries to show stock in the smallest practical units.

That means:

• single cans usually stay as single cans
• cartons and packs are usually converted into the number of single cans or bottles inside them
• mix packs are usually converted into the items inside the mix pack
• O 現在 (Remaining Total) is the running balance after each row

Rule of thumb

• normal stock movements are broken down
• linked transform actions are excluded

In other words:

• normal incoming, returns, fulfilled stock, report-as-sold stock, and discarded stock usually appear in the smallest units
• linked repackaging and linked mix pack package / unpackage actions do not appear as stock movement rows on this page

What goes into each column

B 詰口 (Incoming)

Used when stock is added into a sales channel as normal incoming stock.

Example: adding single cans

Date	SKU	B Incoming	O Remaining
2026-03-16	BIGI-B301	24	124

Why:

• This example assumes the opening balance was 100.
• 100 + 24 = 124.

Example: adding cartons

Date	SKU	B Incoming	O Remaining
2026-03-16	BIGI-B301	48	148

Why:

• This example assumes the opening balance was 100.
• If you add 2 cartons of 24, the report usually shows 48 single cans.
• 100 + 48 = 148.

Example: adding mix packs

If 1 mix pack contains:

• 2 x BIGI-B301
• 2 x BISS-B301

and you add 3 mix packs, the report can look like this:

Date	SKU	B Incoming	O Remaining
2026-03-16	BIGI-B301	6	106
2026-03-16	BISS-B301	6	86

Why:

• This example assumes the opening balances were 100 BIGI-B301 and 80 BISS-B301.
• 3 mix packs becomes 6 BIGI-B301 and 6 BISS-B301.
• 100 + 6 = 106
• 80 + 6 = 86

D 戻入れ / E 戻入れの理由 (Return / Return Reason)

Used when stock comes back into stock from a return.

Example: returned single cans

Date	SKU	D Return	E Reason	O Remaining
2026-03-16	BIGI-B301	2	Customer return	102

Why:

• This example assumes the opening balance was 100.
• 100 + 2 = 102.

Example: returned carton

Date	SKU	D Return	E Reason	O Remaining
2026-03-16	BIGI-B301	24	Customer return	124

Why:

• This example assumes the opening balance was 100.
• 1 carton of 24 is usually shown as 24 single cans.
• 100 + 24 = 124.

Example: returned mix pack

If 1 mix pack contains:

• 2 x BIGI-B301
• 2 x BISS-B301

the report can look like this:

Date	SKU	D Return	E Reason	O Remaining
2026-03-16	BIGI-B301	2	Customer return	102
2026-03-16	BISS-B301	2	Customer return	82

Why:

• This example assumes the opening balances were 100 BIGI-B301 and 80 BISS-B301.
• 1 mix pack becomes 2 BIGI-B301 and 2 BISS-B301.
• 100 + 2 = 102
• 80 + 2 = 82

G 課税移出 (Outgoing)

Used when stock leaves because it was fulfilled or reported as sold.

Example: fulfilled singles

Date	SKU	G Outgoing	J Order	O Remaining
2026-03-16	BIGI-B301	6	#1001	94

Why:

• This example assumes the opening balance was 100.
• 100 - 6 = 94.

Example: fulfilled carton

Date	SKU	G Outgoing	J Order	O Remaining
2026-03-16	BIGI-B301	24	#1002	76

Why:

• This example assumes the opening balance was 100.
• 1 carton of 24 is usually shown as 24 single cans.
• 100 - 24 = 76.

Example: fulfilled mix packs

If 1 mix pack contains:

• 2 x BIGI-B301
• 2 x BISS-B301

and you fulfil 2 mix packs, the report can look like this:

Date	SKU	G Outgoing	J Order	O Remaining
2026-03-16	BIGI-B301	4	#1003	96
2026-03-16	BISS-B301	4	#1003	76

Why:

• This example assumes the opening balances were 100 BIGI-B301 and 80 BISS-B301.
• 2 mix packs becomes 4 BIGI-B301 and 4 BISS-B301.
• 100 - 4 = 96
• 80 - 4 = 76

N 腐敗・廃棄 (Discarded)

Used when stock is removed without a sale, such as damage, breakage, or waste.

Example: discarded singles

Date	SKU	N Discarded	O Remaining
2026-03-16	BIGI-B301	3	97

Why:

• This example assumes the opening balance was 100.
• 100 - 3 = 97.

Example: discarded carton

Date	SKU	N Discarded	O Remaining
2026-03-16	BIGI-B301	24	76

Why:

• This example assumes the opening balance was 100.
• 1 carton of 24 is usually shown as 24 single cans.
• 100 - 24 = 76.

Example: discarded mix pack

If 1 mix pack contains:

• 2 x BIGI-B301
• 2 x BISS-B301

the report can look like this:

Date	SKU	N Discarded	O Remaining
2026-03-16	BIGI-B301	2	98
2026-03-16	BISS-B301	2	78

Why:

• This example assumes the opening balances were 100 BIGI-B301 and 80 BISS-B301.
• 1 mix pack becomes 2 BIGI-B301 and 2 BISS-B301.
• 100 - 2 = 98
• 80 - 2 = 78

O 現在 (Remaining Total)

This is the running total after each row.

Example:

Step	Change	O Remaining
Opening stock	-	100
Incoming	+48	148
Fulfilled	-6	142
Discarded	-3	139

Why:

• The remaining total starts from the opening stock.
• Each row then adds to it or subtracts from it.
• 100 + 48 - 6 - 3 = 139.

What repackaging does

Sales-channel repackaging

Linked sales repackaging itself is not shown as an incoming or discard row in the Stock Ledger.

Example:

• You repackage 24 single cans into 1 carton in the same sales channel.

You will not see a row like this:

Date	SKU	B Incoming	N Discarded
2026-03-16	BIGI-B301	24	24

Why:

• The repackaging action is a linked transform.
• Linked transforms are excluded from the Stock Ledger page.

The same applies if you unpackage 1 carton back into 24 singles.

What mix pack packaging does

Mix pack package / unpackage actions

Linked mix pack package / unpackage actions are also not shown as incoming or discard rows in the Stock Ledger.

Example:

• You package:
  • 2 x BIGI-B301
  • 2 x BISS-B301
  • into 1 mix pack

You will not see rows like this:

Date	SKU	B Incoming	N Discarded
2026-03-16	BIGI-B301	2	2
2026-03-16	BISS-B301	2	2

Why:

• The package / unpackage action itself is a linked transform.
• Linked transforms are excluded from the Stock Ledger page.

Quick summary

The Stock Ledger shows:

• normal incoming stock
• returns
• fulfilled stock
• report-as-sold stock
• discarded stock

The Stock Ledger usually shows stock as:

• the smallest single units
• or, for mix packs, the items inside the mix pack

The Stock Ledger does not show:

• linked sales repackaging rows
• linked mix pack packaging rows
• linked mix pack unpackaging rows

Generating worksheet (tab) names

Worksheet names are generated with the following format:

• {sku} {product title}

Constrants

Any invalid characters will be substituted with -
The worksheet name will be truncated to 31 characters
If the worksheet name has been used, it will be appended with (n) suffix

Example

Example worksheet title that breaks all the rules

• sku: IPAG?-C301
• product title: Double Indian Pale Ale of the Gods?

Worksheet name:

• from: IPAG?-C301 Double Indian Pale Ale of the Gods?
• to: IPAG--C301 Double Indian Pale A
  If this worksheet name is already taken (which should not be possible):
• to: IPAG--C301 Double Indian Pal(1)

Columns

A 年月日 (Date)

B -> F 受入れ (Incoming)

In Yellow

B 詰口 (Incoming Quantity)

C 未納税移入 (Non-excise Incoming)

D 戻入れ (Return)

E 戻入れの理由 (Return Reason)

F 移入 (TODO)

G -> M 払出し (Outgoing)

In Blue

G 課税移出 (Tax Transfer Quantity)

H (区分) (Customer Type)

eg.,

• 小売
• 卸
• 一般

I (店名) (Customer Name)

eg.,

• B2B
• B2C
• name

J オーダー番号 (Order name)

K 未納税移出 (Non-excise outgoing)

L 輸出 (Export)

M 詰替え (Repackaging)

N 腐敗・廃棄 (Discarded)

O 現在 (Remaining Total)

Incoming Items

Includes:

• Incoming
• Return

Incoming

A 年月日 (Date)

B 詰口 (Incoming Quantity)

O 現在 (Remaining Total)

Return

A 年月日 (Date)

D 戻入れ (Return quantity)

E 戻入れの理由 (Return Reason)

O 現在 (Remaining Total)

Outgoing Items

Includes:

• Discarded Stock
• Fulfilled
• Report as sold

	G (Tax Transfer Qty)	H (Customer Type)	I (Customer Name)	J (Order Name)	N (Discarded)	R (Event Type)
Discarded
Fulfilled
Report as sold

Discarded

A 年月日 (Date)

N 腐敗・廃棄 (Discarded)

O 現在 (Remaining Total)

R (Event type description)

Fulfilled

A 年月日 (Date)

G 課税移出 (Tax Transfer Quantity)

H (区分) (Customer Type)

I (店名) (Customer Name)

J オーダー番号 (Order name)

O 現在 (Remaining Total)

Report as sold

A 年月日 (Date)

G 課税移出 (Tax Transfer Quantity)

J オーダー番号 (Note)

O 現在 (Remaining Total)