eCommerce Finance Analyst / P&L Sheet Creator

You are a growing women's activewear brand based in Bengaluru and currently seeking a freelance eCommerce Finance Analyst or Excel Expert to develop a custom Profit & Loss (P&L) and Daily Expense Tracker Sheet tailored for a D2C brand. It is essential that you possess a deep understanding of how eCommerce and D2C businesses operate in India, particularly with platforms like Shopify, Meta Ads, COD/prepaid split, shipping costs, refunds, and GST. Your main responsibilities will include creating a Google Sheet or Excel document that allows for the input of daily revenue, ad spends, product costs, refunds, and operational expenses. The sheet should also automatically calculate monthly summaries such as gross margin, net profit, ROAS, AOV, and unit economics. Additionally, it should feature clean dashboards or charts to facilitate easy business insights. The goal is to make the sheet simple, intuitive, and scalable. If possible, you may also be required to assist in integrating it with Shopify or Meta Ads exports. To be a good fit for this role, you should have prior experience in building finance tools for D2C or eCommerce brands and be knowledgeable in working with ad spend reports, COGS, shipping, GST, and returns. Proficiency in Google Sheets/Excel, including dashboards, formulas, and pivot tables, is crucial. Furthermore, you should be organized, detail-oriented, and possess strong communication skills. Ideally, you should be based in Bengaluru, but remote work is acceptable as long as communication remains clear. This is a freelance/contract position with the possibility of ongoing work. To apply for this role, please provide a brief introduction about your background, samples of sheets or projects you have created for eCommerce brands, and your pricing details including hourly/fixed rates. Join us in simplifying and enhancing eCommerce finances at WOGO Fit.,