VTC — Inventory Accuracy KPI

Period: Filter:

Inventory Accuracy

—

CC / GRMS Value

Monthly Progress

—

— / — classes

Quarterly Progress

—

— / — classes

Total Records

—

In selected period

Inventory Accuracy Trend — —

Monthly Completion %

Class Breakdown

Loading…

Freq.	Class	Description	Date	Assigned To	# Parts	# Adj.	GRMS Value	CC Value	Variance	Mat. Usage	Adj. %	Status	Actions

Enter Cyclic Count

Record inventory count results for a class

⚠ Mark this class as N/A for this period — will exclude it from the accuracy calculation

Plant

Class

Frequency

Class Description

Count Date

Fiscal Week

Fiscal Month

Assigned To

# of Parts

# of Adjustments

GRMS Value ($)

CC Value ($)

Variance ($) auto

Adjustment % auto

Material Usage since last adj. ($)

Submitted Date

Approval Date

Adjustment Date

Count Log

All recorded cycle counts

Plant	Freq.	Class	Description	Date	Assigned To	# Parts	# Adj.	GRMS Value	CC Value	Variance	Adj. %	Fiscal Month	Status	Actions

Class Catalog

Inventory classes template — same for both plants

📋

Upload Calendario 2026.csv

Drag & drop or click • Columns: Frequency, Class, Class Description • Will replace existing catalog

#	Frequency	Class Code	Class Description

Fiscal Calendar

Maps calendar dates to fiscal weeks and fiscal months

📅

Upload Fiscal year.csv

Drag & drop or click • Columns: DATE, WEEK, FISCAL MONTH

Year: Month:

Date	Fiscal Week	Fiscal Month

Settings

Supabase connection and database setup

🔗 Supabase Connection

Supabase Project URL

Anon Public Key

🗄 Database Setup SQL

Run this once in your Supabase project's SQL Editor to create all required tables.