Automated Accounting & Shop Performance System
Modsera Watches
Replaced 2–3 hours of daily manual reporting with a fully automated pipeline delivering a performance report to the owner's inbox every night.
Overview
Modsera Watches is an international Shopify brand that was spending 2–3 hours every day manually consolidating sales, ad spend, COGS, and bank transactions into a spreadsheet. A 6-stage automated pipeline was built to handle everything — from currency exchange snapshots to formatted daily email delivery.
The Problem
Every day the owner manually collected Shopify orders, computed COGS for bundle promotions, pulled ad spend from Meta and Snapchat, categorized bank transactions, and consolidated everything into a spreadsheet. 2–3 hours of repetitive work with a high risk of calculation errors.
The Solution
A multi-trigger n8n pipeline with 6 sequential stages: currency rate snapshot, real-time AI transaction categorization, daily ad spend collection, Shopify order processing with promo detection, financial computation, and automated daily report delivery.
Stage 1 — Currency Exchange Snapshot
A daily scheduled trigger locks the exchange rates for all shipping countries before end-of-day. All revenue calculations use these locked rates for consistency.
Stage 2 — AI Transaction Categorization
Every bank/card transaction fires a real-time webhook into n8n. Jina AI resolves the merchant name, then OpenAI classifies the transaction into the correct expense category automatically.
Stage 3 — Ad Spend Collection
Meta Ads and Snapchat Ads APIs are queried daily, pulling spend broken down by country — feeding directly into the P&L computation.
Stage 4 — Shopify Order Processing
All orders are pulled, segmented by country, and scanned for promotional bundles (3-for-2, 6-for-5) using line-item quantity and discount logic. Line items are stored individually for granular reporting.
Stage 5 — Financial Computation
COGS, gross profit, net profit, total ad spend, and multi-currency revenue are all computed automatically — with promo pricing handled correctly to prevent inflated figures.
Stage 6 — Report Delivery
All data is committed to Supabase and Google Sheets. A formatted daily summary email is sent to the owner every night — complete picture, zero manual work.
Results
Tech Stack
Key Takeaways
Promo bundle detection logic in Shopify orders is critical for accurate COGS — generic templates never account for this.
Real-time AI transaction categorization eliminates one of the most tedious parts of daily bookkeeping.
A locked end-of-day exchange rate snapshot ensures historical financial reports stay consistent regardless of currency fluctuations.
Want something similar for your firm?
Let's talk about what a custom automation system could look like for your operations.
Book a Discovery Call