The problem: Your bank balance tells you where you are today, not where you'll be when payroll and rent hit. A slow month can sneak up on you.
What you end up with: A simple week-by-week look at the next four weeks: money you expect in, bills going out, and the weeks that look tight, rebuilt every Monday from your own lists, for you to check.
What you'll need
Your current bank balance, a list of unpaid invoices with expected pay dates, and a list of upcoming bills, payroll, and subscriptions with due dates.
Getting set up
Wondering whether you'll have enough cash next month? Here's a playbook built from what each tool's official docs say it can do. First, pick a tool. Microsoft says Copilot in Excel analyzes data, creates charts, and generates insights. Google says Gemini in Sheets can build spreadsheets and fill in tables from plain-English prompts. xAI lists routines on a schedule in every Grok Bot plan, so a Bot could rebuild the sheet each Monday. Next, keep two simple lists: money coming in and money going out, each with a date. Then, pick one day a week to update your balance. And last, the agent builds the look-ahead. You check it and decide what to do.
Step by step
- Each Monday, update your bank balance and both lists.
- Have the agent sort everything into the next four weeks.
- Ask it to work out a running balance at the end of each week.
- Have it flag any week that drops below the cushion you set.
- Ask for a short list of options for tight weeks, like following up on an invoice early.
- Check the numbers against your bank and bills.
- Decide your next steps. The agent doesn't move any money.
A prompt to start with
Here's a prompt to start with. Adjust it to fit your tool. "Using my starting balance of [amount], this list of expected payments in: [list], and this list of bills out: [list], build a week-by-week table for the next four weeks with money in, money out, and the ending balance. Flag any week below [cushion]. Then suggest three options for tight weeks. Only use my numbers, and mark anything unclear with [CHECK]."
What you'll get
A four-week table with a running balance, flags for tight weeks, and a few options to consider.
If something goes wrong
If totals look off, check for duplicate bills or invoices already paid. If it assumes clients pay on time, add your real average delay. If the table gets cluttered, group small bills into one line.
Keep in mind
This is a planning aid, not accounting or financial advice. Payment dates are guesses until money arrives, so keep a cushion. Keep financial files private, and talk to your bookkeeper or accountant about big decisions.
Sources
- Microsoft Copilot for small business — product page and FAQ
- Google Workspace — AI tools for business
- Grok Bot — official product page (xAI)
Where each fact came from
- Recommended tools · checked Oct 28, 2026 · rechecked regularly — Microsoft Copilot for small business — product page and FAQ
- Getting set up · checked Oct 28, 2026 · rechecked regularly — Grok Bot — official product page (xAI)
Heads-up: some links here may become affiliate links down the road. Here's how that works. Right now, no affiliate programs are connected.