Hub/Finances/Generate Financial Reports
Task IntentFinances

Generate Financial Reports

Create professional financial reports including profit and loss, balance sheet summaries, and key financial ratios for your store.

What This Sidekick Query Does

Create professional financial reports including profit and loss, balance sheet summaries, and key financial ratios for your store.

Prompts

Copy, adapt, and run this directly in Shopify Sidekick.

Generate comprehensive financial reports for my Shopify store:

Reporting Period:

  Report period: [THIS MONTH / THIS QUARTER / THIS YEAR / CUSTOM RANGE]
  Comparison period: [PREVIOUS PERIOD / SAME PERIOD LAST YEAR]
  Fiscal year start: [MONTH YOUR FISCAL YEAR BEGINS]


Profit and Loss Statement:

  Gross revenue (total sales before deductions)
  Less: discounts, returns, refunds
  Net revenue
  Less: cost of goods sold (product costs)
  Gross profit and gross margin percentage
  Operating expenses by category:
    
      Marketing and advertising
      Shopify plan and app fees
      Payment processing fees
      Shipping and fulfillment
      Payroll and contractors
      Rent and utilities
      Software and tools
      Other operating expenses
    
  
  Operating profit (EBITDA)
  Net profit and net margin percentage


Key Financial Ratios:

  Gross margin: [TARGET]% – are we hitting target?
  Net margin: trend over past [6] months
  Operating expense ratio (OpEx / Revenue)
  Customer acquisition cost (CAC) vs customer lifetime value (LTV)
  Inventory turnover ratio
  Return on ad spend (ROAS) by channel


Cash Flow Summary:

  Cash from operations (net profit + non-cash adjustments)
  Cash used for inventory purchases
  Cash used for capital expenditures
  Net change in cash position


Comparative Analysis:

  Period-over-period changes for all major line items
  Highlight items with greater than [15]% change
  Year-to-date totals and progress toward annual goals: [ANNUAL REVENUE GOAL]


Visualizations:

  Revenue and profit trend chart (monthly for past 12 months)
  Expense breakdown pie chart
  Margin trend line chart


Format as a professional report suitable for [PERSONAL REVIEW / INVESTOR UPDATE / LOAN APPLICATION / TAX PREPARATION].

Expected Output

Create professional financial reports including profit and loss, balance sheet summaries, and key financial ratios for your store.

Tips to Improve Results

Copy the prompt above
Open Shopify Sidekick in your Shopify admin
Paste the prompt and replace the bracketed placeholders with your details
Review Sidekick's response and apply the suggestions