PromptBase
Upgrade
Close icon
General
Home
Marketplace
Create
Hire
Login
Chat
Sell
Explore

Prompt Details

Model
Chat - (gpt-5.5)
Token size
630
Example input
[Business Context]: Small Shopify store selling handmade skincare products with one owner and two part-time helpers. [Revenue Details]: Average monthly revenue is about $8,000. Main income comes from online product sales, repeat customers, and seasonal gift bundles. [Expense Details]: Main costs include product ingredients, packaging, Shopify apps, paid ads, shipping supplies, part-time help, and email marketing software. [Financial Problems]: Cash flow feels tight even when sales are good. Product costs keep rising, ad spending is inconsistent, refunds sometimes hurt profit, and the owner does not know which products are most profitable. [Goals Limits Data]: Goal is to improve monthly profit, reduce waste, understand margins, and create a simple tracking system. Budget is limited. Current data comes from Shopify, bank statements, and a basic spreadsheet.
Example output
Below is a CFO-style diagnostic based on the information provided. Exact profitability cannot be calculated yet because product-level costs, cash balance, ad spend, refund volume, inventory value, and labor hours are missing. Any numbers below are **estimates**, not facts. ## 1. Financial Health Diagnosis The store is generating meaningful revenue at about **$8,000 per month**, but the business likely has a **profit visibility problem**, not just a sales problem. Sales are coming in, but the owner does not clearly know how much cash is left after ingredients, packaging, fulfillment, ads, apps, refunds, and labor. The biggest warning sign is: **cash flow feels tight even when sales are good**. That usually means one or more of these issues is happening: The business may be over-ordering ingredients or packaging before cash is available. Handmade skincare often requires buying materials upfront, while customer revenue arrives later or gets absorbed by ads, refunds, and operating costs. Margins may be inconsistent by product. Some products may look popular but actually produce weak profit after packaging, shipping materials, discounts, labor, and refunds. Marketing may be reactive instead of controlled. Inconsistent ad spending can create cash spikes: one week the business spends heavily to drive sales, but the profit from those sales may not cover the ad cost fast enough. Refunds are likely being treated as a customer service issue, but they should also be tracked as a **profit leak**. Shopify reporting treats net sales differently from gross sales because discounts and returns reduce sales; Shopify’s own reporting terminology defines net sales as gross sales minus discounts and returns. ([Shopify Help Center][1]) The business also has weak financial decision support. Without product-level gross margin, the owner cannot confidently decide which products to promote, bundle, discontinue, reprice, or restock. A simple CFO diagnosis would be: | Area | Current Risk | CFO View | | ------------ | -----------------: | ------------------------------------------------------------------- | | Revenue | Moderate | $8,000/month is viable, but may be unstable due to seasonal bundles | | Gross margin | Unknown/high risk | Product costs are rising and product-level margins are unclear | | Cash flow | High risk | Tight cash despite sales means timing, waste, or margin leakage | | Ads | High risk | Inconsistent spend can hide poor return on ad spend | | Refunds | Moderate/high risk | Refunds directly reduce net sales and cash | | Tracking | High risk | Basic spreadsheet is not enough unless it tracks SKU-level margin | | Labor | Moderate risk | Part-time help may be necessary, but must be tied to order volume | ## 2. Cash Flow Analysis Money likely moves through the business like this: Customer pays through Shopify → payment processor releases cash → cash goes to ingredients, packaging, shipping supplies, ads, Shopify apps, email software, part-time helpers, refunds, and owner pay. The problem is that cash probably leaves the business **before the owner clearly sees true profit**. Possible cash timing problems: | Cash Flow Issue | Why It Hurts | | ------------------------------------------ | --------------------------------------------------------------------------- | | Ingredients bought upfront | Cash is spent before the product sells | | Packaging bought in batches | Inventory cash gets locked in boxes, jars, labels, and mailers | | Paid ads spent before profit is confirmed | Sales may rise while net cash falls | | Refunds after money has already been spent | Refunds hurt twice: lost revenue plus unrecovered product/fulfillment costs | | Seasonal bundles | Strong revenue months may require heavier upfront buying | | Software subscriptions | Small monthly tools quietly reduce profit every month | | Labor paid regardless of product margin | Help may be needed, but low-margin orders may not support the labor cost | The store should create a **13-week cash forecast**. SCORE recommends cash flow projections because they help identify periods where cash may run low before the problem becomes urgent. ([SCORE][2]) A simple weekly forecast should track: | Week | Starting Cash | Expected Shopify Payouts | Ingredient/Packaging Buys | Ads | Labor | Software | Refunds | Ending Cash | | ---- | ------------: | -----------------------: | ------------------------: | --: | ----: | -------: | ------: | ----------: | This is more useful than looking only at monthly revenue because the business may be “profitable on paper” but cash-poor during the week when inventory, ads, or payroll hit. ## 3. Profit Leak Detection The likely profit leaks are: ### Product Cost Creep Ingredients and packaging are rising. If prices have not been updated recently, every sale may be less profitable than the owner thinks. The store needs a product cost card for every SKU: | Cost Component | Example | | ----------------------- | ------------------------------------------------ | | Ingredients per unit | Oils, butters, actives, fragrance, preservatives | | Primary packaging | Jar, bottle, tube, label | | Outer packaging | Box, tissue, insert, sticker | | Shipping supplies | Mailer, filler, tape | | Payment/platform cost | Shopify/payment processing estimate | | Labor per unit | Making, labeling, packing | | Refund/defect allowance | Small percentage reserve | | Total unit cost | True cost before profit | Shopify’s profit margin calculator uses the basic gross margin logic: **net sales minus cost of goods sold, divided by net sales**. ([Shopify][3]) ### Discounts and Gift Bundles Seasonal gift bundles may increase revenue but reduce profit if the discount is too deep or packaging cost is too high. A bundle should not be judged by revenue. It should be judged by: **Bundle profit = bundle price − product costs − bundle packaging − shipping materials − payment cost − ad cost allocation − labor time.** Some bundles may be cash traps if they sell well but require expensive packaging, extra assembly time, or discounted pricing. ### Paid Ads Inconsistent ad spending is dangerous because the owner may not know whether ads are creating profit or only creating volume. The business should track: **Contribution profit after ads = net sales − COGS − shipping supplies − payment fees − ad spend.** If ads create $2,000 in sales but only $200 in contribution profit, they may not be worth scaling. ### Refunds Refunds need to be categorized by reason: | Refund Reason | CFO Action | | ------------------------------- | --------------------------------------- | | Damaged item | Improve packaging or carrier choice | | Skin reaction / dissatisfaction | Improve product expectation setting | | Wrong item | Fix fulfillment checklist | | Late delivery | Review shipping promises | | Buyer regret | Tighten refund policy and product pages | Refund rate should be tracked monthly. If one product has a high refund rate, it may need reformulation, clearer instructions, better photos, or removal. ### Software Subscriptions Shopify apps and email tools often start cheap but become silent profit drains. Each tool should be assigned one of three labels: **Revenue-generating, operations-critical, or optional.** Anything optional should be paused unless it clearly saves time or increases profit. ### Labor Two part-time helpers may be justified, but the store needs to know: **Labor cost per order** and **labor cost per product batch**. If labor is not tracked, the owner may underprice handmade products. ## 4. Expense Optimization Plan Here is the CFO priority order. | Expense | Action | Reason | | ------------------------ | ---------------------------------- | ------------------------------------------------------------------------ | | Ingredients | Keep, but control | Essential, but rising costs must be reflected in pricing | | Packaging | Reduce/standardize | Too many packaging types increase waste and cash tied in inventory | | Shopify core plan | Keep | Operating platform | | Shopify apps | Audit and cut | Remove apps that do not increase sales, save labor, or improve retention | | Paid ads | Pause weak campaigns, cap tests | Ads should be controlled by margin and cash availability | | Shipping supplies | Standardize and bulk-buy carefully | Avoid overbuying slow-moving supplies | | Part-time help | Keep if tied to volume | Track labor per order and per batch | | Email marketing software | Keep if producing repeat sales | Email is likely more profitable than ads if used well | | Seasonal extras | Reduce | Gift packaging can quietly destroy margin | | Discounts | Restrict | Replace blanket discounts with strategic bundles or thresholds | Immediate expense rules: Do not buy ingredients for products that sell slowly unless they have strong margins. Do not run ads for products with unknown margins. Do not discount bestsellers until product-level profit is known. Do not keep software because it is “only $20/month.” Ten small tools can become a major leak. ## 5. Pricing And Revenue Strategy The store should not raise every price blindly. It should segment products into four groups. | Product Type | Action | | ------------------------ | ------------------------------------------------------- | | High sales + high margin | Promote, bundle, restock first | | High sales + low margin | Reprice, reduce packaging cost, or increase order value | | Low sales + high margin | Improve product page and email promotion | | Low sales + low margin | Discontinue or sell through inventory | Practical revenue moves: ### Raise Prices Selectively Start with products where ingredient or packaging costs have increased. A small price increase of 5% to 12% may be easier than trying to double sales. Example estimate: If monthly revenue is $8,000, a 7% effective price increase on only half of sales would add about: **$8,000 × 50% × 7% = $280/month extra revenue** If costs do not rise, most of that becomes additional gross profit. ### Improve Average Order Value Use simple offers: “Buy 2, save slightly” instead of deep discounts. Free shipping threshold above current average order value. Example: if current AOV is $38, set free shipping at $55 or $60, not $40. ### Build Higher-Margin Bundles Do not bundle only by theme. Bundle by margin. A good skincare bundle should include one hero product plus one or two high-margin add-ons. Example: Cleanser + moisturizer + lip balm may be better than three expensive-to-produce core products. ### Add Refill or Subscription Options Repeat customers are already a main income source. This business should test: Monthly skincare restock bundle. Seasonal self-care box. Subscribe-and-save for consumable bestsellers. VIP early access for seasonal gift bundles. Recurring revenue helps smooth cash flow, but only if fulfillment and margins are controlled. ### Reduce Refunds Through Better Product Pages Improve product descriptions with: Skin type guidance. Scent strength. Texture. Patch test reminder. Product size clarity. Expected results timeline. Refund prevention is profit improvement. ## 6. Runway And Risk Review Exact runway cannot be calculated because current cash balance and monthly net cash outflow are missing. Use this formula: **Runway = available cash ÷ average monthly cash loss** If the business is profitable: **Safety runway = available cash ÷ fixed monthly expenses** For this store, fixed or semi-fixed costs likely include Shopify, apps, email software, recurring labor, minimum ad spend, and basic supplies. Estimated risk scenarios: | Scenario | Meaning | | ----------------------------------------- | --------------------------------------------------- | | Cash covers less than 1 month of expenses | High risk; avoid big inventory buys and ad scaling | | Cash covers 1–2 months | Manageable but tight; weekly cash forecast required | | Cash covers 3+ months | Healthier; can test ads and bundles cautiously | Biggest short-term risks: Ingredient cost increases reduce margin before the owner notices. Ads consume cash without verified profit. Refund spikes create sudden cash pressure. Seasonal inventory overbuying locks up cash. Labor cost rises faster than order volume. Biggest long-term risks: The owner keeps scaling revenue without knowing product-level profit. Too many SKUs create complexity, waste, and cash tied in inventory. The store relies too much on seasonal sales instead of predictable repeat purchases. The business underprices handmade products because labor is not fully counted. ## 7. 30-Day Cash Improvement Plan ## Week 1: Build Financial Visibility Create one simple spreadsheet with these tabs: | Tab | Purpose | | ------------------ | ------------------------------- | | Monthly P&L | Revenue, COGS, expenses, profit | | SKU Margin | Profit by product | | Cash Forecast | Weekly cash in/out | | Refund Log | Refund reason and product | | Subscription Audit | Apps and software | | Ad Tracker | Spend, sales, profit estimate | Pull from Shopify: Gross sales. Discounts. Returns/refunds. Net sales. Units sold by SKU. Shipping charged to customer. Payment fees if available. Shopify reporting distinguishes gross sales, discounts, returns, net sales, taxes, shipping, and cost of goods sold in its reporting terminology, so those fields should be separated instead of lumped together. ([Shopify Help Center][1]) ## Week 2: Calculate Product-Level Margins For the top 10 products by revenue, calculate: Selling price. Discounted selling price. Ingredients per unit. Packaging per unit. Shipping supplies. Labor estimate. Refund allowance. Gross profit dollars. Gross margin percentage. Then classify each product: | Margin Status | Action | | ------------------------- | ---------------------------- | | Strong margin | Promote | | Okay margin | Monitor | | Weak margin | Reprice or reduce cost | | Negative/near-zero margin | Stop discounting immediately | ## Week 3: Cut Waste and Control Cash Cancel or pause non-essential apps. Set a weekly ad budget cap. Stop promoting products with unknown or weak margins. Reduce packaging complexity. Use current inventory before buying more ingredients. Review refunds and identify the top causes. Set a purchasing rule: **Only restock products that have clear sales velocity and acceptable margin.** ## Week 4: Improve Revenue Quality Raise prices on weak-margin bestsellers. Create one high-margin bundle. Add an upsell at checkout. Email repeat customers with a margin-friendly offer. Test a free shipping threshold above current AOV. Create a monthly financial review routine. By the end of 30 days, the owner should know: Which products make the most profit. Which products drain cash. Which expenses are unnecessary. How much cash is needed for the next 4 weeks. Whether ads are profitable or just creating sales volume. ## 8. KPI Dashboard Track these monthly and weekly. | KPI | Formula | Why It Matters | | ------------------------- | ------------------------------------------------------- | --------------------------------------------- | | Revenue | Total monthly sales | Shows business volume | | Net sales | Gross sales − discounts − returns | Better than gross revenue for decision-making | | Gross profit | Net sales − COGS | Shows money left after product costs | | Gross margin % | Gross profit ÷ net sales | Shows product profitability | | Cash balance | Bank cash available | Shows survival capacity | | Monthly expenses | All operating expenses | Shows burn rate | | Net profit | Net sales − COGS − operating expenses | Shows true owner profit | | Average order value | Net sales ÷ number of orders | Helps improve revenue without more traffic | | Customer acquisition cost | Ad spend ÷ new customers | Shows cost to acquire buyers | | Refund rate | Refunds ÷ gross sales or orders refunded ÷ total orders | Shows product/service leakage | | Ad spend % of sales | Ad spend ÷ net sales | Prevents overspending | | Labor cost per order | Labor cost ÷ orders shipped | Prevents hidden underpricing | | Inventory cash tied up | Value of ingredients/packaging/inventory | Shows cash locked in stock | | Runway | Cash ÷ monthly fixed expenses or cash burn | Shows financial breathing room | Suggested alert levels: | Metric | Warning Sign | | ------------ | ------------------------------------------------- | | Gross margin | Falling for 2 months | | Refund rate | Rising or concentrated in one product | | Ads | Spend increasing faster than profit | | AOV | Flat while costs rise | | Cash balance | Less than 1 month of fixed costs | | Inventory | Buying increases but sales do not | | Labor | Labor cost per order rises without price increase | ## 9. Decision Recommendations ## Do Next Build SKU-level margin tracking immediately. Separate revenue from profit in the spreadsheet. Create a weekly cash forecast. Audit all software subscriptions. Track refund reasons by product. Set a fixed weekly ad budget until margins are known. Raise prices on products where costs have increased. Create one high-margin bundle instead of discount-heavy gift sets. ## Stop Doing Stop judging products by revenue only. Stop running ads for products without known gross margin. Stop offering blanket discounts. Stop buying ingredients based only on hope or seasonality. Stop treating refunds as isolated events. Stop adding new tools before checking whether current tools pay for themselves. ## Test Test a 5% to 12% price increase on selected products. Test a free shipping threshold above current AOV. Test one subscription/restock offer for repeat customers. Test replacing discounts with gifts-with-purchase using low-cost, high-perceived-value items. Test fewer packaging options to reduce waste. ## Monitor Before Bigger Decisions Monitor profit by SKU for at least 30 to 60 days before expanding the product line. Monitor ad profitability before increasing spend. Monitor refund rate before scaling seasonal bundles. Monitor inventory turnover before buying larger ingredient quantities. Monitor owner pay after true profit is known. ## 10. Executive CFO Summary This Shopify skincare store has a real revenue base at about **$8,000 per month**, repeat customers, and seasonal demand. The main issue is not that the business has no opportunity. The issue is that the owner does not yet have enough financial visibility to know which sales are actually profitable. The biggest opportunity is to move from “sales tracking” to **profit tracking by product**. Once each SKU has a real cost card, the owner can promote the right products, reprice weak-margin items, reduce waste, and stop selling offers that create revenue but drain cash. The biggest risk is continuing to grow revenue while cash remains tight. That can happen when ingredient costs rise, ads are inconsistent, refunds reduce net sales, and inventory is purchased before profit is confirmed. The next 30 days should focus on four actions: calculate SKU margins, build a weekly cash forecast, audit expenses, and restructure offers around higher-margin products. Do not scale ads or launch more products until the business knows which products produce real contribution profit. This is not legal, tax, or investment advice. It is a practical financial operating diagnosis based on the limited information provided. [1]: https://help.shopify.com/en/manual/sell-in-person/shopify-pos/inventory-management/stocky/reporting/profit-reporting?utm_source=chatgpt.com "Profit reporting terms" [2]: https://www.score.org/resource/template/3-year-cash-flow-statement?utm_source=chatgpt.com "3-Year Cash Flow Statement - SCORE.org" [3]: https://www.shopify.com/tools/profit-margin-calculator?utm_source=chatgpt.com "Profit Margin Calculator: Boost Your Business Growth"
🤖 GPT

Cash Flow Cfo

Add to Cart
Instant accessInstant access
Usage rightsCommercial use
Money-back guaranteeMoney‑back
By purchasing this prompt, you agree to our terms of service
GPT-5.5
Tested icon
Guide icon
4 examples icon
Free credits icon
Turn AI into a practical CFO for small businesses. Analyze cash flow, profit leaks, expenses, pricing, runway, financial risks, and growth decisions. Perfect for founders, freelancers, agencies, creators, and online businesses that need clearer financial direction.
...more
Added 2 days ago
Report
Browse Marketplace