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