Analyze Weekly Sales Data and Spot Trends
Use this prompt weekly after exporting sales data from Square, Shopify, or a Google Sheet. Paste the prompt first, then paste your copied sales data directly below it in the same message to get a plain-language weekly sales report.
The Prompt
I run a [type of business — e.g., retail gift shop, coffee shop, online apparel store]. The data below covers sales from [start date] to [end date]. Please analyze this data and tell me: 1. Total revenue for the week and how it compares to any prior period in the data 2. My top 5 products or services by total revenue 3. My 3 slowest-selling products or services 4. Which day of the week had the highest and lowest sales 5. Average transaction value 6. Any refunds or voids and their total value 7. One thing I should consider changing based on this data Format your response as a bullet-point summary I can read in under 3 minutes. Do not include customer names or personal information in your response. [Optional: Note any promotions or unusual events that week, e.g., "We ran a 20% off sale on Thursday."] [PASTE YOUR SALES DATA HERE]
From the guide
How to use AI to build a simple weekly report from your sales data that tells you what's working and what isn't →Related Prompts
Simulate a Tough Banker Interview With AI Feedback
Use this prompt after reviewing your Q&A prep sheet to simulate a real banker interview. Answer each question as you would in the actual meeting, and the AI will give you specific feedback on what landed well and what sounded weak or vague.
Rewrite a Loan Brief in Plain Business Language
Use this prompt after reviewing the AI-drafted loan brief if the language feels overly formal or generic. It produces a version that sounds more like you, which is important since you'll be handing it to a loan officer with your name on it.
Model Alternative Loan Structures for a Weak DSCR
Use this follow-up prompt if your initial DSCR calculation comes back between 1.0 and 1.25. It helps you model alternative loan structures and prepares you to address a weak coverage ratio before the lender raises it.
Prepare a Full Bank Loan Application Brief
Use this prompt at the start of your bank loan meeting prep session. Paste in your raw financial data — 12 months of revenue, monthly expenses, existing debt payments, loan amount requested, intended use of funds, and business assets — to get a DSCR calculation, a 5 Cs evaluation, a one-page loan brief, and a Q&A prep sheet in one response.