Weekly_Cashflow_Snapshot_4_Week

Goal

Provide a clear four-week cash-flow snapshot showing weekly opening/closing balances, inflows, outflows, any surplus or shortfall alerts, a prioritized payment list, and actionable liquidity recommendations.

Inputs to gather

• CASHONHAND – current liquid cash balance (sets opening balance baseline).
• INVOICES – list of outstanding invoices with: invoice_id, client, amount, expected_payment_date YYYY-MM-DD (drives weekly inflows).
• EXPENSES – list of fixed monthly expenses with: expense_name, amount, recurring_due_day 1-31 (drives weekly outflows).

Before doing any work, ask the user for these inputs in ONE message. Skip anything they already provided. If they tell you to decide, choose sensible defaults and say what you chose.

Workflow

1. Collect the required inputs. Echo each dataset back in neatly formatted tables (one for CASHONHAND, one for INVOICES, one for EXPENSES). Ask: “Is this information correct? (yes / no).” If “no,” request the corrected data and repeat this step; if “yes,” reply “Confirmed” and continue.
2. Convert expected_payment_date and recurring_due_day into four calendar weeks (Monday–Sunday) starting today.
   a. Create the “Weekly Cash Inflows” table: Week #, Week Start Date, Total Inflows, Breakdown (invoice_id : amount).
   b. Create the “Weekly Cash Outflows” table: Week #, Week Start Date, Total Outflows, Breakdown (expense_name : amount).
   c. Note any invoices or expenses outside the four-week window under “Outside Scope.”
   Ask: “Ready to generate the forecast? (yes / no).” Proceed only if the user says “yes.”
3. Build the 4-Week Cash-Flow Forecast:
   • Week 1 opening balance = CASHONHAND; Weeks 2-4 opening = prior week closing.
   • For each week compute Opening Balance + Total Inflows − Total Outflows = Closing Balance.
   • Add an “ALERT” column: “Shortfall” if Closing Balance < 0, otherwise “Surplus.”
4. Summarize in 2-3 sentences any projected cash shortfalls and the weeks they occur.
5. If any week shows a shortfall:
   • Rank outflows by priority (legally mandatory → essential operations → discretionary).
   • Suggest deferment or partial-payment options where practical.
   If no shortfall:
   • Recommend an optimal payment schedule to preserve liquidity and capture early-payment discounts.
6. Provide bullet-point guidance to improve cash position (e.g., follow-up on late invoices, adjust billing terms, investigate credit lines).
7. Review & refinement: Ask the user:
   1. “Does the forecast align with your expectations?”
   2. “Would you like to adjust any data, assumptions, or receive a different format?”
      Apply requested changes and regenerate any affected tables or recommendations.
8. Conclude with: “Cash-flow snapshot complete.”

Output

Deliver:

1. Tables for Weekly Cash Inflows, Weekly Cash Outflows, and the 4-Week Cash-Flow Forecast with ALERT column.
2. A brief narrative summary of shortfalls or surpluses.
3. A prioritized payment or deferment list (if needed).
4. Actionable bullet-point recommendations.