# SAP Physical Inventory Count Sheet Template

> Source: https://netray.co/tools/sap-physical-inventory-count-sheet-template
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Fill in a count plan and count sheet for SAP physical inventory (MI01, MI04, MI07) and export it as a document.

## Category

sap

## Erp

SAP S/4HANA

## Audience

- SAP MM consultant
- Warehouse manager
- Inventory controller

## Tool

**Kind:** template

**Output:** document

**Fields:**

#### Company name

**Key:** company

**Type:** text

**Default:** Acme Precision Ltd

#### Plant

**Key:** plant

**Type:** text

**Default:** 1000

#### Storage location

**Key:** sloc

**Type:** text

**Default:** 0001

#### Count date

**Key:** count_date

**Type:** date

**Default:** 2026-11-02

#### Count method

**Key:** method

**Type:** select

**Options:**

- Annual physical inventory
- Cycle counting
- Continuous inventory
- Inventory sampling

**Default:** Cycle counting

#### Freeze book inventory

**Key:** freeze

**Type:** select

**Options:**

- Yes, freeze book inventory on document creation
- No, count with movement allowed

**Default:** Yes, freeze book inventory on document creation

#### Counter name

**Key:** counter

**Type:** text

**Default:** R. Patel

#### Difference tolerance for auto-post

**Key:** tolerance

**Type:** text

**Default:** 2 percent of book value, maximum 500 per item

#### Scope notes

**Key:** notes

**Type:** textarea

**Default:** Class A items and all batch-managed raw materials. Quarantine and blocked stock counted separately.

**Blocks:**

#### Physical Inventory Count Plan

**Body:** Company: {{company}}
Plant: {{plant}}
Storage location: {{sloc}}
Count date: {{count_date}}
Method: {{method}}
Book inventory: {{freeze}}

#### Scope and Rules

**Body:** {{notes}}

Counter: {{counter}}
Posting tolerance: {{tolerance}}

#### SAP Step Sequence

**Body:** 1. MI01 create the physical inventory document (set the posting block or freeze flag as planned).
2. Print count sheets and issue them to counters.
3. MI04 enter count results, or MI09 if counting without a document reference.
4. MI20 print the difference list and have a supervisor review.
5. MI08 or recount for items above tolerance.
6. MI07 post differences to the stock and the inventory difference accounts.

#### Count Sheet

**Table:**

**Columns:**

- Item
- Material
- Description
- Batch
- Special stock
- Counted qty
- UoM
- Zero count

**Rows:**

**0:** 1

**0:** 2

**0:** 3

**0:** 4

**0:** 5

**0:** 6

#### Approvals

**Signatures:**

- Counter
- Recount verifier
- Warehouse manager
- Finance controller

**Notes:** Transaction codes and field names vary slightly by release and by whether you use Fiori apps. Confirm the posting tolerance with finance and the tolerance group configured for the user.

## Content

**Intro:** A physical inventory in SAP is only as clean as the paperwork behind it. This template builds a count plan and a printable count sheet so counters, supervisors and finance agree on scope, freeze rules and tolerances before the first document is created.

**Sections:**

#### How to use the template

**Body:** Enter plant, storage location, count date and the method you are running. Choose whether book inventory is frozen when the physical inventory document is created, because that decision controls whether goods movements can post during counting. Add scope notes such as which ABC classes, batch-managed materials or special stock types are included. The exported document gives you the plan, the SAP step sequence and a blank count sheet with room for batch, special stock indicator and a zero count flag.

**Bullets:**

- Print one sheet per bin or storage section
- Record the counter name for audit
- Use the zero count column for empty bins so they are not missed
- Attach the exported file to your inventory close checklist

#### The SAP process behind it

**Body:** The standard flow is create the document (MI01), enter counts (MI04), review differences (MI20), recount where needed, then post (MI07). Cycle counting uses an indicator on the material master (the cycle counting indicator, A B C and so on) to drive how often items come up. Continuous inventory counts different items on different days during the year, while annual inventory counts everything at once. Inventory sampling lets you extrapolate from a statistical sample, subject to your auditor accepting the method.

#### Reading differences before posting

**Body:** Differences post to the stock and to an inventory difference account, so each posting hits the P&L. Review the difference list sorted by value, not by quantity. A small quantity difference on a high value item deserves more scrutiny than a large one on fasteners. Check for unposted goods receipts, open transfer orders, in-transit stock and batch mix-ups before you accept a difference. Recount high value items with a second counter who has not seen the first count.

#### Common mistakes

**Body:** The most common failure is counting while goods movements are still posting without freezing, which creates false differences. The second is ignoring special stock such as consignment, project and subcontractor stock, which sits under separate stock categories. The third is posting differences without a tolerance review. Finally, do not forget blocked and quality inspection stock, which is counted as a separate stock type and will not match if you only count good stock.

**Cta:** If you want count variances, aged blocked stock and recount candidates pulled straight from your SAP data, Netray can build that as a read-only report.

**Faq:**

#### Which SAP transactions are used for physical inventory?

**Answer:** The core ones are MI01 to create the document, MI04 to enter count results, MI20 to print the difference list and MI07 to post differences. MI09 allows count entry without a document reference. Fiori apps cover the same steps in S/4HANA.

#### Should I freeze book inventory?

**Answer:** Freezing blocks goods movements for the material in that storage location until posting, which avoids false differences. It disrupts operations, so many sites freeze only short windows or use cycle counting with careful timing instead.

#### Can I count batch-managed materials in one line?

**Answer:** No. Batch-managed materials are counted per batch, so each batch needs its own item on the document and its own line on the count sheet. Missing a batch is a common cause of unexplained differences.

#### Does this template post anything to SAP?

**Answer:** No. It runs in your browser and produces a document. You still create and post the physical inventory documents inside SAP using your own authorizations.

## Search terms

sap physical inventory template, sap count sheet format, sap mi01 mi04 mi07 steps, sap cycle count plan, physical inventory document sap, sap stock take checklist, sap inventory count form

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json