Erick

Finance & accounting analyst who turns manual chaos into streamlined systems — reporting pipelines, data processing, and automation that actually ships.

What clients say

Projects

  • Warehouse Management System

    Finished Goods dashboard turning Sheets into a real-time, single source of truth. Track stock across warehouses; see mix by products handle as CTN/PCK/KG. Built as a Google Apps Script web app with live rollups, search, quick filters, export and clear visuals. FEFO-ready structure. impacting seconds-fast answers, fewer picking errors, smarter planning, and auditable totals that scale as locations and SKUs grow.

    Google App ScriptGoogle SheetsWarehouseCustomable
    View
  • Sales Monitoring

    Turns Google Sheets into a real-time revenue cockpit. Consolidate orders from stores/marketplaces, enrich with price/discount/cost, and watch revenue, units, AOV, margin, and sell-through update live. Drill by date, channel, region, salesperson, SKU, or customer; compare new vs repeat, promo vs non-promo, and cohort retention. Built as a Google Apps Script web app with cached rollups, fast search, quick filters, forecasts, alerts, and one-click export. Delivers seconds-fast answers, cleaner reporting, and smarter decisions—scaling smoothly as products, channels, and teams grow.

    Google App ScriptGoogle SheetsSalesCustomable
    View
  • Purchasing Requisition

    Think of this Purchase Requisition as your office wishlist: pick a supplier, choose item specs, enter the quantity, and the smart bits handle the rest—searchable dropdowns, prices and units auto-filled from the supplier catalog, instant totals, and a fresh PR number generated every time you save. With one click you get a clean A4 print preview, and the form resets for your next request. It’s fast, lightweight, and drama-free—fewer typos, smoother approvals, and everything tidy on a single screen.

    Google App ScriptGoogle SheetsPurchasingCustomable
    View
  • Excel Playground

    Think of this Excel Playground as your personal practice arena: a safe, resettable workbook where you can play with formulas, functions, charts, and pivot tables without breaking anything important. Each sheet gives you guided tasks, sample data, and space to experiment—filter, clean, analyze, and visualize while seeing instant results. Whether you're fixing messy data or testing a new formula combo, this sandbox keeps everything in one place, with no risk and all the learning fun.

    Google App ScriptGoogle SheetsExcelLearn in fun way
    View