Don Macchiatos Web POS

TODAY · HOURLY

Sales Statistic

Selected range

Actual sales by category · hover for details

View Timeline

Based on recorded transactions. Series reflect actual category sales; a category with no sales stays at zero.

THIS MONTH

Category Mix

Gross sales by menu category

Latest transactions

Loading transactions…

Loading inventory…

Ingredient	UOM	Stock	Threshold

Ingredient Name	Unit	On Hand	Reorder Level	Last Updated	Status

Showing 0 ingredients

Replenish

Record incoming stocks from suppliers to increase ingredient quantities.

Transfer

Move ingredient stocks between branches or storage locations.

MOVEMENT HISTORY

Inventory Audit

One row per transaction. Expand a row to see every ingredient and stock change.

Date & time	Type	Transaction / Reference	Ingredients	Source / Destination	Actor	Action

Loading transactions…

Historical Sales Access

Download older sales as free Excel-compatible CSV; online historical viewing is limited by your plan.

YearBranch

Select a year for a free CSV export.

Product Summary

Product	Qty	Gross	Adjusted	Actual	Costing	Net Sales

Promo Purchases

Promo	Qty	Gross	Adjusted	Actual

Ingredient Usage and Cost

Transaction Logs

Reference	Cashier	Status	Payment	Remark	Date/Time	Gross	Adjustment	Actual	Action

CATALOG

Products

Name	Category	Price	Unit Cost	Recipe	Status	Action

POS TILES

Category Buttons

Change the icon for any existing category. Create additional category buttons that display selected products without modifying their inventory, recipes, or base category.

Open this section to load categories.

INVENTORY MASTER

Ingredients & Measurement

Ingredient	Code	UOM	Stock	Low	Status	Action

PRODUCTLIST + COSTINGLIST

Recipe & Costing Editor

Choose ingredients

Multi-select ingredients, Shift-select a range, or drag into the recipe editor. Add from the picker on mobile.

Select all matching0 selected

Recipe editor

Drop selected ingredients here or click Add selected. Enter quantity and optional cost per item below.

Ingredient	UOM	Qty Required	Cost Contribution

Unit Cost: ₱0.00

PROMOLIST

Promos

Name	Inclusion	Price	Limits	Status	Action

PACKAGELIST

Packages

Name	Price	Composition	Status	Action

EMAIL SERVER

SMTP Status

SMTP passwords are never stored in the browser or database. Configure them through server environment variables.

DATABASE SAFETY

Backup & Restore

PORTABLE DATA EXPORT

Keep your own copy

Download a secure data snapshot for archiving. Export is not an automatic restore and does not include passwords or active sessions.

OPTIONAL RETENTION ADD-ON

Historical Sales Access

Pro includes 12 months of online sales viewing; Business includes 24 months. Older sales remain stored and are always available as free year-by-year CSV downloads from Sales Report. An optional managed archive add-on (proposed ₱299/month or ₱2,990/year) is a development preview only; no billing, automatic off-site backup or extended historical viewing is active.

Preview subscribed retentionBackup frequency

HISTORICAL SALES · DATA MIGRATION

Import Sales from Excel / CSV

Already have sales in Excel? Save the sheet as CSV UTF-8, then preview and validate it here. Only approved rows will be imported, without changing today's inventory.

Preview before import

1. Download the exact CSV template

One row per item; repeat sale-level columns for items sharing the same reference.

2. Convert and validate your Excel file

In Excel: Save As → CSV UTF-8 (Comma delimited). References must be unique; dates use Philippine local time.

Loading branch names…

View required fields and database-compatible format

Column	Format / rule
`reference`	Unique sale ID, maximum 80 characters. Repeat for every item belonging to one sale.
`sold_at`	YYYY-MM-DD HH:mm, Philippine local time (e.g. 2026-10-30 14:30).
`branch_name`	Must match an existing branch name.
`status`	Sold, Voided, or Cancelled. Unpaid/pending cannot be imported into this sales table.
`payment_mode`	Cash or GCash (supported by the current database constraint).
`item_name`	Product name, 1–150 characters, one row per item.
`quantity`	Positive number, at most 3 decimal places.
`unit_price`	Non-negative number, at most 2 decimal places, without currency symbol or commas.
`sale_total`	Repeated total for this sale: sum of item quantities × unit prices minus discount.
Optional columns: `customer_name`, `cashier_name`, `order_type` (Dine In / Take Away / Order Online), `discount_amount`, `payment_reference`, `remark`.

Imports do not affect current stock. Historical recipe costs cannot be reconstructed from sales totals, so legacy profit/costing figures require separate verification. Existing sales are never overwritten.

Choose sales CSV file (up to 1 MB, 500 item rows)

No CSV selected yet.

Import Preview

Reference	Date	Branch	Status	Items	Total

I have reviewed the preview. I understand the import is permanent and does not update inventory or historical costs.

READ-ONLY DATABASE REVIEW

Upload & Compare Data Archive

Upload the .json file from Download Data Archive. Compare table counts and changed records without restoring or modifying live data.

No restore · no overwrite

Don Mac JSON archive (up to 60 MB)

No archive uploaded for comparison yet.

Comparison access expires 24 hours after upload. The upload record remains listed afterward.

Archive vs. Current Database

Counts describe differences between the uploaded archive and current live records. Nothing is restored, imported, or changed.

Table	Archive	Live	Only archive	Only live	Changed	Identical

Historical records remain available. No annual deletion, hiding, or automatic off-site backup is active.

Backup	Date	Size	Actions

FRANCHISE SALES

Transaction Ledger

Completed and voided POS transactions, restricted to your franchise branches.

Transactions—

Completed sales—

Date	Reference	Branch	Cashier	Payment	Order type	Status	Amount
Select Transactions to load the ledger.

FRANCHISE EXPENDITURE

Expenses Ledger

Enter daily expenses by branch. Saving the same branch and date updates that day's row.

FromToBranch

Total recorded expenses—

Daily records—

Date	Branch	Rent	Stocks	Salary	Transportation	Electricity	Ice	Water	Misc	Total	Notes	Action
Select Expenses to load records.

Order supplies for your registered branches, upload payment proof and track delivery.

MAIN OFFICE PRICE LIST

Select requested supplies

Quantity is by unit of measure (UOM). Review the packing unit before ordering.

ORDER TRACKING

My supply requests

Request	Branch	Priority	Total	Progress	Submitted

CURRENT REQUEST

Order details

Fulfillment timeline

Items

Item	UOM	Quantity	Price

Messages with Main Office

ACCESS & LOCATIONS

Branches & Cashiers

Manage branch information and staff access in one workspace.

Branches

Locations, contacts and operational status

Checking branch allowance…

Branch directory10 per page

Branch	Accounts / Sales	Status	Actions

Cashiers

Staff credentials and branch assignments

Staff directory10 per page

Cashier	Role	Branch	Status	Password	Actions

BUSINESS FEATURES

Advanced inventory

Gain deeper insight into your inventory and operations.

Your Pro plan includes replenishment. Transfer operations are for Business accounts.

INVENTORY MANAGEMENT & REPORTING

Pro and Business: what is included

These capabilities are based on the existing POS and saved records. Business adds a dedicated analytics workspace and inter-location stock transfers.

PRO PLANCore operations

Sales reports, discounts and payment breakdown
Inventory list, stock monitoring and replenishment
Existing inventory movement audit
Standard dashboard with hourly and date-range trends
Transaction and expense ledgers

BUSINESS PLANPro plus advanced operations

Everything included in Pro
Inter-location ingredient transfers with recorded movement history
Dedicated eight-section Advanced Analytics workspace
Branch sales comparison and 12-month trends
Sales vs expenses, menu mix and payment analysis
Customer records, cashier performance and operational alerts

Inventory is currently maintained as shared stock, not separate per-branch balances. Physical cash-count reconciliation, timekeeping, purchase-order approvals and stocktake adjustments are not yet recorded as dedicated workflows.

BUSINESS · ADVANCED ANALYTICS

Advanced Analytics

Eight integrated analytical sections using saved franchise transactions, expense records and inventory movements.

Business account

Business analytics

Upgrade to Business to access live financial, branch, menu, customer, cashier and operational analytics.

ACCOUNT SETTINGS

Subscription & account type

Manage your subscription and request plan updates through Admin Control.

Status not configured

Subscribed planPro

Plan started—

Next payment date—

Days remaining—

Account plan

SUBSCRIPTION BILLING

Pay your Don Mac POS subscription

Pay securely when checkout is configured by Admin Control. Billing status is managed centrally.

PayMongo not connected yet

Assigned Plan—

Amount Due—

Payment Status—

Next Payment—

Checking subscription details…

Verified payment history

Invoice	Plan	Amount	Status	Date
No transactions recorded.

PLAN CHANGE HISTORY

Subscription history

Recorded account changes

Date	Plan	Start Date	Renew Date	Days Remaining	Status	Remark
Loading subscription history…

AUDIT

System Logs