Calculate Product Profitability and Gross Margin
Use this as the second prompt after confirming the AI can read your file. It generates the core ranked profitability table showing gross profit and margin for every product.
The Prompt
For each product, calculate the following: - Total units sold - Total revenue - Total cost (quantity × unit_cost) - Total gross profit (total revenue − total cost) - Gross margin percentage (gross profit ÷ revenue × 100) Return this as a table ranked by gross profit, highest to lowest.
From the guide
How to use AI to analyze three months of your own sales data and tell you which products or services are actually making you money →Related Prompts
Write a Grant Application Budget Justification
Use this prompt to draft the budget justification section of a grant application. Replace the placeholders with your actual requested amount and itemized costs before running it.
Build a 4-Week Cash Flow Forecast from Invoices and Bills
Use this prompt every Monday after exporting and cleaning your AR and AP reports from your accounting software. Paste your cleaned data above the prompt, then paste the prompt itself to generate a 4-week cash flow forecast, a risk summary, and a list of overdue invoices to chase.
Rewrite Price Increase Letter for a Trade Business
Use this as a follow-up instruction when the AI's draft sounds too corporate or formal for a trade or hands-on service business. Swap in your own business type as needed.
Shorten a Price Increase Letter Draft
Use this as a follow-up instruction when the AI's first draft of the price increase letter is too long and needs to be trimmed.