The Import CSV button auto-detects whether you're dropping a Shopify products export or an orders export and routes it to the right place. For products: reads Handle, Title, Option1 Value, Variant SKU, Variant Inventory Qty, Cost per item, Variant Price. Existing SKUs update quantity/price; manual fields (reorder, supplier, lead days) are preserved. For orders: reads Name, Created at, Lineitem sku, Lineitem quantity, Lineitem price. Each line item becomes a sale. Duplicate order+SKU combos are skipped automatically.

Every transaction is a double-entry journal. Money flows from one account (credited) into another (debited). Buying inventory: Debit Inventory, Credit Bank. Paying for marketing: Debit Marketing, Credit Bank. A refund reverses the direction. When you imported your old Monzo CSV the categories were mapped automatically. New CSV imports keep working the same way. To add accounts, run an UPDATE/INSERT in Supabase against public.accounts; everything in the dropdowns refreshes in real time.

Export campaign performance from Meta Ads Manager (or Google Ads) as a CSV, then click Import CSV. Sixforty auto-detects Meta exports by their column headers (Campaign name, Amount spent, Reporting starts, Reporting ends, Impressions, Reach, Clicks, CTR, CPC, CPM, Frequency, Results, Purchases conversion value). One CSV row becomes one campaign-period record. Re-imports for the same campaign and date range update in place. Blended ROAS below is computed against actual Shopify revenue in the same period, so you can compare Meta's reported attribution to what hit the till.

Each panel below checks a specific consistency rule in your books at a chosen as-of date. Green means the numbers match, amber means there's a gap worth investigating. Bank balances are populated automatically from any native Monzo CSV you import (the Balance column); you can also enter a point by hand. Shopify snapshots come from periodic pulls via the Shopify MCP (or manual entry). Once you've set up the scheduled task, this whole tab runs hands-off.