MWO Prague Property & Supplies Monitoring System

Main Dashboard

Overview of supplies, stock status, FF&E and accountability

Quick Actions

Supply Items

—

Low Stock

—

Out of Stock

—

Inventory Value

—

Active Assets

—

Asset Acquisition Cost

—

Net Book Value

—

Forms Outstanding

—

Items Requiring Attention

Type	Code	Description	Status

Recent Staff Issuances

Date	Issuance	Staff	Items

Supplies Inventory

Item code	Category	Description	Unit	Stock	Reorder level	Unit cost	Location	Status

Low Stock & Reorder

Shows active supplies at or below their reorder level. Adjust the proposed reorder quantity before exporting the Excel reorder file.

0 low-stock itemsEstimated reorder value: CZK 0.00

Item code	Category	Description	Unit	Current stock	Reorder level	Proposed reorder qty	Unit cost	Estimated total	Supplier	Location	Status

Furniture, Fixtures & Equipment

Property no.	Category	Description	Brand / Model	Serial no.	Acquired	Cost	Residual rate	Residual value	Accum. depreciation	Book value	Location	Accountable person	Condition	Status

Property Stickers

Prepare printable property labels directly from the FF&E register. All FF&E property numbers are included regardless of prefix.

Stickers per A4 sheet

Find an asset

0 FF&E records0 selected0 A4 sheets

Printing tip: Use A4 paper, scale 100% / Actual Size, and disable browser headers and footers. The 12-per-page layout is recommended when labels need more readable text; 16-per-page uses smaller labels.

	Property no.	Description	Brand / Model	Serial no.	Acquired	Accountable person	Condition	Status

Asset History

Transfers, repairs, inventory checks, returns, losses, disposals and Supplies → FF&E conversions are retained here.

Date	Property no.	Description	Action	From location	To location	From person	To person	Cost	Reference	Remarks

Stock Transactions

Receipts, issues and adjustments post immediately to cloud stock balances.

Date	Item	Type	Quantity	Unit cost	Reference	Issued to	Remarks

Staff Directory

Maintain personnel records used for supply and property accountability.

ID	Employee ID	Full Name	Position	Office Unit	Email	Active

Staff Supplies Issuance

Issue multiple supply items to one staff member in a single transaction. Current stock is shown before posting.

ID	Issuance No.	Issue Date	Staff	Position	Office	Items	Reference	Status

Accountable Forms / Official Receipts

Every serial number is controlled individually. Receive batches, issue or transfer forms, record use/exceptions, return unused forms, and retain permanent event history.

Unissued: 0Outstanding: 0Used: 0Exceptions: 0

Serial No.	Form Type	Status	Current Holder	Issue Date	Used Date	Amount	Payor	Reference	Batch No.	Remarks

Accountable Forms Event History

Permanent serial-level history. Events are not deleted when a form changes status.

Date	Serial No.	Event	From Holder	To Holder	Amount	Payor	Reference	Remarks

Import Utilities

Bulk upload and maintenance tools for Supplies and FF&E records

Supplies Bulk Import

Download the standard template, encode your stock additions, then upload the completed Excel file. Existing item codes add to the current stock instead of replacing it.

No file selected.

Raw Excel → Supplies Mapper

Use an existing Excel file without first rearranging its columns. Select the worksheet, map its columns to the Supplies template, validate, then import.

No raw workbook selected.

FF&E Bulk Import

Download the FF&E template and upload existing property records. Property numbers are checked for duplicates, and each imported asset receives an initial Asset History entry.

No file selected.

FF&E Residual Rate Maintenance

Preview and apply one residual rate to all FF&E records. Residual value is recalculated from Acquisition Cost × Residual Rate, and the depreciation view updates automatically.

Residual rate (%)

Assets0

Total Acquisition CostCZK 0.00

New Total Residual ValueCZK 0.00

Enter a rate and preview before applying.

This does not delete or recreate assets. It updates the residual rate and residual value of the existing FF&E records.

Reports

Prepare inventory, accountability and audit reports from the records already in the system

Reports are generated from the current cloud records. Exporting a report does not change inventory balances or FF&E data.

Supplies & Stock

Appendix 57 – Supplies Ledger Card

Detailed ledger for one supply item, including receipts, issues and running balance.

Appendix 58 – Stock Card

Stock movement card for one supply item with receipt, issue and balance columns.

Office Supplies Inventory

Current supply balances, reorder levels, unit costs and inventory values.

Supply Transaction Ledger

Chronological list of receipts, issues, adjustments and reversals.

Individual Staff Supplies Report

Supplies issued to a selected staff member, grouped from posted issuance records.

FF&E / Property

Appendix 59 – ICS

Inventory Custodian Slip for a selected FF&E asset using its property and accountability details.

Property Acknowledgment Receipt (PAR)

Property accountability report for assets with a PAR number, or all active assets if needed.

FF&E Asset Register + Depreciation

Complete asset register with acquisition cost, residual value, accumulated depreciation and book value.

Asset History

Permanent history of transfers, repairs, inventory checks, returns, losses and disposals.

Accountable Forms

Accountable Forms Register

Current serial-level register of Official Receipts and other accountable forms.

Accountable Forms Event History

Permanent movement and disposition history for each accountable form serial.

Administration

Audit Log

Administrative audit trail of recorded system actions. Available to ADMIN accounts.

User Administration

Manage MWO system users, access status and application roles

Users

Add, edit or remove access to this monitoring system. Deleting a user here removes application access only; the Supabase Authentication identity is retained for security and audit purposes.

Email	Full Name	Role	Active	Actions
Open this page to load users.

ADMIN access required.

Role Administration

Create custom roles and control what each role can do in the system. Built-in roles are protected from deletion.

Code	Name	Description	Write	Users	Roles	Backup	Active	Users	Actions
Open this page to load roles.

Role changes take effect when affected users reload the application.

Settings / Backup

System preferences, access controls, backup exports and basic system checks

System Settings

Maintain the defaults used for new property records and general system identification.

Organization Name

System Name

Default Location

Default Residual Rate (%)

Default Useful Life (Years)

Settings are shared by users of this project.

Manual Backup

Download a complete operational snapshot before major maintenance, imports or database changes.

No backup downloaded during this session.

The backup contains system records but does not contain user passwords or Supabase secret keys.

System Health

Quick check of the records currently loaded by this browser.

Supplies0

Transactions0

FF&E0

Asset History0

Staff0

Issuances0

Forms0

Form Events0

Using the latest data loaded in this session.

Recent Audit Activity

Latest recorded actions for quick administrative review. The full audit export remains available under Reports.

Date / Time	Module	Action	Record	User	Details
Open this page to load recent audit activity.

System Check & Recovery

Check system health, verify backups and use controlled recovery tools when needed

Production Diagnostics

Run database integrity checks before major maintenance, imports or deployment changes.

DatabaseNot checked

Negative Stock—

Invalid Assets—

User / Role Issues—

Diagnostics have not been run in this session.

Backup Verification

Check a downloaded JSON backup before relying on it for recovery. Validation does not change the database.

Select JSON Backup

No backup file selected.

Server Recovery Snapshots

Create a protected snapshot inside Supabase before high-risk maintenance. Recovery restores only missing records; it never deletes or overwrites current live records.

Snapshot Label

Created	Label	Created By	Records	Actions
Open this page to load recovery snapshots.

Maximum 10 server snapshots. Delete older snapshots when no longer needed.

Safe Recovery intentionally restores missing records only. Existing live records are not replaced, changed or deleted.

Production Checklist

Recommended checks before treating this deployment as the production system.

Portal is using HTTPS Supabase connection is configured Signed-in user is active Backup / recovery permission is available Database diagnostics passed At least one server recovery snapshot exists

Open this page and run diagnostics to complete the checks.

System Connection

MWO Property & Supplies

Main Dashboard

Items Requiring Attention

Recent Staff Issuances

Supplies Inventory

Low Stock & Reorder

Furniture, Fixtures & Equipment

Property Stickers

Asset History

Stock Transactions

Staff Directory

Staff Supplies Issuance

Accountable Forms / Official Receipts

Accountable Forms Event History

Import Utilities

Supplies Bulk Import

Raw Excel → Supplies Mapper

FF&E Bulk Import

FF&E Residual Rate Maintenance

Reports

Appendix 57 – Supplies Ledger Card

Appendix 58 – Stock Card

Office Supplies Inventory

Supply Transaction Ledger

Individual Staff Supplies Report

Appendix 59 – ICS

Property Acknowledgment Receipt (PAR)

FF&E Asset Register + Depreciation

Asset History

Accountable Forms Register

Accountable Forms Event History

Audit Log

User Administration

Users

Role Administration

Settings / Backup

System Settings

Manual Backup

System Health

Recent Audit Activity

System Check & Recovery

Production Diagnostics

Backup Verification

Server Recovery Snapshots

Production Checklist

Signed-in account

Edit