Using AI to build a simple weekly cash position update you can read in two minutes so you always know if you can make payroll

Most small business owners find out they can't make payroll the week it's due. This post shows you how to track cash flow for your small business without an accountant — using a weekly AI-powered cash check with ChatGPT{:target="_blank"}, Claude{:target="_blank"}, or Google Gemini{:target="_blank"}. No accounting software required. A structured prompt turns five numbers from your bank into a clear payroll safety answer in under two minutes.

What you need before you start

Tool: ChatGPT (GPT-4o), Claude (Claude 3.5 or 3.7 Sonnet), or Google Gemini (2.0 Flash or Pro) — any of these works. All have free tiers. Claude 3.7 Sonnet and Gemini 2.0 accept direct CSV uploads if your bank exports them, which saves copy-paste time.

Time required: 5–10 minutes per week once set up; 15–20 minutes the first time you run it

Skill level: No coding required. You need to export or view recent transactions in your online banking portal and be able to copy text.

The Five Numbers You Need to Track Cash Flow Without Bookkeeping Software

You do not need full bookkeeping records. You need five specific numbers. Nothing else.

1. Open your online banking portal. Navigate to your primary operating account — the one payroll comes from. You should see your current available balance.

2. Write down your current balance. Use the available balance, not the ledger balance. This is the number the bank will actually let you spend today.

3. Pull your outstanding invoices. Open your invoicing tool — Wave{:target="_blank"}, QuickBooks{:target="_blank"}, a spreadsheet, whatever you use. List every invoice due in the next 14 days with the client name, amount, and due date. If you don't use software, check your email for sent invoices you're waiting on.

4. List every bill or expense due in the next 14 days. Include rent, subscriptions, vendor payments, loan payments, and any tax deposits. Check your email, your calendar, and your bank's scheduled payments screen. IRS payroll tax deposits count here — include the full gross payroll amount, not just net pay.

5. Confirm your next payroll date and total cost. Total cost means gross wages plus employer-side payroll taxes, not just the net amount your employees receive. Missing this distinction is how businesses end up short even when they think they planned correctly.

These five inputs are the whole picture: current balance, incoming money, outgoing money, and the payroll obligation you're protecting. Keep them in a simple three-column table formatted as: Item | Amount | Due Date. That format produces cleaner AI output than narrative notes.

Building Your Weekly Cash Flow Check Prompt

This is the prompt. Copy it. Save it in Apple Notes, Notion, Google Docs — anywhere you'll find it on Monday morning. Fill in your five numbers before you paste.

Paste this into ChatGPT, Claude, or Gemini:

I need a plain-English cash position update for my small business. Here is my current financial snapshot:

Current bank balance: $[X]

Incoming money in the next 14 days (outstanding invoices):

Client / Source	Amount	Expected Date
[Client A]	$[X]	[Date]
[Client B]	$[X]	[Date]

Outgoing money in the next 14 days (bills, expenses, tax deposits):

Item	Amount	Due Date
[Expense A]	$[X]	[Date]
[IRS payroll tax deposit]	$[X]	[Date]

Next payroll:

• Date: [Date]
• Total cost (gross wages + employer taxes): $[X]

Please do the following:

1. Calculate my projected cash balance on payroll day, assuming all listed receivables arrive on time.
2. Calculate my projected cash balance on payroll day if none of my receivables arrive on time.
3. Tell me whether I can cover payroll under both scenarios — yes or no.
4. Flag any single item that poses the biggest risk to making payroll.
5. Give me this summary in plain English. No jargon.

The prompt forces two scenarios — receivables arriving and not arriving — because a business can look fine on paper and still miss payroll if one client pays late. That gap between profitable and cash-positive is where most payroll problems live.

How to read the output

The AI will return a short analysis. Here is how to interpret what it tells you.

Safe: Your projected balance covers payroll in both scenarios — receivables arriving and not arriving. You have enough on hand today. No action needed beyond confirming your bills are queued.

Tight: You can cover payroll if receivables arrive on time, but not if they're late. This is your signal to follow up on outstanding invoices immediately. Send a payment reminder today. Do not wait until Friday.

Danger: You cannot cover payroll even if all receivables arrive as expected. This requires immediate action — not a workflow adjustment. You need to either delay a non-critical expense, negotiate a short-term credit line, or call your biggest outstanding client directly and ask for early payment.

The AI will also flag a single highest-risk item. Pay attention to this line. It is usually either your largest outstanding invoice or a bill due before payroll that you may have underweighted.

Making it a weekly Monday morning routine

The cadence is Monday, before you open email. It takes ten minutes.

1. Open your banking portal. Copy your available balance.
2. Open your invoicing tool or sent-invoice folder. Note what's due in 14 days.
3. Check your bill payment calendar and IRS deposit schedule. Note what's due in 14 days.
4. Open your saved prompt. Fill in the five numbers.
5. Paste into ChatGPT, Claude, or Gemini. Read the output.
6. If the result is Tight or Danger, take one action before you close the tab.

The whole process runs under ten minutes for a business with fewer than ten employees. A non-financial team member — an office manager, an executive assistant — can run this with no training beyond reading this post. Save the filled prompt from last week as your starting template for the next week. Most of your numbers will carry forward with small changes.

When something goes wrong

The AI gives generic cash flow advice instead of specific numbers. You left the prompt vague or skipped the table format. Go back, fill in actual dollar amounts with actual due dates, and paste the full structured prompt. Vague inputs return advice, not answers.

The projected balance looks wrong — numbers don't add up. You likely mixed available balance with ledger balance, or included a receivable that is already in your bank but not yet cleared. Use only the available balance figure from your bank. Remove any invoices for which you've already received payment from your incoming table.

The AI flags a bill you already paid. You copied from a list that wasn't current. Before you run the prompt each week, remove any paid items from your outgoing table. Keeping a running spreadsheet that you update each week is faster than rebuilding the list from scratch every Monday.

What to do next

Save the prompt in a document called "Weekly Cash Check" and set a recurring Monday morning calendar block for ten minutes. Run it this week using last week's numbers if you don't have current figures yet. The habit matters more than the precision on the first run.

If you want to take this further and reduce the manual data entry, read about how to automate financial data collection for your weekly cash check using Zapier and bank exports.

FAQ

Can I use this if I have multiple bank accounts? Yes. Run the prompt once per account, or combine the balances into a single "current bank balance" line if all accounts feed the same payroll. If payroll comes from one specific account, use only that account's balance — mixing accounts gives you a misleading picture.

Do I need to share my real bank login with any of these AI tools? No. ChatGPT, Claude, and Gemini do not connect to your bank. You are copying and pasting numbers manually, or uploading a CSV export. Your login credentials never enter the conversation.

What if my receivables are unpredictable — clients who always pay late? The prompt already handles this by running both scenarios. If you have a client who reliably pays 15 days late, move their invoice out of the 14-day incoming column and into a longer-range column. Don't count money that isn't reliably going to arrive.

Is this a substitute for an accountant or bookkeeper? No. This is a weekly payroll safety check, not a financial management system. It tells you one thing: can you make payroll. Tax planning, profitability analysis, and compliance work require a professional. SCORE{:target="_blank"} offers free mentorship if you need help finding affordable accounting support.

What about the IRS payroll tax deposit — how do I know what I owe? Your payroll software or payroll service calculates this. If you process payroll manually, the IRS page on payroll tax penalties and deposit requirements{:target="_blank"} explains your deposit timing. Many small businesses with lower payroll totals deposit monthly. When in doubt, include the full gross payroll amount in your outgoing column — it's better to overestimate what's leaving than to undercount it.