PRISM · Command Center

Import Scan Data

Upload a CSV export from JM Die Track. The file should have columns: Scan ID, Job, Date and Time, Employee Name, Department Name, Status, Pieces.

Drop CSV file(s) here or click to browse

scan-reports-export.csv

IMPORT PRICING — QUICKBOOKS

Upload Sales by Customer Detail from QuickBooks Desktop (.csv or .xls). Maps PO numbers to fill missing unit prices.

Drop file here or click to browse

SALES_BY_CUSTOMER_DETAILS.CSV / .XLS / .XLSX

IMPORT JOBS — QB SALES ORDERS

Upload Open Sales Orders from QuickBooks (CSV, XLS, or XLSX). Auto-creates jobs with format CODE_SO_LINE. Maps customer codes, prices, quantities, and due dates.

Drop file here or click to browse

JM_Open_Sales_Orders (CSV, XLS, or XLSX)

IMPORT INVOICES — QB SALES DETAIL

Upload Sales Detail XLSX from QuickBooks. Imports invoiced line items and cross-references with existing jobs to fill in unit prices.

Drop XLSX here or click to browse

JM_Die_*_Sales_Detail.xlsx

Employee Roster

Upload employee XLSX with columns: Last Name, First Name, Hire Date, Last Raise, 2026 Raise, Term Date, Pay Rate 1/1, $ Change YTD, Current Rate, % Change, Years.

Drop employee .xlsx here or click to browse

Timecard Import

Upload a screenshot from OpenTimeClock. AI will extract employee names, dates, and hours automatically.

Drop timecard screenshot(s) here or click to browse

Total

—

Active

—

Departments

—

Name	Code	Department	Status	Actions

Employee Badges — QR badges for clock in/out

Kiosk Settings

Geofence

Require on-site to clock in.

Radius (m)

Auto Clock-Out

Auto clock-out after inactivity.

After (hours)

Camera

Which camera for QR scanning.

Require Piece Count

Must enter piece count when completing a job.

Data Health — flags issues across operators, jobs, and scans

Checking...

PRISM AI