A
Arkana
Production ERP
Live sync ready
More Tools
Paid Invoice Today
PHP0.00
owner-confirmed payments today
Awaiting Payment Today
PHP0.00
invoice balance created today
For Dispatch
0
invoice(s) ready for release
Payment Confirmation Today
PHP0.00
uploaded payments waiting owner approval
Total Monthly Sales
PHP0.00
fully paid invoices only
Monthly Sales Target
Not set
No sales target set for this month
Target Progress
--
Set Monthly Target to activate quota tracking
Total Expenses
PHP0.00
expenses recorded this month
Production Losses
PHP0.00
scrapped items this month

Production Queue

Paid and owner-approved invoices automatically appear here. Production Manager reviews the order, then clicks Create Batch Order to generate separate production batches per product.

InvoiceClientBrandDate PaidOrder StatusTotal ProductsPrioritySales RepEstimated LoadRaw MaterialsAction

REWORK NEEDED

Invoices returned by QC for correction appear here. Open a rework item to view what must be fixed, who will do it, and update the assignment or status.

InvoiceClientProductIssueRejected QtyStatusAssigned ToAction

Click Open Rework to view correction instructions and assignments.

Executive Assistant Summary

Command center
Here's what needs your attention today

AI Performance Assistant

Smart assistant AI powered report today based on Arkana Production Department's Performance.

Department Performance Today

Suggested Improvements

Invoice Progress Summary

Every invoice is summarized here so all users can quickly see the current process, completion percentage, and next action.

InvoiceClient / BrandItemsCurrent ProcessProgressNext Action

Inventory Alerts

IngredientStockLevelExpirySuggested Action

Today's Production

BatchInvoiceClientProductFormulaOptionsOutput / RejectGoodStageStatusAction

Sales

Create Quotation

Repacking Calculator
After adding a product, type Repackage Into (ml). The Expected Repacked Qty will calculate automatically. Example: 1 kilo/liter ordered into 10ml = 100 pcs.
Product Details / Color / Scent / SizeQuantity PurchasedBase PriceAdd-onsAdd-on CostLine TotalRemove
Subtotal: PHP0.00
Discount: PHP0.00
Tax: PHP0.00
Grand Total: PHP0.00

Quotes made

QuoteClientProductTotalStatusActions

Invoices

InvoiceClientProductTotalBalanceStatusActions

Awaiting Payment

Invoices with outstanding balances. Upload payment proof directly from here - no need to scroll through the invoice table.

Receivables

Clients with unpaid balances are shown here for easier collection follow-up.

Receivable DetailStatus

Payment records

All uploaded client payments grouped by date. Green border = confirmed. Amber = pending owner confirmation.

Payment confirmation

Owner-only. Review each payment proof and confirm before it becomes an official paid amount.

View Quote / Invoice

Click View in Quotes or Invoices to see a read-only copy here.

Clients' List

BrandCustomerContactEmailAddressOrdersTotal Sales

Sales Target Settings

Owner/Admin sets the monthly sales quota here. Dashboards use the saved month and year target instead of any hardcoded quota.

Optional Target Per Sales Agent

Sales AgentTarget Amount

Saved Monthly Targets

Month / YearTargetCurrent SalesProgressRemainingProjected Month-EndUpdatedAction

Financial Stability

Owner-only view. This combines confirmed sales, receivables, recorded expenses, and product cost information to estimate company net income.

Sales Report

Price Management

Owner/Admin can update products and pricing by editing the table or uploading CSV. Sales staff can view the product and add-on list only.

Products

Page 1 of 1
NameCategoryPackSRP PriceActiveAction

Add-On Services

FDA Registration Services

Selling prices are visible to all staff in the Price List. Costs are Owner-only and never shown to other roles.

Price List

Read-only price list for client quoting reference - Made to Order products, add-ons, and finished samples.

Client Label File Storage

Upload each client's label artwork here so the team can find and download it again before printing.

BrandCustomerFileUploadedNotesDownload

Expense Management

Record company expenses here. Owner/Admin can approve and mark expenses as paid. Paid expenses are locked to protect records.

New Expense Entry

New expense entry
Fields marked * are required
Supplier Invoice / Bill
Click to upload supplier invoice or bill
JPG, PNG, PDF - max 8MB

Expense Records

Deleting an expense hides it from all views but keeps it recoverable. Paid expenses are locked and can't be deleted, to protect your records.
DateExpenseVendorAmountStatusAction

Approved

Owner-approved expenses appear here. Executive Assistant can mark them Paid only after approval is already confirmed.

Expenses By Category

CategoryTotalPendingApproved / Paid

Expense Report

Owner-only expense analytics with percentage breakdowns for faster financial review.

Category Percentage

CategoryTotal% of ExpensesVisual

Status Percentage

StatusTotal% of ExpensesVisual

Monthly Expense Trend

MonthTotal Expense% of Recorded ExpensesTop Category
Sample Preparation
Track packing steps per invoice - container, sticker, shrink, bubble wrap
0
Active
0
Finished
0
Pending steps
Changes are saved only after clicking Save.

Sample Performance Report (Last 30 Days)

Shows which samples are being requested most, whether stock can keep up, and how often a sample turns into a real order.

Samples Given Out
0
Unique Samples Requested
0
Conversion Rate
--
Sample ProductTimes OrderedTotal Qty GivenCurrent StockStock StatusConversion Rate

Made to Order

Owner-only formula-linked costing list for made-to-order products. This is separate from Products, Samples, and quotation creation for now.

Formula Pack Size SRP Cost Per Kg Cost For This Size Margin Margin % Active Action

Create New Batch

Formula ingredients stay hidden. Staff see formula code only.

Staff Assignment
Choose who will compound and who will repack this batch.

Job Order Queue

All paid invoices awaiting batch creation. Sorted by urgency - oldest orders first. Check stock status before creating a batch.

Pending batch creation

Sorted by urgency - oldest order first. Red = 3+ days waiting. Amber = 1-2 days.

Production

Choose a batch, then click Load Selected Batch.Updates save to the server.
Click after reviewing the Production updates.

Quality Control Center

Only invoices with completed compounding/production and pending Quality Control checking are listed here. Click Open QC to see the items and quantity boxes.

In Queue For Quality Control

InvoiceClientDate CompletedItems ReadyAction

Open a completed production batch to start final QC and dispatch verification.

Finished QC

Smart summary will appear here after finished QC records load.
Choose a finished invoice, then click Load Selected Batch.

Finished Samples

InvoiceClientSample ItemsPaymentSample StatusRemarksAction

Finished Bulk Orders

InvoiceClientProductQC StatusDispatch StatusFinal Qty

Load a finished invoice or batch to review the selected finished QC record.

Rework History

Only invoices with rejected products, failed QC, missing items, incomplete packaging, or rework requirements appear here.

Choose a rework invoice, then click Load Selected Rework.

Current Ongoing Rework

InvoiceClientProductIssueRejected QtyStatus

Rework Invoice History

InvoiceBatchProductTimeUserActionNotes

Load a rework invoice to review rejected quantity and issue details.

Rework Center

QC sends failed but correctable products here. Production handles correction, then QC reviews again before the batch becomes saleable, rejected again, or scrapped.

Releasing Dashboard

Orders marked Ready for Courier Pickup automatically appear here. This area is for arranging shipment, courier proof, and release records.

Smart AI releasing lead-time report will appear here.
InvoiceClientPrepared DateWorking ProgressLead TimeLikely Slow Part

Ready For Release

InvoiceClientTypeItemsStatusCourierShipment AmountReceiptCourier Proof 1Courier Proof 2Action

Formula Management

Owner can add and edit formulas here. Staff will still see code names only.

Formula Guide

Choose a formula from the dropdown above, then click Search to view its required ingredients and compounding procedure.

Ingredient Inventory

Owner sees complete raw material details. Other staff see safe coded material details only.

Showing the first 10 ingredients only. Use search to find a specific raw material, code, supplier, CAS number, lot number, or price.
Showing first 10 ingredients.

Quote Inventory Check

Choose a paid invoice, then click CHECK INGREDIENTS to compare that order against formula requirements and ingredient stock.

Total Lacking Ingredients For All Paid Invoices
Use this to see the combined raw material shortage for every fully paid invoice that needs production.

Ingredients Report

Read-only ingredient intelligence report. This does not change inventory, formulas, batch creation, or QC records.

Stock Status Overview

IngredientCodeSupplierLotExpiryCurrent StockStatus

Supplier Cost Comparison

Grouped by INCI name when more than one supplier or lot is encoded. Lowest visible cost is marked as cheapest.

INCI NameSupplierRaw MaterialCodeUnit CostStockStatus

Most-Used Ingredients

Calculated from all saved batch records, using batch bulk size and the encoded formula amount per kg.

RankIngredientCodeTotal Kg ConsumedUnit CostEstimated Total Cost Consumed

Productivity

Operational KPIs

Staff Productivity Report

Performance Analysis

StaffPerformanceSpeedQualityWorkloadBest RoleRecommendation

Detailed Staff Output

StaffRoleStagesHoursOutputRejectedOutput / Hour

Production Trace / Complaint Investigation

Search by sales invoice, client, batch number, product, or formula. This report shows who handled weighing, mixing, repacking, labeling, shrinking, boxing, QC, and dispatch.
Choose a production batch, then click Load Selected Batch.

Audit Log

Choose a user to review their logins, logouts, and system activity.

Showing all audit activity.
TimeUserRoleActionDetails

Payroll Management

Manage staff attendance, compute payroll, and release salary expenses automatically on the 15th and 30th of each month.

Staff Rates

Set the daily rate for each staff member. Click Save after editing.

NamePositionTypeDaily ratePay basisCA installment / cutoffStatus badgeEdit statusAction

Supplier Audit - Outsourced Items

Shows what Arkana actually paid to suppliers vs what was charged to clients for containers, sticker prints, box packaging, and other sourced-out items. Only owner-confirmed invoices are counted.

Supplier Rating - Order Volume

Ranked by total amount spent. Shows which suppliers Arkana relies on most.

Security & Backup Center

Owner-only safety area for account access, password protection, and backups before upgrades.

Login Lockout
5x
15-minute lock after failed attempts
Session Timeout
4h
Automatic sign-out protection
Backup
JSON
Owner downloadable safety copy
Users
0
Managed accounts

Change My Password

Users & Access

Only Owner/Admin can save users. Usernames must use small letters and numbers only, with no spaces. Example: execassistant. Passwords also use small letters and numbers only.

UsernameNameRoleAccess TemplateNew PasswordStatusLast LoginAction

Production Staff Management

Owner/Admin can manage the active production staff names used in assignment dropdowns.

NameLinked payroll rateAction

Backup Center

Download a backup before uploading a new version to GitHub or Render. Keep it somewhere safe.

Email Alert Log

Email sending is checked from server settings.

TimeTypeSubjectStatusDetails

Production Calendar

Overdue Due soon On track QC/Release
Click a date to see details
Select a date on the calendar.
All deadlines - sorted by urgency