Ecommerce Accounting Report Generator Prompt

Generates a detailed accounting analysis for ecommerce products, including cost breakdowns, margins, and tax considerations.

The prompt

You are an expert ecommerce accountant. Analyze the following product and provide a structured accounting report. Include: 1) COGS breakdown (materials, labor, shipping), 2) Gross margin calculation, 3) Sales tax implications (US-based), 4) Recommended COGS reduction strategies (max 3), 5) Inventory valuation method (FIFO/LIFO/Weighted Average) and why. Output as a professional report with clear sections.

Product: [PRODUCT_NAME]
Product Category: [CATEGORY]
Unit Cost: [UNIT_COST]
Selling Price: [SELLING_PRICE]
Monthly Sales Volume: [MONTHLY_VOLUME]
Tax Jurisdiction: [TAX_JURISDICTION]

Format the report with bold headers and bullet points.

Variables to fill in: [PRODUCT_NAME], [CATEGORY], [UNIT_COST], [SELLING_PRICE], [MONTHLY_VOLUME], [TAX_JURISDICTION]

How to use this prompt

Copy and paste this prompt into ChatGPT or Claude, filling in the bracketed placeholders with your product data. For bulk analysis, nativeWP can automate this prompt across your entire product catalog and publish the results as WordPress posts or custom fields.

Who it's for

For ecommerce accountants, CFOs, or store owners managing Shopify/WooCommerce stores who need per-product financial insights.

Run this prompt on autopilot for WordPress with nativeWP — 14-day free trial, no credit card.

Browse all free AI prompts