Inventory Intelligence, Operations & Executive Analytics Suite
When you log into מיקאפ · MAKEUP BOUTIQUE, the first screen is the Executive Overview. It aggregates sales, stock, cost of goods, customer velocity, and transactions live from Airtable.
Directly below the KPI cards, three real-time SVG charts give you instant macro intelligence without needing manual calculations:
A smooth curved SVG line chart displaying daily revenue progression across the chosen date filter.
Interactive distribution ring comparing revenue share across all three stores.
Horizontal bar ranking of the top selling makeup brands by revenue.
Located in the topbar and report headers, the global filter bar controls the entire intelligence engine in real time.
Any time you see a product, customer, or branch anywhere in the system, you can click it to open a 360° Full Intelligence Modal.
Isolates individual store performance with retail stock valuation, cost basis, transactions, and employee sales velocity.
Universal 6-Way Filter Bar across 8 Specialized Financial & Management Tabs
Click Reports & Export in the sidebar to access the dedicated 8-tab analytics platform. The top bar provides real-time multi-dimensional filtering across Date Preset / Custom Range, Branch, Brand, Product, Customer, and Salesperson / Employee.
Gross list sales, discounts given, actual net sales, order counts, average ticket (AOV), net paid per unit, and interactive SVG sales curve graph.
Executive waterfall: Gross Sales → Discounts → Net Sales → Israeli VAT 17% Toggle (Inc/Ex VAT) → COGS → Gross Profit & Margin %, plus Brand profit contribution.
Units sold, realized revenue, cost of goods, gross profit, margin %, realized price, best-selling brand pills, and 1-click Product 360° modal.
Branch stock distribution, wholesale cost valuation vs. retail consumer valuation, potential unrealized margin, and quick filters: All, Low Stock, Negative Deficit.
Customer lifetime value (LTV), transaction counts, average order ticket, last purchase date, favorite brands/products, and purchase history.
Direct comparative scorecards for Beit Shemesh, Jerusalem, and Beitar: Net Sales, COGS, Gross Profit, Margin %, AOV, unique customers, and Top 3 products.
Volume attributed to each cashier / salesperson (מוכר/ת): transactions, units, net sales, profit, average basket, and estimated sales per work day.
Day-by-day performance audit: transactions, units sold, net revenue, wholesale cost, gross profit, margin %, and top-selling product of the day.
Every table and report in the system features instant Export Excel (.xlsx) and Export CSV buttons.
In standard systems, Hebrew product names often appear as garbled characters (???? or מיק×...) when opened in Microsoft Excel.
מיקאפ · MAKEUP BOUTIQUE automatically embeds the UTF-8 Byte Order Mark (\uFEFF) into all CSV exports and generates native multi-sheet Excel files. Hebrew text opens crisply and perfectly formatted on Windows, Mac, and mobile devices.
Import end-of-day sales from registers. Fastest way to record daily sales in bulk across all branches.
sales_item_lines_report_6004.xlsx. SKUs and quantities are read automatically.sales_report_3250_6004.xlsx to link customers, or click Skip File 2.Relocate physical stock between Beitar, Beit Shemesh, and Jerusalem.
Record counter sales outside the main POS or make quick adjustments.
Track vendor orders from draft to arrival.
Draft → Ordered.The built-in receipt scanner recognizes Israeli cash register slips, supplier invoices, and delivery notes.
The scanner prioritizes catalog numbers (e.g. 100059) printed under item descriptions. If there is no barcode or SKU, it leaves it blank and matches via learned memory.
If a receipt has an overall discount (e.g. 10% / ₪61.40) or promotional ₪0 gift items, the system distributes the discount proportionally to save the actual price paid per item, ensuring the line totals match the receipt total (e.g. ₪552.60) exactly.
Names appearing next to "מוכר/ת" (Seller/Cashier, e.g. רבקי רבינוביץ) are saved as the Employee / Salesperson, never misattributed as a Customer.
If a receipt line is unrecognized or matched to the wrong item, simply click Change, select the correct catalogue product, and click Confirm & Remember.
Standard inventory apps silently clamp negative numbers to zero, hiding stock shrinkage and data discrepancies. מיקאפ · MAKEUP BOUTIQUE tracks true physical deficits (e.g. -3 units) so inventory anomalies can be audited and corrected.