Frequently Asked Questions
Which CSVs does GICA expect?
Per department: *_inventory_starting.csv, *_inventory_purchases.csv, *_inventory_returns.csv, *_inventory_sales.csv, *_inventory_losses.csv. Admin produces *_inventory_ending.csv on close.
How are ending quantities computed?
Ending Qty = Starting + Purchases + Returns − Sales − Losses, adjusted by FIFO layer consumption for Sales & Losses. Ending Value is the remaining FIFO layers’ value.
How are Sales Revenue, Returns Value, and COGS calculated?
- Sales Revenue = sales quantity × sales price
- Returns Value = returns quantity × sales price (presentation), with returns added back as cost layers (defaulting missing return cost to current FIFO top)
- COGS = FIFO cost of Sales + FIFO cost of Losses (losses hit COGS)
What is the “Transaction Date” used for?
Monthly filtering during period close. Admin selects a month; running rows outside that month are ignored for the computation.
Where are passwords stored?
Locally in the browser (localStorage). Session access gates are stored in sessionStorage. Each protected page includes a “Change Password” panel after login.
Can I sort and edit CSVs in the browser?
Yes. Clerk and DB Admin offer inline editing. Admin’s CSV Editor adds click-to-sort headers and row deletion. Download writes out your current in-memory table.
What happens on Close Period?
- Downloads the ending CSV (with audit columns)
- Downloads a refreshed starting CSV (ending becomes new starting)
- Archives each running file with -YYYY-MM suffix, then resets those files to headers only
Do you upload our data anywhere?
No. Everything is in your browser; CSVs are loaded from your computer and written back as downloads.