Audit Shopify Sheets Formulas

My online footwear brand runs entirely out of Google Sheets synced to our Shopify store, yet the Profit & Loss tab keeps showing numbers that just don’t add up. I need a detail-oriented accountant who is comfortable inside Sheets formulas to trace where the profit calculations are going wrong, fix them, and leave the file cleaner for future updates.

Here’s the situation:
• Multiple linked sheets pull sales, returns, discounts, shipping fees, and COGS.
• Gross profit looks inflated, so something is mis-referenced or double-counted.
• Once costs and revenues are aligned, I want an accurate, easy-to-refresh P&L view.

What I expect from you
1. A forensic review of every formula that feeds the current P&L.
2. Corrections or rebuilds of SUMIFs, ARRAYFORMULAs, imports, or any other logic that skews the numbers.
3. A short note beside each change so I understand the fix.
4. A final, balanced Profit & Loss statement that matches Shopify exports for the same period.

If you regularly reconcile Shopify or e-commerce data in Google Sheets—and can explain VLOOKUP versus INDEX-MATCH without blinking—we’ll get along well. Let me share view-only access first, then we can dive in together.