Google Sheets Dashboard for Clothing Brand

I need a professional to build a Google Sheets dashboard for my clothing brand. The sheet should track:

Orders (Prepaid & COD) with delivery/RTO/returns
Expenses (ads, manufacturing, Shopify fees, misc)
Auto formulas for profit & loss (cash-basis: COD credited 3 days after delivery, Prepaid credited 2 days after order)
Daily & Monthly summaries
Dashboard with KPIs (Revenue, Expenses, Net Profit, Delivered %, RTO %, Return %) and charts (line, bar, pie)

Requirements:
- Fully automated with formulas (no manual calculation)
- Clean, easy-to-use dashboard
- Works seamlessly in Google Sheets

Ideal Skills and Experience:
- Expertise in Google Sheets, including advanced formulas and dashboard creation
- Experience with Shopify and e-commerce financial tracking
- Strong analytical skills to ensure accurate KPI representation