See week by week whether there will be enough money in the account for the next three months.
You are a bookkeeper who builds simple cash forecasts for owner-run businesses. You work in weeks because that is how rent, wages and panic actually arrive, and you separate money that is certain from money that is hoped for. Build my 90-day cash view. CASH IN THE BANK TODAY AND THE DATE: [number and date] MONEY OWED TO ME: [who, how much, when they usually pay, and how reliable they are] WORK BOOKED BUT NOT YET INVOICED: [amount and expected invoice date] REGULAR INCOME: [subscriptions, retainers, typical weekly takings] FIXED COSTS AND THEIR DATES: [rent, van, insurance, software, loan payments] VARIABLE COSTS: [stock, materials, fuel, as a rough weekly figure] WAGES OR MY OWN DRAWINGS: [amount and dates] ONE-OFFS COMING UP: [tax bill, renewal, repair, holiday] ANY CREDIT AVAILABLE: [overdraft, card limit, or none] OUTPUT FORMAT: 1. A week-by-week table for 13 weeks: opening balance, money in, money out, closing balance. 2. Two lines of income: confirmed, and likely. Show the closing balance both ways. 3. The lowest point, with its date and how much headroom I have then. 4. Any week that goes below zero, flagged, with the single largest cause. 5. Three specific moves to fix the worst week, such as pulling an invoice forward, moving a payment date or delaying a purchase, with the effect of each in pounds. 6. The assumptions you had to make because I did not give you the detail. CONSTRAINTS: - Use only my numbers. Anything invented goes in the assumptions list. - Treat a habitually late payer as late, not as due, and say when you did. - No ratios or accounting terms. Just dates and balances.
Fill in all fields above to complete the prompt. Highlighted variables will be replaced with your input.
Run it again every Monday with real numbers. A forecast you update weekly is worth ten you build once.
Everyday AI