No results
1
Home
dlawler489 edited this page 2026-06-20 07:29:33 +10:00
Table of Contents
Etsy Finance Tracker
Self-hosted finance and profit tracker for an Etsy shop. Pulls orders, fees, refunds, and listings directly from the Etsy API, matches them against a product catalogue with per-item costs, and reports profit, margins, expenses, and an AU financial-year P&L.
Live at etsy.plexultra.com.
Pages
- Architecture — stack, structure, data model
- Etsy Integration — connecting your shop, syncing orders/fees/listings
- Data Import — CSV/PDF imports (Australia Post + legacy)
- Reports & Analytics — dashboards, P&L, GST, ad ROI
- Deployment & CI — Forgejo Actions, registry, Dockhand, Traefik
- Troubleshooting — common issues and fixes
What it does
- Order sync from Etsy — line items, variations/sizes, tracking, customer, with per-item costs snapshotted at sync time
- Fee sync from the Etsy payment ledger — transaction, processing, listing, ads (
prolist/offsite), and GST, categorised automatically - Refunds netted from revenue so profit isn't overstated
- Catalogue sync from active listings — one product per size, costs preserved
- Customers built from buyers, with repeat-rate
- Reports — profit/margin dashboards, monthly trends, ad ROAS, AU financial-year P&L, and an indicative GST summary
What you maintain
Etsy provides the sales/catalogue side. You provide the cost side — set printing/material cost once per product (Products → "Missing costs" filter finds the ones needing it). Australia Post postage is imported via CSV (no usable API for MyPost Business history).
Quick links
- Settings → Etsy Integration: connect shop, Sync Orders, Sync Catalog
- Products → Missing costs: fill in per-product printing/material costs
- Profit Analysis → P&L / GST: financial-year reporting