📴 You're offline. Drafts save locally and submissions will sync when you reconnect.
🔄 New version available
Micmakin Nigeria Limited
Inventory Management System
Admin/Users
ADMIN
0
Staff Accounts
0
Active Branches
0
Submissions
Staff Accounts
Bulk Upload Users
Upload a CSV or Excel file with columns: Email, Password, Role, Branch Role must be: staff, accountant, or admin. Branch must match an existing branch name.
🎂 Cake — Reports
Recipe matrix and the Actual-vs-Expected (DRS & Zoho) usage report.
🧩 Zoho Integration
Map cake items to Zoho composite/component items (for Assemble in Zoho), and choose the vendor that cake purchase Bills are created against.
Billing contacts
🔍 Verify Cake Stock on Zoho
Reads each mapped production cake's current stock-on-hand in the branch's Zoho warehouse — confirm your opening position before a supply run. Read-only, no Zoho changes.
📊 Cake Report
The cake manager's report: production by cake, ingredient / decoration / packaging variances, purchases, supply to stores (Cake + OCAKE), invoiced value, Zoho push status and an auto-written discussion. Weekly = the Monday–Sunday week containing your date, vs the previous week. Daily = the single date you pick, vs the day before.
🥧 Pie Express — Settings
Recipe engine coefficients, product yields, the selling price list, and the weekly sauce constants.
📦 Zoho Composites
The (PIE EXPRESS) composite recipes fetched from Zoho — what the Bundles step consumes per unit. Re-fetch after any recipe change in Zoho.
📊 Weekly Report
The manager's Monday–Sunday report: production, raw-material variances, sauce kitchen, supply value, consumables, Zoho push status and an auto-written discussion — compared with the previous week. Both weeks' submissions are loaded and hydrated before anything renders.
🔗 Zoho Item Mappings
DRS pie item → Zoho item. Items without a mapping are skipped and reported on every Bills/Close run, so nothing posts wrong — but map them here so they post at all. Editing is admin/audit only.
🥨 Crunchy — Settings
Recipe-engine coefficients, the two product yields, pack size, ingredient unit costs and the selling price list. The form runs on the built-in workbook defaults until you override them here.
📊 Weekly Report
The manager's Monday–Sunday report: average analysis per item with week-over-week movement, production against expected yield, ingredient usage against the recipe, submission coverage, waste and an auto-written discussion. Both weeks are loaded and hydrated before anything renders. Opens print-ready in a new tab.
Accountant Pickings
—
DRS-Zoho Variance Check
—
Bundle vs Actual Yield
Compares total Actual Yield from SICS Cooks (all batches + shifts) against Zoho Quantity In for each recipe.
—
⚙️ Picking Exclusions
Items in these lists are skipped from accountant picking variance calculations.
Use the Global list for items you never want counted (e.g. spoilage promos).
Use Per-Branch overrides to deviate from the global policy at a specific branch
(either add an extra exclusion or re-include something that's globally excluded).
🌍 Global Exclusions
🏬 Per-Branch Overrides
🎂 Cake Recipe Manager
Each cake's recipe = ingredient amount used to make one cake. This drives Expected Usage on the Cake forms:
Expected ingredient usage = Σ (cakes produced × this amount).
Loading…
🧮 Cake Usage — Actual vs Expected (DRS & Zoho)
Per ingredient: Actual Usage (from the Cake forms) vs DRS Expected (recipe matrix) and Zoho Expected (Zoho composite recipe), both = cakes produced × recipe. Recipe Δ = DRS − Zoho shows where the two recipes disagree (for reconciling Zoho); Var = Actual − Zoho Expected.
Pick a branch + date.
Deleted Submissions
No deleted submissions.
All Submissions
📂 Archives — on-demand lookup
Pull submissions for a specific branch, date range, and shift on demand — without loading the whole history. Pick what you need and click Load. Loaded entries keep the full View / CSV / PDF / Push actions (and also appear in the Submissions tab).
Quick range:
Pick a branch + date range above and click Load.
Generate Reports
Report Preview
Select filters above to preview report data.
💰 Bakery Sales Rates
Per-item rates for the bakery DRS Sales Analysis section. Defaults apply to every bakery branch unless overridden below.
EditingThese rates apply to every bakery branch.
Item
🚶 Walk-in (₦)
🪑 Table Topper (₦)
🚚 Distributor (₦)
📦 B/D (₦)
Loading rates...
How rates work: When a bakery accountant opens the Sales Analysis section in a bakery DRS submission, the form looks up the rate for that branch + item + category. It checks branch overrides first, then falls back to the defaults you set here. Staff/accountants only enter the quantity sold — the rate and amount are computed automatically. Only Admin/Audit roles can edit these rates.
Add / Remove Items in Forms
Branch Management
Branch Overview
🔧 Correction Requests
🔄 Reassignment Requests
🔧 Submission Data Repair
Click "Scan for Issues" to check for corrupted submission data (e.g. double-stringified data from old reassignment bug).
0
Total Transfers
0
Tallied
0
Mismatch
0
Unrecorded
Bakery Transfer Reconciliation
Loading...
Date
Item
From Branch
To Branch
Out Qty
In Qty
Status
📡 Connectivity Log
Tracks offline incidents and save failures per staff member. Admin events are not tracked.
0
Total events
0
Offline incidents
0
Save timeouts
0
Save failures
0
Branches affected
—
Longest offline
🔧 Cascade Audit
Finds shifts where an automatic cascade revision overwrote human-entered closing values. Scan range: last 30 days.
—
Shifts scanned
—
Affected shifts
—
Items to restore
—
Branches affected
How this works: For each shift in the last 30 days, checks if there's a HUMAN revision whose Closing Bulk / Closing WIP values got zeroed out by a later CASCADE revision. Flagged shifts can be reviewed and restored individually.
Click "Scan Last 30 Days" to begin.
🔧 RESTORE HUMAN-ENTERED VALUES
Choose restoration method:
Cancelling leaves this shift unchanged. You can always come back to it later.
🕒 Activity Log
Every session, form open, field change, draft save, submit, and outcome. Retention: 90 days. Use the Forensic Lookup below to settle disputes.
—
Events (loaded)
—
Unique users
—
Submit failures
—
Sessions
🔍 Forensic Lookup — "Did this user actually do what they claim?"
Click "Refresh" to load the activity log.
0
Total Discrepancies
0
Flagged
0
Reviewed
0
Resolved
0
Missing Components
0
Warehouses Affected
BOM Discrepancy Monitor
Loading...
Assembly #
Item
Date
Warehouse
Expected
Missing
Status
ITEM
DATE
WAREHOUSE
COMPONENTS
MISSING COMPONENTS
0
DRS Items
0
Mapped
0
Unmapped
0
Zoho Items Known
DRS Item
Form Type
Zoho Inventory Item
Status
Map each Cake Production item to its Zoho composite item, and each recipe ingredient to its Zoho component item. The "Assemble in Zoho" push (Phase 2) uses these IDs to build the bundle. No Zoho changes happen here.
Paste rows for the current tab, one per line: NAME [tab/comma] ZOHO_ITEM_ID [tab/comma] ZOHO_NAME(optional). Names are matched leniently.
DRS Item
Zoho Item ID
Zoho Name
Map each board / pack to the Cake Production items that use it. On the Packaging Analysis form, Expected Usage = Σ of the mapped cakes for that day — boards count cakes PRODUCED (a board goes on at production), packs count cakes OCAKE-SUPPLIED (a cake is only packed when it goes out). Seeded from your Excel — refine as needed. Note: shapes that share the same cakes (e.g. Round/Square/Love 10″) will each show that full total.
Packaging Item
Cakes That Use It
Import Preview
00
DRS Branch
Type
Zoho Warehouse
Status
📤
Upload Zoho Purchase Data
Upload a Zoho "Purchases by Item" CSV export. The system will auto-match items by name and let you confirm or adjust each mapping.
Upload a CSV with your own confirmed mappings. Requires columns: DRS Item Name, Zoho Item Name, Zoho Item ID. Optional: Zoho Unit, Action (update/delete).
0 matched to DRS0 not found in DRS0 already mapped
DRS Item
Zoho Item
Status
Save?
Match Results
0 auto-matched0 new Zoho items
Zoho Item
DRS Match
Score
Action
0
Total Mappings
0
With POS Code
0
Missing POS Code
0
Distinct Zoho Items
🚶 Walk-in Customer
One shared Books contact_id used as the customer on every invoice.
Find it in Books → Contacts → "Walk-in Customer" → URL after contacts/.
🔌 Test Books Connection
Verifies that Books OAuth credentials are configured correctly. Hits /organizations/{id}.
🏢 Branch → Books Branch (Optional)
Note: Warehouse routing (which warehouse stock decrements from) is handled automatically — we reuse the existing Zoho Mapping → Branch → Warehouse mappings, so make sure those are filled in there.
This section is only needed if your Books org has the separate Branches feature enabled (Settings → Branches in Books) for revenue-segmentation reporting. Leave blank otherwise — invoices are still tagged with branch via reference number.
DRS Branch
Books Branch ID
Save
Zoho Item
POS
POS Code
POS Description
Actions
🌱
Bootstrap Mappings from CSV
Upload a Zoho Books "Sales by Item" CSV export. We'll create empty mapping rows
— one per (Zoho item × Uniwell) and one per (Zoho item × ICG). Fill in POS codes in the Item Mapping tab.
Sales analysis, actual vs expected (distributor-rate), and waste loss — per bakery or collective, for any period: this/last week (Mon–Sun), this/last month, or a custom date range.
Pick a bakery + period above.
🌙 Nightly Inventory Adjustments
Adjusts Zoho stock to match DRS closing counts. Runs 10 PM next day (Mon–Fri). Weekends processed Monday night. AM→PM order with snapshots.
🟢 LIVE
⚙️ Adjustment Settings
10:00 PM daily (Tue–Fri + Mon for weekends)
How far back accountants can see the "Push to Zoho" button. Admin & audit always see it.
📋 Schedule: Tue–Fri 10PM adjusts previous day. Monday 10PM adjusts Fri+Sat+Sun. Sat/Sun no runs. Order: Snapshot → AM → Snapshot → PM per date.
⚠️ Dry-Run Mode: When active, the system logs what would be pushed to Zoho but does not create actual inventory adjustments. Use this to validate data before going live.
0
Queued
0
Pushed (Last 7d)
0
Errors
0
Holds
0
Enabled Branches
Adjustment Queue
Push History
↩️ Reverse & Readjust
Reset pushed items back to "queued" so the next nightly run re-processes them. Remember to also delete the Zoho adjustments manually.
⏸️ Not Ready Holds
Flag a branch-date as "not ready" to skip it in tonight's 10 PM run. It will be retried the next night. Remove the flag when the accountant finishes their work.
📸 Stock Snapshots — Zoho readings before adjustments
Loading snapshots...
🧪 Dry-Run Preview — What Would Be Pushed
Click "Run Preview" to scan today's queue and show what would be sent to Zoho.
📊 Push Activity Log
to
Loading push activity log...
📊 Stock Comparison Dashboard
DRS closing stock vs Zoho stock at time of adjustment push. Permanent audit trail — every comparison is stored historically.
0
Total Records
0
Branches
0
Exact Matches
0
DRS > Zoho
0
DRS < Zoho
to
Loading stock comparison data...
0 records
Page 1
Branch Summary — Aggregated Deltas by Branch & Date
Click Refresh to load summary data.
📦 Stock Movement Dashboard
Upload multiple weeks of Zoho Stock Summary CSVs to track and compare stock movement over time.
0
Total Records
0
Branches
0
Unique Items
0
Total Qty In
0
Total Qty Out
0
Periods Stored
Loading stock movement data...
0 records
Page 1
Branch Movement Summary — Inflows vs Outflows by Branch
Click Refresh to load summary data.
Item Trend — Stock Movement Over Multiple Periods
Select an item above to view its movement trend across periods.
📦 Manage Items
Sync DRS items with Zoho. Filtered to STORE INVENTORY = YES.
💡 Export from Zoho: Reports → Stock Summary → filter by warehouse & date range → Export CSV. Upload one per branch.
📁
Drop CSV here or click to browse
Zoho Stock Summary Report export (.csv)
🆕 New Items Found (not yet mapped)
These items were in the CSV but aren't in your DRS mappings. Select the ones you want to include in requisitions.
Item Name
Item ID
Qty Out
Closing
Branches
0
Items
0
With Movement
0
Period
—
📊 Data Preview
Branch
Item
Opening
Qty In
Qty Out
Closing
Use/Day
Wk Use
Status
🌐 Global Defaults
📦 Per-Item Configuration
Set pack size, unit, reorder level, buffer for each item. Blank buffer = global default. These settings persist in Firebase.
Item
Pack Size
Unit
Reorder ≤
Buffer%
Min Order
Max Order
Skip
📅 Period
Branch Approval Progress
0 / 0 branches approved
🏪 Branches
—
Item
Stock
Wk Use
+Buffer
Need
Status
ORDER
Packs
Adj
Actions
📨 Staff Change Requests
📅 Special Events Calendar
Define periods with increased demand (holidays, promos). The event multiplier scales up the weekly usage calculation during these periods.
No events configured. Add events for holidays, Sallah, Christmas, etc.
Staff/New Entry
STAFF
Form Entry
📝Draft saved
Staff on Duty
🔒
Select Date & Shift to Begin
Please choose a date and shift above before entering data.
📊 Sales Analysis Summary
🚶 Walk-in
₦0
0 units · avg ₦0
🪑 Table Topper
₦0
0 units · avg ₦0
🚚 Distributor
₦0
0 units · avg ₦0
📦 B/D
₦0
0 units · avg ₦0
Grand Total Quantity
0
units sold across all categories
Grand Total Revenue
₦0
total sales for this shift
Overall Avg Price
₦0
revenue ÷ quantity
📝 Extra Notes
These figures are recorded for reference only — not part of the denomination formula.
📷 Photo Evidence
Upload photos or take pictures with your camera. Max 5MB per image.
✅ Submitted successfully! Your entry has been recorded.
✓ Draft auto-saved
My Drafts
My Submissions
My Correction Requests
📦 Branch Requisition
Loading...
📅 Period
Loading your branch requisition...
Request Change
📊 Pie Express Report
The manager report: production, raw-material variances, sauce kitchen, supply value, consumables, Zoho push status and an auto-written discussion. Weekly reports the Monday–Sunday week containing your date, vs the week before. Daily reports the single date you pick, vs the day before. Opens in a new window (use 🖨 there to save as PDF).
📊 Cake Report
The manager report for the cake section: production by cake, ingredient / decoration / packaging variances, purchases, supply to stores (Cake + OCAKE), invoiced value, Zoho push status and an auto-written discussion. Weekly reports the Monday–Sunday week containing your date, vs the week before. Daily reports the single date you pick, vs the day before. Opens in a new window (use 🖨 there to save as PDF).
Items sales export from ICG. SKU references (e.g. NGFG/010101001).
Drop XLSX or browse
📋 Preview
✅ 0 Resolved Lines (will be invoiced)
⚠️ 0 Skipped Lines (no mapping found)
⚠️ CASCADE REVISION PREVIEW
Review downstream changes before applying
⚠️ Important: "Apply" will save your revision AND auto-revise each downstream shift listed above. Closing Bulk / Closing WIP values that staff already entered are PRESERVED (only opening stock is recalculated, which changes closing stock math). "Cancel" will skip BOTH — your revision will NOT be saved either. Review carefully.
⚠️ Cancel discards your revision entirely — your data stays in the form so you can edit and retry.
🔍 Unmapped Items Report
Scanning...
🧩 Adjustment Integrity Check
Pick a branch and click Scan.
📤 Bulk Re-push Range
Re-pushes every shift for one branch across a date range, one at a time, regenerating each with the current Zoho mappings. Use after a mapping fix. ~30–60s per shift — keep this tab open.
🌙 PM Zero-Lock Items
These CR inventory items automatically close at 0 on the PM shift — exactly like menu items.
Their Closing Bulk / WIP / Total are locked to 0 and pushed to Zoho as 0 at end of day. Menu items are always zeroed and don't need to be listed here.
📡 Push to Zoho
Branch
Date being pushed
Shift · Items
·
Creates the inventory adjustment in Zoho immediately — undone only by a reverse in DRS/Zoho. Confirm the date above is correct.
Working…
Starting…
Keep this tab open — this can take a minute.
🔍 Cake Stock on Zoho
🚚 Supply Cakes → Zoho Invoices (all stores)
Enter quantities under each store; price pre-fills from Zoho (editable, applies to all stores). One push → one invoice per store; already-invoiced stores are skipped.
