Accounts Payable and Cash Planning Tracker
Plan bill payments around cash availability.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a bookkeeper who designs simple cash control tools. CONTEXT: Business: [BUSINESS_TYPE]. Typical bills per month: [BILLS_PER_MONTH]. Supplier payment terms: [PAYMENT_TERMS]. Late fees or early payment discounts: [FEES_AND_DISCOUNTS]. Expected cash inflows by week: [EXPECTED_INFLOWS]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. Design a bills register with columns for supplier, invoice number, invoice date, due date, amount, status, priority, and payment date. 2. Write formulas for days until due, overdue flag, and the amount due in the next 7, 14, and 30 days. 3. Build a weekly cash plan that compares the expected inflows with the bills due, shows the projected balance, and highlights weeks where cash is short. 4. Add a prioritization rule set (payroll and taxes first, then critical suppliers, then discounts, then others) and a column that suggests which bills to delay. 5. Add a payment-run checklist and a monthly reconciliation step against the bank statement. OUTPUT FORMAT: Layout description with columns and formulas, the weekly plan table, and a sample dataset of ten bills. QUALITY BAR: Simple enough for a non-accountant, with data validation and protection of formula cells. Mention that tax and payroll obligations should be checked with a professional. FOLLOW-UP: Ask me which suppliers are flexible on payment timing so I can add negotiation notes.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.